SheetMagic: ChatGPT + Google Sheets Integration

Product details

Q: Error: Unable to fetch data from the API.

Error: Error: An error occurred from OpenAIs side. This is not related to SheetMagic & the issue stems directly from your OpenAI account. Error Message: {"error":{"message":"You exceeded your current quota, please check your plan and billing details.","type":"insufficient_quota","param":null,"code":"insufficient_quota"}} (line 94).

I keep getting this error. I checked on my ChatGPT account and there is plenty of content still available. I have barely used any of my account. Do I have to upgrade to a paid version to use this product? Do you know why I may be getting this message?

nerdyguruAug 29, 2023
Founder Team
Curran35278

Curran35278

May 14, 2024

A: Hi there!

This is an error directly from OpenAI. It could mean a few things. They put out a simple help article for solving the issue though - so I'd recommend following that: https://help.openai.com/en/articles/6891831-error-code-429-you-exceeded-your-current-quota-please-check-your-plan-and-billing-details

Best,
Curran

Share
Helpful?
Log in to join the conversation
Verified Purchaser badge

Verified purchaser

Posted: Aug 29, 2023

So I got it working now but it doesn't read from the keyword on left side column,. Like column A is Keywords and I asked Column B to write the title. It writes the title but does not know the keywords are there. Can you help me?

Founder
Posted: Aug 29, 2023

Hard to tell exactly from your message, but usually this is an issue with the formula. You'll want to keep all cell references out of quotes. So for example

=AI("Write an article title based on this keyword: ", A1)

Think of it as the prompt being in the quotes and the cell references always being outside of the quotes.

Hope that helps!

Best,
Curran