AI Plugin Index
mcp-gsheets
CommunityMCP server by freema · updated · ★ 104 · 2.4k downloads a week
MCP server for Google Sheets API — read, write, format, batch operations. mcp-gsheets is a community project by freema, not verified by a company domain.
Last commit 18 days ago
MIT: permissive, fine for commercial use
Clear description, published package or server URL, 104 stars, original repository
No risky patterns in the files we checked
What you need
| Setting | Needed | What it is |
|---|---|---|
GOOGLE_PROJECT_IDEnvironment variable | Required | Google Cloud project ID |
GOOGLE_APPLICATION_CREDENTIALSEnvironment variable | Optional | Path to service account key JSON file (auth method 1) |
GOOGLE_SERVICE_ACCOUNT_KEYEnvironment variable, secret | Optional | Service account key as JSON string (auth method 2) |
GOOGLE_PRIVATE_KEYEnvironment variable, secret | Optional | Service account private key in PEM format (auth method 3) |
GOOGLE_CLIENT_EMAILEnvironment variable | Optional | Service account email (auth method 3) |
From the publisher's entry in the official MCP Registry. Required settings are already in the install config below as placeholders.
Install mcp-gsheets
Built from the published package, never by AIclaude mcp add mcp-gsheets -e GOOGLE_PROJECT_ID=YOUR_GOOGLE_PROJECT_ID -- npx -y mcp-gsheetsRun in your terminal. Add --scope user to use it in every project.
{
"mcpServers": {
"mcp-gsheets": {
"command": "npx",
"args": [
"-y",
"mcp-gsheets"
],
"env": {
"GOOGLE_PROJECT_ID": "YOUR_GOOGLE_PROJECT_ID"
}
}
}
}Settings, Developer, Edit config. Paste into claude_desktop_config.json and restart.
{
"mcpServers": {
"mcp-gsheets": {
"command": "npx",
"args": [
"-y",
"mcp-gsheets"
],
"env": {
"GOOGLE_PROJECT_ID": "YOUR_GOOGLE_PROJECT_ID"
}
}
}
}Add to ~/.cursor/mcp.json (all projects) or .cursor/mcp.json (this project).
{
"servers": {
"mcp-gsheets": {
"command": "npx",
"args": [
"-y",
"mcp-gsheets"
],
"env": {
"GOOGLE_PROJECT_ID": "YOUR_GOOGLE_PROJECT_ID"
}
}
}
}Add to .vscode/mcp.json. VS Code uses "servers", not "mcpServers".
codex mcp add mcp-gsheets --env GOOGLE_PROJECT_ID=YOUR_GOOGLE_PROJECT_ID -- npx -y mcp-gsheets{
"mcpServers": {
"mcp-gsheets": {
"command": "npx",
"args": [
"-y",
"mcp-gsheets"
],
"env": {
"GOOGLE_PROJECT_ID": "YOUR_GOOGLE_PROJECT_ID"
}
}
}
}Add to ~/.gemini/config/mcp_config.json (all projects) or .agents/mcp_config.json (this project).
gemini mcp add mcp-gsheets npx -y mcp-gsheetsGemini CLI was replaced by Antigravity CLI in June 2026 and remains only for enterprise licences and paid API keys.
MCP servers run with your permissions and can read what you give them access to. Some need an API key: check the README and add it under env in the mcp-gsheets block.
Security check
ANo download-and-run commands, hidden instructions or signs of sending keys out were found.
Checked automatically: README.md, package.json. This looks for known risky patterns and is not a full audit. How grades work
Alternatives to mcp-gsheets
All alternatives →
Manage Jitsu data pipelines: destinations, streams, connections, functions, live events.
Validate oh-my-posh configurations and segment snippets against the official schema.
Real-time global intelligence across conflict, markets, energy, trade, shipping and cyber. 95 tools.
Securely access and manage FHIR healthcare data stored in Medplum.
Manage monitors, status pages, incidents and maintenances in your openstatus workspace.
MCP tools for interacting with Microsoft Fabric
mcp-gsheets: common questions
How do I install mcp-gsheets?
In Claude Code run claude mcp add mcp-gsheets -e GOOGLE_PROJECT_ID=YOUR_GOOGLE_PROJECT_ID -- npx -y mcp-gsheets. For Claude Desktop, Cursor and VS Code, paste the config shown above and restart. See the install guides.
Is mcp-gsheets the official server?
mcp-gsheets is a community project by freema, not verified by a company domain.
Is mcp-gsheets free?
The code is published under the MIT licence. The service it connects to may have its own pricing.
Is mcp-gsheets safe to use?
It scores 84 of 100. Grades: maintenance A, licence A, quality B. Security check: grade A, no risky patterns found in the files checked. Review the code before you install. How grades work.
What are alternatives to mcp-gsheets?
Similar MCP servers: Jitsu, Oh My Posh Validator, World Monitor, mcp.
Does mcp-gsheets work with ChatGPT?
Not directly. It runs locally, and ChatGPT only connects to remote servers with a URL. Use it in Claude Code, Claude Desktop, Cursor, VS Code or Codex.