- 12
- 197 981
Wim's Coding Secrets
Netherlands
Приєднався 4 лис 2017
Hello coder!
My name is Wim, I live in Amsterdam and I love to code. At this channel I'm posting coding tutorials about Google Apps Script, Telegram Bots.
Please subscribe to my channel and let me know your questions and suggestions in the comments below! My website is www.wimdenherder.com
My name is Wim, I live in Amsterdam and I love to code. At this channel I'm posting coding tutorials about Google Apps Script, Telegram Bots.
Please subscribe to my channel and let me know your questions and suggestions in the comments below! My website is www.wimdenherder.com
Summarize YouTube Videos with ChatGPT for YouTube
A small preview of the UA-cam Summarize Extension I am working on (as a personal project). Based on the famous ChatGPT-for-Google extension (with over 600,000+ users). This one summarizes UA-cam Videos. Please share your ideas! It's very cool to see applications and ideas with ChatGPT
Переглядів: 87
Відео
You can actually run the old Mac's hypercard in the browser these days!
Переглядів 742 роки тому
Try it out yourself: jamesfriend.com.au/projects/tryhypercard/
NOS scraper - listen to news mp3s in any language
Переглядів 1803 роки тому
NOS scraper - listen to news mp3s in any language Code: github.com/wimdenherder/nos-news-to-speech-translated # NOS news reader (in any language) This script reads NOS news articles for you in any language! It creates an mp3 and plays it. Works from the terminal. # Clone project 1. Download this repo: click the green Code button on top right of this page. 2. Unzip & open this folder in terminal...
Send the weather by email (super simple script!)
Переглядів 1913 роки тому
Important change to video: 1. Go to openweathermap.org/api 2. Current Weather Data - click subscribe (not hourly forecast) 3. Under free, click get API key 4. Go to Api keys 5. Copy the weather api key Daily Weather Emailer (super simple script!) Code: github.com/wimdenherder/DailyCalendarMailerGoogle 0:00 google apps script 0:35 send emails 1:00 execute & permissions 1:30 triggered functions -...
Daily Calendar Mailer (super easy script for Gmail & Calendar)
Переглядів 2043 роки тому
Daily Calendar Mailer (super easy script for Gmail & Calendar) Code: github.com/wimdenherder/DailyCalendarMailerGoogle 0:00 demo 0:37 time-based trigger 1:12 Google Apps Script 2:30 execute & permissions 2:45 debugger vs logger 3:40 CalendarApp 5:30 map to data 9:15 map to string 10:00 display date and time 13:20 show two digits 15:50 send Email 17:10 time-based trigger 17:44 clean up code 20:4...
Telegram Bot Tutorial - 6 - Uploading photos and videos to Google Spreadsheet with Telegram Bot
Переглядів 5 тис.3 роки тому
Telegram Bot Tutorial - 6 - Uploading photos and videos to Google Spreadsheet with Telegram Bot Code below. Don't forget to test with own data in testPhoto function and add a check to your own doPost(e) function (is not visible below) function testPhoto() { var contents = {} // replace this! send a photo and then replace this with your own contents processPhoto(contents); } function processPhot...
Telegram Bot Tutorial - 3 - Process Data and Send Text Back
Переглядів 27 тис.6 років тому
Telegram Bot Tutorial - 3 - Process Data and Send Text Back
Telegram Bot Tutorial - 2 - Webhook & GmailApp
Переглядів 36 тис.6 років тому
Telegram Bot Tutorial - 2 - Webhook & GmailApp
Telegram Bot Tutorial - 1 - Setting up the Bot and Google Apps Script
Переглядів 77 тис.6 років тому
Telegram Bot Tutorial - 1 - Setting up the Bot and Google Apps Script
Telegram Bot Tutorial - 4 - Update Your Spreadsheet
Переглядів 33 тис.6 років тому
Telegram Bot Tutorial - 4 - Update Your Spreadsheet
Telegram Bot Tutorial - 5 - Insert a New Sheet and Error Logging
Переглядів 18 тис.6 років тому
Telegram Bot Tutorial - 5 - Insert a New Sheet and Error Logging
Thanks for the tutorial just one question, my doPost function is not able to update the spreadsheet. Although that test function run in App Script does update the spreadsheet. Any help on this please.
Thanks sir.
thanks bro ...
can i ask, what should i fill int the var contents if i never send a photo to my bot
i keep getting TypeError: Cannot read properties of undefined (reading 'postData') doPost not sure whats the cause
Thank you for the tutorial. When setting the Webhook I got a message "WebHookAlreadyDeleted". I think the issue is that you there's a different way you need to add the URL. I used the code from GitHub that referenced this playlist to fix this. function setWebhook(){ var url = telegramUrl + "/setWebhook?url=" + webAppUrl; var response = UrlFetchApp.fetch(url); Logger.log(response.getContentText()); }
Is there a way to not show the Username and First Name? Meaning I want to completely hide it away and don't let it appear in the JSON file as well.
HI , can we also send messages from Google Sheets to telegram bot by any chance?
Same question!!!
hello dear, thanks for share your knowledge. Can you help me to create a telegram bot to read a google sheet and return a value? Like a lookup function on excel.
I have gone through all the tutorial. Thanks a lot for this.... please add the name Google App script in the video name to make it searchable for people working with GAS and Telegram Bot
I am not receiving email from telegram bot. Please help me !
Hello mr. Wim How to reply to sender?
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.
I've added code to send keyboard menu to the user, you can find it here: stackoverflow.com/questions/48431352/telegram-bot-keyboard-with-google-apps-script/72147367#72147367
Dude email code doesn't work, please fix your code
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
what if i want to fill the spreadsheets data in different column based on telegram text data with comma separator?
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
Sometimes i have to upload 4 photos togther? Then what to do
{ "name": "Exception" }
Hi.. I am not getting any email when I am giving input into Bot.
Hi there.. I am not getting any email when i am sending input to bot, working on new updated app script.. Please help.
Thanks for the video, however, can we get msg sender Lat long.
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.
thanks for the tutorial. but mybot didn't send the message back.
Its not work TypeError: Cannot read property 'postData' of undefined
Hello mate.. Can I able to send a specific telegram channel message into googlesheet thx...
Hi Wim, I would like to take a link of google drive, which a user uploaded via telegram bot. Please help me with your code available. I run several times but it did not deployed yet. Thanks for your help!
Hi Wim, can you share me how to upload photo in Telegram through Google drive photo?
hello, is it possible to make it so each word uses a new cell?
Important change to video: 1. Go to openweathermap.org/api 2. Current Weather Data - click subscribe (not hourly forecast) 3. Under free, click get API key 4. Go to Api keys 5. Copy the weather api key
nice videos bro
every this is correct but not getting first name only i am getting hi
Excellent tutorial, only one question, what explanation would I have, in my case the telegram bot does not update the spreadsheet
Hi, I would like to ask if there is any way to update the URL of an uploaded Ami BOT image using some formula?
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.
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)
Thanks!!
Hello from 2021! Its work!
OMG!!!! its work!!
Hey
Actually I have little bit confused about webAppurl can u help me
Hi Wim, nice to see your still active. Question: it seems that the webhook (deployment) no longer has access option "anyone, even anonymous", so telegram no longer works. Did you find a workaround? Thanks.
Ah! I found a solution (works April 5, 2021), there is a link in the new editor that says "use legacy editor", from there everything is as it was before, including the option "anyone, even anonymous". Hope this helps someone.
@@claudioestevez61 good stuff! Thanks for sharing this :)
You're alive!
Hey! My bot didn't send the message back. I checked the code. Everything seems alright. Please help!
have you run the webhook function?
@@iwansuryo1716 thank youuu
Hey thanks for an awesome video! Is there anyway to use app script to forward massages from one channel to the next?
Wim's , I don't know how you got "var webAppUrl = "script.google.com/macros/s/AKfycba............"
2021 is it still working. My bot once done by following this is not working anymore.
excusme mr. please tell me.whhy. cant sentText to bot telegram. can u tell me why?
Hi! Strange, but after I've added writing to sheet my bot no more send message to me. function doPost(e) { var contents = JSON.parse(e.postData.contents); Logger.log(JSON.stringify(contents)); var chat_id = contents.message.from.id; var name = contents.message.from.first_name + " " + contents.message.from.last_name; var text = contents.message.text; SpreadsheetApp.openById(ssId).appendRow([new Date(), name, text]); sendMessage(chat_id, "Written down."); }
ooops, foun the mistake.
Wim, Nice tutorial! I am getting this when I run getWebhookInfo though last_error_message "Wrong response from the webhook: 401 Unauthorized"
спасибо что ты есть