谷歌应用程序脚本。从工作表中检索电子邮件列表

你期望的剧本是这样的吗?

修改脚本:

function sendReport() {
  URL = 'url'
    + '/export?'
    + 'format=pdf'
    + '&size=A4'
    + '&gid=id'
    + '&scale=4'
    + '&portrait=true';
  var response = UrlFetchApp.fetch(URL, {
    headers: {
      'Authorization': 'Bearer ' + ScriptApp.getOAuthToken()
    }
  });

  // Retrieve values from Spreadsheet.
  var sheet = SpreadsheetApp.getActiveSheet();
  var values = sheet.getRange("A2:A" + sheet.getLastRow()).getDisplayValues();
  
  // Send the email using the email addresses.
  values.forEach(([email]) => {
    if (email) {
      var message = {
        to: email,
        subject: "subject",
        body: "body",
        attachments: [response.getBlob().setName('file.pdf')]
      }
      MailApp.sendEmail(message);
    }
  });
}

• 如果要设置具体的工作表,请修改 var sheet = SpreadsheetApp.getActiveSheet(); 到 var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1"); .

参考:

• forEach()