SourcetoMCP
← Back to articles

How to Connect Google Sheets to ChatGPT?

Published September 9, 2026 · Written by Aanart

Illustrated frozen waterfall in a canyon at dusk, with snow-laden pines and a lantern-lit temple below.

Contents

  1. 1Before you start
  2. 2Connect Google Sheets to SourcetoMCP
  3. 3Add SourcetoMCP as a connector in ChatGPT
  4. 4Ask ChatGPT about your spreadsheets
  5. 5A note on write actions
  6. 6Troubleshooting
  7. 7Revoking access
  8. 8Still stuck?

This is a two-part setup: first link Google Sheets to SourcetoMCP, then add SourcetoMCP itself as a custom app inside ChatGPT's developer mode. Sheets works differently from most sources here, because you pick individual spreadsheets rather than handing over a whole account, and ChatGPT only ever reaches the ones you picked. For what it can do with them once connected, see the Google Sheets MCP server page.

Before you start

You need a SourcetoMCP account with a brand created, a Google account with edit rights on the spreadsheets in question, and a ChatGPT account on a Pro, Plus, Business, Enterprise or Education plan. Custom MCP connectors run through developer mode, which works on ChatGPT on the web only.

Connect Google Sheets to SourcetoMCP

  1. 1From your dashboard, go to Connectors → Add a connection.
  2. 2Find the Google Sheets card and select Connect.
  3. 3Sign in with the Google account that can open the spreadsheets you want. SourcetoMCP asks for Google's drive.file permission, which covers individual files you choose and nothing else in your Drive.
  4. 4Select + Choose spreadsheets from Google Drive and pick everything you expect to work with. Each visit to Google's picker grants only what you tick during it.
  5. 5Confirm. Each spreadsheet becomes its own entry on your Connections page.

Add SourcetoMCP as a connector in ChatGPT

  1. 1In SourcetoMCP, open Connect an agent from the dashboard sidebar and copy your server address (it looks like https://sourcetomcp.com/api/mcp).
  2. 2In ChatGPT, open Settings, then Security and login, and turn on Developer mode. Custom MCP connectors sit behind this toggle, and it only appears on ChatGPT on the web.
  3. 3Open the Plugins menu and select the “+” button to create a developer-mode app.
  4. 4Enter the name SourcetoMCP, paste in your server address, and pick OAuth as the authentication type.
  5. 5Save. The app now sits under Drafts in your app settings, where you can switch individual tools on or off.
  6. 6The first time ChatGPT calls it, you'll be asked to sign in to SourcetoMCP and approve access, the same OAuth approval you'd see connecting any other app. After that it reconnects on its own.

Being able to switch individual tools off is worth using here. Sheets exposes 34 operations and most of them write, so a session meant only for reporting can have the destructive ones turned off in the app's settings before you start.

Ask ChatGPT about your spreadsheets

A developer-mode app stays off until you pick it. In a chat, open the Plus menu, choose Developer mode, and select SourcetoMCP for that conversation. Naming the app in your question helps ChatGPT reach for the right tool, as in “Use the SourcetoMCP app to read my tracker”.

Anything that writes back asks you to confirm first, and ChatGPT shows the JSON payload it plans to send. On a spreadsheet that payload names the exact range, so read it before you approve. Try something like:

  1. 1Read the Q3 tab and tell me which regions missed target.
  2. 2Sort the pipeline range by close date, newest first.
  3. 3Protect the totals row so nobody edits it by accident.
  4. 4Add a filter to the header row of the leads tab.
  5. 5Freeze the first column and widen it to fit the names.

A note on write actions

27 of the 34 Sheets operations change something. ChatGPT can clear a range, delete a tab, remove a chart, or drop a conditional formatting rule, and the change lands in the Google file rather than in a copy, so there is no undo inside SourcetoMCP. Google's version history under File then Version history is the way back.

Troubleshooting

The spreadsheet isn't in the picker: the picker only lists files the signed-in Google account can already open. If the file lives in a shared drive, get that account access to it in Google Drive first, then reopen the picker.

Developer mode is missing from Settings: it is available on Pro, Plus, Business, Enterprise and Education accounts, and only on ChatGPT on the web. The mobile apps do not show it.

The app never appears in a chat: developer-mode apps sit under Drafts and stay off until you pick them. Open the Plus menu, choose Developer mode, and tick SourcetoMCP for that conversation.

ChatGPT says it can't find the tool or has no data: open the app's details page and use Refresh to pull the current tool list from the server. If that changes nothing, check the spreadsheet still shows under Active connections in SourcetoMCP.

Revoking access

Each spreadsheet is its own entry on your Connections page, so removing one leaves the rest working. To cut everything at once, revoke ChatGPT from the Connect an agent page. Turning Developer mode back off in ChatGPT hides every custom app without deleting any of them, which is the quickest temporary stop.

Still stuck?

Reach us at [email protected].