Use ChatGPT in Google Apps Script

Thank you so much! This was so valuable.

Boa noite amigo, coloque a tradução👍

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?

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?

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?

Great work!!!👍
Please how do I implement access control to the app script and keep some users from accessing the script details.
Thanks

How do you push it o to the AAppsScript IDE? Have you got some kind of keyboard shortcuts for clasp?

How do I turn this into an add on for the extension marketplace

Ben - Great Stuff. I implemented all of it and it was working really well. Then I encountered an issue of the App Starting and Completing in a second without it delivering an output. I can't figure out why it's not performing now when it was yesterday. Changed API and went over it. Any tips? Love the videos and for a nub like me so helpful.

Could chatgpt write most of the appscript code?

Subscribed, value added content 💯

Mind blowing. Thankyou