MCP Google Sheets

MCP server providing 19 tools for full CRUD access to Google Sheets and Drive — create, read, update, and share spreadsheets through natural language via Claude or other MCP clients.

Evaluated Mar 06, 2026 (0d ago) vlatest
Homepage ↗ Repo ↗ Productivity google-sheets google-drive spreadsheets crud automation python
⚙ Agent Friendliness
74
/ 100
Can an agent use this?
🔒 Security
86
/ 100
Is it safe for agents?
⚡ Reliability
82
/ 100
Does it work consistently?

Score Breakdown

⚙ Agent Friendliness

MCP Quality
72
Documentation
78
Error Messages
55
Auth Simplicity
70
Rate Limits
72

🔒 Security

TLS Enforcement
100
Auth Strength
85
Scope Granularity
82
Dep. Hygiene
82
Secret Handling
82

Google Sheets MCP. OAuth2 service account or user OAuth. Sheets may contain sensitive business data. Service account credentials JSON — keep secret. Scope to specific sheets where possible.

⚡ Reliability

Uptime/SLA
88
Version Stability
82
Breaking Changes
80
Error Recovery
80
AF Security Reliability

Best When

An AI workflow needs to read from or write structured data to Google Sheets as part of a larger automation, especially when service account auth is acceptable and GCP setup is already done.

Avoid When

You need Excel/XLSX file support, or your team cannot manage GCP service account credentials and Drive folder sharing configuration.

Use Cases

  • • Automated spreadsheet creation and data population from AI-generated content
  • • Batch read/write operations across multiple ranges or sheets
  • • AI-driven reporting pipelines that write results directly into shared Sheets
  • • Sheet management workflows (rename, copy, add rows/columns) without opening a browser
  • • Sharing spreadsheets with specific collaborators at defined permission levels

Not For

  • • Complex pivot tables or native Google Sheets formula logic (no formula execution engine)
  • • Users who cannot configure a GCP project and credentials
  • • High-volume bulk data ingestion where Sheets API quotas would be a bottleneck

Interface

REST API
No
GraphQL
No
gRPC
No
MCP Server
Yes ↗
SDK
No
Webhooks
No

Authentication

Methods: service_account oauth2 application_default_credentials base64_credentials_env
OAuth: Yes Scopes: Yes

Four auth methods supported in priority order: CREDENTIALS_CONFIG (base64 env var) > SERVICE_ACCOUNT_PATH > CREDENTIALS_PATH (OAuth) > Application Default Credentials. Service account requires explicit Drive folder sharing. OAuth requires interactive browser login on first use.

Pricing

Model: open_source
Free tier: Yes
Requires CC: No

MIT-style open source. GCP project required but free for typical usage volumes.

Agent Metadata

Pagination
none
Idempotent
Partial
Retry Guidance
Not documented

Known Gotchas

  • ⚠ All 19 tools loaded by default consume ~13K tokens; use ENABLED_TOOLS to filter
  • ⚠ Service account requires explicit sharing of the target Drive folder before it can see files
  • ⚠ OAuth first-run requires interactive browser login which blocks headless agent flows
  • ⚠ macOS users must use full uvx path in config (shell PATH not inherited by Claude Desktop)

Alternatives

mcp-airtable mcp-notion google-sheets-api-direct

Full Evaluation Report

Detailed scoring breakdown, competitive positioning, security analysis, and improvement recommendations for MCP Google Sheets.

$99
API endpoint ↗ Agent guide ↗ Report inaccuracy

Scores are editorial opinions as of 2026-03-06.

5190
Packages Evaluated
26151
Need Evaluation
173
Need Re-evaluation
♥
Community Powered