GoogleSheets股价电子邮件提醒的实现

function sendEmailAlert() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var dataRange = sheet.getRange("A2:B"); // 假设股价数据在A列和B列
  var data = dataRange.getValues();
  
  for (var i = 0; i < data.length; i++) {
    var stockName = data[i][0];
    var stockPrice = data[i][1];
    
    // 根据股价数据和提醒规则判断是否发送提醒邮件
    if (stockPrice > 100) {
      var recipient = "your-email@example.com"; // 设置收件人邮箱地址
      var subject = "股价提醒：" + stockName + "超过100美元";
      var body = "当前股价：" + stockPrice;
      
      MailApp.sendEmail(recipient, subject, body);
    }
  }
}