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

54,514

635 0

Published 2020-04-10

EDIT: I wrote a new Medium post detailing how this works: bit.ly/3gLLxDt
---
Part 1: Creating a telegram bot
Part 2: Getting our bot to place values inside a cell in a Spreadsheet and getting the sheet to send back values to our bot when we send in some key words
Part 3: Creating inline keyboard inside our bot so we won't need to send in keywords but instead, just press buttons

Mainly dedicate this tutorial to everyone who's been reaching out to me about my Medium post. I hope this helps! And if there are technical concepts in this video that you think you can explain better to your fellow viewers, please share in the comments. It would be much appreciated :)

P.S- Thanks to Wim for the foundational tutorial on Telegram Inline Keyboards. You may check it out for extra resources at / @wimscodingsecrets265

All Comments (21)

@noneedtoknowaname8199 3 years ago

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

This is brilliant and right what I needed. Thanks Mars!
@iamyen2 3 years ago

Thanks for your sharing! It's clear and it works~
@allancfc2818 3 years ago

thank you for your tutorial!
@dwiantoro4011 4 years ago

Usefull for Newbie like me. Thank You.... :)
@Alberto-dt1ip 3 years ago

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.
@praveenbhargava9667 2 years ago

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.
@krisriley2206 2 years ago

This is a great tutorial. How do you add the bot to a Telegram group?
@johandebruyn3533 3 years ago

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
@rafaelbertasso3254 3 years ago

Excellent video! But I cant find the code in Medium post
@MarioBarretta 1 year ago

Thnak You How to publish on telegram the info received on a google sheet?
@NamNguyen-ih8oe 2 years ago

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")"
@almadanimart3534 3 years ago

hi, can this method applied in a group ?
@srinithinachiyar4755 1 year ago

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
@014ylrezeb 2 years ago

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
@lordheman7974 3 years ago

Life is too short and you are so smart....LOL
@syazwanaariffin6905 2 years ago

Thank you so much
@sheenng 3 years ago

Can this be done for fb messenger or whatsapp?
@rimaldz8232 1 year ago

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

Thanks!