Connecting OpenAI GPT-4 with Google Sheets (Google Apps Script)

Рет қаралды 9,124

Күн бұрын

In this tutorial, we dive into the integration of OpenAI's latest model, GPT-4, with Google Sheets using Google Apps Script. We get our api key, open app script and do the basic setup!
Github code link: github.com/hitchon1/google_sc...
0:00 Intro
0:25 Writing the App Script
7:30 Demo of Formulas in Gsheets
#appscript #googlesheets #openai

Пікірлер: 74

@alex_strauss 11 күн бұрын

this has been super helpful ! now I can nerd out on using gpt, store data an google sheets using ai and automation

@caitlinhathaway 5 ай бұрын

Thank you so much, this has been so unbelievably helpful and easy to get started!

@Hitchon 5 ай бұрын

Thanks for watching :) good luck 👍

@pngnyc 8 күн бұрын

This worked great! Thank you!

@AlexFreixa18 3 ай бұрын

This was very easy to follow and very helpful. Thanks!!

@cgc2300 Ай бұрын

no, this method is much more difficult than when you use a module and copy and paste your 10-digit key

@godogood5712 Ай бұрын

This video was amazing, great work man.

@VitaliiVarbanets 6 ай бұрын

An't believe it has only 1.2k views. Great job

@ivanseife 3 ай бұрын

Really helpful video. Thank you.

@CamilleChang-df5mi 2 ай бұрын

it worked ! thanks

@TheLoneCamper Ай бұрын

I just use the Google Apps Script GPTs to create any script. Great tutorial, though. Will definitely help getting better results faster now that I understand a few basics.

@kimjunoh1 3 ай бұрын

Thanks a million. Wow~

@ipistsov 5 ай бұрын

Thank you!

@williammelo4800 2 ай бұрын

Wow. Just wow.

@vincenttetu757 8 ай бұрын

Sorry it doesn't works : TypeError: Cannot read properties of undefined (reading '0')

@rveronez 4 ай бұрын

The problem stops as soon as you buy some credits from OpenAI

@0koreanssam0 8 ай бұрын

Thank you sir

@st.3m906 3 ай бұрын

You're amazing!!!

@Hitchon 3 ай бұрын

Thank you for the support. U are amazing too

@jaimeruiz7096 4 ай бұрын

I owe you a beer!!!! Thank you very much

@Hitchon 4 ай бұрын

Haha thanks Jamie glad it was helpful:)

@elkingold 6 ай бұрын

Awesome! I'll send you a mocha coffee. thanks

@MrDschuls 4 ай бұрын

Very helpful video, thank you! Did you create your Google Slide builder yet? Would be keen to know how to make this work for Slides!

@antonisaskianakis8367 7 ай бұрын

Error TypeError: Cannot read properties of undefined (reading '0') GPT @ Code.gs:32

@John-jt3dn 5 ай бұрын

I think this is related to BASEURL.. Did you solve it?

@HarisRehman 4 ай бұрын

@@John-jt3dn Same, did you find a solution?

@rveronez 4 ай бұрын

The problem stops as soon as you buy some credits from OpenAI

@zachtatum457 3 ай бұрын

I added credits but I still haven’t figured out how to get past that code.

@user-ib8qm8eh3q 4 ай бұрын

Hey Bro. Can open source llm be used instead of open ai?

@DennyViko 2 ай бұрын

Thank you for your brief tutorial. I have a question, how to handle secret api key outside the script like an env file. And if i want to make this script can be use by other people but they need to input their own API key, what choice should i choose in the deployment setting. Thanks again.

@GaryWGrimes 2 ай бұрын

Awesome script! Works beautifully. One issue I run into is that it runs again each time the sheet loads, replacing an existing response with a new one and unnecessarily using api tokens. For my use case, I need the text generated only once and then saved as static text to a cell where it will not be overwritten. Any ideas on modifying the script for this use case?

@charafes3874 3 ай бұрын

Hello, thank you for the video. The code is functioning well for me! Is there any possibility to integrate the OpenAI Assistant API instead of the default language models? I have a considerable amount of data already uploaded into the Assistant, and I want Google Sheets to access it for reference.

@adamfachler 7 ай бұрын

Even with very short GPT prompts, I can't get it to read multiple rows. On Google Sheets, I'm calling upon 65 rows of exercises to build a workout: =GPT("Build a workout from these movements."&(B1:B65)) Any ideas? It just returns data from the first cell. Thanks so much!

@Hitchon 7 ай бұрын

Hi Adam, I never really designed this to work with multiple rows but I have a suggestion that may be a good workaround. Try this =GPT(“Build a workout from these movements. ” & TEXTJOIN(“ “, TRUE, B1:B65))

@adamfachler 7 ай бұрын

This was very helpful!@@Hitchon

@bilalmosbah3247 2 ай бұрын

This is very helpful for working inside the google sheets, I have question about app script, so i'm tring to receive data from a platfrom to google sheets, The platfrom requires crc_token and 200 respnse. After using chatGPT to write the code and deploying the project as a web app then pasting the URL to the platfrom (Receipt link) it didn't work, Is is posibble to use app script for webhooks or no?

@cgc2300 Ай бұрын

This method is much more complicated than the other method which consists of copying and pasting the key into a module, are there any differences in using this method?

@good_vibes_20 3 ай бұрын

def worked, error code appears in debugging go back to his video he shows you how to add a variable to test it, remove the variable hit hte little save button and it should work through your API, make sure your api is loaded for a few minutes, mine kind of glitched out for 30 minutes or, took me a little while to get it to work but it's def possible

@danielwallace5799 9 ай бұрын

nice!! any idea how to get around the completion rate limiting? keep getting errors when I do stuff in bulk

@Hitchon 9 ай бұрын

Hey! I can look into this for a future video. My guess would be to make a more efficient formula so perhaps making an array formula. I was curious to hear more what your use case was and approximately the amount of rows you are dealing with?

@danielwallace5799 9 ай бұрын

10k rows in google sheets, doing a bulk title tag optimization for all my blog posts. your script doesn't seem to be jamming up actually though, it was all the other options I tried@@Hitchon

@ItzMasonChase 3 ай бұрын

Getting this error message, anyone know why? "TypeError: Cannot read properties of undefined (reading '0')" Help is appreciated thanks.

@d-codify 5 ай бұрын

Very cool, thanks. Hey is it possible to make it so that gpt accesses the web and returns responses to Google sheet?

@Hitchon 4 ай бұрын

Yes that should be possible do you have a specific use case here. If so I can look into making a tutorial on this

@MdAlAmin-xj1km 4 ай бұрын

how to avoid time exucuting error? I want to write bulk content

@Hitchon 4 ай бұрын

If the content is very large you may need to look at other options combined with google sheets. One suggestion is maybe make.com I have had trouble as well in the past with this and used make.com and then passed the output into google sheets

@Videodecumple 8 ай бұрын

I would like to use my own fine_tuned_model. Can I just put my "ft:gpt-3.5-turbo-0613:........ " information as "model" : ?

@Hitchon 7 ай бұрын

You should be able to add fine tune models. Admittedly I haven’t had a chance to really dive into fine tuned models and test them in appscript but something I will be trying out in future videos

@SimoneGrisorio 28 күн бұрын

How can I ask to analyze multiple cells? for example a table with data?

@SimoneGrisorio 28 күн бұрын

Using chat GPT I found a workaround to select multiple cells at the same time to analyze a table with data. You can use the function TEXTJOIN in the google sheet formula. EXAMPLE: =GPT("what's the date with less session?" &TEXTJOIN("; "; TRUE;A2:B27))

@gasia112 Ай бұрын

first, i need to add GPT for sheet extension, right?

@Hitchon Ай бұрын

Hey no need to add that.

@gasia112 Ай бұрын

@@Hitchon It's my misunderstanding. Sometimes I turn on GPT for the sheet extension, and it uses that instead of my API.

@user-kb4sf6yx7d 4 ай бұрын

Getting this error - TypeError: Cannot read properties of undefined (reading '0') (line 32).

@rveronez 4 ай бұрын

The problem stops as soon as you buy some credits from OpenAI

@miguelcanonunez611 8 ай бұрын

I've copy the script. The formula it isn't visible in drive when i enter +GPT or =GPT. Why is this happen¿?

@Hitchon 8 ай бұрын

Hi there I can’t say for sure what your issue is but a few possibilities did you save everything, and enter api key , also is the function name GPT and not something else?

@rexgyasi7746 7 ай бұрын

Yh the get the same, when i run it in App script it self it seems to work. but not in sheets

@rexgyasi7746 7 ай бұрын

so it seems to be related to permission issue although i had already gave it permission, to resolve this i recreated the spreadsheet as new and recreated the function in the new sheet run in app script to prompt me the permission again > allowed. then refresh the spread sheet, the formula started to work although it wasn't visible. 🤷🏾‍♂

@Hitchon 7 ай бұрын

@@rexgyasi7746 hey that makes sense that it was a permission issue the first time an app script is run a permission window will pop up. Thanks for finding this and posting your solution. Glad you were able to get it to work 👍👍

@ProttoyDipto 7 ай бұрын

I keep getting this error TypeError: Cannot read properties of undefined (reading '0') GPT @ Code.gs:32

@Hitchon 7 ай бұрын

Seems like you are getting some error with the array not having a 0 element. I suggest trying maybe to console.log(response) and see if you get valid output.

@antonisaskianakis8367 7 ай бұрын

not a coder here - can you suggest how to edit the text I have the same issue @@Hitchon

@Hitchon 7 ай бұрын

@@antonisaskianakis8367 Hey both! I’m not too sure myself yet on the fix here. I was wondering are you guys getting this with all prompts even if it is short? Or just certain longer prompts?

@cd38plus 5 ай бұрын

I encounter exactly the same problem - with longer or shorter promts. Is there any way out?

@HarisRehman 4 ай бұрын

Same, did you find a solution?

@cgc2300 Ай бұрын

Bonjour j'ai vu une vidéo où c'est beaucoup plus simple car c'est une simple clés gpt à 10 chiffres à copier-coller, est-ce que tu peux m'expliquer pourquoi cette méthode est différente ?