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 GPT for Sheets sidebar, click Spreadsheet Settings from the GPT functions tab.

   

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

   

The creativity level you defined is now the default for all GPT function executions. New executions will use this creativity level.

What's next

Specify a different creativity level within a formula with the temperature parameter.