使用onEdit()将工作表保存为pdf

function onEdit(e) {
  var sheet = e.source.getActiveSheet();
  var range = e.range;
  
  // 判断是否在指定的工作表中编辑
  if (sheet.getName() == "Sheet1") {
    // 将工作表保存为PDF
    var url = "https://docs.google.com/spreadsheets/d/" + sheet.getParent().getId() + "/export?exportFormat=pdf&format=pdf" +
              "&size=A4&portrait=true&fitw=true&source=labnol";
    var options = {
      headers: {
        'Authorization': 'Bearer ' + ScriptApp.getOAuthToken()
      }
    };
    var response = UrlFetchApp.fetch(url, options);
    var blob = response.getBlob();
    
    // 保存PDF文件
    var folder = DriveApp.getFolderById("FolderID"); // 替换为你想保存PDF文件的文件夹ID
    folder.createFile(blob).setName("Sheet1.pdf"); // 文件名可以根据需要进行更改
  }
}