异常：一天内调用的服务次数过多" - 今天只使用了一次...为什么？

Question

异常：一天内调用的服务次数过多"

今天只用了一次...为什么？

/**
* Sends emails with data from the current spreadsheet.
*/
// This constant is written in column C for rows for which an email
// has been sent successfully.
var EMAIL_SENT = 'EMAIL_SENT';
function sendEmails2() {
var sheet = SpreadsheetApp.getActiveSheet();
var startRow = 2; // First row of data to process
var numRows = 32; // Number of rows to process
// Fetch the range of cells 
var dataRange = sheet.getRange(startRow, 1, numRows, 10);
// Fetch values for each row in the Range.
var data = dataRange.getValues();
for (var i = 0; i < data.length; ++i) {
var row = data[i];
var emailSent = row[3];  //This puts email sent in column 3 so no duplicates
if (emailSent !== EMAIL_SENT) { // Prevents sending duplicates
//message content  '/xa0' is space, 'rn' is new line
var emailAddress = "[e-mail]" ; //email address
var message = row[4] + 'xa0' + 'xa0' +'xa0' + 'xa0' +'xa0' +'xa0' + 'xa0' +'xa0' +'xa0' +row[1] + 'rn' +' rn' +' rn'+'' + 'rn'+ 'rn' +'DATE items to be picked up or delivered by:' + 'rn' +'rn' + row[2] + 'rn' + 'rn' + 'rn' +'Vehicle to be used:' + 'xa0xa0' + row[3] + 'rn'+ 'rn' + 'rn'+ 'rn'+'rn'+'Products/Parts to be picked up or delivered:' + 'rn' + 'rn' +row[5];
var subject = 'New Pickup & Delivery Request from enter code here****';
MailApp.sendEmail(emailAddress, subject, message);
sheet.getRange(startRow + i, 3).setValue(EMAIL_SENT);
SpreadsheetApp.flush();
}
}
}

Answer 1

假设其他一切正确，这应该会阻止您的重复问题。

var EMAIL_SENT='EMAIL_SENT';
function sendEmails2() {
var sheet=SpreadsheetApp.getActiveSheet();
var startRow=2;
var numRows=32;
var dataRange=sheet.getRange(startRow, 1, numRows, 10);
var data=dataRange.getValues();
for (var i=0;i< data.length;++i) {
var row=data[i];
var emailSent=row[2];//modified
if (emailSent !== EMAIL_SENT) {
var emailAddress="email address" ;
var message=row[4] + 'xa0' + 'xa0' +'xa0' + 'xa0' +'xa0' +'xa0' + 'xa0' +'xa0' +'xa0' +row[1] + 'rn' +' rn' +' rn'+'' + 'rn'+ 'rn' +'DATE items to be picked up or delivered by:' + 'rn' +'rn' + row[2] + 'rn' + 'rn' + 'rn' +'Vehicle to be used:' + 'xa0xa0' + row[3] + 'rn'+ 'rn' + 'rn'+ 'rn'+'rn'+'Products/Parts to be picked up or delivered:' + 'rn' + 'rn' +row[5];
var subject='New Pickup & Delivery Request from enter code here****';
MailApp.sendEmail(emailAddress, subject, message);
sheet.getRange(startRow + i, 3).setValue(EMAIL_SENT);
SpreadsheetApp.flush();
}
}
}