mcpbeat Sign in

Google Sheets MCP Server

local only

Google Sheets runs on your own machine — the client starts it, so there is no endpoint to ping. 324 installs a week from npm. Last commit 25 Oct 2026.

Allow AI systems to read, write, and query spreadsheet data via Google Sheets.

Installs per day peak 116 · avg 57 · +271% w/w
a month agotoday
324
Installs / week
npm · google-sheets-mcp
2
Stars
0 open issues
25 Oct 2026
Last commit
1 release in 90 days
MIT
License
TypeScript

Nothing serious here today

Today is the operative word: we check Google Sheets every 15 minutes and re-read its code on every release. Watch it and you find out the day that stops being true.

Three servers free · no card

Connect this server

This server runs on your own machine — install it with the package manager and the client starts it for you. Package name taken from the official registry entry.

run in your terminal
claude mcp add google-sheets-mcp -e 'MCP_TRANSPORT=<MCP_TRANSPORT>' -e 'GOOGLE_CLIENT_ID=<GOOGLE_CLIENT_ID>' -e 'GOOGLE_CLIENT_SECRET=<GOOGLE_CLIENT_SECRET>' -- npx -y google-sheets-mcp
~/Library/Application Support/Claude/claude_desktop_config.json
{
  "mcpServers": {
    "google-sheets-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "google-sheets-mcp"
      ],
      "env": {
        "GOOGLE_CLIENT_ID": "<GOOGLE_CLIENT_ID>",
        "GOOGLE_CLIENT_SECRET": "<GOOGLE_CLIENT_SECRET>",
        "MCP_TRANSPORT": "<MCP_TRANSPORT>"
      }
    }
  }
}
~/.codex/config.toml
[mcp_servers.google-sheets-mcp]
command = "npx"
args = ["-y", "google-sheets-mcp"]
env = { MCP_TRANSPORT = "<MCP_TRANSPORT>", GOOGLE_CLIENT_ID = "<GOOGLE_CLIENT_ID>", GOOGLE_CLIENT_SECRET = "<GOOGLE_CLIENT_SECRET>" }
.cursor/mcp.json
{
  "mcpServers": {
    "google-sheets-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "google-sheets-mcp"
      ],
      "env": {
        "GOOGLE_CLIENT_ID": "<GOOGLE_CLIENT_ID>",
        "GOOGLE_CLIENT_SECRET": "<GOOGLE_CLIENT_SECRET>",
        "MCP_TRANSPORT": "<MCP_TRANSPORT>"
      }
    }
  }
}
.vscode/mcp.json
{
  "servers": {
    "google-sheets-mcp": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "google-sheets-mcp"
      ],
      "env": {
        "GOOGLE_CLIENT_ID": "<GOOGLE_CLIENT_ID>",
        "GOOGLE_CLIENT_SECRET": "<GOOGLE_CLIENT_SECRET>",
        "MCP_TRANSPORT": "<MCP_TRANSPORT>"
      }
    }
  }
}

Put your own values in place of <MCP_TRANSPORT> (Transport type), <GOOGLE_CLIENT_ID> (Google OAuth client ID), <GOOGLE_CLIENT_SECRET> (Google OAuth client secret). The author’s registry entry marks them as required.

Alternatives to Google Sheets

same job, measured the same way
Google Docs
by domdomegg

Allow AI systems to read and edit Google Docs.

123 installs/wk local only
Gogcli MCP
by chrischall

Google Sheets (and more) for Claude via gogcli — read, write, and manage spreadsheets

702 installs/wk local only
Google Contacts
by domdomegg

Allow AI systems to list, search, and manage contacts via Google Contacts.

138 installs/wk local only
Google Sheets Import & Export (Ctrio Lab)
by ctriolab

Google Sheets via Apify: write Apify datasets or JSON rows to a sheet, or read a sheet as JSON.

answering
Sheetport
by cloudcorprecords

Google Sheets spreadsheets and cell values via the Sheets API, as MCP tools.

local only
Google Calendar
by domdomegg

Allow AI systems to list, create, update, and manage Google Calendar events.

118 installs/wk local only
Google Maps Places
by domdomegg

Allow AI systems to search for places and get business info via Google Maps Places API.

93 installs/wk local only
Google Sheets
by mcparmory

Create, read, and modify spreadsheet data, formatting, and sheets

217 installs/wk local only

Google Sheets — questions

Answers built from our own checks of this server.

Why is there no uptime for Google Sheets?
Google Sheets runs on your own machine over stdio — there is no network address to reach, so uptime cannot be measured for it by anyone. What can be measured is adoption: the npm package google-sheets-mcp was installed 324 times last week.
How do I connect Google Sheets?
Copy the ready config from this page. We generate it for Claude Code, Claude Desktop, Codex, Cursor and VS Code, each in the form that client actually reads. It runs locally, so the command pulls google-sheets-mcp straight from npm; nothing to host, nothing to sign up for.
How many people use Google Sheets?
The npm package google-sheets-mcp was installed 324 times in the last week. Week over week that is +271%. We show installs rather than GitHub stars on purpose: a star is a bookmark, an install is someone actually running it.
Is Google Sheets open source?
Yes — it is published under the MIT licence, written in TypeScript and 2 stars on GitHub. The source link is on this page, so you can read exactly what it does with your data before you connect it.