Adjust advanced settings in GPT for Sheets

Adjust the advanced settings in GPT for Sheets to have greater control over generated output in Google Sheets. You can learn more in the OpenAI API documentation.

Term	Definition
Token	Tokens can be thought of as pieces of words. During processing, the language model breaks down both the input (prompt) and the output (completion) texts into smaller units called tokens. Tokens generally correspond to ~4 characters of common English text. So 100 tokens are approximately worth 75 words. See how text is split into tokens.
Top P	Helps adjust creativity level – Lower values result in more focused output, while higher values allow for more creative responses.
Frequency penalty (not available for Claude models)	Penalizes tokens based on their frequency in the text so far – Higher values discourage the model from repeating the same tokens too frequently, as the more they appear in the text, the more penalized they get.
Presence penalty (not available for Claude models)	Penalizes new tokens based on whether they appear in the text so far – Higher values encourage the model to use new tokens that are not penalized.

1. In the sidebar, select GPT functions, and click Model settings.

   

2. Open the View advanced settings dropdown.

   

3. Use the corresponding sliders to set the values for:

   • Top P: Adjust creativity by setting the value between 0 and 1.

     Set the creativity level to 1 when the value for Top P is lower than 1.

   • Frequency penalty: Set a penalty between 0 and 2 to apply to tokens each time they are repeated in the result.

   • Presence penalty: Set a one-time penalty between 0 and 2 for tokens that appear more than once in the result.

     

GPT for Sheets uses the selected model to generate all responses for GPT functions and bulk AI tools.

info

When cache is enabled, existing GPT formulas will not automatically update to the new advanced settings when you re-execute them.

To re-execute existing formulas with different advanced settings, you can either:

• Change a parameter in the formulas and press Enter.

• Disable the cache, select the formulas, and regenerate their results.

What's next

• Run bulk AI tools and execute GPT functions in GPT for Google Sheets.

• Configure other settings to customize how the language model operates.