MCP server

mcp-gsheets

Repository:: github.com/freema/mcp-gsheets
Stars:: 104
Last push:: 2026-10-25
License:: MIT

MCP server for Google Sheets API — read, write, format, batch operations.

Good fit for

One-command install
Runs fully local
MIT license

Facts

Category: Databases
Pricing: Unknown
Authentication: API key
Transport: stdio
Hosting: Local
Maker: Unknown
Access: Unknown
Language: TypeScript
Install method: npx
Operating system: Unknown
Client: Unknown
License: Permissive
Maintenance: Active

Install

claude mcp add --env 'GOOGLE_PROJECT_ID=<YOUR_VALUE>' --transport stdio mcp-gsheets -- npx -y mcp-gsheets

Paste into claude_desktop_config.json

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

Paste into ~/.cursor/mcp.json

{
  "mcpServers": {
    "mcp-gsheets": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "mcp-gsheets"
      ],
      "env": {
        "GOOGLE_PROJECT_ID": "<YOUR_VALUE>"
      }
    }
  }
}

Paste into .vscode/mcp.json

{
  "servers": {
    "mcp-gsheets": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "mcp-gsheets"
      ],
      "env": {
        "GOOGLE_PROJECT_ID": "<YOUR_VALUE>"
      }
    }
  }
}

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

[mcp_servers.mcp-gsheets]
command = "npx"
args = ["-y", "mcp-gsheets"]
env = { GOOGLE_PROJECT_ID = "<YOUR_VALUE>" }

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

Env vars and secrets

GOOGLE_PROJECT_IDEnv var
Google Cloud project ID
GOOGLE_SERVICE_ACCOUNT_KEYEnv varSecret
Service account key as JSON string (auth method 2)
GOOGLE_PRIVATE_KEYEnv varSecret
Service account private key in PEM format (auth method 3)

Ratings

Not enough ratings yet

Ratings show once 3 people have rated.

Comments (0)

No comments yet.

Alternatives

From the same category

Name	Pricing	Authentication	Hosting	Stars
Jitsu	Unknown	Unknown	Remote	5.1k
Supabase	Unknown	API key	Local, Remote	3k
ArcadeDB MCP ServerOfficial	Unknown	Unknown	Local	1.2k
dbx	Unknown	Unknown	Local	28k
mcp	Unknown	Unknown	Remote	2.8k
DBHub	Unknown	API key	Local	3.7k

Score: 75

Popularity: 55
Maintenance: 100
Trust: 73
Completeness: 90
Community: 50

Formula version 1

Listed in:

Official MCP Registry, awesome-mcp-servers.

Data from the Official MCP Registry.