Set the creativity level in GPT for Sheets

Set the creativity level that will be used for all GPT for Sheets operations in your spreadsheet to define how standard (or not) your output is expected to be. You can find out more about the temperature setting, used by OpenAI to set a creativity level, in our Temperature guide.

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

   

2. Use the slider to set Creativity between 0 and 1.

   

GPT for Sheets uses the creativity level to generate all responses for GPT functions and bulk AI tools.

info

When cache is enabled, existing GPT formulas will not automatically adopt the new creativity level when you re-execute them.

To re-execute an existing formula with a different creativity level:

1. Set the temperature parameter directly in the formula.

2. Press Enter to re-execute the formula.

What's next

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

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