Google Apps 脚本：在电子邮件中发送 PDF 而不是 .zip 文件

我有这段代码，可以从 Google 电子表格生成 PDF 文件并将其作为电子邮件附件发送。问题是它压缩文件const zipBlob = Utilities.zip(blobs).setName('${ss.getName()}.zip');.

我想更改它，以便附加文件是 PDF 而不是 .zip 文件。

/* Send Spreadsheet in an email as PDF, automatically */
function emailSpreadsheetAsPDF() {
  // Send the PDF of the spreadsheet to this email address
  const email = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Árajánlat - EKOL Hungary').getRange('E3').getValue().toString();

  // Get the currently active spreadsheet URL (link)
  // Or use SpreadsheetApp.openByUrl("<>");
  const ss = SpreadsheetApp.getActiveSpreadsheet();

  // Subject of email message
  const subject = `EKOL Hungary - ${ss.getName()}`;

  // Email Body can  be HTML too with your logo image - see ctrlq.org/html-mail
  const body = "Ide majd kell valami szöveg";

  // Base URL
  const url = 'https://docs.google.com/spreadsheets/d/SS_ID/export?'.replace('SS_ID', ss.getId());

  const exportOptions =
    'exportFormat=pdf&format=pdf' + // export as pdf / csv / xls / xlsx
    '&size=A4' + // paper size legal / letter / A4
    '&portrait=true' + // orientation, false for landscape
    '&fitw=true&source=labnol' + // fit to page width, false for actual size
    '&sheetnames=false&printtitle=false' + // hide optional headers and footers
    '&pagenumbers=false&gridlines=false' + // hide page numbers and gridlines
    '&fzr=false' + // do not repeat row headers (frozen rows) on each page
    '&gid='; // the sheet's Id

  const token = ScriptApp.getOAuthToken();
  const sheets = ss.getSheets();

  // make an empty array to hold your fetched blobs
  const blobs = [];

  for (let i = 0; i < sheets.length; i += 1) {
    // Convert individual worksheets to PDF
    const response = UrlFetchApp.fetch(url + exportOptions + sheets[i].getSheetId(), {
      headers: {
        Authorization: `Bearer ${token}`
      }
    });

    // convert the response to a blob and store in our array
    blobs[i] = response.getBlob().setName(`${sheets[i].getName()}.pdf`);
  }

  // create new blob that is a zip file containing our blob array
  const zipBlob = Utilities.zip(blobs).setName(`${ss.getName()}.zip`);

  // Define the scope
  Logger.log(`Storage Space used: ${DriveApp.getStorageUsed()}`);

  // If allowed to send emails, send the email with the PDF attachment
  if (MailApp.getRemainingDailyQuota() > 0)
    GmailApp.sendEmail(email, subject, body, {
      htmlBody: body,
      attachments: [zipBlob]
    });
}

我也尝试过这种方式，但它发送的 PDF 已损坏。

function emailSpreadsheetAsPDF() {
  const sheetToPrint = "Árajánlat - EKOL Hungary"; // name of the sheet to print
  const ss = SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/1XTJF_-qYFvE4IVkA77YsOg3yfO_PX46z8z0_AtYg_Go/edit#gid=0");
  const ssID = ss.getId();
  const email = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Árajánlat - EKOL Hungary').getRange('E3').getValue().toString();
  const subject = `EKOL Hungary - ${ss.getName()}`;
  const body = "Kicsit szépítettem rajta. Viszont, ide majd kéne valami szöveg. Mi legyen?";
  const shID = ss.getSheetByName(sheetToPrint).getSheetId();
  const url = 'https://docs.google.com/spreadsheets/d/SS_ID/export?'.replace('SS_ID', ss.getId());
  const exportOptions =
    '&size=A4'+
    '&portrait=true'+
    '&fitw=true'+
    '&sheetnames=false&printtitle=false'+
    '&pagenumbers=false&gridlines=false'+
    '&fzr=false'+
    '&gid='+shID; 
  var params = {method:"GET",headers:{"authorization":"Bearer "+ ScriptApp.getOAuthToken()}};
  
  var response = UrlFetchApp.fetch(url+exportOptions, params).getBlob();
  
    GmailApp.sendEmail(email, subject, body, {
      htmlBody: body,
      attachments: [{
            fileName: `EKOL Hungary - Árajánlat` + ".pdf",
            content: response.getBytes(),
            mimeType: "application/pdf"
        }]
    });
}

我真的很感激你能给我的任何帮助，因为我是编码新手。

而不是使用UrlFetchApp， 去做ss.getAs('application/pdf') (See here https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet#getascontenttype)

function emailSpreadsheetAsPDF() {
  // Send the PDF of the spreadsheet to this email address
  var email = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Árajánlat - EKOL Hungary').getRange('E3').getValue().toString();

  // Get the currently active spreadsheet
  var ss = SpreadsheetApp.getActiveSpreadsheet();

  // Subject of email message
  const subject = `EKOL Hungary - ${ss.getName()}`;

  // Get blob
  var blob = ss.getAs('application/pdf');

  // Send email
  GmailApp.sendEmail(email, subject, body, {
    htmlBody: body,
    attachments: [blob]
  });