Purchase Completed, follow guide based on your plan

Errors - SheetAI App

Errors - SheetAI App Error: your OpenAI API free trial is expired or inactive.Exceeded maximum execution time Error: Invalid parameter Error: Please set OpenAI API key in Extensions menu Cannot use GPT-4 Response is cut or incomplete The menu only shows “help”Exception: Service invoked too many times for one day: urlfetch.429: Rate limit reached for […] requests per min.#NAME? Unknown function: 'SHEETAI' or 'sheetai’Formula parse error ScriptError: Authorisation is required to perform that action Need more help?

Error: your OpenAI API free trial is expired or inactive.

If you receive this error, it indicates that your OpenAI free trial is no longer active or has expired. Please note that ChatGPT Plus subscriptions do not include paid access to the OpenAI API platform.

To confirm, you can visit the OpenAI playground and try submitting a prompt. If you encounter an error there, it indicates that you need to set up a paid account with OpenAI.

Solution: set up a paid account on the OpenAI dashboard: https://platform.openai.com/account/billing/overview

Note: verifying your account with a phone number that hasn’t been used before is necessary to benefit from a free trial

Exceeded maximum execution time

OpenAI API servers are usually under extremely heavy load and the response time depends on the model and your account status.

If you see this error message, it means your request took more than 30 seconds which is above the limit of Google Sheets functions. It happens more frequently at peak usage time when OpenAI servers are taking a lot of load.

Solutions:

Use SheetAI Sidebar

Upgrade your free trial OpenAI account to a Pay as you go account, as the response time is much faster for paid accounts

Choose a model with a faster response time (text-davinci-003 is usually much faster)

Try again, outside of peak hours

Note that we are working on a definitive fix of this problem, which should be released middle of April.

Error: Invalid parameter

If you see this error message, make sure that:

you have quotation marks around your prompt if it is not in a cell. This works: =GPT("hello"). This works: =SHEETAI(A1). This doesn't work: =SHEETAI(hello)

you have quotation marks around your model parameter: "text-davinci-003", not text-davinci-003.

you are using the correct number format for temperature for your locale: 0.8 or 0,8

your arguments are in the correct order.

Error: Please set OpenAI API key in Extensions menu

If you see this error message, here’s how you can fix it (2 possibilities depending on your case):

Problem	Solution
You have not set your API key.	You need to set up your API key. Here’s how.
You're using multiple Google accounts in the same browser session	Follow these steps to fix it: 1. Follow this procedure to create a dedicated Chrome profile 2. Create a new spreadsheet 3. Set up your API key in this new file 4. Try using a GPT function in Sheets or submitting a prompt in Docs

Cannot use GPT-4

The GPT-4 API which this extension uses is currently only available via waitlist. The waitlist can be found here: https://openai.com/waitlist/gpt-4-api

The ChatGPT Plus subscription DOESN’T cover usage of OpenAI API and so paying for ChatGPT Plus WILL NOT enable you to use GPT-4 in this extension.

In order to check if you have access, you should go to the OpenAI playground and check if you can select the gpt-4 model there.

Response is cut or incomplete

You need to increase the last parameter of the formula: max_tokens. It is the maximum size of the response. You can increase it to a maximum of 4000.

The menu only shows “help”

Refresh your spreadsheet, wait 30 seconds, then try to launch the add-on again.

Exception: Service invoked too many times for one day: urlfetch.

If you see this error message, it means you have reached your daily quota of calls to an external service from Google Sheets.

Quota for gmail.com accounts: 20k / day

Quota for Google Workspace accounts: 100k / day

(subject to arbitrary change by Google)

Solution: wait 24 hours

429: Rate limit reached for […] requests per min.

If you see this error message, it means you have reached your limit of requests per minute.

Solution:

Wait one minute then retry.

Long-term solution:

Set up a payment method on OpenAI dashboard in order to increase your rate limit: https://platform.openai.com/account/billing/overview It will be increased to 3500 requests per minute after 48 hours.