使用Apps脚本从Google电子表格发送消息到行通知

function sendNotification() {
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = spreadsheet.getActiveSheet();
  var lastRow = sheet.getLastRow();
  
  // 获取消息内容
  var message = sheet.getRange(lastRow, 1).getValue();
  
  // 发送行通知
  var lineUrl = "https://api.line.me/v2/bot/message/broadcast";
  var accessToken = "YOUR_ACCESS_TOKEN";
  
  var options = {
    "method": "post",
    "headers": {
      "Content-Type": "application/json",
      "Authorization": "Bearer " + accessToken
    },
    "payload": JSON.stringify({
      "messages": [
        {
          "type": "text",
          "text": message
        }
      ]
    })
  };
  
  UrlFetchApp.fetch(lineUrl, options);
}