Select a model for bulk AI tools in Sheets
GPT for Sheets supports a range of models that you can use with the bulk AI tools. To help you find the model that offers the best balance of accuracy, speed, and cost for your use case, see our recommended models.
The available models depend on:
The API keys set for your current space. GPT for Sheets gives you access to a default set of models available without API keys. To access additional models, set an API key for one or more AI providers.
The model settings for your current space. Space owners and admins can control which models are available in GPT for Sheets.
Select a model without an API key
-
Open a Google spreadsheet.
-
In the menu bar, select Extensions > GPT for Sheets and Docs > Open.
-
In the sidebar menu, select Bulk AI tools.
-
Expand the model switcher.
-
Under No API key needed, select a model.
GPT for Sheets now uses the selected model to generate responses for bulk AI tools.
Select a model with an API key
Prerequisites
You have set an API key for the AI provider whose model you want to use.
-
Open a Google spreadsheet.
-
In the menu bar, select Extensions > GPT for Sheets and Docs > Open.
-
In the sidebar menu, select Bulk AI tools.
-
Expand the model switcher.
-
Under Use your API key or endpoints, select a model with a key icon.
GPT for Sheets now uses the selected model to generate responses for bulk AI tools.
Recommended models
As a general rule, OpenAI models are more reliable and less likely to decline prompts than models from other providers.
The following table lists our recommended models available without an API key. For more information about which add-on supports which models, see AI providers & models.
| Model | Provider | Description |
|---|---|---|
gpt-4.1 | OpenAI | Best overall balance of easy prompting, speed, quality, reliability, and cost. Recommended for most use cases. |
gpt-4.1-mini | OpenAI | Fast, cost-effective model with strong reasoning and language capabilities. Follows instructions closely. |
gpt-4.1-nano | OpenAI | Great for extremely high-volume but easy tasks. |
gpt-5.2 | OpenAI | Exceptionally strong at image understanding. Learn more about vision models. |
claude-4.5-sonnet | Anthropic | Great at content creation, summarization, and nuanced reasoning across a wide range of tasks. |
gemini-2.5-flash | Cost-effective model ideal for lightweight tasks and rapid responses. Supports reasoning, web search, and web scraping (enabled from the model settings). | |
sonar | Perplexity | Cost-effective search model optimized for simple queries. Grounded in recent web search data. Learn more about web search models. |
sonar-pro | Perplexity | Advanced search model optimized for complex queries, multi-step synthesis, and accurate question answering. Grounded in recent web search data. |
To learn more about a model, hover over the model info icon in the model switcher. A tooltip opens with detailed information about the model.
What's next
Learn more about models: