Wim's Coding Secrets
Wim's Coding Secrets
  • 12
  • 197 981
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...
Super Megaman Bros
Переглядів 933 роки тому
Super Megaman Bros
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

КОМЕНТАРІ

  • @RiteshKumar-gk7pz
    @RiteshKumar-gk7pz 5 місяців тому

    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.

  • @bikrampurkait3786
    @bikrampurkait3786 6 місяців тому

    Thanks sir.

  • @draiver17
    @draiver17 11 місяців тому

    thanks bro ...

  • @yyirex
    @yyirex Рік тому

    can i ask, what should i fill int the var contents if i never send a photo to my bot

  • @Lemonsclement
    @Lemonsclement Рік тому

    i keep getting TypeError: Cannot read properties of undefined (reading 'postData') doPost not sure whats the cause

  • @emmnttvideogamemusic6021
    @emmnttvideogamemusic6021 Рік тому

    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()); }

  • @yulehan6403
    @yulehan6403 2 роки тому

    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.

  • @IndianTalentHunt
    @IndianTalentHunt 2 роки тому

    HI , can we also send messages from Google Sheets to telegram bot by any chance?

  • @rafaelmiranda9237
    @rafaelmiranda9237 2 роки тому

    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.

  • @notificationsls1986
    @notificationsls1986 2 роки тому

    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

  • @wikiplayers9301
    @wikiplayers9301 2 роки тому

    I am not receiving email from telegram bot. Please help me !

  • @afayyub5831
    @afayyub5831 2 роки тому

    Hello mr. Wim How to reply to sender?

  • @VirgoINFP
    @VirgoINFP 2 роки тому

    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"}

    • @РинаЗемерова-э7с
      @РинаЗемерова-э7с Рік тому

      Same! Have you gotten a solution for that when you coded?

    • @bikrampurkait3786
      @bikrampurkait3786 6 місяців тому

      var response = UrlFetchApp.fetch(url + "/setWebhook?url=" + webAppUrl); Previously, it was missing the = sign after url, which resulted in an incorrect URL construction.

  • @wimscodingsecrets265
    @wimscodingsecrets265 2 роки тому

    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

  • @tyr731
    @tyr731 2 роки тому

    Dude email code doesn't work, please fix your code

  • @arun11737
    @arun11737 2 роки тому

    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

  • @medieyunianto7057
    @medieyunianto7057 2 роки тому

    what if i want to fill the spreadsheets data in different column based on telegram text data with comma separator?

  • @mosebonacchi2392
    @mosebonacchi2392 2 роки тому

    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

  • @ShivaSingh-vs4yv
    @ShivaSingh-vs4yv 2 роки тому

    Sometimes i have to upload 4 photos togther? Then what to do

  • @m.ibnuwildan264
    @m.ibnuwildan264 2 роки тому

    { "name": "Exception" }

  • @AakashGuptaAaky
    @AakashGuptaAaky 2 роки тому

    Hi.. I am not getting any email when I am giving input into Bot.

  • @AakashGuptaAaky
    @AakashGuptaAaky 2 роки тому

    Hi there.. I am not getting any email when i am sending input to bot, working on new updated app script.. Please help.

  • @talibabbas6518
    @talibabbas6518 2 роки тому

    Thanks for the video, however, can we get msg sender Lat long.

  • @khosroueghsh
    @khosroueghsh 2 роки тому

    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.

  • @ciliboh
    @ciliboh 2 роки тому

    thanks for the tutorial. but mybot didn't send the message back.

  • @Fenix-pw6xh
    @Fenix-pw6xh 3 роки тому

    Its not work TypeError: Cannot read property 'postData' of undefined

  • @noobtoob6297
    @noobtoob6297 3 роки тому

    Hello mate.. Can I able to send a specific telegram channel message into googlesheet thx...

  • @tiendang9371
    @tiendang9371 3 роки тому

    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!

  • @tiendang9371
    @tiendang9371 3 роки тому

    Hi Wim, can you share me how to upload photo in Telegram through Google drive photo?

  • @isaacmagalhaes7279
    @isaacmagalhaes7279 3 роки тому

    hello, is it possible to make it so each word uses a new cell?

  • @wimscodingsecrets265
    @wimscodingsecrets265 3 роки тому

    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

  • @wwidestories9680
    @wwidestories9680 3 роки тому

    nice videos bro

  • @prashantchouhan5649
    @prashantchouhan5649 3 роки тому

    every this is correct but not getting first name only i am getting hi

  • @frankematheusr6545
    @frankematheusr6545 3 роки тому

    Excellent tutorial, only one question, what explanation would I have, in my case the telegram bot does not update the spreadsheet

  • @armare.i.r.l4561
    @armare.i.r.l4561 3 роки тому

    Hi, I would like to ask if there is any way to update the URL of an uploaded Ami BOT image using some formula?

  • @sanjeevdosi4983
    @sanjeevdosi4983 3 роки тому

    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.

    • @sebastianomarchesini
      @sebastianomarchesini 2 роки тому

      Same problem. did you solve it ?

    • @sanjeevdosi4983
      @sanjeevdosi4983 2 роки тому

      @@sebastianomarchesini Couldn't move ahead. Sorry.

    • @sebastianomarchesini
      @sebastianomarchesini 2 роки тому

      @@sanjeevdosi4983 I use a webhook and after is working. Try with other videos ;) ua-cam.com/video/pV1Jt3fjcq8/v-deo.html

    • @sanjeevdosi4983
      @sanjeevdosi4983 2 роки тому

      @@sebastianomarchesini Thanks a lot Buddy. Will revert after having a look.

  • @HomeAce
    @HomeAce 3 роки тому

    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)

  • @aleksandramalakutsko401
    @aleksandramalakutsko401 3 роки тому

    Thanks!!

  • @aleksandramalakutsko401
    @aleksandramalakutsko401 3 роки тому

    Hello from 2021! Its work!

  • @aleksandramalakutsko401
    @aleksandramalakutsko401 3 роки тому

    OMG!!!! its work!!

  • @claudioestevez61
    @claudioestevez61 3 роки тому

    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.

    • @claudioestevez61
      @claudioestevez61 3 роки тому

      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.

    • @wimscodingsecrets265
      @wimscodingsecrets265 3 роки тому

      @@claudioestevez61 good stuff! Thanks for sharing this :)

  • @bansinxxx
    @bansinxxx 3 роки тому

    You're alive!

  • @snehashukla4415
    @snehashukla4415 3 роки тому

    Hey! My bot didn't send the message back. I checked the code. Everything seems alright. Please help!

  • @HomeAce
    @HomeAce 3 роки тому

    Hey thanks for an awesome video! Is there anyway to use app script to forward massages from one channel to the next?

  • @hermancamacho4230
    @hermancamacho4230 3 роки тому

    Wim's , I don't know how you got "var webAppUrl = "script.google.com/macros/s/AKfycba............"

  • @dcs-hmi-plc-scada8205
    @dcs-hmi-plc-scada8205 3 роки тому

    2021 is it still working. My bot once done by following this is not working anymore.

  • @alexkusuma8228
    @alexkusuma8228 3 роки тому

    excusme mr. please tell me.whhy. cant sentText to bot telegram. can u tell me why?

  • @megadrigter
    @megadrigter 3 роки тому

    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."); }

  • @crystalbot8134
    @crystalbot8134 3 роки тому

    Wim, Nice tutorial! I am getting this when I run getWebhookInfo though last_error_message "Wrong response from the webhook: 401 Unauthorized"

  • @apolisk
    @apolisk 3 роки тому

    спасибо что ты есть