I just tried it. For viewers here. this Google Sheet ADDON needs a PREMIUM ChatGPT account/API. Otherwise, it wont work. Biggest cons so far is that it generates pretty damn slow. Using GPT 3. GPT 4 didnt work since because it says "High latency in selected OpenAI model".
It's Davinci by default, which is the only one I'm gonna use, so I haven't looked too far into switching yet haha sorry I'll update you if I find out quickly
I have tried but the response was unknown function gpt. Why this happen? Is it because i am still using free gpt or not premium? Also i remember this formula is difference than the official gpt released video. Correct me if im wrong and please help! Thank u
Amazing video!! But, I'm getting: "Exceeded maximum execution time (line 0)." many times for using the function =GPT(A1:A2,,1).. My purpose is to automate the writing of product descriptions like this. I have ChatGPT plus, but I think the error is more Google Sheets related.. Any advice?
@@nate_mccallister it's an error related to Google sheets.. 🙄 The developer of this addon will try to fix this issue permanently in the April update.. For now, I'll just ask chatgpt to write the plugin for me inside Microsoft Excel 🤣
The only issue will be that the formulas won't work because you'll have to activate the GPT access in the app. You can use it though and make a copy docs.google.com/spreadsheets/d/1uGTj-eZ1UAs72SbyPyaBsY9mQ66M5o0sJ548D70OxJ8/edit?usp=sharing. The formulas won't be there is the only problem.
@@nate_mccallister thanks so much, it's a good template if you want to create titles and metas for posts and then even more based upon that. I wonder how did you create the slugs so that unnecessary words like "with" or "by" are removed ? I'm asking cause with some plugin all this data could be imported into wordpress and create posts or pages on steroids.
That spreadsheet is actually just the raw data output from my existing posts. I use a tool called WP Sheet Editor to export posts and pages, edit them in spreadsheets and then import them to be updated on my site. It’s a super cool tool but no one seems to care whenever I talk about it 😂
Do you need to have a GPT Plus subscription plan for this? Because it says Error: your OpenAI free trial is expired or inactive. Please set up a paid account on OpenAI dashboard:
I keep get this error "ScriptError: Authorization is required to perform that action." when I try to set the API key in Google sheet. What could be the problem?
Incredibly useful, thanks Nate!
I just tried it. For viewers here. this Google Sheet ADDON needs a PREMIUM ChatGPT account/API. Otherwise, it wont work.
Biggest cons so far is that it generates pretty damn slow. Using GPT 3. GPT 4 didnt work since because it says "High latency in selected OpenAI model".
Nice video ! How do you change the model you are using?
It's Davinci by default, which is the only one I'm gonna use, so I haven't looked too far into switching yet haha sorry I'll update you if I find out quickly
@@nate_mccallister oh good to know I thought it was on the fastest but cheapest one
I have tried but the response was unknown function gpt. Why this happen? Is it because i am still using free gpt or not premium? Also i remember this formula is difference than the official gpt released video. Correct me if im wrong and please help! Thank u
Did you add the API and it said that? The formula has to be exact as well or it won’t work.”
Amazing video!! But, I'm getting: "Exceeded maximum execution time (line 0)." many times for using the function =GPT(A1:A2,,1).. My purpose is to automate the writing of product descriptions like this. I have ChatGPT plus, but I think the error is more Google Sheets related.. Any advice?
Hey, do you have a cap set on your API budget? It’s likely going past your $18 free credits if not.
@@nate_mccallister it's an error related to Google sheets.. 🙄 The developer of this addon will try to fix this issue permanently in the April update.. For now, I'll just ask chatgpt to write the plugin for me inside Microsoft Excel 🤣
@@nate_mccallister basically what I found: Google sheets allows 30 seconds for formulas, until you get this error.
Why does it keep saying my paid account is not paid when I set the API Key?
Hi, very nice explanation. Is is possible to see or get your seo sheet as a template?
The only issue will be that the formulas won't work because you'll have to activate the GPT access in the app. You can use it though and make a copy docs.google.com/spreadsheets/d/1uGTj-eZ1UAs72SbyPyaBsY9mQ66M5o0sJ548D70OxJ8/edit?usp=sharing. The formulas won't be there is the only problem.
@@nate_mccallister thanks so much, it's a good template if you want to create titles and metas for posts and then even more based upon that. I wonder how did you create the slugs so that unnecessary words like "with" or "by" are removed ? I'm asking cause with some plugin all this data could be imported into wordpress and create posts or pages on steroids.
That spreadsheet is actually just the raw data output from my existing posts. I use a tool called WP Sheet Editor to export posts and pages, edit them in spreadsheets and then import them to be updated on my site. It’s a super cool tool but no one seems to care whenever I talk about it 😂
@@nate_mccallister do you have the formulas used here? I still cant even make my paid version work
Fantastic video man. ❤
this is not free. It required me to use the paid chat gpt in order to work.
Do you need to have a GPT Plus subscription plan for this? Because it says Error: your OpenAI free trial is expired or inactive. Please set up a paid account on OpenAI dashboard:
You do yea, but the free version is still around for 3.5
I have a subscription and it keeps happening
I keep get this error "ScriptError: Authorization is required to perform that action." when I try to set the API key in Google sheet.
What could be the problem?
I didn’t have any issues, does yours look like mine when you do the process?
life saver, thanks, subcribed.
Thanks for the sub! Glad it’s helpful.
Can we use FREE version of ChatGPT API?
When I made this video, yes, I believe that’s still true. However you’ll be capped on usage at like $18 I think
Everyone was given $18 worth of credits to start
[429] You exceeded your current quota, please check your plan and billing details - this is the error, how can i fix?
*ps I have not exceeded my usage quota
Can you also use this API key if you not have paid account?
Yes. They give you like $18 to start I believe
Do you need a paid subscription of Chat GPT to use this?
No, you’ll have a decent amount of free tokens to start. If you want to do a ton of stuff you’ll need to buy tokens tho
API key paid and they want us to pay extra...
thank you so much!
You're welcome!
nice!
cool
It's not 🆓
Sadly, it has changed
Go deeper, Nate!
Haha I’ll make another video if this one gets any traction.