SERVER

mcp-gsheets

Rank #1,721

io.github.freema/mcp-gsheets

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

5 versions

103 GitHub stars

by freema (6 servers)View repository ↗

First listed

May 25, 2025

Last publish date

Sep 19, 2026

PURPOSE

What you can do with mcp-gsheets

mcp-gsheets is a Model Context Protocol (MCP) server published by freema. It ranks #1,721 of 144,396 active servers on MCP Toplist, and its repository has 103 GitHub stars. mcp-gsheets is listed across 4 registries — Official MCP, Glama, PulseMCP and mcp.so, with 5 tracked versions. It was first listed on May 25, 2025 and most recently updated on Sep 19, 2026.

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

CAPABILITIES AND LIMITATIONS

What mcp-gsheets can and cannot do

Not verifiedMCP Toplist has not catalogued this server's tools or limitations. The repository README lists them.

REQUIREMENTS

What you need before using mcp-gsheets

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 Glama, last synced Oct 16, 2026. Not independently verified by MCP Toplist.

Declared in the registry install config

GOOGLE_PROJECT_ID · required
GOOGLE_APPLICATION_CREDENTIALS · optional
GOOGLE_SERVICE_ACCOUNT_KEY · optional
GOOGLE_PRIVATE_KEY · optional
GOOGLE_CLIENT_EMAIL · optional

INSTALLATION AND FIRST TASK

Connect mcp-gsheets and confirm it works

npm package

claude mcp add mcp-gsheets -e "GOOGLE_PROJECT_ID=<your GOOGLE_PROJECT_ID>" -e "GOOGLE_APPLICATION_CREDENTIALS=<your GOOGLE_APPLICATION_CREDENTIALS>" -e "GOOGLE_SERVICE_ACCOUNT_KEY=<your GOOGLE_SERVICE_ACCOUNT_KEY>" -e "GOOGLE_PRIVATE_KEY=<your GOOGLE_PRIVATE_KEY>" -e "GOOGLE_CLIENT_EMAIL=<your GOOGLE_CLIENT_EMAIL>" -- npx -y mcp-gsheets

Replace each placeholder with your own value before saving.

npm package

[mcp_servers.mcp-gsheets]
command = "npx"
args = ["-y", "mcp-gsheets"]

[mcp_servers.mcp-gsheets.env]
GOOGLE_PROJECT_ID = "<your GOOGLE_PROJECT_ID>"
GOOGLE_APPLICATION_CREDENTIALS = "<your GOOGLE_APPLICATION_CREDENTIALS>"
GOOGLE_SERVICE_ACCOUNT_KEY = "<your GOOGLE_SERVICE_ACCOUNT_KEY>"
GOOGLE_PRIVATE_KEY = "<your GOOGLE_PRIVATE_KEY>"
GOOGLE_CLIENT_EMAIL = "<your GOOGLE_CLIENT_EMAIL>"

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

npm package

{
  "mcpServers": {
    "mcp-gsheets": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-gsheets"
      ],
      "env": {
        "GOOGLE_PROJECT_ID": "<your GOOGLE_PROJECT_ID>",
        "GOOGLE_APPLICATION_CREDENTIALS": "<your GOOGLE_APPLICATION_CREDENTIALS>",
        "GOOGLE_SERVICE_ACCOUNT_KEY": "<your GOOGLE_SERVICE_ACCOUNT_KEY>",
        "GOOGLE_PRIVATE_KEY": "<your GOOGLE_PRIVATE_KEY>",
        "GOOGLE_CLIENT_EMAIL": "<your GOOGLE_CLIENT_EMAIL>"
      }
    }
  }
}

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

npm package

{
  "mcpServers": {
    "mcp-gsheets": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-gsheets"
      ],
      "env": {
        "GOOGLE_PROJECT_ID": "<your GOOGLE_PROJECT_ID>",
        "GOOGLE_APPLICATION_CREDENTIALS": "<your GOOGLE_APPLICATION_CREDENTIALS>",
        "GOOGLE_SERVICE_ACCOUNT_KEY": "<your GOOGLE_SERVICE_ACCOUNT_KEY>",
        "GOOGLE_PRIVATE_KEY": "<your GOOGLE_PRIVATE_KEY>",
        "GOOGLE_CLIENT_EMAIL": "<your GOOGLE_CLIENT_EMAIL>"
      }
    }
  }
}

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-gsheets": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "mcp-gsheets"
      ],
      "env": {
        "GOOGLE_PROJECT_ID": "<your GOOGLE_PROJECT_ID>",
        "GOOGLE_APPLICATION_CREDENTIALS": "<your GOOGLE_APPLICATION_CREDENTIALS>",
        "GOOGLE_SERVICE_ACCOUNT_KEY": "<your GOOGLE_SERVICE_ACCOUNT_KEY>",
        "GOOGLE_PRIVATE_KEY": "<your GOOGLE_PRIVATE_KEY>",
        "GOOGLE_CLIENT_EMAIL": "<your GOOGLE_CLIENT_EMAIL>"
      }
    }
  }
}

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

npm package

{
  "mcpServers": {
    "mcp-gsheets": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-gsheets"
      ],
      "env": {
        "GOOGLE_PROJECT_ID": "<your GOOGLE_PROJECT_ID>",
        "GOOGLE_APPLICATION_CREDENTIALS": "<your GOOGLE_APPLICATION_CREDENTIALS>",
        "GOOGLE_SERVICE_ACCOUNT_KEY": "<your GOOGLE_SERVICE_ACCOUNT_KEY>",
        "GOOGLE_PRIVATE_KEY": "<your GOOGLE_PRIVATE_KEY>",
        "GOOGLE_CLIENT_EMAIL": "<your GOOGLE_CLIENT_EMAIL>"
      }
    }
  }
}

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

npm package

{
  "mcpServers": {
    "mcp-gsheets": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-gsheets"
      ],
      "env": {
        "GOOGLE_PROJECT_ID": "<your GOOGLE_PROJECT_ID>",
        "GOOGLE_APPLICATION_CREDENTIALS": "<your GOOGLE_APPLICATION_CREDENTIALS>",
        "GOOGLE_SERVICE_ACCOUNT_KEY": "<your GOOGLE_SERVICE_ACCOUNT_KEY>",
        "GOOGLE_PRIVATE_KEY": "<your GOOGLE_PRIVATE_KEY>",
        "GOOGLE_CLIENT_EMAIL": "<your GOOGLE_CLIENT_EMAIL>"
      }
    }
  }
}

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.

ALTERNATIVES

When to choose another server

Other servers by freema

View all freema servers →

No task-specific alternatives are catalogued for mcp-gsheetsyet; the list above is its publisher's other servers.

MAINTENANCE AND EVIDENCE

What changed, and when this was checked

First listed: May 25, 2025
Latest version published: Sep 19, 2026
Version history: 5 versions tracked (below)
Requirements evidence: Declared by Glama, last synced Oct 16, 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 16, 2026

Registry sightings

Official MCP ↗listed since Apr 26, 2026 · still listed
Glama ↗listed since Apr 26, 2026 · still listed
PulseMCP ↗listed since Jun 4, 2026 · still listed
mcp.so ↗listed since Jun 4, 2026 · still listed

Do you maintain mcp-gsheets? to correct or enrich this profile.

VERSIONS

Available versions (5)

Version	Published
1.10.3	Sep 19, 2026
1.10.1	Aug 10, 2026
1.10.0	Jul 27, 2026
1.9.0	Jul 10, 2026
1.8.1	Apr 26, 2026

STANDING

#1,721of 144,396 active serversTop 5%

Ranks ahead of 142,675 of 144,396 servers on MCP Toplist.

Recent momentum

+40GitHub stars since Apr 27 (+63%)

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.freema%2Fmcp-gsheets.svg)](https://mcptoplist.com/server/io.github.freema%2Fmcp-gsheets)

HTML

<a href="https://mcptoplist.com/server/io.github.freema%2Fmcp-gsheets"><img src="https://mcptoplist.com/badge/io.github.freema%2Fmcp-gsheets.svg" alt="MCP Toplist: Top 5% of 144,396" /></a>

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

FAQ

Frequently asked questions

Who maintains mcp-gsheets?: mcp-gsheets is maintained by freema, which publishes 6 MCP servers (27 total versions) tracked on MCP Toplist.
Is mcp-gsheets listed on the Official MCP Registry?: Yes — mcp-gsheets is listed on the Official MCP Registry, alongside Glama, PulseMCP and mcp.so.
How many versions does mcp-gsheets have?: MCP Toplist tracks 5 versions of mcp-gsheets, most recently published on Sep 19, 2026.
Where can I find the source code for mcp-gsheets?: The source code for mcp-gsheets is hosted at github.com/freema/mcp-gsheets.

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 GitHub MCP Servers Best MCP Servers Most Active MCP Servers New MCP Servers Best New MCP Servers