sheet-app-telegram

let sheet_id = 'sheet id dari google sheet';
let Sheet = new Tito.Sheet(sheet_id)
function sendHaloTelegramFromSheet() {
  let data = Sheet.from('Pesan').getAll();
  let message = '';
  for(i = 0; i < data.length; i++){
    if(data[i][0]==='--- diisis dengan penanda pesan----'){
      message = data[i][1];
      break;
    }
  }
  let chat_id = 601588892;
  Telegram.sendMessage(chat_id, message);
}