Is this the official Google Sheets MCP server?

No. Google offers a Google Sheets MCP server as part of the Google Workspace Developer Preview Program. InsightfulPipe is an independent, hosted server that connects to the Google Sheets API. InsightfulPipe is not affiliated with Google.

How is it different from Google's Google Sheets MCP server?

Google's server is in Developer Preview. It requires joining the preview program and setting up a Google Cloud project with the APIs enabled, an OAuth client and a consent screen, and it offers six tools such as get_values, update_values and update_spreadsheet. InsightfulPipe is hosted, needs only a Google sign-in and a file pick, and adds per-spreadsheet action controls and team access.

Which AI assistants does it work with?

Any AI client that supports remote MCP servers. The setup guide on this page covers Claude, ChatGPT, Claude Code, Cursor, Gemini CLI and Codex. You can also work with the same connected accounts from the terminal with the InsightfulPipe CLI.

Is there a Claude connector for Google Sheets?

Yes. In Claude, add https://google-sheets.insightfulmcp.com/ as a custom connector and authorize your InsightfulPipe account. You can also add InsightfulPipe from the Claude Directory, which connects all of your linked accounts at once.

Can I use the Google Sheets MCP server with ChatGPT?

Yes. Add the server URL as a custom connector in ChatGPT Developer mode, or add InsightfulPipe from the ChatGPT app directory to connect all of your linked accounts. Developer mode availability depends on your ChatGPT plan.

Which spreadsheets can my AI access?

Only the spreadsheets you pick with the Google file picker when you connect. InsightfulPipe requests per-file Drive access, so it cannot browse or open other files in your Google Drive.

What can it read from a spreadsheet?

The list of tabs with their IDs and sizes, a tab's column headers with sample rows, and rows from a tab filtered by column values. Queries support selecting columns, filters combined with AND, a limit and offset, and an A1 range.

Can it edit my spreadsheets?

Yes, on spreadsheets connected with Read & Write access. It can update and batch update cells, insert blank rows, create, duplicate and change tabs, format cells and borders, merge cells, sort, set filters and filter views, add conditional formatting, banding, data validation, named and protected ranges, charts and slicers.

Is it safe to let AI edit Google Sheets?

You control the risk. Connect a spreadsheet as Read-only, or choose exactly which actions are allowed. Deleting a chart stays off until an owner, admin or operator enables it. Updating cells overwrites existing values and is a regular write action, so turn it off where agents should only read.

Can I connect multiple spreadsheets?

Yes. Each spreadsheet you pick is its own connection, and you can connect spreadsheets from more than one Google account. Each connected spreadsheet counts as one connection on your plan.

How does authentication work?

You sign in with Google OAuth and pick spreadsheets. InsightfulPipe requests the per-file drive.file scope, and your AI client signs in to the MCP server with your InsightfulPipe account rather than your Google login. You can disconnect a spreadsheet at any time.

What are the limitations?

It cannot create new spreadsheets, delete tabs, rows or columns, or open files you did not pick. Queries fetch the tab and filter it, returning up to 20,000 rows by default. Google Sheets API limits apply, and the server retries when Google asks it to slow down.

How much does the Google Sheets MCP server cost?

The Google Sheets MCP server is included in every InsightfulPipe plan, together with all other MCP servers and the CLI. Plans start at $29.99/month and include a trial. See insightfulpipe.com/pricing for current plans.

Google Sheets MCPProductivity26 actions

Google Sheets MCP Server

Let your AI agents run Google Sheets for you, safely.

A hosted Google Sheets MCP server for Claude, ChatGPT, Cursor and CLI agents. Paste one server URL into your AI client to use its 26 actions. There is nothing to install.

Enable or disable every action, per account. Block your agent from doing dangerous actions.
Ask in plain English. Pull reports, find insights and take action in Google Sheets.
26 read and write actions. Every Google Sheets task your agent needs, from reporting to making changes.
Built for teams. Invite your team and share one connected account.

Start a trial View all 26 actions

Works with

ChatGPT

Claude

Claude Code

Codex

Gemini CLI

Cursor

Mistral

OpenClaw

HermesPerplexityGrokn8nWindsurfVS CodeZed

ChatGPT

connected to Google Sheets MCP

Online

Actions

Available Actions

26 actions available to automate your Google Sheets workflows.

26 actions

Write

Add Banding

Apply alternating (banded) row colours to a range.

Write

Add Conditional Format

Add a conditional formatting rule (colour scale or boolean condition) to a range.

Write

Add Filter View

Create a named saved filter view that can be activated later.

Write

Add Named Range

Create a named range that can be referenced in formulas across the spreadsheet.

Write

Add Protected Range

Lock a cell range so that only editors you choose can modify it.

Write

Add Rows

Insert blank rows into a sheet (default inserts at the end).

Write

Add Slicer

Add an interactive slicer (filter control) anchored to a sheet.

Write

Auto Resize

Auto-fit column widths or row heights to content.

Write

Batch Update Cells

Update multiple ranges in a single call by providing a mapping of range => 2D array of values.

Write

Create Chart

Add an embedded chart (bar, line, pie, column, area, scatter) to a sheet.

Write

Create Sheet

Add a new tab to an existing spreadsheet with optional row/column counts and index.

Write

Delete Chart

Remove an embedded chart from the spreadsheet.

Write

Duplicate Sheet

Clone an existing sheet tab into a new tab within the same spreadsheet.

Write

Format Cells

Apply formatting (bold, colours, fonts, number formats, alignment) to a cell range.

Read

Get Sheet Peak

Peek at sheet to see available columns and sample data. Call this BEFORE query_sheet_data to know which columns you can use in SELECT and WHERE.

Read

List Sheets

List sheet/tab metadata inside a spreadsheet (sheet_id, title, index, optional gridProperties).

Write

Merge Cells

Merge a range of cells into one.

Read

Query Sheet Data

Query sheet data with SQL-like operations (SELECT, WHERE). Fetches data and applies filters in-memory.

Write

Set Basic Filter

Set the basic auto-filter on a sheet range (shows filter dropdowns in column headers).

Write

Set Data Validation

Add a data validation rule (drop-down list, number constraint, etc.) to a range.

Write

Sort Range

Sort a range of cells by one or more columns.

Write

Unmerge Cells

Unmerge previously merged cells in a range.

Write

Update Borders

Set or clear borders on a cell range.

Write

Update Cells

Overwrite a contiguous range of cells with the provided 2D array of values.

Write

Update Sheet Properties

Rename a tab, change its tab colour, freeze rows/columns, or hide/show it.

Write

Update Slicer

Modify an existing slicer's column index or data range.

Compare

Google Sheets MCP servers compared: hosted vs official

Google offers a Google Sheets MCP server in its Workspace Developer Preview. It suits developers who join the preview and manage their own Google Cloud setup. InsightfulPipe is a hosted alternative with a simple sign-in and per-spreadsheet controls.

What you operate	InsightfulPipe MCP server	Google Sheets MCP server (Google, Developer Preview)
Availability	Available on every InsightfulPipe plan	Developer Preview through the Google Workspace Developer Preview Program
Setup	Sign in with Google and pick spreadsheets	Google Cloud project, enabled APIs and MCP services, OAuth client and consent screen
Tools	26 actions: 3 read, 23 write	6 tools: get_values, get_spreadsheet, update_spreadsheet, update_values, update_formulas and insert_dimension
Action control	Read-only connections, per-action switches, deleting charts off by default	Depends on the OAuth scopes you configure
Other platforms	Ads, analytics, e-commerce and data platforms in the same workspace, plus a CLI	Separate Google servers for Gmail, Drive, Docs, Slides, Calendar, Chat and People

Overview

What you can do with the Google Sheets MCP

The InsightfulPipe Google Sheets MCP server is a hosted Model Context Protocol server that connects your spreadsheets to AI assistants such as Claude, ChatGPT, Cursor, Claude Code, Gemini CLI and Codex. You sign in with Google, pick spreadsheets with the Google file picker and add one server URL to your AI client.

Claude

Acme StoreRead-only

Ask about your Google Sheets account…

01Ask questions about sheet data

Ask questions about sheet data

Filter and summarize rows from a tab, such as leads with a given status or orders above a value, without writing formulas.

See all Google Sheets actions

Claude

Acme StoreRead & Write

Ask about your Google Sheets account…

02Keep reports up to date

Keep reports up to date

Write fresh numbers from your other InsightfulPipe connections into a reporting tab, updating several ranges in one call.

See all Google Sheets actions

Claude

Acme StoreRead & Write

Ask about your Google Sheets account…

03Clean up and format

Clean up and format

Apply number formats, bold headers, borders and alternating row colors, and auto-fit column widths.

See all Google Sheets actions

26

actions

one server URL

3

read actions

reports, audits, research

23

write actions

create, update, manage

Setup

How to connect the Google Sheets MCP server

Add the server URL to your AI client, then sign in with your InsightfulPipe account to authorize access. The server is hosted, so there is nothing to install.

MCP server URL

https://google-sheets.insightfulmcp.com/

Connect Google Sheets to Claude

Fastest: add InsightfulPipe from the Claude Directory

One click connects the full InsightfulPipe MCP with all your connected accounts. To add a server scoped to Google Sheets only, follow the steps below.

Open Claude Directory

Or add the Google Sheets server manually:

01

Copy the server URL:

https://google-sheets.insightfulmcp.com/

02
Open Claude connector settings (Customize > Connectors), click + and then Add custom connector.
03
Paste the URL and click Add.
04
Click Connect, then click Authorize access in the browser.

Start a new chat, click +, open Connectors and turn the connector on to use it.

The Free plan can add one custom connector. On Team and Enterprise plans, an Owner first adds it under Organization settings > Connectors, then each member clicks Connect in Customize > Connectors.

Connect Google Sheets to ChatGPT

Fastest: add InsightfulPipe from the ChatGPT app directory

One click connects the full InsightfulPipe MCP with all your connected accounts. To add a server scoped to Google Sheets only, follow the steps below.

Open in ChatGPT

Or add the Google Sheets server manually. Custom MCP servers need ChatGPT's Developer mode, which OpenAI offers on Plus, Pro, Business, Enterprise and Education accounts on the web.

01

Copy the server URL:

https://google-sheets.insightfulmcp.com/

02
In ChatGPT, open Settings → Security and login and turn on Developer mode.
03
Go to ChatGPT Plugins and select the + button.
04
Enter a name, paste the URL under Connection and create the connection.
05
When the sign-in opens, click Authorize access in the browser.
06
In a new chat, choose Developer mode from the + menu and select the app. Select it again in each new chat.

See OpenAI's Developer mode guide.

Connect Google Sheets to Claude Code

01

Add the server:

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

02
In Claude Code, run /mcp, select google-sheets-mcp and choose Authenticate.
03
Sign in to InsightfulPipe in the browser window and click Authorize access.

Connect Google Sheets to Cursor

01
Add the Google Sheets MCP server to Cursor, or add it to ~/.cursor/mcp.json (all projects) or .cursor/mcp.json (one project):
```
{
  "mcpServers": {
    "google-sheets-mcp": {
      "url": "https://google-sheets.insightfulmcp.com/"
    }
  }
}
```
02
The server shows Needs authentication. Click Connect, then Open.
03
Sign in to InsightfulPipe and click Authorize access.

Connect Google Sheets to Gemini CLI

01

Add the server:

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

02
In Gemini CLI, run /mcp auth google-sheets-mcp.
03
Sign in to InsightfulPipe in the browser window and click Authorize access.

Connect Google Sheets to Codex CLI

Using the Codex app? Add InsightfulPipe from the OpenAI app directory

The listed app connects the full InsightfulPipe MCP with all your connected accounts, in both ChatGPT and Codex.

Open the app listing

01
Add the server. When Codex detects OAuth support, it starts sign-in right away:
```
codex mcp add google-sheets-mcp --url https://google-sheets.insightfulmcp.com/
```
02
A browser window opens. Sign in to InsightfulPipe and click Authorize access. If no browser opens, run codex mcp login google-sheets-mcp.

Watch the setup tutorial

Works everywhere

Bring Google Sheets into the AI tools you already use

One hosted server URL, any MCP-compatible client. Pick yours to see the setup steps, or paste the URL into anything that speaks MCP.

Playbook

Prompts and skills that run on the Google Sheets MCP

Copy a prompt into any connected client, or install a Claude skill that chains the actions for you.

Prompt

“Show all rows in the Leads tab where Status is Qualified”

Queries the tab with a filter

View prompt

Prompt

“Which columns does the Budget tab have?”

Peeks at headers and two sample rows

View prompt

Prompt

“Write these campaign totals into A2:D10 on the Report tab”

Updates a range of cells

View prompt

Prompt

“Add a line chart of monthly revenue from the Summary tab”

Creates an embedded chart

View prompt

Prompt

“Bold the header row of the Orders tab and freeze it”

Formats cells and updates tab properties

View prompt

Prompt

“Add a drop-down with Open, Won and Lost to column E”

Adds a data validation rule

View prompt

Prompt

“Sort the Orders tab by Date, newest first”

Sorts a range by a column

View prompt

Prompt

“## Persona You are a reporting specialist who transforms raw spreadsheet data into meaningful reports. ## Tone - Report-focused and…”

Google Sheets Custom Report Builder

View prompt

Prompt

“## Persona You are a sales operations analyst helping teams work efficiently with lead data. ## Tone - Organized and systematic -…”

Google Sheets Lead List Processor

View prompt

Browse the prompt library All Claude skills

HAVE QUESTIONS?

Frequently asked questions

A Google Sheets MCP server connects spreadsheets to AI assistants through the Model Context Protocol (MCP), an open standard for giving AI tools access to data and actions. Once connected, you can ask Claude, ChatGPT or Cursor to find rows, update cells or format a sheet in plain English.

Google Sheets MCP Server

Available Actions

Add Banding

Add Conditional Format

Add Filter View

Add Named Range

Add Protected Range

Add Rows

Add Slicer

Auto Resize

Batch Update Cells

Create Chart

Create Sheet

Delete Chart

Duplicate Sheet

Format Cells

Get Sheet Peak

List Sheets

Merge Cells

Query Sheet Data

Set Basic Filter

Set Data Validation

Sort Range

Unmerge Cells

Update Borders

Update Cells

Update Sheet Properties

Update Slicer

Google Sheets MCP servers compared: hosted vs official

What you can do with the Google Sheets MCP

Ask questions about sheet data

Keep reports up to date

Clean up and format

How to connect the Google Sheets MCP server

MCP server URL

Connect Google Sheets to Claude

Connect Google Sheets to ChatGPT

Connect Google Sheets to Claude Code

Connect Google Sheets to Cursor

Connect Google Sheets to Gemini CLI

Connect Google Sheets to Codex CLI

Watch the setup tutorial

Bring Google Sheets into the AI tools you already use

ChatGPT

Claude

Claude Code

Codex

Cursor

Gemini CLI

Mistral

OpenClaw

Hermes

OpenAI Agents SDK

Claude Agents SDK

Google ADK

Perplexity

Grok

n8n

Windsurf

VS Code

Zed

OpenCode

CLI

Prompts and skills that run on the Google Sheets MCP

Frequently asked questions

What is a Google Sheets MCP server?

Is this the official Google Sheets MCP server?

How is it different from Google's Google Sheets MCP server?

Which AI assistants does it work with?

Is there a Claude connector for Google Sheets?

Can I use the Google Sheets MCP server with ChatGPT?

Which spreadsheets can my AI access?

What can it read from a spreadsheet?

Can it edit my spreadsheets?

Is it safe to let AI edit Google Sheets?

Can I connect multiple spreadsheets?

How does authentication work?

What are the limitations?

How much does the Google Sheets MCP server cost?

Explore more MCP servers