Telegram Bot Tutorial – 1 – Setting up the Bot and Google Apps Script -adsmember

I've added code to send keyboard menu to the user, you can find it here: https://stackoverflow.com/questions/48431352/telegram-bot-keyboard-with-google-apps-script/72147367#72147367

Bro, i ve found ur tutorial so helpful… Kindly help me to do same thing with telegram group.. i have added my bot to a group buts it's not reading the messages from group.. pls help

hi wim, good job!
how can i send 2 different messages.
for example: i click the start button then it shows me hello… then i type the message and it shows me thanks for your comments.

Hello mate.. Can I able to send a specific telegram channel message into googlesheet thx…

hello, is it possible to make it so each word uses a new cell?

Is it possible to use Google App Script to make a telegram bot that forwards from one channel to another (with the possibility to filter posts)

Hello from 2021! Its work!

Hey thanks for an awesome video!
Is there anyway to use app script to forward massages from one channel to the next?

2021 is it still working. My bot once done by following this is not working anymore.

спасибо что ты есть

How to do it the other way round…. When a cell is updated in Google sheet I need notification in my telegram channel… Any advice would be great help….

How to add to the spreadsheet by a predefined word Only.

bro how to make inlimited filter bot

I have one question sir, where do I need to start if I need to request some information from one dastasheet. For expample one parameter which is measuring something and I'm keeping on excell. I'm industrial engineer but I don't know programming. Could you give me some recommendation from where should I start? I'm seeing too many application for this bots but I need basic knowledge. Thank you so much, I would share any kind of knowledge that you need if I'm able.

Great tutorial! Thanks ?

Hi Wim, Which Mic do you using for this video?
thats hell a damn clear voice

how to do Request failed for https://api.telegram.org returned code 409. Truncated server response: {"ok":false,"error_code":409,"description":"Conflict: can't use getUpdates method while webhook is active; use deleteWebhook to delete the webhook … (use muteHttpExceptions option to examine full response) (line 10, file "Code")

there is something problem 404 error

Hi!!
I will share my code but like many others I have an error I cannot solve (TypeError: Cannot read property 'postData' of undefined (line 31, file "Code"), does anyone know what's wrong?

Thank you in advance!

var token = "replaceforTOKENID";
var url = "https://api.telegram.org/bot" + token;
var webAppUrl = "replacefor URL YOU GET WHEN YOU PUBLISH";
var ssId = "replacefor SPREADSHEET ID IN URL";

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

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

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

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

function doGet(e) {
return HtmlService.createHtmlOutput("Hello " + JSON.stringify(e));
}

function doPost(e) {
var contents = JSON.parse(e.postData.contents);
GmailApp.sendEmail(Session.getEffectiveUser().getEmail(),"Telegram Bot Update",JSON.stringify(contents,null,4));

var text = contents.message.text;
var id = contents.message.from.id;
var name = contents.message.from.first_name + " " + contents.message.from.last_name;
sendText(id, "Hello " + name);

SpreadsheetApp.openById(ssId).appendRow([new Date(),id,name,text,contents]);
}

var response = UrlFetchApp.fetch(url + "/getUpdates"); erorr !!!!!!!

Wim, make subtitles to your videos in English, please. It shows in Dutch automaically.

nice tutorial… can you make tutorial on reply_markup with google apps script?

Hi, this is awesome, can you make reverse method?
I mean how i can read/get data from spreadsheet and post it in bot
thanks btw

Thanks dude ?

Bot for instagram telegram?

Hello! Thanks for tutorial!
Is it possible to get information from google sheets when I write a command in telegram bot?

Hi Wim, thanks for your great tutorial. I made it work however for some strange reason the new tab creation doesn't work at all and ie posting with @todo on Telegram sends a text starting with @ and it still lands in the Sheet1. Any idea of what to change to make it work properly?

You have brilliant coding skills & i have brilliant revolutionary busi ideas. Lets find a startup together. Mail me at rakeshagg233@gmail.com

i needed your help! where can i contact you plz?