用雲端打造自動化環境-永康
https://forms.gle/XeJXYpkeyqc2SXu28
- 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); }