Telegram Bot Tutorial: How to connect your Telegram Bot to a Google Spreadsheet (Apps Script) HD

Connect Telegram Bot to Google Spreadsheet (Google Apps Script). Improved Tutorial: https://www.youtube.com/watch?v=24EyItKfm50&index=1&list=PLGGHwNnXfci86dfqIVLc5l391SPk-RX1F // FULL SCRIPT BELOW: // How to connect your Telegram Bot to a Google Spreadsheet (Google Apps Script) // https://www.youtube.com/watch?v=mKSXd_od4Lg&lc=z232c12ysyjcgf4zz04t1aokge3lgpwnkkjdaonvvvs3rk0h00410 // // FILL IN THE GLOBAL VARIABLES token, webAppUrl and ssId // var token = ""; // FILL IN YOUR OWN TOKEN var telegramUrl = "https://api.telegram.org/bot" + token; var webAppUrl = ""; // FILL IN YOUR GOOGLE WEB APP ADDRESS var ssId = ""; // 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; sendText(id,answer); 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]); } }