Gsheets MCP Server: Install & Setup

Install Gsheets in Claude Code

Claude Code

claude mcp add gsheets -e GOOGLE_PROJECT_ID=... -- npx -y mcp-gsheets

mcp.json (Claude Desktop, Cursor, VS Code, Windsurf)

{
  "mcpServers": {
    "gsheets": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-gsheets"
      ],
      "env": {
        "GOOGLE_PROJECT_ID": "..."
      }
    }
  }
}

Replace each ... with your own value.

Frequently asked questions

What does the Gsheets MCP server do?

Google Sheets API integration for reading, writing, formatting and sheet management.

Is the Gsheets MCP server free?

The server is free, but you will likely need an account. The server itself is free, but it connects to a service that needs an account or API key, which may have paid tiers. Check the provider for current pricing.

Does Gsheets run locally or remotely?

Local. Runs on your machine (stdio). You install it with npx, uvx, Docker or from source.

How do I add Gsheets to Claude Code?

Run: claude mcp add gsheets -e GOOGLE_PROJECT_ID=... -- npx -y mcp-gsheets

More databases MCP servers

View all

DB

474

FreePeak/db-mcp-server

MySQL and PostgreSQL access: query execution, transaction management, schema exploration, query building and performance analysis.

LocalFreeGo

Prometheus

521

pab1it0/prometheus-mcp-server

Query and analyze Prometheus, the open-source monitoring system.

LocalFreePython

Alchemy

422

runekaagaard/mcp-alchemy

Access PostgreSQL, MySQL, MariaDB, SQLite, Oracle, SQL Server and more via SQLAlchemy, with schema and relationship inspection and large dataset analysis.

LocalFreePython

MotherDuck

536

motherduckdb/mcp-server-motherduck

Query and analyze data with MotherDuck and local DuckDB

LocalFree

Elasticsearch

314

cr7258/elasticsearch-mcp-server

Interact with Elasticsearch.

LocalFreePython

Pgmcp

541

subnetmarco/pgmcp

Natural-language queries for any PostgreSQL database, with automatic streaming and read-only safety.

LocalFreeGo