Automate Google Sheets with Chat GPT Macros & Apps Script

How to automate Google Sheets using Apps Script macros generated by with Chat GPT?

#googlesheets #chatgpt #appsscript

[bechalyn]

This is one of those beautiful life moments where you have a very specific question with specific parameters and you find the youtube video that answers you perfectly

[ScampMichael]

Thanks! Just what I needed to get me to dive in. Your incremental progression in bite-size pieces made it very easy to digest. Great teacher!

[juanmikael]

Your tutorials are great man. Appreciate it. 😊

[onderex]

Finally somebody started from simple. Thank you very much!

[juanparra]

dios mio, que genialidad, llevo bastante tiempo tratando con appsheet y desde que vi la funcionalidad de chatgpt no dejo de darme vueltas en la cabeza si todo esto iba a poder asociarse

[JohnDeir]

I'm no coder but I got chat GPT to write a script to insert data from my Google Calendar into Google sheet and update when there are changes. I can see that this is going to help a lot

[jdavis]

As always, you never disappoint. Thanks for the inspiration!

[rizalitobartolinijr.]

Yey. Thank you for this kind of videos... I was really able to practice creating my own macros. Thanks!

[MrLittletube]

I’ve been doing this for a few weeks now. Creating ever more complicated scripts for my work data. The sheets i made at work to control the inventory and sales data are a million times better and almost fully automated. It’s opened up a whole new world to me. I know nothing about coding though. I didnt know there was a possibility i could potentially copy and paste a code that delete my files. Shitting myself now 😂

[TilakConrad]

another superb tutorial - congratulations and thanks for all you do

[ryanibarrientos]

Very helpful as always. Very clear and easy to digest. Great Teacher!

[The_Benjamins]

I will have to try this on any future App Script projects

[dagnabit]

Wow this is life changing! Thank you so much,

[qrmthlt]

I am not a coder, but this video made me to do coding with the help of chat gpt

[scuzzyboy]

Thanks for sharing this knowledge to us. Do you have a sample script that it will run the import file function within app script?

[ManojGuptahome]

🤫Thank! I have been using your earlier videos to write basic macros. They have really impressed me taught a lot and also helping a lot of other people in no profit service oriented places like RWA's etc. The introduction of AI has been very interesting to me like many others.
I followed this video to generate code using CHATGPT. At one place where CHATGPT was asked about clearing data leaving the heading line, It got confused and did not give code however in third attempt it did work normally.
I would appreciate if you could give a video of AI scanning through whatsapp messages for a particular text and reporting to me, since google has triggers.

[AnshulMarele-gbaa]

How to give Individual Worksheet View, Edit & download Access to Specific Email in one Google Sheet Workbook?

For example: Sheet1 can be viewed, edited & downloaded by Mr. A only,  
Sheet2 can be viewed, edited & downloaded by Mr. B only, likewise

[AthlitikoSteki]

I tried your first example in a Google sheet but when i am going to run the script in Google Apps Scipt i am getting an error : "Exception: The number of rows in the data does not match the number of rows in the range. The data has 5 but the range has 1."
Additionally chatGPT doesnt give me the same code as in your video. I use chatGPT 3.5

[gasia]

What about cost? Does it hase free daily use?

[TomWien]

Thank you as usual.

I tried this (chatGpt) to "help" me to display pictures in a web-app providing a simple version from one of your web-app series's.
I/Chatgpt failed as well :(((