I'm from Indonesia, I was very helped by this tutorial because it is very detailed and very easy to understand & implement. its very useful tutorial. I hope you always have success ..🙏🏻👍🏻
Great series of videos, is there a way for the bot to only respond to a certified user, lets say that i can approve if a user uses a credential first time engaing the bot?
Hi Mars, Thanks for your tutorial. it worked.copied the code without any knowledge on JSON,Webhooks,JAVA/Google scripts. but having some knowledge on programming. To add some beauty to my Bot pls help me in the following case 1.how to compare text (budget here) with out case sensitive 2.how to format simply bold/italic for some of the words that we are sending to bot using sendMessage 3.how to add line break for the string we are sending to bot using sendMessage. i googled some methods found but not success.
Hey Mars great video. I’m working on a project on transport system for a university and i’d love it if you make a UA-cam video on transportation system using telegram and Google spreadsheet.
Thanks.. this tutorial help me in creating my own telegram bot.. really appreciate your effort.. but I have a quick question like... How to set self destruct timer for sent messages in google script ??
HI! Thanks for the tutorial. I was able to finish this. One thing I wonder, if this is expense tracking, how would you set the budget from telegram, without editing it in the spreadsheet? Also, how to refresh the budget/expenses once we have entered a new month? without refreshing, the expenses will go on forever and we cant keep track of it monthly. Thanks for your effort!
A really easy way to do that without coding is to copy paste your data for the month and move it to amother tab say April 2020. When May comes, you just delete all data for the main sheet. If you want to change the value of budget through telegram bot, you can program it in a way such that when you send in a keyword itd allow you to change the budget cell
Hey Mars, great video! I really loved it, thank you so much for doing this! I followed it and manged to get my bot to send back an inline keyboard. Your code works really well, but can I just ask about the sendtext function in your video? You mentioned at 9.49 that it was a better way of sending over data and that this format is just copied from your older bots. How is that data format actually generated? The old sendtext function was easier to understand because it was clear cut from telegram API, but this one seems to have many additional parameters that appear out of nowhere. Would appreciate it if you could explain how that format came about!
Hi Eusebius! Check this documentation: core.telegram.org/bots/faq#how-can-i-make-requests-in-response-to-updates It was mentioned under "How can I make requests in response to updates?" that you can "Reply directly and give method as JSON payload in the reply"
Hi Mars, Thank you so much for the video! I want to create a telegram bot that is able to pull the data from google spreadsheet. For example, I will enter some ID numbers, the bot will bring me other infos in that ID's row or column. I will keep updating my spreadsheet everyday so the bot will always be updated. Do you think it is possible? If yes, I will need some cheet sheet bc I have no background in coding. Thanks!
Hi! I want to let you know that I've been looking for this code for quite a while (specially on how to send messages via fetchApp params). You have been a great help. Thanks!
@@marsescobin There's a niche for google app script based telegram bot programming here in youtube. i cant seem to find a good one. I highly encourage you to fill it up before people gets wiser. Haha. Suggested: > Switch inline query option on inline keyboard > Inline bots > methods Salamat!
Do you have a copy of the code so I can just copy it in. Tried doing it verbatim myself but I keep messing up/writing it incorrectly as it goes grey after the 2nd else if. Tried solving it but failed...
Hey thank you for the video!!! was really appreciative. However, my bot stopped responding when I added in the inline keyboard command. May I know what is the issue? I could still enter 'apple - 5' and it would be recorded in my spreadsheet, but it just stopped responding,,, nor did the inline keyboard show up :(
Followed according to your medium article + video but it seems like the callback_query doesn't work? when i click on the button, it just has the loading icon and disappears. nothing happens. but when i delete the webhook and click on the button, the getUpdates does register the callback.. a little stuck here. does anyone know how to solve this?
Hi, great content! Do you know how I can add 'negative price' in the spreadsheet. As for now if I write "Apple-+8", it will register Apple as an item and 8 as the price. As when I write "Apple--8", it will register Apple an item but without any price. Appreciate your input. Cheers
how can I modify specific row data? appendRow is filling the data below of the filled data right? in this case, I want to set my budget right inside of the bot. and in advance, actually I would like to create a new sheet (found one, seems here: developers.google.com/apps-script/reference/spreadsheet/spreadsheet#insertSheet(String)) for my next month expenses, etc, all in this bot. I've been trying to find from google apps script doc, but I'm not sure which one that I should take for that: developers.google.com/apps-script/reference/spreadsheet
Is there a copy of this code available somewhere? The keyboards appear but nothing happens, it seems like callback_query doesn't happen but it's hard to verify if my code matches yours.
Hi! Thanks for script! Can you help with re-made your code and add editMessageText function, it will look much better, i tried but nothing worked for me
Thank you! Do you know how can we protect our bot since it will be directly accessing our spreadsheet? Since we don't want random people found out about our bot and creating garbage/accessing info about our savings ;)
Please help and thanks for your awesome Effort : In my case I hope if you can help me: I have a google spreadsheet which contains only customers IDs who I issued a certificate to them So how could I let my telegram bot reply the customer when they write their ID so if he was one of the ids in my google spreadsheet which, the bot will reply them automatically (Yes your certificate ready) if not and the customer ID was not in my google spreadsheet the bot will reply them ( No please wait your turn) I hope that I succeeded in communicating the information to you clearly
Hi. I need help. After copying your script from your old bot i still dont get any inline keyboard? How to solve it? *the code starting from function sendText(chatId, text, keyBoard) {
Thanks for the great tutorial. Share my solution with inline button not responding. function doPost(e) { var contents = JSON.parse(e.postData.contents); if (contents.callback_query) { var from_id = contents.callback_query.from.id; var data = contents.callback_query.data; return sendText(from_id,data); } else if (contents.message) { var id_message = contents.message.from.id; var keyBoard = { "inline_keyboard": [ [{ "text": "Register", "callback_data" : "register" }], [{ "text": "Setup", "callback_data" : "setup" }] ] } return sendText(id_message,"INLINE KEYBOARD",keyBoard); } }
Thank you very much! I was thinking of doing a spreadsheet for my expenses and this 3 part tutorial will elevate it to another level!
Your way of filming your code is great! During lockdown it seems like having an office-mate who is also coding.
Just me?
I dig it.
Lol thanks Michael
you've just got a new subscriber, keep up the good work Mars
This video deserves many more views.
I like the way you sing)))) Beautiful voice!
I'm from Indonesia, I was very helped by this tutorial because it is very detailed and very easy to understand & implement. its very useful tutorial.
I hope you always have success ..🙏🏻👍🏻
Great series of videos, is there a way for the bot to only respond to a certified user, lets say that i can approve if a user uses a credential first time engaing the bot?
Hi Mars,
Thanks for your tutorial. it worked.copied the code without any knowledge on JSON,Webhooks,JAVA/Google scripts. but having some knowledge on programming. To add some beauty to my Bot pls help me in the following case
1.how to compare text (budget here) with out case sensitive
2.how to format simply bold/italic for some of the words that we are sending to bot using sendMessage
3.how to add line break for the string we are sending to bot using sendMessage.
i googled some methods found but not success.
Work like a charm!!!!
Great tutorial & nice voice.
Love it when you're sing......
Respect from Indonesia.....
Hey Mars great video.
I’m working on a project on transport system for a university and i’d love it if you make a UA-cam video on transportation system using telegram and Google spreadsheet.
all these three parts are really helpful. 3000 thanks!
Thanks.. this tutorial help me in creating my own telegram bot.. really appreciate your effort.. but I have a quick question like... How to set self destruct timer for sent messages in google script ??
HI! Thanks for the tutorial. I was able to finish this. One thing I wonder, if this is expense tracking, how would you set the budget from telegram, without editing it in the spreadsheet? Also, how to refresh the budget/expenses once we have entered a new month? without refreshing, the expenses will go on forever and we cant keep track of it monthly. Thanks for your effort!
A really easy way to do that without coding is to copy paste your data for the month and move it to amother tab say April 2020. When May comes, you just delete all data for the main sheet.
If you want to change the value of budget through telegram bot, you can program it in a way such that when you send in a keyword itd allow you to change the budget cell
Otherwise you can program it in a way such that when the date column starts registering another month, it goes to a different tab in the spreadsheet
@@marsescobin How we can do that? I'm newbie in this coding thing and would appreciate if you could show it :)
Hey Mars, great video! I really loved it, thank you so much for doing this!
I followed it and manged to get my bot to send back an inline keyboard. Your code works really well, but can I just ask about the sendtext function in your video? You mentioned at 9.49 that it was a better way of sending over data and that this format is just copied from your older bots. How is that data format actually generated?
The old sendtext function was easier to understand because it was clear cut from telegram API, but this one seems to have many additional parameters that appear out of nowhere.
Would appreciate it if you could explain how that format came about!
Hi Eusebius! Check this documentation: core.telegram.org/bots/faq#how-can-i-make-requests-in-response-to-updates
It was mentioned under "How can I make requests in response to updates?" that you can "Reply directly and give method as JSON payload in the reply"
Hi, is it possible to create Daily Reminder with webhooks
Hi Mars, Thank you so much for the video! I want to create a telegram bot that is able to pull the data from google spreadsheet. For example, I will enter some ID numbers, the bot will bring me other infos in that ID's row or column. I will keep updating my spreadsheet everyday so the bot will always be updated. Do you think it is possible? If yes, I will need some cheet sheet bc I have no background in coding. Thanks!
T.T
you are a queen
tqvm
hopefully you could share more tutorials with us
Hi! I want to let you know that I've been looking for this code for quite a while (specially on how to send messages via fetchApp params). You have been a great help. Thanks!
Thank you for taking the time out to let me know. Appreciate it and glad I was able to help :)
@@marsescobin There's a niche for google app script based telegram bot programming here in youtube. i cant seem to find a good one.
I highly encourage you to fill it up before people gets wiser. Haha.
Suggested:
> Switch inline query option on inline keyboard
> Inline bots
> methods
Salamat!
@@techhome6362 I will check it out. Thank you for the suggestion! haha
Timely and super helpful. You go, Mars!
hey, did u know how to send response from inline keyboard to google spreadsheet? because i've tried so hard but still failed
Just what I needed, much appreciated!
Thank you very much! It's amazing!
Do you have a copy of the code so I can just copy it in. Tried doing it verbatim myself but I keep messing up/writing it incorrectly as it goes grey after the 2nd else if. Tried solving it but failed...
@@thenoizeeone I made bot with another structure using this base
@@alexandrkorobkov6831 Honestly I don't mind, might even suit me better for my use. Just having something to work with would be very appreciated
same, can you give me whatever code you wrote? it would help a lot, thanks!
I did everything like on video. Webhook is working, but I still don't get callback_query((( Please help!
do u have a solution? i got the same problem
Hi, how for me to add the budget into the spreadsheet? I saw your video showing on how to add an expenses but not showing on how to add a budget
Thank you so much for theses tutorials!
Thank you so much!!! Respect from Russia xD
Привет, земляк) ты смог запустить этот код? У меня не отвечает на нажатие. Не могу разобраться в чём проблема...
Hi Mars, for the date format, I would like to be "day/month". I tried rearranging. it doesnt seem to work. Any workaround for this ?
Hey thank you for the video!!! was really appreciative. However, my bot stopped responding when I added in the inline keyboard command. May I know what is the issue? I could still enter 'apple - 5' and it would be recorded in my spreadsheet, but it just stopped responding,,, nor did the inline keyboard show up :(
Hi Mars! where and how should I define postData? the term used inline 23
Thank you so much! Just what I needed!
Followed according to your medium article + video but it seems like the callback_query doesn't work? when i click on the button, it just has the loading icon and disappears. nothing happens. but when i delete the webhook and click on the button, the getUpdates does register the callback.. a little stuck here. does anyone know how to solve this?
Hi, great content! Do you know how I can add 'negative price' in the spreadsheet. As for now if I write "Apple-+8", it will register Apple as an item and 8 as the price. As when I write "Apple--8", it will register Apple an item but without any price. Appreciate your input. Cheers
Hey Mohd! Why not try using another character instead of "-" to split the text? That's probably where the confusion is coming from
how can I modify specific row data?
appendRow is filling the data below of the filled data right?
in this case, I want to set my budget right inside of the bot.
and in advance, actually I would like to create a new sheet (found one, seems here: developers.google.com/apps-script/reference/spreadsheet/spreadsheet#insertSheet(String)) for my next month expenses, etc, all in this bot.
I've been trying to find from google apps script doc, but I'm not sure which one that I should take for that:
developers.google.com/apps-script/reference/spreadsheet
Can I run multiple telegram bots using 1 sheet1? I want every user to get value from a specific cell using his own bot
Is there a copy of this code available somewhere? The keyboards appear but nothing happens, it seems like callback_query doesn't happen but it's hard to verify if my code matches yours.
Try the medium post she based it on. No? I haven’t checked because I’m just on my phone but once I get to the computer it’s the first place I’m going.
Hi! Thanks for script! Can you help with re-made your code and add editMessageText function, it will look much better, i tried but nothing worked for me
hello! after rerunning webhook , it still doesnt show the inline keyboard. What could my error be??
Thank you! Do you know how can we protect our bot since it will be directly accessing our spreadsheet? Since we don't want random people found out about our bot and creating garbage/accessing info about our savings ;)
Hmm you can code it in a way so that it only works if the callback_query ID is equal to your ID :)
@@marsescobin Hi, I've been trying this and already look around few months about this, but I still cannot get it. can you help to create about this?
So pity part of the screen is cut.
Can't see what you are typing in browser in some requests.
Awesome! Thank you for sharing. ;D
can you share the URL path on 13:37? your screen is not showing the URL
Please help and thanks for your awesome Effort :
In my case I hope if you can help me:
I have a google spreadsheet which contains only customers IDs who I issued a certificate to them
So how could I let my telegram bot reply the customer when they write their ID so if he was one of the ids in my google spreadsheet which, the bot will reply them automatically (Yes your certificate ready) if not and the customer ID was not in my google spreadsheet the bot will reply them ( No please wait your turn)
I hope that I succeeded in communicating the information to you clearly
Hi vary usefull how send Google sheets to telegram bot rows updates notification
Hi. I need help. After copying your script from your old bot i still dont get any inline keyboard? How to solve it? *the code starting from function sendText(chatId, text, keyBoard) {
Hello! Make sure your webhook is working by rerunning the set webhook function
@@marsescobin IT WORKS!!!! THANK YOU!!!
@@muhammadizwan7865 Nice! Glad to have helped!
hello can you PLEASE teach me how can i make a shopping bot
hey, did u know how to add timestamp. thanks
very good.
thanks!
Great!.. Can i get the code?
Please give the github link of this project
Hi mars ;
Can you help me
Somebody please upload the code to github
Thanks for the great tutorial. Share my solution with inline button not responding.
function doPost(e) {
var contents = JSON.parse(e.postData.contents);
if (contents.callback_query) {
var from_id = contents.callback_query.from.id;
var data = contents.callback_query.data;
return sendText(from_id,data);
} else if (contents.message) {
var id_message = contents.message.from.id;
var keyBoard = {
"inline_keyboard": [
[{
"text": "Register",
"callback_data" : "register"
}],
[{
"text": "Setup",
"callback_data" : "setup"
}]
]
}
return sendText(id_message,"INLINE KEYBOARD",keyBoard);
}
}
Where's code txt
hello