日期搜索自动报告 - Google文档(Date Search for Automatic Reporting - Google Docs)

 好的，我在问这个之前已经经过这个站点前进和后退，但由于某种原因我无法获得我已经实现的代码自动工作。 我只需要运行脚本（我已经设置了一个触发器）来检查表5第3列（称为Reports）中的电子邮件。 如果今天的日期与给定的日期相符，我需要它向我发送包含第1列数据和第2列数据的电子邮件。 
 
 有人可以查看代码并给我一些帮助吗？ 
 
function sendEmails() {
  var spreadsheet = SpreadsheetApp.openById('Unique ID for spreadsheet');           

  var sheet = spreadsheet.getSheets()[4];

  var startRow = 2;  // First row of data to process
  var numRows = 250;   // Number of rows to process
  // Fetch the range of cells
  var dataRange = sheet.getRange(startRow, 1, numRows, 4)
  // Fetch values for each row in the Range.
  var data = dataRange.getValues();   

  var emailAddress = 'email@email.com';
  var subject = "Report Today";

  for (i in data) {
    var row = data[i];
    if( row[3] == true) {
      var message = row[0]+row[1];
      try {
          MailApp.sendEmail(emailAddress, subject, message);
      } catch(errorDetails) {
        MailApp.sendEmail("Email@email.com", "sendEmail script error", errorDetails.message);
      }

    }
  }
}

Ok I've been through this site forward and backward before asking this but for some reason I can't get the code I've implemented to work automatically. I just need the script to run (I setup a trigger already) to check the email in column 3 of sheet 5 (called Reports). I need it to send me an email with column 1 data and column 2 data if today's date matches the date given. 
 
Can someone look at the code and give me a little help?
 
function sendEmails() {
  var spreadsheet = SpreadsheetApp.openById('Unique ID for spreadsheet');           

  var sheet = spreadsheet.getSheets()[4];

  var startRow = 2;  // First row of data to process
  var numRows = 250;   // Number of rows to process
  // Fetch the range of cells
  var dataRange = sheet.getRange(startRow, 1, numRows, 4)
  // Fetch values for each row in the Range.
  var data = dataRange.getValues();   

  var emailAddress = 'email@email.com';
  var subject = "Report Today";

  for (i in data) {
    var row = data[i];
    if( row[3] == true) {
      var message = row[0]+row[1];
      try {
          MailApp.sendEmail(emailAddress, subject, message);
      } catch(errorDetails) {
        MailApp.sendEmail("Email@email.com", "sendEmail script error", errorDetails.message);
      }

    }
  }
}

原文：https://stackoverflow.com/questions/28971841