วีดีโอ

this is genius

Hello

Is there a way to set up a testing form, that with each new participant entering their details creates a new doc for them with their responses recorded beneath each question?

Thanks a lot! Just what I needed.

What if you want to enter a link in the form as a response to a question and the response gets posted as plain text in the doc?

Hello, why you use app script ? not just an add on ?

Do Sidebars appear in Google Sheets mobile app?

Does running this script have any negative effects on your domain sender reputation or deliverability?

so no more free script?

This is an old video does this script still work? I've been looking for a way to do this that won't keep sending automated replies. I love how you say you added a label so this doesn't happen.

I hope you make more vidéo in future, thanks alot

Thanks

Hey, thank you for your efforts I wonder if you could make a video About how to create a Chrome extension to translate images online, such as Yandex Translator, which can translate the entire page and the images on it I'm wondering how to build a Chrome extension that can translate manga images online.Thank you very much for all your videos.

thank you, very informative!

Hi my code is getting executed but in word document when we merge headers that is getting clear when we run the code. Can you let me know what can be the issue.

14:48 Info for uuid not showing up, only the notice. How to show it please?

Exciting news! I've developed a handy tool for small business owners who want to streamline their email responses without the need for technical skills. Now, you can effortlessly set up customized auto-responses based on your specific business needs. Check out the details on my website: : benronkin.com/products/targeted-auto-responder.html

Could you produce a tutorial video demonstrating how to automate the creation of PDF salary slips for employees using Google Sheets and Apps Script? I lack coding skills, so could the script be designed to instruct ChatGPT to generate the slips? Additionally, it would be beneficial if employees could conveniently access their monthly salary online. Thank you 🙏😊

Nice! One of the best AppsScript demos. Nice job!

Hi Ben, I have built the bot as explained in the video and your blog. However I am getting error with processUpdate function. When I deploy the script, bot keeps responding "please try again". Could you update the script and share us please? 😊

Hello sir, please I would be greatful if the html and error handling codes could be shared with me. I love to extend on Google products as well as Microsoft. I am good at VBA Event driven procedures. I am a novice at App scrip. Thank you.

Have you ever gotten this error? error: { "message": "Incorrect API key provided: undefined. I have triple-checked that my API key is correct and I even created new keys to test it, yet I continue getting this error message.

THANK YOU so much for this... I have been trying to do this for years and years and didn't get it ... before Apps Script even.

if you could help to share with us the file include whole script for the code.gs, index.html, and error.html that would be great. Because I'm very bad at coding and I dont know the exact place to put each part of the code. Thank a lots for the video Ben!

hi Ben, is it possible to do a video on how to automate out of office email when theres and event in you google calendar for being out of office.

Sorry, but your video is blurry.

Ben, thanks for the video! Tell me, do you have a project on Google Apps Script to convert an audio file into text, using Whisper from OpenAI? If so, can you share the minimum working code as an example?

submit button is not working from mobile email app.Pls share to me if any solution to fix. Thanks

Thank you so much! This was so valuable.

This means we can also pull the Google Analytics data using ChatGPT and then ask it to analyze that data and generate insights?

Very useful

This video is in desperate need of key moments set up.

Do you happen to have a timer that runs when a button is selected? How does it work even when on idle?

Script I want to learn

if the time runs out, will the form automatically submit?

This is great. Any hints on how to do a full page of labels for each recipient?

Do you offer this service?

Hi. It was hard to find your video again. Please add "mail merge with a preview" into your title. That will help the other people to find it. Thank you so much for the video.

Can we create timer for each question

The idea is awesome, I love it!

Boa noite amigo, coloque a tradução👍

I am trying this. If it works as expected I will give you a thumbs-up! :-) ... Alternately can we automate this into some Google form add-on to avoid all the coding?

When you mean removing header and data splice at 14.49, is that the "Summary"? Trying to understand since my file has like 5 rows I do not need, so not sure if you removed first column, or first row or both?

would it be possible to create like addon for gmail or google sheet that is available when we are in the gmail interface or google sheet , not tied to a specific sheet. would be a good video if you walk us through the process

This is amazing and just what I am looking for. Is there access to the code where I can enter my own credentials to make the magic happen on my end?

I would love to see a video on how to create and use a form that submits to a google sheet. Anyone?

I was also getting the same authentication error yesterday that you have shown here. I will retry with the code however in my case when I was opening the link given by google search console api, it shows me that project id do not exist.

great work , really mazing

Can you create a program like calling openai inside google data studio (data looker) and analyse the search console traffic for seo purposes? I think we will need appscript for that but I don’t understand how I will send data of search console from google data looker to openai to get response

Hey, thanks for the class, loved the way you approached it, great didatics! I did the whole process but, when I hit run, instead of receiving the text generated in the console.log I get an Error of invalid API Key, even though I double checked the API key and the property details and it is accurate. Note that the error I'm getting is not the one we've thrown on the code, which would be for a 'missing API key', but I guess it's something related to the scriptProps, any ideas on what should I try?