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. 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.
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.
Connect it
Open a new connection
In the Sequel dashboard, go to Connections → New connection and choose Google Sheets.
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.
Pick a spreadsheet
Google's file picker opens, filtered to spreadsheets. Select the one you want Sequel to query.
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.
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
employeestable 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. |