javascript - 尝试使用谷歌表格中的谷歌应用程序脚本将电子邮件导出到 sendgrid 帐户）？

Question

我正在尝试将电子邮件从谷歌表导出到我的 Sendgrid 帐户：

function myFunction() {
  var API_KEY = "your api key";
  var url = "https://api.sendgrid.com/v3/contactdb/recipients=" + API_KEY;
  var response = UrlFetchApp.fetch(url);
  var data = JSON.parse(response.getContentText());
  var results = data.hits;

  var sheet = SpreadsheetApp.getActiveSheet();

  var header = ["Email"]
  var items = [header];

  results.forEach(function (result) {
      items.push([result.email]);
  });
  sheet.getRange(1,1,items.length,items[0].length).setValues(items);
}

要完成该脚本，我只需要插入我的 Sendgrid API 密钥，但它仍然无法正常工作......

也许我选择了错误的“var url =”链接？

https://sendgrid.com/docs/API_Reference/Web_API_v3/Marketing_Campaigns/contactdb.html#Add-Single-Recipient-POST

标签： javascriptgoogle-apps-scriptgoogle-sheetssendgrid