一、學員需求
二、Line群組
三、Google表單製做與設定
四、取得Line Notify權杖:https://notify-bot.line.me/zh_TW/
oXPwPQmrozCMkie7E2YHKtB9UkvQNqG0l8HYbfqnNJg
五、Google Apps Script(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); }
六、線上筆記:https://hackmd.io/
七、用5分鐘建置一個網站