Line-Notify / Line Notify ส่งไปหลายกลุ่ม.txt
Line Notify ส่งไปหลายกลุ่ม.txt
Raw
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);
        }
      }
    }
  }
}