如何使用gmail脚本一次附加多个图像.下面是一个附加一个图像的工作脚本示例

Question

我正试图用一些数据建立一个谷歌表单，通过电子邮件发送图像。我有下面的代码来发送一个图像附件，但如果可能的话，我想一次发送多个图像。如何更改下面的代码以处理多个图像？

function emailImage(){
var EMAIL_SENT = "EMAIL_SENT";
var sheet = SpreadsheetApp.getActiveSheet();
var startRow = 2;
var numRows = sheet.getLastRow();
// Fetch the range of cells
var dataRange = sheet.getRange(startRow, 1, numRows, 5)  
var data = dataRange.getValues(); 
for (var i = 0; i < data.length; ++i) {
var row = data[i];
var emailAddress = row[0];  // First column
var subject = row[1];       // Second column
var message = row[2];       // Third column
var image = UrlFetchApp.fetch(row[3]).getBlob();   // Fourth column
var emailSent = row[4];     // Fifth column
if (emailSent != EMAIL_SENT) {  // Prevents sending duplicates
MailApp.sendEmail(emailAddress, subject, message, {attachments: [image]});
sheet.getRange(startRow + i, 5).setValue(EMAIL_SENT);
// Make sure the cell is updated right away in case the script is interrupted
SpreadsheetApp.flush();
}
}
}

Answer 1

这只是一个帮助您的片段：

var image1 = UrlFetchApp.fetch(row[3]).getBlob();
var image2 = 'However you wish to get it';
var options = { attachments: [] }; 
option.attachments.push(image1);
option.attachments.push(image2);
MailApp.sendEmail(emailAddress, subject, message, options);

Answer 2

在@MetaMan的帮助下，我终于能够做到这一点。。。。

function emailImage(){
var EMAIL_SENT = "EMAIL_SENT";
var sheet = SpreadsheetApp.getActiveSheet();
var startRow = 2;
var numRows = sheet.getLastRow();
// Fetch the range of cells
var dataRange = sheet.getRange(startRow, 1, numRows, 6)  
var data = dataRange.getValues(); 
for (var i = 0; i < data.length; ++i) {
var row = data[i];
var emailAddress = row[0];  // First column
var subject = row[1];       // Second column
var message = row[2];       // Third column
var image1 = UrlFetchApp.fetch(row[3]).getBlob();
var image2 = UrlFetchApp.fetch(row[4]).getBlob();
var emailSent = row[5];     // Fifth column
if (emailSent != EMAIL_SENT) {  // Prevents sending duplicates
MailApp.sendEmail(emailAddress, subject, message, {attachments: [image1, image2]});
sheet.getRange(startRow + i, 6).setValue(EMAIL_SENT);
// Make sure the cell is updated right away in case the script is interrupted
SpreadsheetApp.flush();
}
}
}