mcpindex.aiv0
← Index

io.github.freema/mcp-gsheets

io.github.freema/mcp-gsheets·v1.8.1·Documents & Spreadsheets
Quality Score
85
/100

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

Repository →
§01  Install
Claude Desktop (claude_desktop_config.json)
{
  "mcpServers": {
    "mcp-gsheets": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-gsheets"
      ],
      "env": {
        "GOOGLE_PROJECT_ID": "<google_project_id>",
        "GOOGLE_APPLICATION_CREDENTIALS": "<google_application_credentials>",
        "GOOGLE_SERVICE_ACCOUNT_KEY": "<your-google_service_account_key>",
        "GOOGLE_PRIVATE_KEY": "<your-google_private_key>",
        "GOOGLE_CLIENT_EMAIL": "<google_client_email>"
      }
    }
  }
}
Cursor (.cursor/mcp.json)
{
  "mcpServers": {
    "mcp-gsheets": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-gsheets"
      ],
      "env": {
        "GOOGLE_PROJECT_ID": "<google_project_id>",
        "GOOGLE_APPLICATION_CREDENTIALS": "<google_application_credentials>",
        "GOOGLE_SERVICE_ACCOUNT_KEY": "<your-google_service_account_key>",
        "GOOGLE_PRIVATE_KEY": "<your-google_private_key>",
        "GOOGLE_CLIENT_EMAIL": "<google_client_email>"
      }
    }
  }
}
Cline (cline_mcp_settings.json)
npx -y mcp-gsheets
§02  Environment variables
GOOGLE_PROJECT_ID
required

Google Cloud project ID

GOOGLE_APPLICATION_CREDENTIALS

Path to service account key JSON file (auth method 1)

GOOGLE_SERVICE_ACCOUNT_KEY
secret

Service account key as JSON string (auth method 2)

GOOGLE_PRIVATE_KEY
secret

Service account private key in PEM format (auth method 3)

GOOGLE_CLIENT_EMAIL

Service account email (auth method 3)

§03  MCP Quality Score  ·  methodology
freshness
25
completeness
10
installability
25
documentation
15
stability
10
§04  Alternatives in Documents & Spreadsheets
ac.tandem/docs-mcp
ac.tandem/docs-mcp

Remote MCP server for Tandem docs, install guides, SDKs, workflows, and agent setup help.

ai.adramp/google-ads
ai.adramp/google-ads

Google Ads MCP server — manage campaigns, keywords, and metrics.

AutEng MCP - Markdown Publishing & Document Share Links
ai.auteng/docs

Publish markdown documents as public share links with mermaid diagram support. Built by AutEng.ai