Log inSubmit server
Google Sheets MCP logo

Google Sheets MCP

Connects AI clients to Google Sheets for reading, writing, formatting, charts, protection, and sharing.

InstallRepositoryWebsite
Full README Compare alternatives Embed widget Claim this listing

Install Google Sheets MCP

Pick your client, then add it in one click or paste the config.

STDIONode.js
~/Library/Application Support/Claude/claude_desktop_config.json
claude_desktop_config.json
{
  "mcpServers": {
    "google-sheets-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@a1-x-tech/mcp-google-sheets@latest"
      ],
      "env": {
        "GOOGLE_SHEETS_CLIENT_ID": "YOUR_VALUE_HERE",
        "GOOGLE_SHEETS_CLIENT_SECRET": "YOUR_VALUE_HERE",
        "GOOGLE_SHEETS_REFRESH_TOKEN": "YOUR_VALUE_HERE"
      }
    }
  }
}

Settings → Developer → Edit Config, merge this into mcpServers, then fully quit and reopen Claude Desktop.

Values are written into the snippet above so you can paste it as is. They never leave your browser.

Automated check passed— started and listed 26 tools correctly (6d ago).

Overview

Google Sheets MCP connects AI clients to Google Sheets through the Google Sheets API. Google Sheets MCP provides 26 tools for finding and creating spreadsheets, reading and updating ranges, managing sheets, applying formatting, creating charts, and controlling access. It uses conversational OAuth setup with PKCE and stores tokens itself, while separating read operations from changes that require confirmation. Reach for it when an agent needs to inspect or maintain spreadsheet data without exposing a general-purpose Google Drive interface.

Use cases

  • Find a budget spreadsheet and summarize its sheets
  • Write or append records to a worksheet
  • Prepare a copied sheet with cleared values
  • Create charts and apply spreadsheet formatting
  • Share a spreadsheet with read or edit access

Key features

  • Google Sheets OAuth connection with PKCE
  • Read, write, append, and clear cell ranges
  • Sheet structure and formatting management
  • Charts, tables, validation, and protected ranges
  • Spreadsheet sharing and permission inspection
  • Explicit confirmation for destructive changes

Tools26

What Google Sheets MCP lets your agent do. Expand a tool for its parameters.

Verified live~12.0k tokens of context

Security & health

What it can reach and how reliably it runs — from our own checks, not the maintainer’s claims.

ActiveLast checked Today

Recent health check succeeded.

11/11 checks healthy over the last 62d

What it can do

From the 26 tools this server returned when we ran it; 26 declare their own safety hints.

Can delete or modify data · 16Handles credentials · 9Makes network requests · 26Read-only tools · 10
Network at startup4 connections
Files written at startup1
Install scriptsprepare
npm provenanceNot published
Package age64 days
Maintainers1

Observed 2026-11-02 in an isolated sandbox. A description of reach, not a security audit.

Supply-chain signal

No high-severity advisories surfaced by our automated scan.

Critical 0High 0Medium 0Low 0

Scanned 17d ago via OSV.dev · @a1-x-tech/mcp-google-sheets@latest (npm)

Adoption & maintenance

Factual signals from GitHub, npm, and our automated checks — not a rating.

GitHub stars1Stargazers on the source repository.
npm downloads1.1kPackage downloads in the last 30 days.
Last commit3d agoMost recent push to the default branch.
Availability100%Our rolling endpoint + install checks that succeeded.
Install checkPassedOur sandbox started it and listed its tools.
Tools exposed26Callable tools this server registers over MCP.

How Google Sheets MCP works

What Google Sheets MCP does

Google Sheets MCP gives an MCP-compatible AI client tools for working with spreadsheet files and their contents. It can find spreadsheets, create new ones, inspect sheet structure, read values and formulas, write or append rows, and clear cell contents. It also covers spreadsheet presentation and organization, including sheet creation and duplication, frozen rows, formatting, borders, dimensions, data validation, protected ranges, conditional formatting, structured tables, and charts.

Access management is included for spreadsheet files. An agent can inspect existing permissions, grant read or edit access, and share a file. Google Drive is used internally for spreadsheet search and sharing, but the server does not expose generic Drive operations.

How it works

The server runs as an npm package over MCP stdio. After it is added to an AI client, a user can ask the assistant to connect Google Sheets. The connection flow guides the user through OAuth client setup, receives Google's redirect on 127.0.0.1, uses PKCE, and retains the resulting tokens without requiring configuration-file edits or a restart.

Value operations use A1 notation such as 'Q3'!A1:F50. Structural operations use a numeric, zero-based sheetId; the spreadsheet metadata response provides those identifiers. Normal writes replace the addressed range, while appends add rows after the existing data. A null cell is skipped rather than cleared. Clearing values removes values and formulas while preserving formatting, validation, notes, and merges.

Batch operations can combine multiple ranges or requests and count as one quota operation. A Sheets batchUpdate applies all requests together or applies none of them. The server does not replay a write after an ambiguous failure, which avoids duplicating an append. Destructive operations are explicitly marked so the client can request confirmation.

Setup and configuration

Node.js 20 or newer and a Google account are required. Install the latest package through an MCP client using npx -y @a1-x-tech/mcp-google-sheets@latest. The documented stdio setup works with Codex, Claude Code, Claude Desktop configurations that support local MCP servers, Cursor, and VS Code.

The server uses Google OAuth credentials represented by GOOGLE_SHEETS_CLIENT_ID, GOOGLE_SHEETS_CLIENT_SECRET, and GOOGLE_SHEETS_REFRESH_TOKEN. The spreadsheets scope covers Sheets operations. A Drive scope is needed only when searching for spreadsheets or managing sharing permissions.

Tools and capabilities

  • Search for spreadsheets and create new spreadsheet files.
  • Read ranges, formulas, metadata, sheet sizes, frozen rows, and sheet objects.
  • Write, append, clear, and batch-update cell values.
  • Create, duplicate, rename, and manage sheets.
  • Apply formatting, borders, dimensions, conditional rules, validation, protected ranges, and tables.
  • Build charts and manage spreadsheet permissions.
  • Send supported Sheets API requests through raw_request for features without dedicated tools.

raw_request is limited to the Sheets API. Merged cells, named ranges, banding, filters, slicers, find-and-replace, and gradient conditional-format rules may require it. New spreadsheets are created in the My Drive root, and ownership transfer is not supported through permission management.

Read the full README View source on GitHub

Reviews

No reviews yet — be the first to share how it worked for you.

Frequently Asked Questions about Google Sheets MCP

Google Sheets MCP is an MCP server that connects AI clients to the Google Sheets API. Its main tools search and create spreadsheets, read and write ranges, manage sheets and formatting, build charts and tables, apply validation and protection, and inspect or change sharing permissions.

Install it through an MCP client with `npx -y @a1-x-tech/mcp-google-sheets@latest`. The server requires Node.js 20 or newer, and documented stdio configurations are available for Codex, Claude Code, Claude Desktop, Cursor, and VS Code.

Google Sheets MCP authenticates through a conversational OAuth flow. The assistant guides OAuth client setup, handles Google's redirect on `127.0.0.1` with PKCE, and stores the tokens itself; the documented environment variables represent the Google client and refresh-token credentials.

Yes, Google Sheets MCP can modify formatting, borders, dimensions, frozen rows, conditional formats, validation, protected ranges, tables, and charts. Some features without dedicated tools can be sent through `raw_request`, which is restricted to the Sheets API.

Yes, Google Sheets MCP works with Cursor as a stdio MCP server. Add its `npx` command to Cursor's MCP configuration, then connect the server and authorize Google Sheets.

Related MCP servers

All in Workplace & Productivity All alternatives
Add a badge to your READMEShow it’s listed — live SVG, Markdown or HTML.

AllMCPs Directory Badge

Full Badge Customizer

Showcase your server listing on GitHub or your project documentation. Embed this dynamic SVG badge to highlight official listing status and live engagement.

Badge Style:
Live Dynamic SVG PreviewGoogle Sheets MCP AllMCPs Directory Badge
Markdown (GitHub README)
[![AllMCPs](https://allmcps.com/api/badge/google-sheets-mcp?style=directory)](https://allmcps.com/mcp/google-sheets-mcp)
HTML Embed
<a href="https://allmcps.com/mcp/google-sheets-mcp"><img src="https://allmcps.com/api/badge/google-sheets-mcp?style=directory" alt="Google Sheets MCP on AllMCPs" /></a>