在Google Sheets脚本中根据日期发送电子邮件

function sendEmailOnDate() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var dateCell = sheet.getRange("A1"); // 假设日期数据在A1单元格中
  var currentDate = new Date();
  var targetDate = new Date(dateCell.getValue());

  if (currentDate.getDate() === targetDate.getDate() &&
      currentDate.getMonth() === targetDate.getMonth() &&
      currentDate.getFullYear() === targetDate.getFullYear()) {
    // 当当前日期与目标日期相同时发送邮件
    var recipient = "example@example.com"; // 设置收件人邮箱地址
    var subject = "邮件主题"; // 设置邮件主题
    var body = "邮件内容"; // 设置邮件内容

    MailApp.sendEmail(recipient, subject, body);
  }
}