Google Sheets MCP Server

The Google Sheets MCP server lets any AI agent — Claude, ChatGPT, Cursor, or Codex — call Google Sheets through AllMCP's single hosted endpoint. Connect once and your agent gets 77 Google Sheets tools across files, sharing, export, metadata, values, sheets. There is nothing to install or keep running: AllMCP hosts the connector, you get one URL and one sign-in.

How to connect an AI agent to Google Sheets

1. Add the AllMCP endpoint https://go.allmcp.co/mcp/ to any MCP client (Claude, ChatGPT, Cursor, Codex). Sign in with Google or GitHub when the browser opens — no card, no passwords.
2. Ask your agent to connect Google Sheets. When your agent first calls a Google Sheets tool, AllMCP opens a browser tab to sign in with Google Sheets — no API key to copy or paste.
3. Your agent can now call all 77 Google Sheets tools directly. The first 20,000 tool calls each month are free; system and discovery calls never count.

{
  "mcpServers": {
    "allmcp": {
      "url": "https://go.allmcp.co/mcp/"
    }
  }
}

Google Sheets connects with OAuth — sign in with Google Sheets when your browser opens, no API key required.

What you can do with Google Sheets

• Files — Drive-side file operations: list/search/create/copy/trash
• Sharing — Drive permission sharing and ACLs
• Export — Export spreadsheets to CSV / XLSX / PDF
• Metadata — Spreadsheet-level metadata reads
• Values — Cell-range reads and writes (spreadsheets.values.*)
• Sheets — Tab management: add/delete/duplicate/rename/reorder
• Dimensions — Resize, insert, delete, move, or auto-fit rows and columns
• Formatting — Cell formatting, merges, data validation
• Conditional — Highlight or color-scale cells by value
• Filters Sort — Basic filter, filter views, sort ranges
• Find Replace — Find/replace, trim whitespace, delete duplicates
• Named Ranges — Create, rename, repoint, or delete named ranges
• Protection — Protected range CRUD
• Charts — Add, update, or delete charts
• Tables — Structured-table CRUD (2024+ Sheets feature)
• Developer Metadata — Developer metadata (key-value annotations)
• Raw — Raw batch_update escape hatch (all 69 request sub-types)

Full Google Sheets guide — every tool, connect steps, examples: docs.allmcp.co ↗

Frequently asked questions