mcp-gsheets
Rank #1,420io.github.freema/mcp-gsheets
MCP server for Google Sheets API — read, write, format, batch operations.
mcp-gsheets is a Model Context Protocol (MCP) server published by freema. It ranks #1,420 of 115,460 servers tracked on MCP Toplist, and its repository has 95 GitHub stars. mcp-gsheets is listed across 4 registries — Official MCP, Glama, PulseMCP and mcp.so, with 3 tracked versions. It was first listed on May 25, 2025 and most recently updated on Aug 10, 2026.
Ranks ahead of 114,040 of 115,460 servers on MCP Toplist.
Use mcp-gsheets
Requires user-supplied configuration before first use — typically an API key, token or connection string set via environment variables.
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-gsheetsReplace each placeholder with your own value before saving.
[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.
{
"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.
{
"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.
{
"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.
{
"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.
{
"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.
Show your rank
Maintain this server? Add the live rank badge to your README — it updates automatically as the leaderboard changes.
[](https://mcptoplist.com/server/io.github.freema%2Fmcp-gsheets)<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 115,460" /></a>Variants: append ?metric=score or ?metric=stars to the image URL.
Listed on 2 registries (2 delisted)
freema
Other servers by freema
- OpenClaw MCP Server#2,187 · 3 vers
- mcp-jira-stdio#4,891 · 2 vers
- MCP Design System Extractor#5,361 · 1 ver
- pixelforge-mcp#22,789 · 3 vers
Available versions (3)
| Version | Published |
|---|---|
| 1.10.1 | Aug 10, 2026 |
| 1.10.0 | Jul 27, 2026 |
| 1.8.1 | Apr 26, 2026 |
Frequently asked questions
- Who maintains mcp-gsheets?
- mcp-gsheets is maintained by freema, which publishes 5 MCP servers (12 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 3 versions of mcp-gsheets, most recently published on Aug 10, 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.