Google Sheets MCP connector

The Google Sheets connector lets AI agents read and edit the spreadsheets you pick through InsightfulPipe's hosted MCP server at https://google-sheets.insightfulmcp.com/. Agents can preview tabs, query rows with SQL-like filters, write values, and format, sort, filter and chart the data.

Google Sheets MCP server reference

Endpoint: https://google-sheets.insightfulmcp.com/
Server name: google-sheets-mcp
Actions: 26 (3 read, 23 write). Workspace owners, admins and operators choose which actions each connected account exposes, and destructive actions are off by default.

Add it from a terminal, then click Authorize access in the browser window that opens:

claude mcp add --transport http google-sheets-mcp https://google-sheets.insightfulmcp.com/
gemini mcp add --transport http google-sheets-mcp https://google-sheets.insightfulmcp.com/
codex mcp add google-sheets-mcp --url https://google-sheets.insightfulmcp.com/

What agents can do

Read: list the tabs in a spreadsheet, preview a tab's columns and sample rows, and query rows with SELECT and WHERE style filters.
Write values: update a range, update several ranges in one call, and insert rows.
Structure: add, duplicate and rename tabs, freeze rows or columns, and create named or protected ranges.
Format: cell formatting, borders, banded rows, conditional formatting, data validation, merging and auto-resizing.
Analyze: sort ranges, set filters and saved filter views, add slicers, and create or delete charts.

Before you connect

A Google login that can open the spreadsheet.
Put headers in the first row of each tab, so previews and queries return clear column names.

Connect Google Sheets

In the InsightfulPipe app, open Connectors, choose Google Sheets and click Connect.
Sign in with Google.
Pick the spreadsheets in the Google file picker. The connection only gets access to the files you pick.
Add the MCP server to Claude, ChatGPT or another client, then click Authorize access.

Permissions and safety

The connection uses Google's per-file drive.file access, so agents can't browse the rest of your Drive.
Write actions change the spreadsheet directly. Keep a copy of important sheets before asking for large edits.
delete_chart is destructive, so it stays off until an owner, admin or operator enables it in Configure actions for this account.

Limits

Queries fetch the tab and filter it in memory, so very large tabs are slow. Preview the tab first and query only the columns you need.
To use a spreadsheet you didn't pick, reconnect and pick it.

Example prompts

"Preview the Budget tab in my Marketing Plan sheet."
"From the Leads tab, list rows where Status is Qualified and Source is LinkedIn."
"Add a column chart of spend by month on a new tab."
"Compare the targets in the Weekly Targets tab with last week's Google Ads spend."

Troubleshooting

The spreadsheet isn't found: it probably wasn't picked when you connected. Reconnect and pick it.
Columns look wrong: make sure headers are in row 1 of the tab.