jawoebot 1

// FULL SCRIPT BELOW:
// How to connect your Telegram Bot to a Google Spreadsheet (Google Apps Script)
// https://www.youtube.com/watch?v=mKSXd...
//
// FILL IN THE GLOBAL VARIABLES token, webAppUrl and ssId
//

var token = "1810746550:AAEm7a0NQ6FsBUEMEAtLo-3B7Ul7oacc1u4";
// FILL IN YOUR OWN TOKEN
var telegramUrl = "https://api.telegram.org/bot" + token;
var webAppUrl = "https://script.google.com/macros/s/AKfycbwcMJT6zAzTxkscx6xIs_Zdk5u39kruIpaGDP6lMcziseW2Zlm9g3_ixZcC-WTcWKbzHw/exec";
// FILL IN YOUR GOOGLE WEB APP ADDRESS
var ssId = "1sVFpvPk6tPlF7vfD6_68a9AEVvzeiMMjBD9aZ6mx5JE";
// FILL IN THE ID OF YOUR SPREADSHEET

function getMe() {
  var url = telegramUrl + "/getMe";
  var response = UrlFetchApp.fetch(url);
  Logger.log(response.getContentText());
}

function setWebhook() {
  var url = telegramUrl + "/setWebhook?url=" + webAppUrl;
  var response = UrlFetchApp.fetch(url);
  Logger.log(response.getContentText());
}

function sendText(id,text) {
  var url = telegramUrl + "/sendMessage?chat_id=" + id + "&text=" + text;
  var response = UrlFetchApp.fetch(url);
  Logger.log(response.getContentText());
}

function doGet(e) {
  return HtmlService.createHtmlOutput("Hi there");
}

function doPost(e) {

  // this is where telegram works
  var data = JSON.parse(e.postData.contents);
  var text = data.message.text;
  var id = data.message.chat.id;
  var name = data.message.chat.first_name + " " + data.message.chat.last_name;
  var answer = "Hi " + name + ", thank you for your comment " + text;
  var pesan = "asoe pesan";
  //sendText(id,answer);



    var tixt = data.message.text;
var ss = SpreadsheetApp.getActiveSpreadsheet()
var sheet = ss.getActiveSheet()
// Или = ss.getSheets()[0]
// Или = ss.getSheetByName("nameOfYourSheet")

var arrData = sheet.getRange(1, 1, sheet.getLastRow(),
sheet.getLastColumn()).getDisplayValues()
// Или = sheet.getDataRange().getDisplayValues()
for(var row = 0; row<arrData.length; row++){
  for(var col = 0; col<arrData[0].length; col++){
    if(arrData[row][col] == tixt){
      balah = arrData[row][col+1];
       sendText(id, ''+balah+'')
    }
  }
  }










  if ( /\/start/i.exec(text) ){
sendText(id, 'halo')
  SpreadsheetApp.openById(ssId).getSheets()[0].appendRow([new Date(),id,name,text,answer]);




  if(/^@/.test(text)) {
    var sheetName = text.slice(1).split(" ")[0];
    var sheet = SpreadsheetApp.openById(ssId).getSheetByName(sheetName) ? SpreadsheetApp.openById(ssId).getSheetByName(sheetName) : SpreadsheetApp.openById(ssId).insertSheet(sheetName);
    var comment = text.split(" ").slice(1).join(" ");
    sheet.appendRow([new Date(),id,name,comment,answer]);



}



  }
}