How to create a Telegram Bot that interacts with a spreadsheet (Part 1 of 3)

[@014ylrezeb]

i dont get the last part... it says i need do get where you only use do post.. and i dont know what you did at the last part because it was cut on the screen

[@praveenbhargava9667]

I jus followed your instructions and created scrip. It looks like i configured the script exactly the same but I am unable to get the response.

[@irannasir]

Same here. Did you end up finding the solution

[@noneedtoknowaname8199]

Thank you Mars, this is exactly the bot I wanted to build. So happy I found your course!

[@Honestgamer69]

At 21:39, i cant see what is on top the link, and i lose it from there, and what is the Json Parser online for?newbie here

[@marsescobin]

Hi! I deleted the Webhook by api.telegram.org/bot + /deleteWebhook and then I typed out api.telegram.org/bot + /getUpdates You can re-set the webhook by running the setWebhook function on your google app script (click "Run", beside "View")

[@rukoh4980]

hey so since the UI change of the script editor there appears to be one key difference in the way projects are deployed and it may just make this impossible? when deploying it seems the fact that every time i deploy it, a new webapp url is generated for that deployment so when it calls upon the webAppUrl variable, its the webAppUrl of the previous now nonexistant deployment as opposed to the current one. seems like such a niche thing that im not really sure how to find a solution for this? doesnt seem to be a way to make it not do this...

[@rukoh4980]

even copypasting the code in the article and changing the token and url to my bot and my webapp url, i cant get it to do anything

[@rukoh4980]

found a function that fetches the url of the webapp and returns the /dev one which i think is supposed to act the same as the /exec one except it doesnt change each update? replaced it with that but it still hasnt done anything. including the logger.log thing in the function defining sendMessage() where it is in the finished example in the linked article returns nothing in the logs but having it in the setWebhook() one does. im a novice at coding but its really giving me a headache trying to see what the issue is. this is a 3 year old video so could it be the release of the runtime V8 im seeing people talk about a lot around 2022 in the forums? i just cant figure out what that couldve changed that would affect this..

[@srinithinachiyar4755]

Hi. Does this only work for Google Suite or it works for even normal account? I did everything but i get no reply from the telegram bot. I tried everything. I even rerunned the webhook but it still did not work. please help

[@farihaazmi4425]

hey Mars Escobin . I already run it as set webhook and still my bot dont text me back. may i know why ?

[@nizzuan2]

I did delete the webhook and then run "set webhook" and it works

[@carlospalma4327]

@@nizzuan2 IT DOESNT WORK

[@AlbertodeVictoria]

restart the webhook and create another implmentation

[@heitorvida5260]

This is brilliant and right what I needed. Thanks Mars!

[@marsescobin]

Hi all! I wrote a new Medium post detailing how this works: bit.ly/3gLLxDt

[@rimaldz8232]

hi mars i have problem ReferenceError: webAppUrl is not defined (ligne 6, fichier "Code") how i can fix §§

[@johandebruyn3533]

Hi when I run the function doPost the script Editor generates this error message TypeError: Cannot read property 'postData' of undefined (line 23, file "Code") how fix please

[@Alberto-dt1ip]

Hii , I'm an industrial engineer and I'm interesting in develop one bot to track data from an excel worksheet. Do you have any idea where should I start? I don't have knowledge about programming.

[@Exammap]

How can I send my spreadsheet message to my telegram channel or bot. Please make a video on it.

[@krisriley2206]

This is a great tutorial. How do you add the bot to a Telegram group?

[@VirgoINFP]

Doesn't work for me. I didn't recieved a message back in telegram. I try debugging by running the sendMessage function alone. I get an error message of "TypeError: Cannot read property 'postData' of undefined"

[@zzhkszz]

I stuck at 12:38 ,i press run as you do, but it show “exception: bad request: (line 8, file “Code”)

[@marsescobin]

Sounds like there is a syntax error in the code?

[@MarioBarretta]

Thnak You How to publish on telegram the info received on a google sheet?

[@ilyasulaimandali2210]

Hello, thanks for the great video however I can't get my bot to send texts back, everything worked fine up to the JSON Parsor Online. what could be the problem?

[@marsescobin]

Make sure you run "set webhook" :) You can do this by clicking "Run" and choosing a function. It's beside "View"

[@mohdsyazwan299]

@@marsescobin I followed your steps, same result. my bot not texts me back

[@ilyasulaimandali2210]

@@marsescobin The test web app says doGet function not found and when I change doPost to doGet it couldnt read the variable contents. Thanks for the quick reply before!

[@hazmiemohd7089]

@@mohdsyazwan299 same here

[@viganboy126]

@@hazmiemohd7089 change : var id = contents.message.from.id to var id = contents.message.chat.id , u will get error 400 if use id from, the bot can't find the chat id to send message respon CMIIW

[@dwiantoro4011]

Usefull for Newbie like me. Thank You.... :)

[@almadanimart3534]

hi, can this method applied in a group ?

[@sheenng]

Can this be done for fb messenger or whatsapp?

[@NamNguyen-ih8oe]

thanks for video. I was code like you, but when I run, google Appscript says: "TypeError: Cannot read property 'postData' of undefined (line 17, file "Code")"

[@Celestara3]

I want ask you, i was finished until sendMessage and at time 21.30 in your video i trying to use that url and i got error 404, when i using setWebhook, i got webhook was deleted. I can't see what are you doing after that, so could you teach me how to solve it?

[@marsescobin]

Hi! I deleted the Webhook by typing api.telegram.org/bot + /deleteWebhook and then I typed out api.telegram.org/bot + /getUpdates You can re-set the webhook by running the setWebhook function on your google app script (click "Run", beside "View")

[@Celestara3]

@@marsescobin thanks a lot By the way, how did you got an id?

[@iamyen2]

Thanks for your sharing! It's clear and it works~

[@mariodragoti4235]

how i can create a bot to post autopost on group

[@zhongyinghew9820]

Unable to get bot to response , tried all the method mentioned below

[@zhongyinghew9820]

Having error when run doPost : TypeError: Cannot read property 'postData' of undefined (line 18, file "Code")

[@lordheman7974]

Me to let know if you resolved

[@LuJiale]

@@lordheman7974 Hi, I faced the same problem but I found the remedy to it. 1) Perform the /deleteWebhook 2) setWebhook through the "run" button 3) Publish -> Deploy as webapp -> Project Version -> new -> Update This works for me.

[@tomcunningham8935]

Can you release the source code for the bot you've made?

[@lordheman7974]

Life is too short and you are so smart....LOL

[@marufjonmamatkulov1572]

in final, my cod is not working

[@allancfc2818]

thank you for your tutorial!

[@rafaelbertasso3254]

Excellent video! But I cant find the code in Medium post

[@gautamandani547]

Important where i got stuck, after deploying select the deployment script url and paste it in webapp, run the program (which will set the webhook of telegram to the current deployed script)

[@eugenechristopher7909]

Hi - Is it possible for telegram to retrieve data from google sheets?

[@AlbertodeVictoria]

your variable 'text' need to be a getRange().getValue() method

[@sanjeevdosi4983]

@@AlbertodeVictoria i need my bot to read cells in a given range and also certain highlighted text in the spreadsheet. I do not want my bot and it users to make any changes in my original spreadsheet. If you could kindly send me the appropriate code lines and the exact place to insert them in the entire code. Regards

[@bryanling626]

i tried rerunning the webhook but didn’t get any reply from the bot

[@AlbertodeVictoria]

You need another implementation

[@senchaichow2193]

I cant get it also

[@popzmickuumickuu7504]

How can i get code of this

[@obitelsem]

Thanks!

[@andreabezio]

Very useful thanks! But sadly im not able to open the Script on google sheets for some reason. It says "unable to open the file in this moment, verify your link and retry"... I don't really know whats the problem.

[@marsescobin]

Glad its helpful! Yes that randomly happens to me as well :( try using another browser or clearing your cache

[@andreabezio]

@@marsescobin Changing browser worked thx! :)

[@JG-bj1js]

What browser did you use?

[@thestudentsperspective5822]

can you please link it to your source code

[@tyr731]

TypeError: Cannot read property 'postData' of undefined it doesn't identify post data i think your coding is wrong not working

[@vijaykarthik1529]

Pls make video about how to create bot for share market price

[@taufanali3170]

Hello, I tried to replicate what you did. I cannot get response from Apps Script. When I tried to do /getWebhookInfo, it says that the latest status is error 401, unauthorized. I have deployed it to accessible to anyone (even anonymous). Do you know how to fix that?

[@marsescobin]

Hello! Make sure your webhook is working by rerunning set webhook function

[@gigibiruful]

Followed everything but no response..

[@marsescobin]

Hello! Make sure your webhook is working by rerunning set webhook function

[@syazwanaariffin6905]

Thank you so much

[@nyujinseu722]

Hi!! So i tried the deleteWebhook, and running it again. But my bot still does not respond to me. I have an error which says TypeError: Cannot read property ‘postData’ of undefined (line 16)

[@AlbertodeVictoria]

you need a new implementation whe you restar the webhook

[@mostu1009]

Take Me To Mars < Thanks

[@alchemist9812]

How do u fix an error 400?

[@clintonmak4294]

not sure if u still need it. i fixed mine by replacing the google app url to the latest whenever i published

[@sarahhasran]

My bot doesn't response to me :')

[@marsescobin]

It's very likely that it's because the setWebhook function got deleted and was not set back.Just run the function by clicking "Run" beside "View"

[@eliastan1098]

Hi, I am unable to have the bot send me back a message even after setting back the web hook.

[@jacksonl7930]

hi i also encounter this problem do remember to check your webAppUrl, redeployment may cause new url to appear

[@eliastan1098]

@@jacksonl7930 doesn't that mean you need to change the webapp url and redeploy again if the link is different? That doesn't make sense, it would be like an infinite loop of changing webapp url and redeployment again and again wouldn't it?

[@jacksonl7930]

I just started learning about it today, but somehow it works for me

[@eliastan1098]

@@jacksonl7930 alright ill give it a shot

[@Piniron69]

It didnt work

[@nathgomez936]

i followed the instruction but the bot no response. :3

[@SenChaiChow]

damn difficult, is it for beginners? the learning curve is so steep

[@wimscodingsecrets4558]

Hi Mars, very nice tutorial. Could you mention my video as a source? (assuming you had me as the inspiration)

[@shakilabanu7866]

You should explain right from telegram installation, creation of an account, sending receiving the messages... forming the group , what is bot.... usage of this one and what is broadcasting , then the channel what purpose, it function and how to use the channel ... further usage of it for business communication also

[@hbsr5212]

@Mars Escobin - Great Videos. Do you have an email address that you would like to provide for additional questions?