如何在Google Sheet中设置自动电子邮件提醒

function sendEmailReminder() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var dataRange = sheet.getRange("A2:B"); // 更改为你的数据范围
  var data = dataRange.getValues();
  
  for (var i = 0; i < data.length; i++) {
    var row = data[i];
    var emailAddress = row[0]; // 第一列为电子邮件地址
    var reminderDate = row[1]; // 第二列为提醒日期
    
    if (reminderDate !== "") {
      var today = new Date();
      var reminder = new Date(reminderDate);
      
      if (reminder.getDate() === today.getDate() && reminder.getMonth() === today.getMonth() && reminder.getFullYear() === today.getFullYear()) {
        var subject = "提醒：您有一个任务需要完成";
        var message = "请记得在今天完成任务！";
        MailApp.sendEmail(emailAddress, subject, message);
      }
    }
  }
}