Google脚本单元格值按当前日期发送电子邮件通知

function sendEmailNotification() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var currentDate = new Date();
  var range = sheet.getRange("A1"); // 假设要监测的单元格为A1
  var cellValue = range.getValue();
  
  if (cellValue instanceof Date && cellValue.toDateString() === currentDate.toDateString()) {
    var emailAddress = "your-email@example.com"; // 替换为要发送通知的电子邮件地址
    var subject = "单元格值通知";
    var message = "单元格A1的值与当前日期相同：" + cellValue;
    
    MailApp.sendEmail(emailAddress, subject, message);
  }
}