How to connect Google Sheets to Claude (the right way)

The right way to connect Google Sheets to Claude is through a synced connection that keeps pulling your latest data on a schedule — not a one-time file upload or a block of cells pasted into the chat. A one-time upload is a snapshot; the moment your spreadsheet changes, Claude is working from old numbers again.

Why the obvious approaches fall short

Most people start one of two ways:

Uploading the sheet as a file. Claude can read it, but it's frozen at the moment you uploaded it. Update the spreadsheet tomorrow, and Claude doesn't know.
Copy-pasting a range of cells. Works for a quick one-off question. Doesn't scale if you're asking questions regularly, and it only covers whatever range you remembered to copy.

Neither approach gives Claude an actual connection to the spreadsheet. They give it a copy of a copy, frozen in time.

Setting up a real connection

Synquil connects directly to your Google Sheets account over OAuth and keeps a synced copy of the sheets you choose, refreshed on a schedule based on your plan. Here's the setup:

Connect the source. From your Synquil dashboard, go to /dashboard/connect/new and choose Google Sheets. A Google OAuth popup opens; sign in and authorize read access to your Drive.
Choose which spreadsheets to sync. Synquil lists the spreadsheets it can see. Toggle on the ones you want Claude to be able to query, then click "Save and Deploy."
Review the generated schema. Synquil's schema engine looks at your selected sheets and proposes a unified table structure under /dashboard/schema/versions. Confirm it (or regenerate if a column looks off) to apply it.
Add Claude as a connector. Go to /dashboard/mcp in Synquil and open the Claude tab. It links directly to claude.ai/settings/connectors, where you add a custom connector and paste in your Synquil MCP URL. Claude redirects you to Synquil to authorize — no API key to copy or paste.
Ask Claude about your spreadsheet. Once connected, ask something like "what were our top 5 rows by revenue this month" or "how many rows were added to this sheet in the last week." Claude queries the live, synced data directly.

From here, any update to the underlying spreadsheet shows up in Claude on your next sync — hourly, every few hours, or daily depending on your plan — with no re-upload and no re-pasting.

What this unlocks beyond one spreadsheet

Once Google Sheets is connected this way, adding another source — HubSpot, Notion, Stripe, QuickBooks — joins the same synced schema Claude already has access to, so you can ask questions that span sources ("which spreadsheet rows correspond to deals that closed this month") without doing any extra connection work in Claude itself.

Connect your first spreadsheet and see what Claude says when it's reading current data instead of a stale upload.