var token = "";// ambil token dari BotFather telegram
var SheetID = "";// ambil ID pada URL Spreadsheets
var UrlPublish = ""; // ambil url hasil publish
var telegramUrl = "https://api.telegram.org/bot" + token;


function setWebhook() { 
var url = telegramUrl + "/setWebhook?url=" + UrlPublish; 
var response = UrlFetchApp.fetch(url); 
}

function doPost(e) {
  var stringJson = e.postData.getDataAsString();
  var updates = JSON.parse(stringJson);
 
    if(updates.message.text){
      sendText(updates.message.chat.id,CariJadwalDariIDSheet(updates.message.text)); 
    }
}

function AmbilSheet1(){
  var rangeSheet = 'Sheet1!A2:C';
  var rows = Sheets.Spreadsheets.Values.get(SheetID, rangeSheet).values;
  return rows;
}


function CariJadwalDariIDSheet(IDjadwal){
  var dataJadwal = AmbilSheet1(); 
  for (var row = 0; row < dataJadwal.length; row++) {
    if(dataJadwal[row][0]==IDjadwal){ 
      return "Hari : " + dataJadwal[row][0] + "\n" +
             "Jam belajar : " + dataJadwal[row][2] + "\n" + 
             "Mata Pelajaran  : " + dataJadwal[row][1];
    }
  }

  return "Jadwal tidak ditemukan." +"\n"+ "Silakan ketikkan hari lain.";
}

function sendText(chatid,text,replymarkup){
var data = {
    method: "post",
    payload: {
      method: "sendMessage",
      chat_id: String(chatid),
      text: text,
      parse_mode: "HTML",
      reply_markup: JSON.stringify(replymarkup)
    }
  };
  UrlFetchApp.fetch('https://api.telegram.org/bot' + token + '/', data);
}