How to Connect Google Sheets to an AI Agent, Step by Step

· DoubleX

Quick answer

To connect Google Sheets to an AI agent, open the Connectors screen in DoubleX Agentes, choose Google Sheets, and sign in with your Google account. Then pick the scope (personal, team or company) and choose which actions each agent can run, such as read-only access.

Connecting a spreadsheet to an AI agent is mostly a permissions exercise: you decide which Google account the agent uses, who can use that connection, and what the agent is allowed to do with your data. This guide covers only the connection itself, from creating the account to your first test request.

What can the agent do in Google Sheets once it's connected?#

Once connected, an agent can read and write cells, append rows, create new spreadsheets and find files by name. A connector is a system linked to the platform, and agents use that system's tools. You decide which of those tools each agent gets.

What the agent can doExampleType of action
Read cellsLook up a customer's status in a tabRead
Find spreadsheets by nameLocate the "Q3 budget" fileRead
Append rowsAdd a new lead at the end of a listWrite
Write cellsUpdate the status columnWrite
Create spreadsheetsStart a new tracking sheetWrite

For concrete scenarios, see what an AI agent can do in Google Sheets.

How do I create the account and get to the Connectors screen?#

Create a free account, with no credit card, and open the Connectors screen from the main navigation. During sign-up you share your company's industry, what you want to improve and where your information lives.

  1. Go to https://doublex.ai and create your account.
  2. Answer the setup questions about your company.
  3. Optionally run the diagnostic: a 5 to 10 minute conversation with the product's AI consultant. The first one is free, and it can turn into a team of agents with one click.
  4. Open Connectors from the navigation.

The Quickstart walks through these first steps in more detail.

How do I authorize Google Sheets: personal, team or company connection?#

In Connectors, select Google Sheets and sign in with your Google account. A connection can be personal (valid only for you, like your own email), shared with a team, or shared with the whole company.

  1. In Connectors, find Google Sheets.
  2. Start the connection and sign in with the Google account that has access to the spreadsheets.
  3. Approve the access Google asks for.
  4. Choose the scope: personal, team or company.
ScopeBest forWatch out for
PersonalYour own spreadsheets and draftsOnly works with your access
TeamA shared sheet used by one departmentEveryone on the team can use it through their agents
CompanyCompany-wide reference sheetsUse a Google account that should have broad access

Credentials for connections are stored encrypted with AES-256-GCM.

How do I choose which actions the agent can run (read vs. write)?#

For each agent, you choose which systems it uses and, within each system, which actions it can perform. Actions that change data can stay turned off, which leaves the agent with read-only access to your spreadsheets.

  1. Open Agents and select the agent (or create one by describing what you need in your own words).
  2. In the agent's connectors, add Google Sheets.
  3. Turn on the actions it needs: reading cells and finding files for lookups; writing cells, appending rows or creating spreadsheets only if the job requires it.
  4. Save, and repeat for other agents with their own permissions.

Before sending, deleting or changing anything in your systems, the agent asks for confirmation and shows the steps it took. For a broader review, use the checklist for using AI with Google Sheets safely.

How do I test with a first request and check the task history?#

Send a simple read request, then open the task to see exactly what the agent did. Each request becomes a task with a full history: the request, every tool the agent used and the result.

Try requests like these:

  • "Find the spreadsheet called 'Sales pipeline' and tell me how many rows it has."
  • "Read the first 10 rows of the 'Customers' tab and summarize the columns."
  • "List the spreadsheets in my account whose name contains 'budget'."
  • "In the 'Leads' tab, which rows have an empty Owner column?"

Then open Tasks and check who asked, which Google Sheets tool was called and what came back. If you enabled writing, test with a small change on a copy of the file first. Once the connection works, you can have the agent run on a schedule; see how to update Google Sheets automatically with AI routines.

What if the agent can't find the spreadsheet?#

Most of the time, the Google account you authorized doesn't have access to that file, or the agent doesn't have the right action turned on. Check these in order:

  1. Confirm the Google account used for the connection can open the spreadsheet in your browser.
  2. Check the scope. A personal connection only works for the person who made it.
  3. Confirm Google Sheets is added to the agent and that the read and find actions are on.
  4. Use the exact file name, or the tab name, in your request.
  5. Reconnect the connector if the Google sign-in has expired.

The Connectors documentation covers managing connections through the API.

Frequently asked questions#

Do I need to write code to connect Google Sheets?#

No. You connect it from the Connectors screen by signing in with Google. Developers who want more control can also use the REST API, the CLI and the MCP server.

Can the agent only read my spreadsheets and never edit them?#

Yes. Actions that change data can be turned off per agent, so it only reads. You can allow writing later for specific agents.

Is my spreadsheet data used to train AI models?#

No. Your company's content is not used to train models, and requests only go to AI providers that don't use what they receive for training. You can also enable zero retention in Models.

What's the difference between a personal and a company connection?#

A personal connection only works for the person who created it, like their own email. A company connection can be used by agents across the company, so use it for shared reference sheets.

Can I see what the agent did in my spreadsheet?#

Yes. Every request is saved as a task with the request, each tool used and the result, so you can see who asked, what was done and when.

Related guides

More Google Sheets guides