# How to connect Google Sheets to AI agents?

Connect Google Sheets to Sequel with OAuth and ask questions about your spreadsheet data in plain English.

Connect **Google Sheets** to Sequel and ask questions about the data in your spreadsheets in plain English — from the Sequel app or any AI tool wired up to the [MCP server](/docs/install). Once a spreadsheet is connected, you can read any tab and join that data with your databases for questions a single tool can't answer alone.

## What you'll need

- A **Google account** with access to the spreadsheet you want to query (read access is enough).
- Nothing to copy or configure — Google Sheets connects over **OAuth**. After you sign in, you pick the spreadsheet from a Google file picker; there's no URL or ID to paste.

<Callout type="info" title="Scoped to the sheet you pick">
Sequel requests Google's `drive.file` scope, which grants access only to the specific spreadsheet you select in the picker. It cannot read, list, or modify any other files in your Google Drive.
</Callout>

## Connect it

<Steps>
<Step title="Open a new connection">
In the Sequel dashboard, go to **Connections → New connection** and choose **Google Sheets**.
</Step>

<Step title="Sign in with Google">
You'll be redirected to Google's consent screen. Sign in and grant Sequel access to the spreadsheet you'll choose next.
</Step>

<Step title="Pick a spreadsheet">
Google's file picker opens, filtered to spreadsheets. Select the one you want Sequel to query.
</Step>

<Step title="Confirm">
Sequel verifies it can read the spreadsheet, indexes its tabs and column headers, and the connection goes live. One connection represents one spreadsheet — repeat this flow to add more.
</Step>
</Steps>

## What you can query

Sequel exposes the connected spreadsheet as queryable tabs:

- **List the sheet tabs** in the spreadsheet, with each tab's row and column counts.
- **Read rows from any tab** — optionally narrowed to an A1 range like `A1:Z100`. The first row of each tab is treated as the column headers, so the AI can filter and reference columns by name.

On connect, Sequel reads the header row of each tab to learn the spreadsheet's structure, which lets it route your questions to the right tab and columns automatically.

## Try it

- "What sheets are in this spreadsheet?"
- "Show me the first 50 rows from the Sales sheet"
- "What are the column headers in the Inventory sheet?"
- "How many rows are in the Orders sheet?"

## Join it with other sources

Spreadsheet data gets more powerful alongside your databases. With a database also connected, ask:

> "Reconcile the headcount plan in my Planning sheet against the actual `employees` table in Postgres — which roles in the plan don't have a matching active employee?"

## Troubleshooting

| Symptom | Likely fix |
| --- | --- |
| "Access denied" on connect | The Google account you authorized doesn't have access to that spreadsheet — sign in with an account that can open it, or have the owner share it with you. |
| Authorization fails | Re-run the OAuth flow and make sure you grant the requested access on Google's consent screen. |
| "Spreadsheet not found" or a tab returns nothing | Pick the spreadsheet again from the file picker, and check you're naming the exact tab — sheet names are case-sensitive. |

## Related

- [Connecting your first data source](/docs/connecting-your-first-data-source)
- [Chatting with your data](/docs/chatting-with-your-data)
- [Browse all integrations](/docs/integrations)