script แจ้งเตือนไลน์เมื่อสอบเสร็จ

code.gs

function onFormSubmit() {
  var ss = SpreadsheetApp.openById('xxx')// ***ใส่ sheet id***
  var lastRow = ss.getLastRow()
  var score = ss.getRange('B' + lastRow).getValue()
  var form = FormApp.openById('xxx'); // ***ใส่ form id***
  var fRes = form.getResponses();
  var formResponse = fRes[fRes.length - 1];
  var itemResponses = formResponse.getItemResponses();

  var msg = '📣ผลการสอบเก็บคะแนน วิชาครูอภิวัฒน์ ';//+

  msg += ' \n' + itemResponses[0].getItem().getTitle() + ': ' + itemResponses[0].getResponse() +
    ' \n' + itemResponses[1].getItem().getTitle() + ': ' + itemResponses[1].getResponse() +
    ' \n ได้คะแนน ' + score + '/10 คะแนน'

  token.forEach(row => sendNotify(msg, row))
}

var token = ["xxx", "xxx"]; 
function sendNotify(msg, token) {
  let payloadJson = {
    "message": msg  };
  let options = {
    "method": "post",
    "payload": payloadJson,
    "headers": {
      "Authorization": "Bearer " + token
    }
  };
  UrlFetchApp.fetch("https://notify-api.line.me/api/notify", options);
}