Hello brother, I need a program to post content from a column, cell by cell at a particular interval. I want after every 1 minutes content from column A of the excel sheet get posted in telegram channel whenever the script is run. For example after running the script at the content get posted as in such a manner from cells of the sheet. Time= 1 min Post message from Cell A1 Time= 2 min Post message from Cell A2 . . . and so on Can you help me in this
var response = UrlFetchApp.fetch(url + "/setWebhook?url=" + webAppUrl); Previously, it was missing the = sign after url, which resulted in an incorrect URL construction.
Hi Wim. Very useful video. Thanks. But I ran into a problem. Function doPost is never executed. How can check, what is the reason? (Sorry, English is not my native language). How can I check if my bot send POST request? And what is in POST request?
Hi Wim, i'm followed every instructions until the 5 video you've uploaded. im just curious, is it possible if inputing some data to spreadsheet from telegram without getting email updates?
Nice tutorial, If i have php project ('x') how to set up webhook ? Inside the project 'x' ? Or maybe i can set up in another project 'y' (in the same server of project 'x' ) Thanks
Hi Wim's thank you for this tutorial, but I have an explanation to ask you, that I can't go on even if I don't know English well. It is not clear to me what url you put in the webAppUrl variable, between the first and the second video this variable appeared and I cannot understand where you got that link. Thanks for your help good job
Hi Wim though I have gone exactly as per your tutorial I cannot proceed ahead of 1:55 where you are getting the Hello message with the other values at 1:56. I am using mozilla firefox and not chrome. Can you please suggest a way out.
This is a Google bug! The Web App address could be something like: script.google.com/macros/u/0/s/blablabalblajo0s_CNFeUaEMlbsfLl69-GB/exec When you're logged in into multiple gmail accounts. (it adds u/0/ or something simliar) Then use: script.google.com/macros/s/blablablaMnSP14Wbfmkfjo0s_CNFeUaEMlbsfLl69-GB/exec and optionally run setWebHook again.
You probably once called set_webhook by accident. This will configure a web hook for your bot. To delete the webhook, you can either call bot.set_webhook() (no arguments means that the webhook will be removed), or visit this url: api.telegram.org/bot/setWebhook?url= Leaving the "url" parameter empty will remove the webhook as well. bot.set_webhook() simply calls this URL for you :)
Ran into several issues: 1. The deployment part does not work for me on chrome . I copied every lines of codes. But it works on microsoft edge. 2. Did not received emails after sending message to bot. Probably my webhook wasn't set up right. When I run the setWebhook function, the message I get is {"ok":true,"result":true,"description":"Webhook is already deleted"}
var response = UrlFetchApp.fetch(url + "/setWebhook?url=" + webAppUrl); Previously, it was missing the = sign after url, which resulted in an incorrect URL construction.
It's quite been a long time tho, but I had the same issue. When you deploy the web, set the project version "New." Or, make sure you set your webhook properly and permissions.
This is sooo cool! Your tutorial is awesome. Not to fast, not to slow, and I'm learning Telegram bots and Google App Script at the same time.
good job thanks for the tutorials
Thanks sir.
Thanks a lot!
Hello brother,
I need a program to post content from a column, cell by cell at a particular interval.
I want after every 1 minutes content from column A of the excel sheet get posted in telegram channel whenever the script is run.
For example after running the script at the content get posted as in such a manner from cells of the sheet.
Time= 1 min
Post message from Cell A1
Time= 2 min
Post message from Cell A2
.
.
.
and so on
Can you help me in this
[17-12-29 23:52:20:888 ICT] {"ok":true,"result":true,"description":"Webhook is already deleted"} Got that log when setting the webhook part
var response = UrlFetchApp.fetch(url + "/setWebhook?url=" + webAppUrl);
Previously, it was missing the = sign after url, which resulted in an incorrect URL construction.
Hi Wim. Very useful video. Thanks. But I ran into a problem. Function doPost is never executed. How can check, what is the reason? (Sorry, English is not my native language). How can I check if my bot send POST request? And what is in POST request?
Hi Wim, i'm followed every instructions until the 5 video you've uploaded.
im just curious, is it possible if inputing some data to spreadsheet from telegram without getting email updates?
you just turn off the post function
Nice tutorial,
If i have php project ('x') how to set up webhook ? Inside the project 'x' ? Or maybe i can set up in another project 'y' (in the same server of project 'x' )
Thanks
How about SSL certificate? Does your bot work without it?
Hi Wim's thank you for this tutorial, but I have an explanation to ask you, that I can't go on even if I don't know English well.
It is not clear to me what url you put in the webAppUrl variable, between the first and the second video this variable appeared and I cannot understand where you got that link.
Thanks for your help
good job
it's from the BotFather
is it necessary to use gmail app for that?
Hi Wim though I have gone exactly as per your tutorial I cannot proceed ahead of 1:55 where you are getting the Hello message with the other values at 1:56. I am using mozilla firefox and not chrome. Can you please suggest a way out.
Same problem. did you solve it ?
@@sebastianomarchesini Couldn't move ahead. Sorry.
@@sanjeevdosi4983 I use a webhook and after is working.
Try with other videos ;)
ua-cam.com/video/pV1Jt3fjcq8/v-deo.html
@@sebastianomarchesini Thanks a lot Buddy. Will revert after having a look.
At 0:54 I get a "Sorry unable to open a file at this time" message instead of the error message u got. could you help me
This is a Google bug!
The Web App address could be something like:
script.google.com/macros/u/0/s/blablabalblajo0s_CNFeUaEMlbsfLl69-GB/exec
When you're logged in into multiple gmail accounts. (it adds u/0/ or something simliar)
Then use:
script.google.com/macros/s/blablablaMnSP14Wbfmkfjo0s_CNFeUaEMlbsfLl69-GB/exec
and optionally run setWebHook again.
NICE was looking all over for this
can't use getUpdates method while webhook is active
You probably once called set_webhook by accident. This will configure a web hook for your bot. To delete the webhook, you can either call bot.set_webhook() (no arguments means that the webhook will be removed), or visit this url: api.telegram.org/bot/setWebhook?url=
Leaving the "url" parameter empty will remove the webhook as well. bot.set_webhook() simply calls this URL for you :)
Hi man, where i can take my var webAppUrl???
The url is the URL given when you publish the app
OMG!!!! its work!!
Hey
Actually I have little bit confused about webAppurl can u help me
Ran into several issues:
1. The deployment part does not work for me on chrome . I copied every lines of codes. But it works on microsoft edge.
2. Did not received emails after sending message to bot. Probably my webhook wasn't set up right. When I run the setWebhook function, the message I get is {"ok":true,"result":true,"description":"Webhook is already deleted"}
Same! Have you gotten a solution for that when you coded?
var response = UrlFetchApp.fetch(url + "/setWebhook?url=" + webAppUrl);
Previously, it was missing the = sign after url, which resulted in an incorrect URL construction.
How do we get the webApp url
pray to god, god will deliver
Dude email code doesn't work, please fix your code
Wim's , I don't know how you got "var webAppUrl = "script.google.com/macros/s/AKfycba............"
having problems with the e-mail updates... the message isn't coming. what's wrong!?
Same problem did you find any soltuion
It's quite been a long time tho, but I had the same issue. When you deploy the web, set the project version "New." Or, make sure you set your webhook properly and permissions.
same problem. tried everything :(( pleease help
Setting the project version as "New" fixed it for me
The code you have is the same as the video?
Hi there.. I am not getting any email when i am sending input to bot, working on new updated app script.. Please help.