Excel Forum

Code: Select all

function sendHttpPost(message){

  var token = ["......."]; 
  var options =
   {
     "method"  : "post",
     "payload" : "message=" + message ,
     "headers" : {"Authorization" : "Bearer "+ token}
   };
   UrlFetchApp.fetch("https://notify-api.line.me/api/notify",options);
}

function SEND_LINE_DAILY_ONLYNG() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("แผ่น2");
  var data = sheet.getDataRange().getDisplayValues();
  data.splice(0,1); //column = 0, ข้ามrow =1
  var startColumn = 2;
  var LINE_SENT ;
    for (var i=0; i <data.length;i++) {
    for (var n=0; n <data[i].length;n++) {
    if (data[i][n] == "OK") {
      var Status1 = data[i][0];
      var Status2 = data[i][1];
      var Status3 = data[i][3];
      var Status4 = data[i][4];
      var Status5 = data[i][6];
      
      var message1 = "\nวันที่ : " + Status1 +
        "\nสถานะ KILN : " + Status2 +
        "\nรูปภาพ" + "\n" + Status3 +
          
        "\n\nสถานะ Cyclone : " + Status4 +
        "\nรูปภาพ" + "\n" + Status5 + "\n";
      
      sendHttpPost(message1);  
    } 
  }
}
}