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

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!

0:00 Intro
0:25 Writing the App Script
7:30 Demo of Formulas in Gsheets

#appscript #googlesheets #openai

[caitlinhathaway]

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

[MithrilbeatzGethisbeatz]

Bro best video no bs straight to point bravo you save me

[alex_strauss]

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

[vincenttetu]

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

[VitaliiVarbanets]

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

[AlexFreixa]

This was very easy to follow and very helpful. 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.

[godogood]

This video was amazing, great work man.

[antonisaskianakis]

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

[MrDschuls]

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!

[good_vibes_]

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

[DennyViko]

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.

[cgc]

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?

[GaryWGrimes]

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?

[charafes]

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.

[ItzMasonChase]

Getting this error message, anyone know why?

"TypeError: Cannot read properties of undefined (reading '0')"

Help is appreciated thanks.

[bilalmosbah]

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?

[jaimeruiz]

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

[cgc]

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 ?

[ProttoyDipto]

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