โค้ดไลน์แจ้งเตือนข่าว + รูปภาพ

code.gs

=ArrayFormula(IFERROR(VLOOKUP(B2,Room!A:B,2,0),"ไม่มีข้อมูล"))

function send_News() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName("News");
  var lastRows = sheet.getLastRow();
  var message="";
  for(var i=2;i<=lastRows;i++) {
  var token = sheet.getRange(i,1).getValue()
   message = sheet.getRange(i,3).getValue()
  var image = sheet.getRange(i,4).getValue()
    
  if(sheet.getRange(i,5).getValue()==true){
    sendLineNotify(message, token, image)
  }
  
  }
}

function sendLineNotify(message, token, image){
  var options =
   {
     "method"  : "post",
     "payload" :
     {
       "image": "image",
       "imageThumbnail" : image, // max size 240x240px JPEG
       "imageFullsize" : image, //max size 1024x1024px JPEG
       "message" : message,
     },
     "headers" : {"Authorization" : "Bearer " + token}
   };
   UrlFetchApp.fetch("https://notify-api.line.me/api/notify", options);
}