Gsheets MCP Server

A Model Context Protocol (MCP) server for Google Sheets API integration. Enables reading, writing, and managing Google Sheets documents directly from your MCP client (e.g., Claude Code, Claude Desktop, Cursor, etc.). It runs locally over stdio via the published package.

People connecting automation tools to Claude, Cursor, VS Code, or another MCP client. The project is written in TypeScript.

VERIFIED ACTIVE

LAST COMMIT 2026-08-17 · ★ 95 · #9 OF 194 MAINTAINED AUTOMATION · VERIFIED 2026-08-25

MIT · TypeScript servers · how we verify → /methodology

01 · Install Gsheets

before you install - you'll need

Set GOOGLE_APPLICATION_CREDENTIALS, GOOGLE_PRIVATE_KEY, GOOGLE_CLIENT_EMAIL, GSHEETS_TOOLSETS before connecting. GOOGLE_PROJECT_ID is optional or environment-specific per the README.

Claude Code

claude mcp add freema-mcp-gsheets -- npx -y mcp-gsheets

Claude Desktop / Cursor / VS Code - add to config

{
  "mcpServers": {
    "freema-mcp-gsheets": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-gsheets"
      ]
    }
  }
}

Same JSON for Cursor. For VS Code, rename the top-level key from `mcpServers` to `servers`.

Using another client? Same JSON, different key

Claude Desktop · mcpServers

Cursor · mcpServers

VS Code · servers

Windsurf · mcpServers

Zed · context_servers

Cline · mcpServers

Roo Code · mcpServers

Continue · mcpServers

LibreChat · mcpServers

Gemini CLI · mcpServers

Codex CLI · mcp_servers

Full setup guides: every client.

02 · Evidence

Security posture

What to check before giving this server access to your agent - from the registry, GitHub, and our own probes. We don't score safety; we show what's verifiable.

runs as local process (stdio) - runs on your machine with your user's permissions

license MIT - declared in the repository

npm package mcp-gsheets - unscoped; check the name against the project README before installing

registry namespace io.github.freema is GitHub-verified and matches the repo owner

03 · What Gsheets can do

Prose above is summarized from the project's README and registry record - no invented capabilities.

Latest releases

v1.10.2 · 2026-08-16

publish JSON Schema instead of Zod internals in tool input schemas · New Contributors · @jreinaldo-batfer made their first contribution in

v1.10.1 · 2026-08-10

upgrade to eslint 10 · bump zod from 3.25.76 to 4.4.3 · bump @modelcontextprotocol/sdk from 1.29.0 to 1.30.0 · bump @vitest/coverage-v8 from 4.1.4 to 4.1.10 · bump vitest from 4.1.4 to 4.1.10 · bump tsx from 4.21.0 to…

v1.10.0 · 2026-07-27

actually generate and upload coverage · add GSHEETS_TOOLSETS and GSHEETS_READ_ONLY to cut context cost

04 · Who maintains Gsheets

mcp-gsheets is maintained by freema. We track 4 MCP servers from freema - 4 actively maintained, 361 combined GitHub stars, oldest repo from May 2025. Full record: all servers from freema.

05 · Facts

repository: github.com/freema/mcp-gsheets
category: automation - ranked #9 of 194 actively-maintained automation servers as of 2026-08-25.
release cadence: 4 releases in the last 90 days (latest 2026-08-16)
registry: io.github.freema/mcp-gsheets (active, first published 2026-04-26 · 4 versions)
packages: npm:mcp-gsheets

06 · Gsheets FAQ

What is Gsheets?

Is Gsheets still maintained?

Yes - as of 2026-08-25, its last commit was 2026-08-17 and it shipped 4 releases in the last 90 days. We re-verify nightly.

How do I install Gsheets?

Run `npx -y mcp-gsheets`. The README documents 5 environment variables (GOOGLE_PROJECT_ID, GOOGLE_APPLICATION_CREDENTIALS, GOOGLE_PRIVATE_KEY…) to set first. Set GOOGLE_APPLICATION_CREDENTIALS, GOOGLE_PRIVATE_KEY, GOOGLE_CLIENT_EMAIL, GSHEETS_TOOLSETS before connecting. GOOGLE_PROJECT_ID is optional or environment-specific per the README. You can also paste the ready-made client config above.

Does Gsheets run locally?

Yes - it's a stdio server: it runs on your machine (via npx) with your user's permissions. Your data stays local unless the server itself calls external APIs.

07 · Alternatives to Gsheets

Alternatives to Gsheets

Maintained automation servers if Gsheets isn't the fit.

More automation MCP servers · Docs MCP · Funplay Cocos MCP · Galaxy MCP · Glif

More TypeScript MCP servers · Jira Stdio · OpenClaw MCP Server · Docker MCP Server (friendlygeorge) · Frihet ERP · Coolify MCP · see all