Google Sheets Mcp

Name: Google Sheets Mcp
Author: henilcalagiya

by henilcalagiyacommunityv0.1.6

Google Sheets MCP Server provides seamless integration of Google Sheets with any MCP-compatible client, enabling full spreadsheet automation through a secure API layer.

From the registry: Powerful tools for automating Google Sheets using Model Context Protocol (MCP)

GitHub Repository

Install & configure

Prerequisites

required
Google Cloud service account
Create a service account, enable Google Sheets + Drive APIs, and download the JSON key
https://console.cloud.google.com/
required
Share the sheet with the service account
Share each target spreadsheet with the service account email as Editor

Install in your client

Paste into the AI you're chatting with — it will figure out the rest

Please install the `google-sheets-mcp-henilcalagiya` MCP server into my current AI client (that's you).

Required prerequisites (do these first if not already done):
- **Google Cloud service account** — Create a service account, enable Google Sheets + Drive APIs, and download the JSON key (https://console.cloud.google.com/)
- **Share the sheet with the service account** — Share each target spreadsheet with the service account email as Editor

Canonical MCP server config (stdio transport):
- command: `uvx`
- args: ["google-sheets-mcp@latest"]
- required environment variables:
  - `project_id`: GCP project ID (from service account JSON) (example: `<your-project-id>`)
  - `private_key_id`: Service account private key ID (example: `<your-private-key-id>`)
  - `private_key`: Service account private key (PEM) (example: `<your-private-key>`)
  - `client_email`: Service account email (example: `<your-service-account-email>`)
  - `client_id`: Service account client ID (example: `<your-client-id>`)
  - `client_x509_cert_url`: Service account x509 cert URL (example: `<your-cert-url>`)

Note: GOOGLE_* prefixed variants of these env vars are also accepted for backwards compatibility.

Add this MCP server to my current client's config in the correct format for you. If you need secrets or credentials I haven't provided, ASK me — do not invent values or leave raw placeholders. After adding it, tell me how to verify the server is connected.

Note: GOOGLE_* prefixed variants of these env vars are also accepted for backwards compatibility.