请求协助：Google Sheets脚本实现Y列值符合条件的每日邮件通知

数据老陈

2026-8-20

Google Apps Script 调试请求：每日到期订单邮件通知排查

功能需求

监控表格Y3:Y列的单元格值，当值满足≤7 或 ≥0时，每日自动发送邮件通知
邮件需包含对应行Q列的订单信息

当前问题

已编写sendNotification函数，但功能未按预期运行，怀疑触发器设置或代码存在问题，请求协助排查

现有代码

function sendNotification() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getActiveSheet();
  var cell = ss.getActiveCell().getA1Notation();
  var row = sheet.getActiveRange().getRow();
  var cellvalue = ss.getActiveCell().getValue().toString();
  var recipients = "x@email.com";
  var message = '';
  if(cell.indexOf('Y')<=7){ 
    message = sheet.getRange('Q'+ sheet.getActiveCell().getRowIndex()).getValue()
  }
  var subject = 'Order is due soon for'+sheet.getName();
  var body = sheet.getName() + ' order is due soon. Click ' + ss.getUrl() + ' to see which PO is due, look at row # to see details: «' + row + '». PO#: «' + cellvalue;
  MailApp.sendEmail(recipients, subject, body);
};