Agent in GPT for Sheets

The Agent is an AI-powered chat interface that helps you accomplish spreadsheet tasks at scale. Just describe what you need in plain language, and the Agent analyzes your spreadsheet data and executes the task automatically.

You can use the Agent to perform bulk tasks like:

• Translate to multiple languages

• Search the web

• Generate and autofill formulas

Learn more about what the Agent can and cannot do.

How to use the Agent

To use the Agent in GPT for Sheets:

1. In the menu bar, select Extensions > GPT for Sheets and Docs > Open.

   

2. In the sidebar menu, select Agent, if not already selected.

   

3. Type your prompt and click Send.

   

Next, the Agent:

1. Analyzes your request and drafts a plan.

2. Processes the data in the current sheet according to the plan.

Examples

Find out what the Agent can do with the examples below. You can try these examples, and many more, directly from the sidebar.

Translate to multiple languages

Translate spreadsheet content to multiple languages in bulk.

Translate the descriptions in column B to the languages provided in row 1

tip

The Agent can also use a glossary to stick to your brand's language and conventions.

Translate into French, using the following glossary: "Macchiato: Macchiato (Café noisette), Espresso: Expresso, Latte: Café crème (Latte)"

Search the web

When necessary, the Agent searches the web to find the information you need. Learn more about the models used by the Agent.

Fill out this table

tip

The Agent can also scrape specific URLs, using Gemini 2.5 models with URL context.

Generate and autofill formulas

Describe what you need in natural language, and the Agent generates the appropriate Sheets formula, inserts it in the starting cell, and autofills the formula across the range.

Calculate the revenue for each row

tip

The Agent can also fix formulas and explain them.

Fix the formula in H2

What the Agent can and cannot do

The Agent excels at data processing and analysis tasks. You can use it to:

• Process data in bulk: Translate, categorize, tag, or prep your data across multiple rows.

• Enrich your data: Search the web to fill in missing information or gather additional context.

• Generate content: Generate or rewrite text, generate lists or tables.

• Analyze and summarize: Summarize multiple cells at once.

• Work with formulas: Create, fix, or explain spreadsheet formulas using natural language.

The Agent cannot yet:

• Apply formatting (such as colors or text formatting).

• Create visual elements like charts, pivot tables, or dashboards.

• Modify spreadsheet structure (add/remove columns or rows).

• Take images or documents as input.

FAQ

How much does it cost?

On average, the Agent consumes 7 cents of your balance per message, excluding the cost of the bulk tools used to perform the task.

What models does the Agent use?

By default, the Agent uses different models for different tasks. You can configure the model used for some tasks.

Task	Default model	Model configuration
Read and plan	gpt-4.1 without an API key	To use gpt-4.1 with an API key, contact support.
Apply the plan	gpt-4o without an API key	Set the default model in the GPT for Work dashboard.
Search the web	sonar without an API key	Set the default web search model in the GPT for Work dashboard.