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 who work with automation and google sheets api and want it reachable from Claude, Cursor, VS Code, or another MCP client. The project is written in TypeScript.

VERIFIED ACTIVE

LAST COMMIT 2026-09-03 · ★ 98 · #12 OF 227 MAINTAINED AUTOMATION · VERIFIED 2026-09-18

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, 365 combined GitHub stars, oldest repo from May 2025. Full record: all servers from freema.

  1. mcp-jira-stdio MCP server for Jira Cloud - issues, search, comments, attachments, transitions. ★ 14
  2. OpenClaw MCP Server MCP server bridging Claude.ai/Desktop with self-hosted OpenClaw via OAuth 2.1. ★ 184
  3. mcp-design-system-extractor MCP server for Storybook design systems - extract component HTML, styles and metadata. ★ 69

05 · Facts

repository
github.com/freema/mcp-gsheets
category
automation - ranked #12 of 227 actively-maintained automation servers as of 2026-09-18.
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?

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.

Is Gsheets still maintained?

Yes - as of 2026-09-18, its last commit was 2026-09-03 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.

  1. Claude Flow AI orchestration with hive-mind swarms, neural networks, and 87 MCP tools for enterprise dev. ★ 72,753 · 2026-09-18
  2. GitHub Connect AI assistants to GitHub - manage repos, issues, PRs, and workflows through natural language. ★ 33,015 · 2026-09-16
  3. Windows MCP An MCP Server for computer-use in Windows OS ★ 7,034 · 2026-09-16
  4. Claude Code Ultimate Guide Search the Claude Code Ultimate Guide and machine-readable references from any MCP client. ★ 5,990 · 2026-09-17
  5. Ha MCP Comprehensive Model Context Protocol server for managing Home Assistant through AI assistants. ★ 4,770 · 2026-09-18
  6. Stripe Agent Toolkit MCP server integrating with Stripe - tools for customers, products, payments, and more. ★ 1,822 · 2026-09-17

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

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