PluginBench
MCP Server
Maintained

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.

transport: stdio
Config generated by PluginBench — verify against the source before use.
~/Library/Application Support/Claude/claude_desktop_config.json
{
  "mcpServers": {
    "google-sheets": {
      "command": "uvx",
      "args": [
        "mcparmory-google-sheets"
      ]
    }
  }
}

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

What is the Google Sheets MCP server?

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.

Is it free to use?

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.

How do I install it in Cursor or Claude?

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.

What authentication is required?

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.

Can I use it with existing spreadsheets?

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.

What operations are supported?

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.

<p align="center"> <img src="https://wjxawmrpsfuivlicnepc.supabase.co/storage/v1/object/public/newsletter/logo-armory-no-background.png" alt="MCP Armory" height="64"> </p> <h1 align="center">MCP Armory Registry</h1> <p align="center"> Production-ready MCP servers for popular APIs, generated by <a href="https://mcpblacksmith.com">MCP Blacksmith</a>. </p> <p align="center"> <a href="https://github.com/mcparmory/registry/stargazers"><img src="https://img.shields.io/github/stars/mcparmory/registry?style=flat&color=gold" alt="GitHub Stars"></a> <a href="https://github.com/mcparmory/registry/blob/main/servers/github/LICENSE"><img src="https://img.shields.io/badge/license-MIT-blue" alt="License"></a> <img src="https://img.shields.io/badge/servers-79-8A2BE2" alt="Servers"> <img src="https://img.shields.io/badge/python-3.11+-3776AB?logo=python&logoColor=white" alt="Python 3.11+"> </p> <p align="center"> <a href="#servers">Servers</a> &middot; <a href="#install--usage">Install & Usage</a> &middot; <a href="#features">Features</a> &middot; <a href="#how-servers-are-generated">How it works</a> &middot; <a href="#license">License</a> </p>

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:

  1. Parses an OpenAPI specification
  2. Transforms operations through LLM-driven passes (naming, parameter filtering, enhancement, classification)
  3. Generates a complete MCP server with auth, models, validation, and configuration
  4. Tests every tool against the live API using an autonomous agent
  5. 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> &middot; <a href="https://mcpblacksmith.com">MCP Blacksmith</a> &middot; <a href="https://docs.mcpblacksmith.com/quickstart">Docs</a> </p>

Related MCP servers

Manage Grafana dashboards, users, teams, alerts, data sources, and access control via MCP.

30
Python
View repository →

Look up IP address geolocation data including country, city, timezone, and ISP details

30
Python
View repository →

AI-powered email marketing automation and campaign management via Klaviyo API

30
Python
View repository →

Manage LaunchDarkly feature flags, segments, projects, environments, and team members via MCP.

30
Python
View repository →

Create short links, manage domains, and track click analytics with Linkly API integration

30
Python
View repository →

Search the web and fetch pages with sourced results, optimized for AI agents

30
Python
View repository →