com.mcparmory/google-sheets MCP Server
com.mcparmory/google-sheets
Create, read, and modify Google Sheets spreadsheets and data via AI agents.
What is the com.mcparmory/google-sheets MCP server?
The Google Sheets MCP server enables AI agents to create, read, and modify spreadsheet data, formatting, and sheets in Google Sheets. It exposes the full Google Sheets API as MCP tools, allowing agents to automate spreadsheet operations with authentication and validation.
This server connects Claude and other AI agents to Google Sheets, letting you programmatically manage spreadsheets—create sheets, read and write cell data, apply formatting, and more. Use it to automate data entry, generate reports, or sync data between systems.
How to install com.mcparmory/google-sheets
Copy-paste configuration for popular MCP clients.
Use cases
- Automatically populate spreadsheets with data from other APIs or databases
- Generate formatted reports and dashboards in Google Sheets
- Read spreadsheet data and use it in AI workflows
- Update multiple cells or sheets based on conditions or external triggers
- Sync data between Google Sheets and other business tools
com.mcparmory/google-sheets MCP server FAQ
It's an MCP server that exposes Google Sheets API operations as tools for AI agents, enabling create, read, and modify operations on spreadsheets, cells, and formatting.
The server itself is free (MIT licensed), but you need a Google Cloud project with the Sheets API enabled and valid credentials to use it.
Install via pip (pip install mcparmory-google-sheets) or use uvx (uvx mcparmory-google-sheets), then configure it in your MCP client's settings with your Google API credentials.
You need Google OAuth2 credentials or a service account key. Set up a Google Cloud project, enable the Sheets API, and provide the credentials to the server.
Yes, you can read from and modify existing Google Sheets by providing the spreadsheet ID and specifying the ranges or sheets you want to work with.
The server supports all Google Sheets API operations including creating/deleting sheets, reading/writing cell values, applying formatting, and managing spreadsheet properties.
README (reference)
Source of truth, from the repository.
MCP servers that connect AI agents to real-world APIs. Each server is a standalone Python package — generated from the upstream OpenAPI spec using MCP Blacksmith and tested against the live API before release. Hosted on MCP Armory or run independently.
<!-- SERVERS:BEGIN -->Servers
🧠 AI & Machine Learning ElevenLabs · Linkup · Parallel · Perplexity AI · Ragie · Replicate
📊 Analytics Ahrefs · Datadog · Google Analytics · Google Search Console · Linkly · Mixpanel · PostHog
⛓️ Blockchain & Crypto Alchemy NFT
💼 CRM & Sales Apollo
💬 Communication Atlassian Confluence · Google Gmail · MailerSend · Mailtrap · Postmark · Resend · Slack
🗄️ Data & Databases Enigma · Pinecone
🛠️ Developer Tools AgentQL · Apify · Bitbucket · Bright Data · Browserbase · BuiltWith · Canvas · CircleCI · Codacy · Contentful Management · ConvertAPI · E2B · Firecrawl · GitHub · GitLab · LaunchDarkly · Postman · Scrapingant · Semrush AppCenter · Sentry
📄 Documents & Printing PDF.co
🛒 E-commerce Shopify Admin
💰 Finance Alpha Vantage · Polygon · Ramp
👥 HR & Recruiting BambooHR
☁️ Infrastructure Globalping · Grafana · PagerDuty · Rootly · Runpod
⚖️ Legal & Compliance NetLicensing
🗺️ Maps & Location Google Maps Platform · IP2Location.io IP Geolocation · OpenCage Geocoding
📣 Marketing Customer.io Journeys Track · Klaviyo
🎬 Media & Entertainment Canva · Perigon
✅ Productivity Airtable · Asana · Atlassian Jira · ClickUp · Figma · Google Sheets · Miro · Notion · Outline · Shortcut
🔍 Search Algolia Search · Google Search
📦 Storage Box · Files.com · Google Drive
📌 Other Close
More servers are being added continuously.
<!-- SERVERS:END -->Install & Usage
Every server is a standalone PyPI package (mcparmory-<server-name>). Each server's own README.md has full credential setup and configuration instructions.
# With uvx (no install needed)
uvx mcparmory-github
# With pip
pip install mcparmory-github
mcparmory-github
MCP client configuration (Claude Desktop, Cursor, Codex, Claude Code):
{
"mcpServers": {
"github": {
"command": "uvx",
"args": ["mcparmory-github"],
"env": {
"BEARER_TOKEN": "ghp_your_token_here"
}
}
}
}
Features
Every server in this registry provides:
- Full API coverage — all endpoints from the OpenAPI spec are exposed as MCP tools
- Authentication — API key, Bearer token, Basic auth, OAuth2, JWT, OpenID Connect, and mutual TLS
- Multi-auth — servers that support multiple auth methods let you configure whichever you prefer
- Pydantic validation — request parameters are validated before sending to the API
- Resilience — configurable retries with exponential backoff, connection pooling, and timeouts
- Response sanitization — optional redaction of sensitive fields from API responses
How servers are generated
Servers are generated by MCP Blacksmith, an automated pipeline that:
- Parses an OpenAPI specification
- Transforms operations through LLM-driven passes (naming, parameter filtering, enhancement, classification)
- Generates a complete MCP server with auth, models, validation, and configuration
- Tests every tool against the live API using an autonomous agent
- Deploys passing servers to this registry
The generator targets Python 3.11+ and uses FastMCP as the MCP framework.
Contributing
Servers are auto-generated — don't edit server code directly. If you find an issue, open a GitHub Issue describing:
- Broken or deprecated endpoints
- Missing or incorrect parameters
- Authentication problems
- Incorrect request/response models
We'll re-generate the affected server with the fix. To request a new server, open an issue with a link to the API's OpenAPI spec or documentation.
License
Each generated server is released under the MIT License. The underlying APIs have their own terms of service — see individual server READMEs for details.
<p align="center"> <a href="https://mcparmory.com">MCP Armory</a> · <a href="https://mcpblacksmith.com">MCP Blacksmith</a> · <a href="https://docs.mcpblacksmith.com/quickstart">Docs</a> </p>
Related MCP servers

com.mcparmory/grafana
Manage Grafana dashboards, users, teams, alerts, data sources, and access control via MCP.

com.mcparmory/ip2location-geolocation
Look up IP address geolocation data including country, city, timezone, and ISP details

com.mcparmory/klaviyo
AI-powered email marketing automation and campaign management via Klaviyo API

com.mcparmory/launchdarkly
Manage LaunchDarkly feature flags, segments, projects, environments, and team members via MCP.

com.mcparmory/linkly
Create short links, manage domains, and track click analytics with Linkly API integration

com.mcparmory/linkup
Search the web and fetch pages with sourced results, optimized for AI agents