# GPT function issues (GPT for Sheets – Autosheet)

## Functions are stuck on "Loading"

![Spreadsheet cells showing Loading status in GPT Output column](https://autosheet.com/docs/article-images/help/loading-functions.png)

**Problem**: GPT functions fail to execute and remain in a loading state.

Functions can remain stuck because of a temporary Google Sheets or Apps Script issue. Similar behavior has been [reported to Google](https://issuetracker.google.com/issues/222342097). The loading state alone does not show the cause or when the functions will work again.

> **Solutions**
>
> Try the following solutions:
>
> - In the original spreadsheet:
>
>   1. Execute any native formula, such as [`CONCAT`](https://support.google.com/docs/answer/3093592) or [`SUM`](https://support.google.com/docs/answer/3093669), in an empty cell. Delete the formula when done.
>   2. Delete the content of one cell containing a stuck formula and undo the deletion.
>   3. If the formulas remain stuck, try the steps for a new spreadsheet.
>
> - In a new spreadsheet:
>
>   1. Create a new blank spreadsheet.
>   2. In the menu bar, select **Extensions > GPT for Sheets – Autosheet > Enable GPT functions**.
>   3. To test that GPT functions work, enter `=GPT("hello")` in any cell and check that the formula generates a proper "hello" response.
>   4. If the GPT function worked as expected, [disable GPT functions in the original spreadsheet](https://autosheet.com/docs/gpt-for-sheets/gpt-functions/manage-gpt-formulas/disable) before continuing in the new spreadsheet. This prevents new executions in the original spreadsheet if its formulas resume later.
>   5. Delete the test formula, then copy the contents of the original spreadsheet into the new spreadsheet.

## Additional configuration required

`Additional configuration required. Open the sidebar: Extensions > GPT for Sheets – Autosheet > Open.`

GPT functions are not working if the sidebar has not been initially opened. Open the GPT for Sheets – Autosheet sidebar to get started. [Check your permissions](https://autosheet.com/docs/gpt-for-sheets/gpt-functions/shared-spreadsheets) in the spreadsheet to ensure you can execute GPT functions.

## Script error

`ScriptError: Authorisation is required to perform that action.`

![](https://autosheet.com/docs/article-images/help/multi-account-issue.png)

**Problem**: You are likely using multiple Google accounts in the same browsing session.

> **Solution**
>
> 1. Create a dedicated browser profile on [Google Chrome](https://support.google.com/chrome/answer/2364824), [Microsoft Edge](https://support.microsoft.com/en-us/topic/sign-in-and-create-multiple-profiles-in-microsoft-edge-df94e622-2061-49ae-ad1d-6f0e43ce6435), or [Apple Safari](https://support.apple.com/guide/safari/create-a-profile-ibrwf3a9e7d6).
> 2. [Create a new spreadsheet.](https://sheets.new/)
> 3. Open the GPT for Sheets – Autosheet add-on again.

## Invalid parameter

`Error: Invalid xxx parameter.`

![](https://autosheet.com/docs/article-images/help/invalid-parameter-error.png)

**Problem**: The error indicates a formatting issue or an unreadable parameter within the formula.

> **Solutions**
>
> - Check that you have quotation marks around your text if it's not in a cell:
>
>   ✅ `=GPT("hello")`
>
>   ✅ `=GPT(A1)`
>
>   ❌ `=GPT(hello)`
>
> - Check that your parameters are in the correct order. [See the function list.](https://autosheet.com/docs/gpt-for-sheets/gpt-functions/reference)
>
> - Check that all parameters (even optional ones) are added as empty when there is another parameter coming after them:
>
>   ✅ `GPT_TRANSLATE(A2, "french", , "Avoid passive voice")`
>
> - Check that you are using the right parameter separator for your locale: `,` or `;`
>
> - Check that you are using the correct number formats for temperature for your locale: `0.8` or `0,8`

## Error: #NAME? Unknown function

`Error: #NAME? Unknown function: 'GPT'`

**Problem**: This error is caused by one of the following:

- The **GPT for Sheets – Autosheet** add-on is not installed.
- GPT functions have not been enabled in the spreadsheet.
- Google Sheets has stopped recognizing GPT functions in the spreadsheet.

> **Solutions**
>
> Try the following solutions in order:
>
> 1. In the menu bar, select **Extensions** and check for **GPT for Sheets – Autosheet**. If the add-on is not listed, [install it](https://autosheet.com/docs/gpt-for-sheets/setup/install).
>
> 2. Enable GPT functions:
>
>    - If you're the creator of the spreadsheet: In the menu bar, select **Extensions > GPT for Sheets – Autosheet > Enable GPT functions**.
>    - If you're not the creator of the spreadsheet: Ask the creator to enable GPT functions for you, or make a copy of the spreadsheet for yourself.
>
> 3. Reload the add-on for the spreadsheet:
>
>    1. In the menu bar, select **Extensions > Add-ons > Manage add-ons**.
>
>    2. In the list of installed apps, find **GPT for Sheets – Autosheet** and click its options button.
>
>       ![Google Sheets add-ons manager showing GPT for Sheets – Autosheet with options menu](https://autosheet.com/docs/article-images/setup/manage-add-ons-options.png)
>
>    3. In the options menu, unselect and select **Use in this document**.
>
> 4. Try the same solutions as in [Functions are stuck on 'Loading'](https://autosheet.com/docs/gpt-for-sheets/troubleshooting/gpt-function-issues#functions-are-stuck-on-loading).

## Formula parse error

`Formula parse error.`

![](https://autosheet.com/docs/article-images/help/parse-error.png)

**Problem**: Your formula contains a structural or syntax error, making it uninterpretable by Google Sheets.

> **Solutions**
>
> - Check that you have quotation marks around your text if it's not in a cell:
>
>   ✅ `=GPT("hello")`
>
>   ✅ `=GPT(A1)`
>
>   ❌ `=GPT(hello)`
>
> - Check that your parameters are in the correct order. [See the function list.](https://autosheet.com/docs/gpt-for-sheets/gpt-functions/reference)
>
> - Check that all parameters (even optional ones) are added as empty when there is another parameter coming after them:
>
>   ✅ `GPT_TRANSLATE(A2, "french", , "Avoid passive voice")`
>
> - Check that you are using the right parameter separator for your locale: `,` or `;`
>
> - Check that you are using the correct number formats for temperature for your locale: `0.8` or `0,8`

## Missing parameter

`Error: Please set required parameter text in GPT_XXX() function`

**Problem**: One of the parameters in your GPT formula is required and hasn't been set.

> **Solution**
>
> [Check which parameters are required](https://autosheet.com/docs/gpt-for-sheets/gpt-functions/reference) for the GPT function you are using and adjust the formula as needed.

## Formulas are reloaded when I open, reload or edit the spreadsheet

**Problem**: Google Sheets can recalculate GPT formulas when a spreadsheet is opened or edited, or when referenced data changes. If a cached result is not reused, recalculation can generate a new result and consume credits.

**Important note**: Sorting, filtering, or moving rows and columns can cause recalculation. The impact depends on the formulas and spreadsheet changes. [Replace formulas with values](https://autosheet.com/docs/gpt-for-sheets/gpt-functions/manage-gpt-formulas/replace-with-results) before moving things around.

> **Solutions**
>
> GPT for Sheets – Autosheet offers a variety of options to control recalculations:
>
> - **To save results permanently and prevent formula reloading**, [replace GPT formulas with their results](https://autosheet.com/docs/gpt-for-sheets/gpt-functions/manage-gpt-formulas/replace-with-results) in selected cells or across an entire sheet.
> - **To reuse previous results when the same request runs again**, [enable the cache](https://autosheet.com/docs/gpt-for-sheets/gpt-functions/manage-gpt-formulas/manage-cache). Cached results are stored for 30 days.
> - **To prevent new executions in your spreadsheet**, [disable GPT formulas](https://autosheet.com/docs/gpt-for-sheets/gpt-functions/manage-gpt-formulas/disable).

## Response is cut or incomplete

**Problem**: The response you get seems to be incomplete.

> **Solution**
>
> You need to increase the [cut-off limit](https://autosheet.com/docs/gpt-for-sheets/gpt-functions/configure-behavior#set-the-cut-off-limit).

## My results refreshed and I lost data

**Problem**: A GPT formula recalculated and returned a different result. This can happen when a previous result is not reused from cache.

> **Solution**
>
> - Check whether an earlier result is available in the [version history of your Google spreadsheet](https://support.google.com/docs/answer/190843?hl=en\&co=GENIE.Platform%3DDesktop#zippy=%2Crestore-an-earlier-version).
>
> - You can also take steps to prevent this situation from recurring.
>
>   GPT for Sheets – Autosheet offers a variety of options to control recalculations:
>
>   - **To save results permanently and prevent formula reloading**, [replace GPT formulas with their results](https://autosheet.com/docs/gpt-for-sheets/gpt-functions/manage-gpt-formulas/replace-with-results) in selected cells or across an entire sheet.
>   - **To reuse previous results when the same request runs again**, [enable the cache](https://autosheet.com/docs/gpt-for-sheets/gpt-functions/manage-gpt-formulas/manage-cache). Cached results are stored for 30 days.
>   - **To prevent new executions in your spreadsheet**, [disable GPT formulas](https://autosheet.com/docs/gpt-for-sheets/gpt-functions/manage-gpt-formulas/disable).

## Request timed out

`Error: Google Apps Script has timed out but your result could be in cache if you have cache enabled. Retry this cell to get your result. If your result is in cache it will be fetched without additional costs.`

**Problem**: Your request exceeded the [30-second runtime limit for Google Sheets custom functions](https://developers.google.com/apps-script/guides/services/quotas). A slow response from the AI provider can cause the request to exceed this limit.

The response time can vary based on:

- The model you are using
- The time of usage
- The current load on the AI provider's servers

> **Solutions**
>
> - Keep the [cache](https://autosheet.com/docs/gpt-for-sheets/gpt-functions/manage-gpt-formulas/manage-cache) enabled when you [retry formulas](https://autosheet.com/docs/gpt-for-sheets/gpt-functions/manage-gpt-formulas/retry-on-error). If the result is in cache, it is reused without another charge. A retry that sends a new request can consume credits.
> - Choose a model with a faster response time.
> - Set the [cut-off limit](https://autosheet.com/docs/gpt-for-sheets/gpt-functions/configure-behavior#set-the-cut-off-limit) to a lower value.
> - Use GPT for Sheets – Autosheet [bulk tools](https://autosheet.com/docs/gpt-for-sheets/bulk-tools), which are not subject to this 30-second custom-function limit.
> - Use [GPT for Excel – Autosheet](https://autosheet.com/docs/gpt-for-excel) functions, which are not subject to this Google Sheets limit. Other limits can still apply.

## The model you are using is very slow at the moment

`The model you are using is very slow at the moment which could result in timeouts. We canceled your executions to save you costs. Please try again with a faster model or at a later time.`

**Problem**: Executions were canceled after 10 timeout errors within a minute with the same model.

The response time can vary based on the specific model you are using and the time of usage.

> **Solutions**
>
> - Choose a model with a faster response time.
> - [Set the cut-off limit](https://autosheet.com/docs/gpt-for-sheets/gpt-functions/configure-behavior#set-the-cut-off-limit) to a lower value.
> - Keep the [cache](https://autosheet.com/docs/gpt-for-sheets/gpt-functions/manage-gpt-formulas/manage-cache) enabled when you [retry formulas](https://autosheet.com/docs/gpt-for-sheets/gpt-functions/manage-gpt-formulas/retry-on-error). If the result is in cache, it is reused without another charge. A retry that sends a new request can consume credits.
> - Use [GPT for Excel – Autosheet](https://autosheet.com/docs/gpt-for-excel) to avoid the 30-second Google Sheets custom-function limit. Other limits can still apply.