Thanks for the great video. I also paid for the Chat GPT Pro Template and downloaded it. Question: is there an extra step I need to add the OpenAI tab on the Google Sheet? It says in the Apps Script "execution started" + "execution completed," but when I go to the sheet there's no dropdown menu for OpenAI. Thanks for your insight.
Hi @meganfeeney8410 Thanks for your comment.😊 The Chat GPT Pro template bit.ly/gpt-3-5-turbo-instruct-template does not require any menus in the Google Sheet as it uses a custom function that you can call like any other standard function such as =SUM or =VLOOKUP, for example. Therefore, you just need to enter =GPT followed by a text prompt or cell reference, such as =GPT("Explain how the Google Sheets Query functions works") or =GPT(A2). This video should hopefully help you but the Pro template has a few extra benefits: ruclips.net/video/GngdHILvTXk/видео.htmlsi=KLpUptOsFP-r4z5b
Thanks, glad you liked the video 👍🏻 The error code 429 suggests one of a few things: 1. Rate limit reached for requests - Cause: You are sending requests too quickly. Solution: Pace your requests 2. You exceeded your current quota, please check your plan and billing details - Cause: You have hit your maximum monthly spend (hard limit) which you can view in the account billing section. Solution: Apply for a quota increase. 3. The engine is currently overloaded, please try again later - Cause: Our servers are experiencing high traffic. Solution: Please retry your requests after a brief wait If you're using the free credits, then it could be any of the above, but if you're on a paid plan, it might be related to the third point. I've been using it for some time now, but it's hardly costing me anything, so it's well worth submitting card details on OpenAI to avoid these issues. Make sure you check out this video, it might be a better solution, depending on what your trying to achieve: ruclips.net/video/GngdHILvTXk/видео.html
Hi @nickpt4324 Which template are you trying to use this model with? Please note, it will only work with the latest GPT 4 template. The free version and ChatGPT 3.5 are not capable with any GPT 4 models.
Hi @eliadorigatti9118, Which template and model are you using? Please note that GPT 4 models will only work with the latest GPT 4 template. The free version and ChatGPT 3.5 are not capable of using any GPT 4 models.
hello while you make your own Google bank you can choose you asked him which model he should write with I chose the gpt4 model and I asked it to describe the cleaning to me in PNG but it doesn't work
@@spreadsheetwiseI'm not sure I correctly understood what you mean, do you mean that the gpt4 API can be used but in other applications? Which ?What I wanted to do was ask him to give me an image description, but it doesn't work with gpt4 but with gpt4v?
If you want to try Dall-E 3 for free, a version is available through Microsoft's Bing Image Creator, but this is not available with the FREE version of ChatGPT, only the Plus version with GPT-4. This template is not available with GPT-4, sorry.
Great Video! Im Planning to integrate Google Sheets to GPT, as a Trigger - so whenever there is a new Line for eg. Mail Adress. A specific GPT will take that Mail Adress and creates a Mail. For the Integration i only need my API and the Link to the GPT right? There is no specific API for a Specific GPT?
@@spreadsheetwise Each time I run the script, it says I've got a code 400 error. I was using it in Portuguese, but after changing the request to English, it still shows the same error.
How do you not have a million subscribers?!!!
Top-quality content. Thanks so much.
Maybe one day, spread the word 😉 Thanks for watching!
You might like this How to build a ChatGPT Custom Function in Google Sheets
ruclips.net/video/GngdHILvTXk/видео.html
Thanks for the great video. I also paid for the Chat GPT Pro Template and downloaded it. Question: is there an extra step I need to add the OpenAI tab on the Google Sheet? It says in the Apps Script "execution started" + "execution completed," but when I go to the sheet there's no dropdown menu for OpenAI. Thanks for your insight.
Hi @meganfeeney8410
Thanks for your comment.😊 The Chat GPT Pro template bit.ly/gpt-3-5-turbo-instruct-template does not require any menus in the Google Sheet as it uses a custom function that you can call like any other standard function such as =SUM or =VLOOKUP, for example. Therefore, you just need to enter =GPT followed by a text prompt or cell reference, such as =GPT("Explain how the Google Sheets Query functions works") or =GPT(A2).
This video should hopefully help you but the Pro template has a few extra benefits: ruclips.net/video/GngdHILvTXk/видео.htmlsi=KLpUptOsFP-r4z5b
Subscribed with notifications for that next video. Great content!
Awesome, thank you! 👊🏻
How to build a ChatGPT Custom Function in Google Sheets
ruclips.net/video/GngdHILvTXk/видео.html
You are providing pure value. Waiting for the next vid!
I appreciate that! 👍🏻
Can't wait to see the next video, thank you very much for what you are sharing !
Thanks for watching! 😉
How to build a ChatGPT Custom Function in Google Sheets
ruclips.net/video/GngdHILvTXk/видео.html
Very good video, but when I run the script it gives me error 429, I don't know what to do..
Thanks, glad you liked the video 👍🏻
The error code 429 suggests one of a few things:
1. Rate limit reached for requests - Cause: You are sending requests too quickly. Solution: Pace your requests
2. You exceeded your current quota, please check your plan and billing details - Cause: You have hit your maximum monthly spend (hard limit) which you can view in the account billing section. Solution: Apply for a quota increase.
3. The engine is currently overloaded, please try again later - Cause: Our servers are experiencing high traffic. Solution: Please retry your requests after a brief wait
If you're using the free credits, then it could be any of the above, but if you're on a paid plan, it might be related to the third point.
I've been using it for some time now, but it's hardly costing me anything, so it's well worth submitting card details on OpenAI to avoid these issues.
Make sure you check out this video, it might be a better solution, depending on what your trying to achieve: ruclips.net/video/GngdHILvTXk/видео.html
i get a 404 error
{ "error": { "message": "The model `gpt-4o` does not exist or you do not have access to it.", "type": "invalid_request_error",
Hi @nickpt4324
Which template are you trying to use this model with?
Please note, it will only work with the latest GPT 4 template. The free version and ChatGPT 3.5 are not capable with any GPT 4 models.
"The model `text-davinci-003` has been deprecated" - What model can we use instead?
Please refer to this post for updating the model - bit.ly/older-openai-models-update
it doesn't work, I already tried with new free models but told me I reach out the limit every time (but it's not)
Hi @eliadorigatti9118,
Which template and model are you using?
Please note that GPT 4 models will only work with the latest GPT 4 template. The free version and ChatGPT 3.5 are not capable of using any GPT 4 models.
hello while you make your own Google bank you can choose you asked him which model he should write with
I chose the gpt4 model and I asked it to describe the cleaning to me in PNG but it doesn't work
ChatGPT 4 does not have API endpoints for this type of solution yet; it’s more geared towards chat scenarios
@@spreadsheetwiseI'm not sure I correctly understood what you mean, do you mean that the gpt4 API can be used but in other applications? Which ?What I wanted to do was ask him to give me an image description, but it doesn't work with gpt4 but with gpt4v?
If you want to try Dall-E 3 for free, a version is available through Microsoft's Bing Image Creator, but this is not available with the FREE version of ChatGPT, only the Plus version with GPT-4.
This template is not available with GPT-4, sorry.
@spreadsheetwise no I don't want artificial intelligence to generate images for me but I want it to describe images to me
This sheet isn't the answer for you, but there are lots of videos on RUclips showing how to do this with ChatGPT directly.
Great Video! Im Planning to integrate Google Sheets to GPT, as a Trigger - so whenever there is a new Line for eg. Mail Adress. A specific GPT will take that Mail Adress and creates a Mail. For the Integration i only need my API and the Link to the GPT right? There is no specific API for a Specific GPT?
It's hard to say without knowing the scope of your Apps Script for mailing.
I couldn't find the code script in the website. Could somebody help me with it, please? Maybe sending the link in which the code is...?
You can find the full script on this page towards the bottom www.spreadsheetwise.com/post/how-to-connect-chat-gpt-to-google-sheets#viewer-bp7d6
@@spreadsheetwise Thank you! :)
No problem, make sure you check this video out too - How to use Chat GPT in Google Sheets - Part 2
ruclips.net/video/GngdHILvTXk/видео.html
@@spreadsheetwise Each time I run the script, it says I've got a code 400 error. I was using it in Portuguese, but after changing the request to English, it still shows the same error.
Did you add your api key to the script?
where is the google script?
You’ll find the link in the description, but I’ve added it here for you.
How to connect Chat GPT to Google Sheets: bit.ly/chat-gpt-google-sheets