SERVER

Google Sheets

Rank #24,282

io.github.mcp-z/mcp-sheets

Google Sheets integration with OAuth, spreadsheet management, batch operations, and formatting

23 versions

First listed

Dec 29, 2025

Last publish date

Oct 12, 2026

PURPOSE

What you can do with Google Sheets

Google Sheets is a Model Context Protocol (MCP) server. It ranks #24,282 of 150,963 active servers on MCP Toplist. Google Sheets is listed on Official MCP, with 23 tracked versions. It was first listed on Dec 29, 2025 and most recently updated on Oct 12, 2026.

Not verifiedMCP Toplist has not yet written a checked profile for this server, so the paragraph above is assembled from registry data only. Its registry listings below are the authority on what it does.

CAPABILITIES AND LIMITATIONS

What Google Sheets can and cannot do

Not verifiedMCP Toplist has not catalogued this server's tools or limitations. Check its registry listings below.

REQUIREMENTS

What you need before using Google Sheets

DeclaredAPI keyCredentials declared

The registry listing declares required configuration before first use — typically an API key, token or connection string set via environment variables.

Declared by the Official MCP Registry, last synced Oct 22, 2026. Not independently verified by MCP Toplist.

Declared in the registry install config

GOOGLE_CLIENT_ID · required
GOOGLE_CLIENT_SECRET · optional
GOOGLE_SERVICE_ACCOUNT_KEY_FILE · optional
AUTH_MODE · optional
HEADLESS · optional
REDIRECT_URI · optional
RESOURCE_STORE_URI · optional
PORT · optional
BASE_URL · optional
LOG_LEVEL · optional
DCR_MODE · optional
DCR_VERIFY_URL · optional
DCR_STORE_URI · optional

INSTALLATION AND FIRST TASK

Connect Google Sheets and confirm it works

npm package

claude mcp add mcp-sheets -e "GOOGLE_CLIENT_ID=<your GOOGLE_CLIENT_ID>" -e "GOOGLE_CLIENT_SECRET=<your GOOGLE_CLIENT_SECRET>" -e "GOOGLE_SERVICE_ACCOUNT_KEY_FILE=<your GOOGLE_SERVICE_ACCOUNT_KEY_FILE>" -e "AUTH_MODE=<your AUTH_MODE>" -e "HEADLESS=<your HEADLESS>" -e "REDIRECT_URI=<your REDIRECT_URI>" -e "RESOURCE_STORE_URI=<your RESOURCE_STORE_URI>" -e "PORT=<your PORT>" -e "BASE_URL=<your BASE_URL>" -e "LOG_LEVEL=<your LOG_LEVEL>" -- npx -y @mcp-z/mcp-sheets

Replace each placeholder with your own value before saving.

npm package

claude mcp add mcp-sheets -e "GOOGLE_CLIENT_ID=<your GOOGLE_CLIENT_ID>" -e "GOOGLE_CLIENT_SECRET=<your GOOGLE_CLIENT_SECRET>" -e "GOOGLE_SERVICE_ACCOUNT_KEY_FILE=<your GOOGLE_SERVICE_ACCOUNT_KEY_FILE>" -e "AUTH_MODE=<your AUTH_MODE>" -e "HEADLESS=<your HEADLESS>" -e "REDIRECT_URI=<your REDIRECT_URI>" -e "DCR_MODE=<your DCR_MODE>" -e "DCR_VERIFY_URL=<your DCR_VERIFY_URL>" -e "DCR_STORE_URI=<your DCR_STORE_URI>" -e "RESOURCE_STORE_URI=<your RESOURCE_STORE_URI>" -e "PORT=<your PORT>" -e "BASE_URL=<your BASE_URL>" -e "LOG_LEVEL=<your LOG_LEVEL>" -- npx -y @mcp-z/mcp-sheets --port 9004

Replace each placeholder with your own value before saving.

npm package

[mcp_servers.mcp-sheets]
command = "npx"
args = ["-y", "@mcp-z/mcp-sheets"]

[mcp_servers.mcp-sheets.env]
GOOGLE_CLIENT_ID = "<your GOOGLE_CLIENT_ID>"
GOOGLE_CLIENT_SECRET = "<your GOOGLE_CLIENT_SECRET>"
GOOGLE_SERVICE_ACCOUNT_KEY_FILE = "<your GOOGLE_SERVICE_ACCOUNT_KEY_FILE>"
AUTH_MODE = "<your AUTH_MODE>"
HEADLESS = "<your HEADLESS>"
REDIRECT_URI = "<your REDIRECT_URI>"
RESOURCE_STORE_URI = "<your RESOURCE_STORE_URI>"
PORT = "<your PORT>"
BASE_URL = "<your BASE_URL>"
LOG_LEVEL = "<your LOG_LEVEL>"

Add to ~/.codex/config.toml. Replace each placeholder with your own value before saving.

npm package

[mcp_servers.mcp-sheets]
command = "npx"
args = ["-y", "@mcp-z/mcp-sheets", "--port", "9004"]

[mcp_servers.mcp-sheets.env]
GOOGLE_CLIENT_ID = "<your GOOGLE_CLIENT_ID>"
GOOGLE_CLIENT_SECRET = "<your GOOGLE_CLIENT_SECRET>"
GOOGLE_SERVICE_ACCOUNT_KEY_FILE = "<your GOOGLE_SERVICE_ACCOUNT_KEY_FILE>"
AUTH_MODE = "<your AUTH_MODE>"
HEADLESS = "<your HEADLESS>"
REDIRECT_URI = "<your REDIRECT_URI>"
DCR_MODE = "<your DCR_MODE>"
DCR_VERIFY_URL = "<your DCR_VERIFY_URL>"
DCR_STORE_URI = "<your DCR_STORE_URI>"
RESOURCE_STORE_URI = "<your RESOURCE_STORE_URI>"
PORT = "<your PORT>"
BASE_URL = "<your BASE_URL>"
LOG_LEVEL = "<your LOG_LEVEL>"

Add to ~/.codex/config.toml. Replace each placeholder with your own value before saving.

npm package

{
  "mcpServers": {
    "mcp-sheets": {
      "command": "npx",
      "args": [
        "-y",
        "@mcp-z/mcp-sheets"
      ],
      "env": {
        "GOOGLE_CLIENT_ID": "<your GOOGLE_CLIENT_ID>",
        "GOOGLE_CLIENT_SECRET": "<your GOOGLE_CLIENT_SECRET>",
        "GOOGLE_SERVICE_ACCOUNT_KEY_FILE": "<your GOOGLE_SERVICE_ACCOUNT_KEY_FILE>",
        "AUTH_MODE": "<your AUTH_MODE>",
        "HEADLESS": "<your HEADLESS>",
        "REDIRECT_URI": "<your REDIRECT_URI>",
        "RESOURCE_STORE_URI": "<your RESOURCE_STORE_URI>",
        "PORT": "<your PORT>",
        "BASE_URL": "<your BASE_URL>",
        "LOG_LEVEL": "<your LOG_LEVEL>"
      }
    }
  }
}

Add to claude_desktop_config.json (Settings → Developer → Edit Config). Replace each placeholder with your own value before saving.

npm package

{
  "mcpServers": {
    "mcp-sheets": {
      "command": "npx",
      "args": [
        "-y",
        "@mcp-z/mcp-sheets",
        "--port",
        "9004"
      ],
      "env": {
        "GOOGLE_CLIENT_ID": "<your GOOGLE_CLIENT_ID>",
        "GOOGLE_CLIENT_SECRET": "<your GOOGLE_CLIENT_SECRET>",
        "GOOGLE_SERVICE_ACCOUNT_KEY_FILE": "<your GOOGLE_SERVICE_ACCOUNT_KEY_FILE>",
        "AUTH_MODE": "<your AUTH_MODE>",
        "HEADLESS": "<your HEADLESS>",
        "REDIRECT_URI": "<your REDIRECT_URI>",
        "DCR_MODE": "<your DCR_MODE>",
        "DCR_VERIFY_URL": "<your DCR_VERIFY_URL>",
        "DCR_STORE_URI": "<your DCR_STORE_URI>",
        "RESOURCE_STORE_URI": "<your RESOURCE_STORE_URI>",
        "PORT": "<your PORT>",
        "BASE_URL": "<your BASE_URL>",
        "LOG_LEVEL": "<your LOG_LEVEL>"
      }
    }
  }
}

Add to claude_desktop_config.json (Settings → Developer → Edit Config). Replace each placeholder with your own value before saving.

npm package

{
  "mcpServers": {
    "mcp-sheets": {
      "command": "npx",
      "args": [
        "-y",
        "@mcp-z/mcp-sheets"
      ],
      "env": {
        "GOOGLE_CLIENT_ID": "<your GOOGLE_CLIENT_ID>",
        "GOOGLE_CLIENT_SECRET": "<your GOOGLE_CLIENT_SECRET>",
        "GOOGLE_SERVICE_ACCOUNT_KEY_FILE": "<your GOOGLE_SERVICE_ACCOUNT_KEY_FILE>",
        "AUTH_MODE": "<your AUTH_MODE>",
        "HEADLESS": "<your HEADLESS>",
        "REDIRECT_URI": "<your REDIRECT_URI>",
        "RESOURCE_STORE_URI": "<your RESOURCE_STORE_URI>",
        "PORT": "<your PORT>",
        "BASE_URL": "<your BASE_URL>",
        "LOG_LEVEL": "<your LOG_LEVEL>"
      }
    }
  }
}

Add to ~/.cursor/mcp.json (global) or .cursor/mcp.json (per project). Replace each placeholder with your own value before saving.

npm package

{
  "mcpServers": {
    "mcp-sheets": {
      "command": "npx",
      "args": [
        "-y",
        "@mcp-z/mcp-sheets",
        "--port",
        "9004"
      ],
      "env": {
        "GOOGLE_CLIENT_ID": "<your GOOGLE_CLIENT_ID>",
        "GOOGLE_CLIENT_SECRET": "<your GOOGLE_CLIENT_SECRET>",
        "GOOGLE_SERVICE_ACCOUNT_KEY_FILE": "<your GOOGLE_SERVICE_ACCOUNT_KEY_FILE>",
        "AUTH_MODE": "<your AUTH_MODE>",
        "HEADLESS": "<your HEADLESS>",
        "REDIRECT_URI": "<your REDIRECT_URI>",
        "DCR_MODE": "<your DCR_MODE>",
        "DCR_VERIFY_URL": "<your DCR_VERIFY_URL>",
        "DCR_STORE_URI": "<your DCR_STORE_URI>",
        "RESOURCE_STORE_URI": "<your RESOURCE_STORE_URI>",
        "PORT": "<your PORT>",
        "BASE_URL": "<your BASE_URL>",
        "LOG_LEVEL": "<your LOG_LEVEL>"
      }
    }
  }
}

Add to ~/.cursor/mcp.json (global) or .cursor/mcp.json (per project). Replace each placeholder with your own value before saving.

npm package

{
  "servers": {
    "mcp-sheets": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@mcp-z/mcp-sheets"
      ],
      "env": {
        "GOOGLE_CLIENT_ID": "<your GOOGLE_CLIENT_ID>",
        "GOOGLE_CLIENT_SECRET": "<your GOOGLE_CLIENT_SECRET>",
        "GOOGLE_SERVICE_ACCOUNT_KEY_FILE": "<your GOOGLE_SERVICE_ACCOUNT_KEY_FILE>",
        "AUTH_MODE": "<your AUTH_MODE>",
        "HEADLESS": "<your HEADLESS>",
        "REDIRECT_URI": "<your REDIRECT_URI>",
        "RESOURCE_STORE_URI": "<your RESOURCE_STORE_URI>",
        "PORT": "<your PORT>",
        "BASE_URL": "<your BASE_URL>",
        "LOG_LEVEL": "<your LOG_LEVEL>"
      }
    }
  }
}

Save as .vscode/mcp.json in your workspace. Replace each placeholder with your own value before saving.

npm package

{
  "servers": {
    "mcp-sheets": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@mcp-z/mcp-sheets",
        "--port",
        "9004"
      ],
      "env": {
        "GOOGLE_CLIENT_ID": "<your GOOGLE_CLIENT_ID>",
        "GOOGLE_CLIENT_SECRET": "<your GOOGLE_CLIENT_SECRET>",
        "GOOGLE_SERVICE_ACCOUNT_KEY_FILE": "<your GOOGLE_SERVICE_ACCOUNT_KEY_FILE>",
        "AUTH_MODE": "<your AUTH_MODE>",
        "HEADLESS": "<your HEADLESS>",
        "REDIRECT_URI": "<your REDIRECT_URI>",
        "DCR_MODE": "<your DCR_MODE>",
        "DCR_VERIFY_URL": "<your DCR_VERIFY_URL>",
        "DCR_STORE_URI": "<your DCR_STORE_URI>",
        "RESOURCE_STORE_URI": "<your RESOURCE_STORE_URI>",
        "PORT": "<your PORT>",
        "BASE_URL": "<your BASE_URL>",
        "LOG_LEVEL": "<your LOG_LEVEL>"
      }
    }
  }
}

Save as .vscode/mcp.json in your workspace. Replace each placeholder with your own value before saving.

npm package

{
  "mcpServers": {
    "mcp-sheets": {
      "command": "npx",
      "args": [
        "-y",
        "@mcp-z/mcp-sheets"
      ],
      "env": {
        "GOOGLE_CLIENT_ID": "<your GOOGLE_CLIENT_ID>",
        "GOOGLE_CLIENT_SECRET": "<your GOOGLE_CLIENT_SECRET>",
        "GOOGLE_SERVICE_ACCOUNT_KEY_FILE": "<your GOOGLE_SERVICE_ACCOUNT_KEY_FILE>",
        "AUTH_MODE": "<your AUTH_MODE>",
        "HEADLESS": "<your HEADLESS>",
        "REDIRECT_URI": "<your REDIRECT_URI>",
        "RESOURCE_STORE_URI": "<your RESOURCE_STORE_URI>",
        "PORT": "<your PORT>",
        "BASE_URL": "<your BASE_URL>",
        "LOG_LEVEL": "<your LOG_LEVEL>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json. Replace each placeholder with your own value before saving.

npm package

{
  "mcpServers": {
    "mcp-sheets": {
      "command": "npx",
      "args": [
        "-y",
        "@mcp-z/mcp-sheets",
        "--port",
        "9004"
      ],
      "env": {
        "GOOGLE_CLIENT_ID": "<your GOOGLE_CLIENT_ID>",
        "GOOGLE_CLIENT_SECRET": "<your GOOGLE_CLIENT_SECRET>",
        "GOOGLE_SERVICE_ACCOUNT_KEY_FILE": "<your GOOGLE_SERVICE_ACCOUNT_KEY_FILE>",
        "AUTH_MODE": "<your AUTH_MODE>",
        "HEADLESS": "<your HEADLESS>",
        "REDIRECT_URI": "<your REDIRECT_URI>",
        "DCR_MODE": "<your DCR_MODE>",
        "DCR_VERIFY_URL": "<your DCR_VERIFY_URL>",
        "DCR_STORE_URI": "<your DCR_STORE_URI>",
        "RESOURCE_STORE_URI": "<your RESOURCE_STORE_URI>",
        "PORT": "<your PORT>",
        "BASE_URL": "<your BASE_URL>",
        "LOG_LEVEL": "<your LOG_LEVEL>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json. Replace each placeholder with your own value before saving.

npm package

{
  "mcpServers": {
    "mcp-sheets": {
      "command": "npx",
      "args": [
        "-y",
        "@mcp-z/mcp-sheets"
      ],
      "env": {
        "GOOGLE_CLIENT_ID": "<your GOOGLE_CLIENT_ID>",
        "GOOGLE_CLIENT_SECRET": "<your GOOGLE_CLIENT_SECRET>",
        "GOOGLE_SERVICE_ACCOUNT_KEY_FILE": "<your GOOGLE_SERVICE_ACCOUNT_KEY_FILE>",
        "AUTH_MODE": "<your AUTH_MODE>",
        "HEADLESS": "<your HEADLESS>",
        "REDIRECT_URI": "<your REDIRECT_URI>",
        "RESOURCE_STORE_URI": "<your RESOURCE_STORE_URI>",
        "PORT": "<your PORT>",
        "BASE_URL": "<your BASE_URL>",
        "LOG_LEVEL": "<your LOG_LEVEL>"
      }
    }
  }
}

Replace each placeholder with your own value before saving.

npm package

{
  "mcpServers": {
    "mcp-sheets": {
      "command": "npx",
      "args": [
        "-y",
        "@mcp-z/mcp-sheets",
        "--port",
        "9004"
      ],
      "env": {
        "GOOGLE_CLIENT_ID": "<your GOOGLE_CLIENT_ID>",
        "GOOGLE_CLIENT_SECRET": "<your GOOGLE_CLIENT_SECRET>",
        "GOOGLE_SERVICE_ACCOUNT_KEY_FILE": "<your GOOGLE_SERVICE_ACCOUNT_KEY_FILE>",
        "AUTH_MODE": "<your AUTH_MODE>",
        "HEADLESS": "<your HEADLESS>",
        "REDIRECT_URI": "<your REDIRECT_URI>",
        "DCR_MODE": "<your DCR_MODE>",
        "DCR_VERIFY_URL": "<your DCR_VERIFY_URL>",
        "DCR_STORE_URI": "<your DCR_STORE_URI>",
        "RESOURCE_STORE_URI": "<your RESOURCE_STORE_URI>",
        "PORT": "<your PORT>",
        "BASE_URL": "<your BASE_URL>",
        "LOG_LEVEL": "<your LOG_LEVEL>"
      }
    }
  }
}

Replace each placeholder with your own value before saving.

First successful task

After adding the config, ask your client to list this server's tools. A tool list confirms the connection; an empty list or an error means the server did not start or needs credentials.

MAINTENANCE AND EVIDENCE

What changed, and when this was checked

First listed: Dec 29, 2025
Latest version published: Oct 12, 2026
Version history: 23 versions tracked (below)
Requirements evidence: Declared by the Official MCP Registry, last synced Oct 22, 2026. Not independently verified by MCP Toplist.
Profile checked: Not yet — purpose, capabilities and requirements above come from registry data only
Ranking data as of: Oct 12, 2026

Registry sightings

Official MCP ↗listed since Apr 25, 2026 · still listed

Do you maintain Google Sheets? to correct or enrich this profile.

VERSIONS

Available versions (23)

Version	Published
2.4.2	Oct 12, 2026
2.4.1	Oct 12, 2026
2.4.0	Oct 10, 2026
2.3.2	Oct 10, 2026
2.3.0	Oct 10, 2026
2.2.0	Oct 10, 2026
2.1.0	Oct 10, 2026
2.0.0	Oct 10, 2026
1.3.0	Oct 10, 2026
1.2.4	Oct 10, 2026
2.3.1	Sep 13, 2026
2.1.1	Sep 6, 2026
1.2.3	Sep 5, 2026
1.2.2	Aug 31, 2026
1.2.1	Aug 30, 2026
1.2.0	Aug 29, 2026
1.1.1	Aug 29, 2026
1.1.0	Aug 29, 2026
1.1.3	Aug 29, 2026
1.1.2	Aug 29, 2026
1.0.7	Jan 10, 2026
1.0.0	Dec 29, 2025
0.1.0	Nov 25, 2024

STANDING

#24,282of 150,963 active serversTop 25%

Ranks ahead of 126,681 of 150,963 servers on MCP Toplist.

BADGE

Show your rank

Maintain this server? Add the live rank badge to your README — it updates automatically as the leaderboard changes.

Markdown

[![MCP Toplist](https://mcptoplist.com/badge/io.github.mcp-z%2Fmcp-sheets.svg)](https://mcptoplist.com/server/io.github.mcp-z%2Fmcp-sheets)

HTML

<a href="https://mcptoplist.com/server/io.github.mcp-z%2Fmcp-sheets"><img src="https://mcptoplist.com/badge/io.github.mcp-z%2Fmcp-sheets.svg" alt="MCP Toplist: Top 25% of 150,963" /></a>

Variants: append ?metric=score or ?metric=stars to the image URL.

FAQ

Frequently asked questions

Is Google Sheets listed on the Official MCP Registry?: Yes — Google Sheets is listed on the Official MCP Registry.
How many versions does Google Sheets have?: MCP Toplist tracks 23 versions of Google Sheets, most recently published on Oct 12, 2026.

Used in projects

Do you run this server?

Community projects list the MCP servers behind real agents and apps. Publish yours and this page will link to it.

EXPLORE

All MCP Servers Official MCP Servers Best MCP Servers Most Active MCP Servers New MCP Servers Best New MCP Servers