Line Notify ส่งไปหลายกลุ่ม function postContent() { var spreadsheet = SpreadsheetApp.getActiveSpreadsheet(); var sheet = spreadsheet.getActiveSheet(); var last_row = 184; //กำหนดแถวสุดท้าย var begin_row = 3; //กำหนดแถวเริ่ม var confirmSend = Browser.msgBox("Send Line Notifications", "Are you sure you want to send Line notifications for rows " + begin_row + " to " + last_row + "?", Browser.Buttons.OK_CANCEL); if (confirmSend == "ok") { // อาร์เรย์ของโทเค็น Line Notify ตามลำดับของแถว var tokens = ["4hFbwtpe7segD7DfCaQq1jlidnNMO07XQzNNLR6ijme", //กลุ่มที่ 1 "7tUA9AIqzQ8BrsmNEAGOA8q9xhxCVutnzTQeE0xqQUw", //กลุ่มที่ 2 "xDGh6a4JuZUkwRqRKiooMlazN4l1UpJ7wEx5IablRq3", "PtOThcv4HT1giZMd1ZJiewkn2UfFpA9T8obEElWgMdj" ]; // แทนค่าด้วยโทเค็นที่ต้องการ for(var i = begin_row; i <= last_row; i++) { var name = "C"+i; var value2 = sheet.getRange(name).getValue(); var grade = "D"+i; var value3 = sheet.getRange(grade).getValue(); var nick = "E"+i; var value4 = sheet.getRange(nick).getValue(); var checkout_moning = "I"+i; var value5 = sheet.getRange(checkout_moning).getValue(); var checkout_time_moning = "J"+i; var value6 = sheet.getRange(checkout_time_moning).getValue(); var checkout_evening = "K"+i; var value7 = sheet.getRange(checkout_evening).getValue(); var checkout_time_evening = "L"+i; var value8 = sheet.getRange(checkout_time_evening).getValue(); var note = "M"+i; var value9 = sheet.getRange(note).getValue(); var checkin_night = "N"+i; var value10 = sheet.getRange(checkin_night).getValue(); var checkin_time_night = "O"+i; var value11 = sheet.getRange(checkin_time_night).getValue(); var night = "P"+i; var value12 = sheet.getRange(night).getValue(); var token = tokens[i - begin_row]; var checkinTimeNight = Utilities.formatDate(new Date(value11), "GMT+7", "HH:mm"); var checkoutTimeMorning = Utilities.formatDate(new Date(value6), "GMT+7", "HH:mm"); var checkoutTimeEvening = Utilities.formatDate(new Date(value8), "GMT+7", "HH:mm"); var today = new Date(); // วันที่ปัจจุบัน var dateString = Utilities.formatDate(today, "GMT+7", "dd MMM yyyy"); // รูปแบบวันที่ var msg = dateString + "\n【Name】: " + value2 + "\n【Grade】: " + value3 + "\n【Nickname】: " + value4 + "\n===================================" + "\n【Check-Out Morning】: " + value5 + "\n【Check-Out Time Morning】: " + checkoutTimeMorning + "\n===================================" + "\n【Check-Out Evening】: " + value7 + "\n【Check-Out Time Evening】: " + checkoutTimeEvening + "\n===================================" + "\n【Note】: " + value9 + "\n【Check-In Night】: " + value10 + "\n【Check-In Time Night】: " + checkinTimeNight + "\n【Night】: " + value12; var options = { "method": "post", "payload" : {"message": msg }, "headers": {"Authorization": "Bearer " + token} } // UrlFetchApp.fetch("https://notify-api.line.me/api/notify", options); // } // } // } try { UrlFetchApp.fetch("https://notify-api.line.me/api/notify", options); } catch (e) { // ซ่อนข้อผิดพลาด 401 ที่นี่ if (e.message.indexOf("401") == -1) { Logger.log('Error: ' + e); } } } } }