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 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?
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!
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))
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
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?
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?
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
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.
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 ?
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.
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?
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?
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. 🤷🏾♂
@@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 👍👍
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.
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
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?
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
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))
Sorry it doesn't works : TypeError: Cannot read properties of undefined (reading '0')
The problem stops as soon as you buy some credits from OpenAI
Error
TypeError: Cannot read properties of undefined (reading '0')
GPT @ Code.gs:32
I think this is related to BASEURL.. Did you solve it?
@@John-jt3dn Same, did you find a solution?
The problem stops as soon as you buy some credits from OpenAI
I added credits but I still haven’t figured out how to get past that code.
This was very easy to follow and very helpful. Thanks!!
no, this method is much more difficult than when you use a module and copy and paste your 10-digit key
how can I integrate customised assistants of openai with google sheets?
Thank you so much, this has been so unbelievably helpful and easy to get started!
Thanks for watching :) good luck 👍
I keep getting this error
TypeError: Cannot read properties of undefined (reading '0')
GPT @ Code.gs:32
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.
not a coder here - can you suggest how to edit the text I have the same issue @@Hitchon
@@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?
I encounter exactly the same problem - with longer or shorter promts. Is there any way out?
Same, did you find a solution?
Getting this error message, anyone know why?
"TypeError: Cannot read properties of undefined (reading '0')"
Help is appreciated thanks.
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!
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))
This was very helpful!@@Hitchon
how to avoid time exucuting error? I want to write bulk content
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
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?
An't believe it has only 1.2k views. Great job
this has been super helpful !
now I can nerd out on using gpt, store data an google sheets using ai and automation
Error
TypeError: Cannot read properties of undefined (reading '0')
console.log(response.choices[0].message.content);
If you are debugging, then remove the 'Input' parameter from function 'function GPT() {'
then, add first line var Input = "YOUR PROMPT HERE"
The problem stops as soon as you buy some credits from OpenAI
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?
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
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.
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 ?
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.
first, i need to add GPT for sheet extension, right?
Hey no need to add that.
@@Hitchon It's my misunderstanding. Sometimes I turn on GPT for the sheet extension, and it uses that instead of my API.
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?
Error unknown function
I've copy the script. The formula it isn't visible in drive when i enter +GPT or =GPT. Why is this happen¿?
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?
Yh the get the same, when i run it in App script it self it seems to work. but not in sheets
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. 🤷🏾♂
@@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 👍👍
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.
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!
I would like to use my own fine_tuned_model. Can I just put my "ft:gpt-3.5-turbo-0613:........ " information as "model" : ?
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
Hey Bro. Can open source llm be used instead of open ai?
Very cool, thanks. Hey is it possible to make it so that gpt accesses the web and returns responses to Google sheet?
Yes that should be possible do you have a specific use case here. If so I can look into making a tutorial on this
Bro best video no bs straight to point bravo you save me
nice!! any idea how to get around the completion rate limiting? keep getting errors when I do stuff in bulk
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?
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
This video was amazing, great work man.
does it work with google document
Yes google app script works nicely with google docs and google slides as well. I have even used this to write bullets for slides
How can I ask to analyze multiple cells? for example a table with data?
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))
Really helpful video. Thank you.
This worked great! Thank you!
You're amazing!!!
Thank you for the support. U are amazing too
I owe you a beer!!!! Thank you very much
Haha thanks Jamie glad it was helpful:)
it worked ! thanks
Awesome! I'll send you a mocha coffee. thanks
Thanks a million. Wow~
Thank you!
Thank you sir
Wow. Just wow.
some wierd shit with limits. Paid $5 but still free tier with 3 requests per minute
but thank you for a good method
problem was fixed by support, it was a bug
Getting this error - TypeError: Cannot read properties of undefined (reading '0') (line 32).
The problem stops as soon as you buy some credits from OpenAI
Thank you!