Connect

8 clients · secrets stay placeholders

JSON (mcpServers)Claude CodeCodexOpenCodeCursorVS CodeGemini CLIGoose

{
  "mcpServers": {
    "mcp-gsheets": {
      "command": "npx",
      "args": [
        "-y",
        "[email protected]"
      ],
      "env": {
        "GOOGLE_PROJECT_ID": "${GOOGLE_PROJECT_ID}",
        "GOOGLE_SERVICE_ACCOUNT_KEY": "${GOOGLE_SERVICE_ACCOUNT_KEY}",
        "GOOGLE_PRIVATE_KEY": "${GOOGLE_PRIVATE_KEY}"
      }
    }
  }
}

claude mcp add mcp-gsheets -e "GOOGLE_PROJECT_ID=${GOOGLE_PROJECT_ID}" -e "GOOGLE_SERVICE_ACCOUNT_KEY=${GOOGLE_SERVICE_ACCOUNT_KEY}" -e "GOOGLE_PRIVATE_KEY=${GOOGLE_PRIVATE_KEY}" -- npx -y [email protected]

[mcp_servers.mcp-gsheets]
command = "npx"
args = ["-y", "[email protected]"]
env = { "GOOGLE_PROJECT_ID" = "${GOOGLE_PROJECT_ID}", "GOOGLE_SERVICE_ACCOUNT_KEY" = "${GOOGLE_SERVICE_ACCOUNT_KEY}", "GOOGLE_PRIVATE_KEY" = "${GOOGLE_PRIVATE_KEY}" }

{
  "$schema": "https://opencode.ai/config.json",
  "mcp": {
    "mcp-gsheets": {
      "type": "local",
      "command": [
        "npx",
        "-y",
        "[email protected]"
      ],
      "enabled": true,
      "environment": {
        "GOOGLE_PROJECT_ID": "{env:GOOGLE_PROJECT_ID}",
        "GOOGLE_SERVICE_ACCOUNT_KEY": "{env:GOOGLE_SERVICE_ACCOUNT_KEY}",
        "GOOGLE_PRIVATE_KEY": "{env:GOOGLE_PRIVATE_KEY}"
      }
    }
  }
}

{
  "mcpServers": {
    "mcp-gsheets": {
      "command": "npx",
      "args": [
        "-y",
        "[email protected]"
      ],
      "env": {
        "GOOGLE_PROJECT_ID": "${GOOGLE_PROJECT_ID}",
        "GOOGLE_SERVICE_ACCOUNT_KEY": "${GOOGLE_SERVICE_ACCOUNT_KEY}",
        "GOOGLE_PRIVATE_KEY": "${GOOGLE_PRIVATE_KEY}"
      }
    }
  },
  "deeplink": "cursor://anysphere.cursor-deeplink/mcp/install?name=mcp-gsheets&config=eyJjb21tYW5kIjoibnB4IiwiYXJncyI6WyIteSIsIm1jcC1nc2hlZXRzQDEuMTAuMyJdLCJlbnYiOnsiR09PR0xFX1BST0pFQ1RfSUQiOiIke0dPT0dMRV9QUk9KRUNUX0lEfSIsIkdPT0dMRV9TRVJWSUNFX0FDQ09VTlRfS0VZIjoiJHtHT09HTEVfU0VSVklDRV9BQ0NPVU5UX0tFWX0iLCJHT09HTEVfUFJJVkFURV9LRVkiOiIke0dPT0dMRV9QUklWQVRFX0tFWX0ifX0%3D"
}

{
  "servers": {
    "mcp-gsheets": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "[email protected]"
      ],
      "env": {
        "GOOGLE_PROJECT_ID": "${GOOGLE_PROJECT_ID}",
        "GOOGLE_SERVICE_ACCOUNT_KEY": "${GOOGLE_SERVICE_ACCOUNT_KEY}",
        "GOOGLE_PRIVATE_KEY": "${GOOGLE_PRIVATE_KEY}"
      }
    }
  }
}

{
  "mcpServers": {
    "mcp-gsheets": {
      "command": "npx",
      "args": [
        "-y",
        "[email protected]"
      ],
      "env": {
        "GOOGLE_PROJECT_ID": "${GOOGLE_PROJECT_ID}",
        "GOOGLE_SERVICE_ACCOUNT_KEY": "${GOOGLE_SERVICE_ACCOUNT_KEY}",
        "GOOGLE_PRIVATE_KEY": "${GOOGLE_PRIVATE_KEY}"
      }
    }
  }
}

extensions:
  "mcp-gsheets":
    enabled: true
    name: "mcp-gsheets"
    type: stdio
    cmd: "npx"
    args:
      - "-y"
      - "[email protected]"
    envs:
      "GOOGLE_PROJECT_ID": "${GOOGLE_PROJECT_ID}"
      "GOOGLE_SERVICE_ACCOUNT_KEY": "${GOOGLE_SERVICE_ACCOUNT_KEY}"
      "GOOGLE_PRIVATE_KEY": "${GOOGLE_PRIVATE_KEY}"
    timeout: 300

Placeholders to fill from your own secret store: ${GOOGLE_SERVICE_ACCOUNT_KEY}, ${GOOGLE_PRIVATE_KEY}. The registry never accepts secret values.

This is a local package: the command runs on your machine.

Quality – / 100not scored

Not scored: fewer than three checks apply, usually because no remote answered a credential-free probe or the server is a local package.

protocoln/a · weight 25

n/a
protocol.modern, protocol.stateless, protocol.transport, protocol.list_ttlno remote answered a protocol handshake (not probed yet, unreachable, or local-only)

authorizationn/a · weight 15

n/a
auth.prm, auth.as_metadata, auth.cimdno remote uses OAuth
n/a
auth.secret_in_urlno templated URL

tool hygienen/a · weight 30

n/a
tools.descriptions, tools.description_length, tools.schemas, tools.annotations, tools.directory_hints, tools.token_cost, tools.api_dumptool list unknown (behind auth, not probed, or empty)

stabilityn/a · weight 15

n/a
stability.changes, stability.rug_pulltool list unknown

dependencies67 · weight 15

pass
deps.known_vulnsno known advisory in 163 resolved packages
fail
deps.mcp_sdk_version@modelcontextprotocol/sdk 1.30.1 has 1 known advisory (GHSA-6qxp-vccf-f47h); update @modelcontextprotocol/sdk to 1.31.0 or later
pass
deps.resolvable[email protected] resolved: 163 packages

Tool list unknown · checked 2026-10-20 11:08 UTC

Tool changes

No tool definition changes recorded. A server's first observation is its baseline; later probes record what changes.

Checks run on what our credential-free, read-only probes observe; tools are never called and no code audit is performed. How it is computed.

Trust 87 / 100

provenance80

livenessn/a

freshness85

hygiene100

+repository +namespace-matches-repo ~liveness-unmeasured ~updated-31d-ago

Derived from observable signals (official registry feed and our own credential-free probes); no code audit performed. How it is computed.

Dependencies

[email protected] npm162 dependencies, resolved · MCP SDK @modelcontextprotocol/sdk 1.30.1 · advisories checked 2026-10-19

advisory	severity	package	fixed in
GHSA-6qxp-vccf-f47hMCP TypeScript SDK: OAuth client could send credentials to an authorization server chosen by the MCP server	high	`@modelcontextprotocol/[email protected]`MCP SDK, direct	fixed in `1.31.0`

Dependency graphs from deps.dev; advisories from OSV.dev, including the GitHub Advisory Database and the PyPI Advisory Database; all CC BY 4.0. The graph is what a clean install of this version resolves today; nothing was installed or run. How it is checked.

Endpoints

package	registry	version	runtime	secrets
`mcp-gsheets`	npm	1.10.3	–	`GOOGLE_SERVICE_ACCOUNT_KEY`, `GOOGLE_PRIVATE_KEY`

Tools (0)

No tools observed. Local packages are never executed by the registry.

Schemas: list_tools.

Similar MCP servers

More from io.github.freema

Official server.json

{
  "name": "io.github.freema/mcp-gsheets",
  "$schema": "https://static.modelcontextprotocol.io/schemas/2025-09-29/server.schema.json",
  "version": "1.10.3",
  "packages": [
    {
      "version": "1.10.3",
      "transport": {
        "type": "stdio"
      },
      "identifier": "mcp-gsheets",
      "registryType": "npm",
      "registryBaseUrl": "https://registry.npmjs.org",
      "environmentVariables": [
        {
          "name": "GOOGLE_PROJECT_ID",
          "isRequired": true,
          "description": "Google Cloud project ID"
        },
        {
          "name": "GOOGLE_APPLICATION_CREDENTIALS",
          "description": "Path to service account key JSON file (auth method 1)"
        },
        {
          "name": "GOOGLE_SERVICE_ACCOUNT_KEY",
          "isSecret": true,
          "description": "Service account key as JSON string (auth method 2)"
        },
        {
          "name": "GOOGLE_PRIVATE_KEY",
          "isSecret": true,
          "description": "Service account private key in PEM format (auth method 3)"
        },
        {
          "name": "GOOGLE_CLIENT_EMAIL",
          "description": "Service account email (auth method 3)"
        }
      ]
    }
  ],
  "repository": {
    "url": "https://github.com/freema/mcp-gsheets",
    "source": "github"
  },
  "description": "MCP server for Google Sheets API — read, write, format, batch operations."
}