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

Пікірлер: 52

  • @bechalyn
    @bechalyn25 күн бұрын

    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
    @ScampMichael8 ай бұрын

    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!

  • @jdavis6650
    @jdavis6650 Жыл бұрын

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

  • @ExcelGoogleSheets

    @ExcelGoogleSheets

    Жыл бұрын

    👍

  • @joanneosborne2428
    @joanneosborne2428 Жыл бұрын

    This was a great tutorial. Thank you!

  • @rizalitobartolinijr.
    @rizalitobartolinijr.2 ай бұрын

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

  • @ryanibarrientos2959
    @ryanibarrientos29598 ай бұрын

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

  • @onderex
    @onderex Жыл бұрын

    Finally somebody started from simple. Thank you very much!

  • @TilakConrad
    @TilakConrad11 ай бұрын

    another superb tutorial - congratulations and thanks for all you do

  • @dagnabit2020
    @dagnabit20209 ай бұрын

    Wow this is life changing! Thank you so much,

  • @JohnDeir
    @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

  • @JohnDeir

    @JohnDeir

    Жыл бұрын

    Oh and I forgot very good tutorial thanks a lot.

  • @ExcelGoogleSheets

    @ExcelGoogleSheets

    Жыл бұрын

    👍

  • @juanparra1150
    @juanparra115010 ай бұрын

    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

  • @The_Benjamins
    @The_Benjamins Жыл бұрын

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

  • @CustAndCode
    @CustAndCodeАй бұрын

    pretty nice! 😀

  • @saurabhdas7724
    @saurabhdas772410 ай бұрын

    You are the Best in whole KZread

  • @JerryEduardo
    @JerryEduardo Жыл бұрын

    Amazing!

  • @KE010101
    @KE010101 Жыл бұрын

    Very good!

  • @ivanurbina2422
    @ivanurbina242210 ай бұрын

    AWESOME!!!

  • @MrLittletube
    @MrLittletube11 ай бұрын

    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 😂

  • @user-qr7mt1hl4t
    @user-qr7mt1hl4t3 ай бұрын

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

  • @passiveincome9460
    @passiveincome9460 Жыл бұрын

    Thank you for u tutorial

  • @academiaclics
    @academiaclics Жыл бұрын

    you rock!

  • @anarabbasov7600
    @anarabbasov7600 Жыл бұрын

    Very nice

  • @mrashid229
    @mrashid229 Жыл бұрын

    Unbelievable! 😲

  • @PodcastCartel
    @PodcastCartel Жыл бұрын

    You’re great

  • @omprakashsrivastava3920
    @omprakashsrivastava3920 Жыл бұрын

    Very good sir

  • @gustavocampos4797
    @gustavocampos4797 Жыл бұрын

    TOOP!

  • @ManojGuptahome
    @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.

  • @anarabbasov7600
    @anarabbasov7600 Жыл бұрын

    Hi. Can you create a dynamic page? When you change the number on the Sales page, the number on the Bacup page should also change.

  • @ExcelGoogleSheets

    @ExcelGoogleSheets

    Жыл бұрын

    Theoretically possible if you make the whole backup with formulas.

  • @scuzzyboy
    @scuzzyboy11 ай бұрын

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

  • @AthlitikoSteki
    @AthlitikoSteki4 ай бұрын

    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

  • @gasia112
    @gasia1124 ай бұрын

    What about cost? Does it hase free daily use?

  • @Electric-Bob
    @Electric-Bob8 ай бұрын

    Teacher... miss your videos

  • @AnshulMarele-gbaa
    @AnshulMarele-gbaa2 ай бұрын

    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

  • @SD-rg5mj
    @SD-rg5mj11 ай бұрын

    hello is it possible to do the same thing with another artificial intelligence? thank you very much for your videos

  • @TomWien
    @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 :(((

  • @ExcelGoogleSheets

    @ExcelGoogleSheets

    Жыл бұрын

    It's ultimately a super powerful autocomplete combined with search. If there was no example of code like that written before, it's unlikely to give you what you want.

  • @Lyresh-rr8se
    @Lyresh-rr8se Жыл бұрын

    Can we use codes in chatgpt with using modals?

  • @vampy5071
    @vampy5071 Жыл бұрын

    Is it possible if you could do a tutorial on how to take only the units of a number, and not the tens or hundreds, thoudands? So say theres a cell with 152, and I wish to take only the 2 and add it to another cell, how would I go about achieving this? Thankyou

  • @RegassaTheRegassa

    @RegassaTheRegassa

    Жыл бұрын

    Use the function "=RIGHT(Cell, 1)", so you only the take the last (right) number, in this case the unit

  • @vampy5071

    @vampy5071

    Жыл бұрын

    @@RegassaTheRegassa Oh wow!Thank you so much, thats a huge help for me 🥰

  • @Electric-Bob
    @Electric-Bob Жыл бұрын

    Teacher... what are your Personal Thoughts on ChatGPT?

  • @ExcelGoogleSheets

    @ExcelGoogleSheets

    Жыл бұрын

    You can write code faster with it if you know what you're doing. It can also be a giant waste of time otherwise.

  • @bobmastermotovlog
    @bobmastermotovlog Жыл бұрын

    OMFG

  • @HelicopterShark
    @HelicopterShark4 ай бұрын

    Just clear your code and use the copy code button. Don't do something unnecessary like copying all but the first and last name. To easy for a new user to miss a character and the code doesnt work

  • @nagaming30
    @nagaming30 Жыл бұрын

    How to connect chatgpt to Google sheet?

  • @ExcelGoogleSheets

    @ExcelGoogleSheets

    Жыл бұрын

    Sign up and use the paid API.

  • @bathindamis2419
    @bathindamis24196 ай бұрын

    send me the code sir pls

  • @lleayyea
    @lleayyea7 ай бұрын

    Saya yakin khaby lame pasti tertawa melihat ini.