Set up your OpenAI API key in GPT for Sheets and Docs

Struggling with your OpenAI API key? 🔑 - don't worry we're here to help you out! Learn how to set up your OpenAI API key within the GPT for Sheets and Docs add-on and get the job started! 💪

⌚️ TIMESTAMPS
00:00 Set-up prerequisites
01:19 Configure your OpenAI account
2:35 Create an API key
2:55 Add your API key to the add-on
3:45 How to test if your API key works
4:30 Outro

▶️ PLAYLIST:

------------------------------------------------------------------------------------------
Like ChatGPT? Imagine using it in bulk in Google Sheets or Microsoft Excel and Word! 🤠
Make ChatGPT and other AIs write, rephrase, translate, categorize, extract, reformat, summarize, do research… 1000x faster than you could.

Popular use-cases for Excel and Sheets:
🌍 Translate in bulk
✍️ Create SEO content or ads copy at scale
🗂️ Clean and categorize your PIM or CRM
📊 Analyze survey results or customer feedback
📋 Review / Score a list of leads or candidates
🔍 Automate market research

Why use GPT for Work?
🚫 Stop copy/pasting to and from ChatGPT
⚡ Run up to 1000 prompts per minute
🎛️ Large model choice: GPT-4o, Claude 3.5 Sonnet, Gemini...
🔑 No API key required

Privacy and security:
🔒 Talarian is ISO 27001 certified and GDPR compliant
🛡️ We do not use your content to train models
🔐 Bring your own API key for enhanced privacy

Learn more:

[autonicaadabsurdum]

Worked like a charme. Helped my business partner to get it, too.

[SaerahMontaena]

thanks for the helpful explanation - make sure to deativate your add blocker - otherwise you wont see and be able to copy your API key ;)

[webb.industries]

Thank you so much, we are testing this out and it works like a dream.

[nickygood]

This is incredible :) Thank you so much

great video! How can I make the function =gpt("... understand a forms and give me insights about the responses, public etc>

[jasonvansteenwyk]

Am I supposed to be able to do this with Chat GPT plus? I don't see a Talarian link to click or an API to grab. I have GPT-4. Seems like there's a step missing.

[GeorgeKalenderov]

Hi Stan, I'm invited to use the OpenAI GPT-4 API. When I generate the API key as shown in the video, how do I know if I'm using GPT-4 or GPT-3 in Google Docs and Google Sheets when I've switched on your addon? I would like to work with GPT-4 rather than GPT-3.
Is there a way to find out which of the two versions is being used?

[BarryCourt]

Getting error "No API key type speficied" when copying in the API Key. Have setup fresh account and fresh chrome account etc.

[PeakDistrictSEO]

still having an issue. we have a plus account with chat gpt and have created api keys for other apps no problem...when we try to add this key to the add on it says we need to create a paid account. But we already have one??? Any ideas

[affiliateinfo]

Stan at approx 1:10 in this video you promised a link to a tutorial or instructions on how to create a new chrome profile for just 1 google account. Pls post this... merci!

[CodyTunnels]

stan, you are so helpful. I have implemented so much of what you teach. I built a website and currently trying to integrate chatgpt into the site but I can't get the code right. Do you know how to do this?

[retrorecordings]

so you need a pay openai account for using this?

[elearningmarketplace]

Hi, I've installed the extension, my =GPT formula is working on 50% of the rows. Where it is not working it is saying #Error and states Error: Empty balance. Go to: Extensions > GPT for Sheets™ and Docs™ > Billing. (line 8204). I have looked to try and renew the API key, however the API key is not listed in the extension menu. Any help will be greatly received.

[thisisrapha]

Hey there - integration works totally fine but once I open a new sheet, the API integration is gone and I can't use =runOpenAI anymore but have to do the integration again. How do I make sure it works over all work sheets I use? Thanks

[klmabry]

What about GPT-4, I just signed up as a Plus member with OpenAI ChatGPT so I can use GPT-4 but when I put a new API key in, it does recognize I have GPT-4.

[andrelawrence]

Hi,
does your instruction works with chatgpt 3.5

[homesellercashoffer]

Can it analyze the document where you enabled the API and it gives you results? Can it create new tabs in spreadsheet depending on what you ask it to do?

[murthi]

HI . i have a chatgpt plus acount on my android phone ; it is different from openaiacout bill!, ?

[jeyshs]

Stan, thank you for explaining it patiently, but i feel unless i have a paid version GPT is not going to allow me to integrate with Google sheets or docs, please let me know if there is an alternate method. Thank you! 🙏🙏

[wynthein]

Hi Stan! i followed all the steps but it's not working on my end. I always get an error message. I have a new API key I don't know what is causing the problem. I tried it on the playground and it's working.