Select a model or an OpenAI Assistant in GPT for Sheets

Select the most adapted model or OpenAI Assistant in terms of accuracy, speed and cost, and set it as default for all GPT executions from Google Sheets.

You can refer to the following material for guidance:

• List of supported models for GPT for Sheets with or without your own API keys

• Average response time for each model

• Guide to use OpenAI Assistants as models

Prerequisites

You have opened a Google spreadsheet and selected Extensions > GPT for Sheets and Docs > Open.

1. In the GPT for Sheets sidebar, expand the model switcher.

   

2. Select a model.

   If you require a model or an OpenAI Assistant that is only accessible with a key, set up an API key first.

   

The model you selected is now the default for all GPT function executions. New executions will use this model.

Existing formulas will not automatically update to the new model if the cache is enabled. To re-execute them with a different model, you can either disable the cache, select the formulas and regenerate their results, or change a parameter in the formulas and press Enter.

note

The GPT_MATCH and GPT_VISION functions use specific models, not the default one. Learn more.

What's next

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