Search / io.github.A1-x-Tech/mcp-google-sheets
Google Sheets MCP
L0· runs locallyMCP server for the Google Sheets API: read and write ranges, sheets, formatting, charts, sharing.
v1.0.0 · active · repository · website · descriptor JSON · versions
Search / io.github.A1-x-Tech/mcp-google-sheets
L0· runs locallyMCP server for the Google Sheets API: read and write ranges, sheets, formatting, charts, sharing.
v1.0.0 · active · repository · website · descriptor JSON · versions
{
"mcpServers": {
"mcp-google-sheets": {
"command": "npx",
"args": [
"-y",
"@a1-x-tech/[email protected]"
],
"env": {
"GOOGLE_SHEETS_CLIENT_SECRET": "${GOOGLE_SHEETS_CLIENT_SECRET}",
"GOOGLE_SHEETS_REFRESH_TOKEN": "${GOOGLE_SHEETS_REFRESH_TOKEN}",
"GOOGLE_SHEETS_ACCESS_TOKEN": "${GOOGLE_SHEETS_ACCESS_TOKEN}",
"GOOGLE_SHEETS_API_BASE": "https://sheets.googleapis.com",
"GOOGLE_SHEETS_TIMEOUT_MS": "60000",
"GOOGLE_SHEETS_MAX_RETRIES": "3"
}
}
}
}claude mcp add mcp-google-sheets -e "GOOGLE_SHEETS_CLIENT_SECRET=${GOOGLE_SHEETS_CLIENT_SECRET}" -e "GOOGLE_SHEETS_REFRESH_TOKEN=${GOOGLE_SHEETS_REFRESH_TOKEN}" -e "GOOGLE_SHEETS_ACCESS_TOKEN=${GOOGLE_SHEETS_ACCESS_TOKEN}" -e "GOOGLE_SHEETS_API_BASE=https://sheets.googleapis.com" -e "GOOGLE_SHEETS_TIMEOUT_MS=60000" -e "GOOGLE_SHEETS_MAX_RETRIES=3" -- npx -y @a1-x-tech/[email protected][mcp_servers.mcp-google-sheets]
command = "npx"
args = ["-y", "@a1-x-tech/[email protected]"]
env = { "GOOGLE_SHEETS_CLIENT_SECRET" = "${GOOGLE_SHEETS_CLIENT_SECRET}", "GOOGLE_SHEETS_REFRESH_TOKEN" = "${GOOGLE_SHEETS_REFRESH_TOKEN}", "GOOGLE_SHEETS_ACCESS_TOKEN" = "${GOOGLE_SHEETS_ACCESS_TOKEN}", "GOOGLE_SHEETS_API_BASE" = "https://sheets.googleapis.com", "GOOGLE_SHEETS_TIMEOUT_MS" = "60000", "GOOGLE_SHEETS_MAX_RETRIES" = "3" }
{
"$schema": "https://opencode.ai/config.json",
"mcp": {
"mcp-google-sheets": {
"type": "local",
"command": [
"npx",
"-y",
"@a1-x-tech/[email protected]"
],
"enabled": true,
"environment": {
"GOOGLE_SHEETS_CLIENT_SECRET": "{env:GOOGLE_SHEETS_CLIENT_SECRET}",
"GOOGLE_SHEETS_REFRESH_TOKEN": "{env:GOOGLE_SHEETS_REFRESH_TOKEN}",
"GOOGLE_SHEETS_ACCESS_TOKEN": "{env:GOOGLE_SHEETS_ACCESS_TOKEN}",
"GOOGLE_SHEETS_API_BASE": "https://sheets.googleapis.com",
"GOOGLE_SHEETS_TIMEOUT_MS": "60000",
"GOOGLE_SHEETS_MAX_RETRIES": "3"
}
}
}
}{
"mcpServers": {
"mcp-google-sheets": {
"command": "npx",
"args": [
"-y",
"@a1-x-tech/[email protected]"
],
"env": {
"GOOGLE_SHEETS_CLIENT_SECRET": "${GOOGLE_SHEETS_CLIENT_SECRET}",
"GOOGLE_SHEETS_REFRESH_TOKEN": "${GOOGLE_SHEETS_REFRESH_TOKEN}",
"GOOGLE_SHEETS_ACCESS_TOKEN": "${GOOGLE_SHEETS_ACCESS_TOKEN}",
"GOOGLE_SHEETS_API_BASE": "https://sheets.googleapis.com",
"GOOGLE_SHEETS_TIMEOUT_MS": "60000",
"GOOGLE_SHEETS_MAX_RETRIES": "3"
}
}
},
"deeplink": "cursor://anysphere.cursor-deeplink/mcp/install?name=mcp-google-sheets&config=eyJjb21tYW5kIjoibnB4IiwiYXJncyI6WyIteSIsIkBhMS14LXRlY2gvbWNwLWdvb2dsZS1zaGVldHNAMS4wLjAiXSwiZW52Ijp7IkdPT0dMRV9TSEVFVFNfQ0xJRU5UX1NFQ1JFVCI6IiR7R09PR0xFX1NIRUVUU19DTElFTlRfU0VDUkVUfSIsIkdPT0dMRV9TSEVFVFNfUkVGUkVTSF9UT0tFTiI6IiR7R09PR0xFX1NIRUVUU19SRUZSRVNIX1RPS0VOfSIsIkdPT0dMRV9TSEVFVFNfQUNDRVNTX1RPS0VOIjoiJHtHT09HTEVfU0hFRVRTX0FDQ0VTU19UT0tFTn0iLCJHT09HTEVfU0hFRVRTX0FQSV9CQVNFIjoiaHR0cHM6Ly9zaGVldHMuZ29vZ2xlYXBpcy5jb20iLCJHT09HTEVfU0hFRVRTX1RJTUVPVVRfTVMiOiI2MDAwMCIsIkdPT0dMRV9TSEVFVFNfTUFYX1JFVFJJRVMiOiIzIn19"
}{
"servers": {
"mcp-google-sheets": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@a1-x-tech/[email protected]"
],
"env": {
"GOOGLE_SHEETS_CLIENT_SECRET": "${GOOGLE_SHEETS_CLIENT_SECRET}",
"GOOGLE_SHEETS_REFRESH_TOKEN": "${GOOGLE_SHEETS_REFRESH_TOKEN}",
"GOOGLE_SHEETS_ACCESS_TOKEN": "${GOOGLE_SHEETS_ACCESS_TOKEN}",
"GOOGLE_SHEETS_API_BASE": "https://sheets.googleapis.com",
"GOOGLE_SHEETS_TIMEOUT_MS": "60000",
"GOOGLE_SHEETS_MAX_RETRIES": "3"
}
}
}
}{
"mcpServers": {
"mcp-google-sheets": {
"command": "npx",
"args": [
"-y",
"@a1-x-tech/[email protected]"
],
"env": {
"GOOGLE_SHEETS_CLIENT_SECRET": "${GOOGLE_SHEETS_CLIENT_SECRET}",
"GOOGLE_SHEETS_REFRESH_TOKEN": "${GOOGLE_SHEETS_REFRESH_TOKEN}",
"GOOGLE_SHEETS_ACCESS_TOKEN": "${GOOGLE_SHEETS_ACCESS_TOKEN}",
"GOOGLE_SHEETS_API_BASE": "https://sheets.googleapis.com",
"GOOGLE_SHEETS_TIMEOUT_MS": "60000",
"GOOGLE_SHEETS_MAX_RETRIES": "3"
}
}
}
}extensions:
"mcp-google-sheets":
enabled: true
name: "mcp-google-sheets"
type: stdio
cmd: "npx"
args:
- "-y"
- "@a1-x-tech/[email protected]"
envs:
"GOOGLE_SHEETS_CLIENT_SECRET": "${GOOGLE_SHEETS_CLIENT_SECRET}"
"GOOGLE_SHEETS_REFRESH_TOKEN": "${GOOGLE_SHEETS_REFRESH_TOKEN}"
"GOOGLE_SHEETS_ACCESS_TOKEN": "${GOOGLE_SHEETS_ACCESS_TOKEN}"
"GOOGLE_SHEETS_API_BASE": "https://sheets.googleapis.com"
"GOOGLE_SHEETS_TIMEOUT_MS": "60000"
"GOOGLE_SHEETS_MAX_RETRIES": "3"
timeout: 300
Placeholders to fill from your own secret store: ${GOOGLE_SHEETS_CLIENT_SECRET}, ${GOOGLE_SHEETS_REFRESH_TOKEN}, ${GOOGLE_SHEETS_ACCESS_TOKEN}. The registry never accepts secret values.
This is a local package: the command runs on your machine.
Not scored: fewer than three checks apply, usually because no remote answered a credential-free probe or the server is a local package.
protocol.modern, protocol.stateless, protocol.transport, protocol.list_ttlno remote answered a protocol handshake (not probed yet, unreachable, or local-only)auth.prm, auth.as_metadata, auth.cimdno remote uses OAuthauth.secret_in_urlno templated URLtools.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)stability.changes, stability.rug_pulltool list unknowndeps.known_vulnsno known advisory in 99 resolved packagesdeps.mcp_sdk_version@modelcontextprotocol/sdk 1.30.1 has 1 known advisory (GHSA-6qxp-vccf-f47h); update @modelcontextprotocol/sdk to 1.31.0 or laterdeps.resolvable@a1-x-tech/[email protected] resolved: 99 packagesNo 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.
+repository +namespace-matches-repo +website ~liveness-unmeasured +updated-27d-ago
Derived from observable signals (official registry feed and our own credential-free probes); no code audit performed. How it is computed.
@a1-x-tech/[email protected] npm98 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.
| package | registry | version | runtime | secrets |
|---|---|---|---|---|
@a1-x-tech/mcp-google-sheets | npm | 1.0.0 | – | GOOGLE_SHEETS_CLIENT_SECRET, GOOGLE_SHEETS_REFRESH_TOKEN, GOOGLE_SHEETS_ACCESS_TOKEN |
No tools observed. Local packages are never executed by the registry.
Schemas: list_tools.
And 17 more from this publisher.
{
"name": "io.github.A1-x-Tech/mcp-google-sheets",
"title": "Google Sheets MCP",
"$schema": "https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json",
"version": "1.0.0",
"packages": [
{
"version": "1.0.0",
"transport": {
"type": "stdio"
},
"identifier": "@a1-x-tech/mcp-google-sheets",
"registryType": "npm",
"registryBaseUrl": "https://registry.npmjs.org",
"environmentVariables": [
{
"name": "GOOGLE_SHEETS_CLIENT_ID",
"description": "Google OAuth2 client id (refresh-token flow)."
},
{
"name": "GOOGLE_SHEETS_CLIENT_SECRET",
"isSecret": true,
"description": "Google OAuth2 client secret (refresh-token flow). Treat it as a secret."
},
{
"name": "GOOGLE_SHEETS_REFRESH_TOKEN",
"isSecret": true,
"description": "Google OAuth2 refresh token, exchanged for access tokens automatically. Treat it as a secret."
},
{
"name": "GOOGLE_SHEETS_ACCESS_TOKEN",
"isSecret": true,
"description": "Static OAuth2 access token (~1h lifetime) — alternative to the refresh-token trio, mostly for testing."
},
{
"name": "GOOGLE_SHEETS_OAUTH_PORT",
"description": "Fixed port for the loopback listener of the in-chat login (127.0.0.1 + PKCE). Set it when the client runs over SSH port forwarding; otherwise a free port is picked per login."
},
{
"name": "GOOGLE_SHEETS_API_BASE",
"default": "https://sheets.googleapis.com",
"description": "Sheets API root override."
},
{
"name": "GOOGLE_SHEETS_TIMEOUT_MS",
"default": "60000",
"description": "Per-request timeout in milliseconds."
},
{
"name": "GOOGLE_SHEETS_MAX_RETRIES",
"default": "3",
"description": "Retries on transient errors (429 always; 5xx/network for reads)."
}
]
}
],
"repository": {
"url": "https://github.com/A1-x-Tech/mcp-google-sheets",
"source": "github"
},
"websiteUrl": "https://github.com/A1-x-Tech/mcp-google-sheets#readme",
"description": "MCP server for the Google Sheets API: read and write ranges, sheets, formatting, charts, sharing."
}