1-2 Google表單+ Mail通知填報者+ Mail通知整理者 + Line通知

https://forms.gle/XeJXYpkeyqc2SXu28

1. Line Notify: https://notify-bot.line.me/zh_TW/

GAS程式碼：

var token = "Line Notify權杖";
function getFormData(e) {
  var ss = SpreadsheetApp.getActive();
  var ws = ss.getActiveSheet();
  var lastColumn = ws.getLastColumn();
  var datas = ws.getSheetValues(1, 1, 1, lastColumn);
  var message = "\n\n";
  for (var i = 0 ; i < lastColumn; i++) {
    message += datas[0][i] + "：" + e.values[i] + "\n\n";
  }
  sendLineNotify(message);
}

function sendLineNotify(message){
  var options =
   {
     "method"  : "post",
     "payload" : {"message" : message},
     "headers" : {"Authorization" : "Bearer " + token}
   };
   UrlFetchApp.fetch("https://notify-api.line.me/api/notify", options);
}