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);
}
}
}
}
}