Google Sheets MCP Server

Google Sheets MCP Server

Automate Google Sheets with Model Context Protocol integration.

View on GitHub Visit Website
12
Stars
3
Forks
12
Watchers
0
Issues
Google Sheets MCP Server enables seamless integration between Google Sheets and any MCP-compatible client, providing rich API access for spreadsheet automation. It offers full CRUD operations on spreadsheets and tables, secure authentication with Google Service Accounts, and compatibility with tools like Continue.dev, Claude Desktop, and Perplexity. The service can be rapidly installed with the uvx package manager, making it fast and easy to connect Google Sheets to various AI and automation workflows.

Key Features

Full CRUD operations for Google Sheets and tables
Secure authentication via Google Service Account
Easy installation via uvx package manager
Seamless integration with MCP-compatible clients
Supports Continue.dev, Perplexity, Claude Desktop, and more
API layer for spreadsheet automation
Comprehensive context handling for model workflows
Automatic server configuration through environment variables
Supports Google Sheets and Google Drive APIs
Configurable for multiple clients and use cases

Use Cases

Automating data entry and retrieval in Google Sheets from AI tools
Integrating spreadsheet processing into custom model pipelines
Enabling LLM-powered assistants to update and manage sheets
Securely managing Google Sheets in collaborative environments
Building dashboards that synchronize real-time data with spreadsheets
Batch processing and bulk operations on Google Sheets
Connecting workflow automation tools with spreadsheet data
Automated report generation and data analysis via sheet APIs
Enabling MCP agents to access business data stored in Google Sheets
Synchronizing multiple data sources with Google Sheets for unified access

README

Google Sheets MCP Server

Powerful tools for automating Google Sheets using Model Context Protocol (MCP)

mcp-name: io.github.henilcalagiya/google-sheets-mcp

Overview

Google Sheets MCP Server provides seamless integration of Google Sheets with any MCP-compatible client. It enables full spreadsheet automation — including creating, reading, updating, and deleting sheets — through a simple and secure API layer.

Features

  • Full CRUD support for Google Sheets and tables
  • Works with Continue.dev, Claude Desktop, Perplexity, and other MCP clients
  • Secure authentication via Google Service Account
  • Comprehensive tools for Google Sheets automation
  • Automatic installation via uvx

Requirements

  • Python 3.10+
  • uv package manager (for uvx command)
  • A Google Cloud project with a Service Account
  • MCP-compatible client (e.g., Continue.dev)

Install uv:

bash
# macOS/Linux
curl -LsSf https://astral.sh/uv/install.sh | sh

# Windows PowerShell
irm https://astral.sh/uv/install.ps1 | iex

Quick Start

1. Set Up Google Service Account

Step 1: Create a Google Cloud Project

  1. Go to Google Cloud Console
  2. Click "Select a project" → "New Project"
  3. Enter a project name (e.g., "my-sheets-automation")
  4. Click "Create"

Step 2: Enable Required APIs

  1. In your project, go to "APIs & Services" → "Library"
  2. Search for "Google Sheets API" → Click → "Enable"
  3. Search for "Google Drive API" → Click → "Enable"

Step 3: Create Service Account

  1. Go to "IAM & Admin" → "Service Accounts"
  2. Click "Create Service Account"
  3. Enter service account name (e.g., "sheets-mcp-service")
  4. Click "Create and Continue"
  5. Skip role assignment → Click "Continue"
  6. Click "Done"

Step 4: Generate JSON Key

  1. Click on your new service account email
  2. Go to "Keys" tab → "Add Key" → "Create new key"
  3. Choose "JSON" format → Click "Create"
  4. The JSON file will download automatically

Step 5: Extract Required Values Open the downloaded JSON file and note these values:

  • project_id (e.g., "my-sheets-automation-123456")
  • private_key_id (e.g., "a4ae73111b11b2c3b07cc01006e71eb8230dfa29")
  • private_key (the long private key starting with "-----BEGIN PRIVATE KEY-----")
  • client_email (e.g., "sheets-mcp-service@my-sheets-automation-123456.iam.gserviceaccount.com")
  • client_id (e.g., "113227823918217958816")
  • client_x509_cert_url (e.g., "https://www.googleapis.com/robot/v1/metadata/x509/sheets-mcp-service%40my-sheets-automation-123456.iam.gserviceaccount.com")

Example Google service account JSON structure:

json
{
  "type": "service_account",
  "project_id": "your-project-id",
  "private_key_id": "your-private-key-id",
  "private_key": "-----BEGIN PRIVATE KEY-----\n...\n-----END PRIVATE KEY-----\n",
  "client_email": "your-service@your-project.iam.gserviceaccount.com",
  "client_id": "your-client-id",
  "auth_uri": "https://accounts.google.com/o/oauth2/auth",
  "token_uri": "https://oauth2.googleapis.com/token",
  "auth_provider_x509_cert_url": "https://www.googleapis.com/oauth2/v1/certs",
  "client_x509_cert_url": "https://www.googleapis.com/robot/v1/metadata/x509/your-service%40your-project.iam.gserviceaccount.com"
}

Follow this guide if needed

2. Configure MCP Client

json
{
  "mcpServers": {
    "google-sheets-mcp": {
      "command": "uvx",
      "args": ["google-sheets-mcp@latest"],
      "env": {
        "project_id": "your-project-id",
        "private_key_id": "your-private-key-id",
        "private_key": "-----BEGIN PRIVATE KEY-----\n...\n-----END PRIVATE KEY-----\n",
        "client_email": "your-service@your-project.iam.gserviceaccount.com",
        "client_id": "your-client-id",
        "client_x509_cert_url": "https://www.googleapis.com/robot/v1/metadata/x509/your-service%40your-project.iam.gserviceaccount.com"
      }
    }
  }
}

💡 Pro Tip: You can copy the values directly from your Google service account JSON file. The field names in the JSON file are used exactly as they are - no changes needed!

🔄 Backward Compatibility: The server also supports the old GOOGLE_ prefixed variable names (e.g., GOOGLE_PROJECT_ID) for existing configurations.

3. Share Your Google Sheet with the Service Account

  • Open your target Google Spreadsheet in your web browser.
  • Click the Share button.
  • Enter the service account email (e.g., your-service@your-project.iam.gserviceaccount.com) and assign Editor access.
  • Click Send to provide editor permissions.

🎉 You're all set! Your MCP client will automatically install and run the package when needed.

License

This project is licensed under the MIT License - see the LICENSE file for details.

Author

Henil C Alagiya

Support & Contributions:

  • 🐛 Report Issues: GitHub Issues
  • 💬 Questions: Reach out on LinkedIn
  • 🤝 Contributions: Pull requests welcome!

Star History

Star History Chart

Repository Owner

henilcalagiya

Repository Details

Language Python
Default Branch main
Size 538 KB
Contributors 1
License Other
MCP Verified Nov 12, 2025

Programming Languages

Python
98.58%
Shell
1.42%

Tags

API server

Join Our Newsletter

Stay updated with the latest AI tools, news, and offers by subscribing to our weekly newsletter.

We respect your privacy. Unsubscribe at any time.

Related MCPs

Discover similar Model Context Protocol servers

  • mcp-google-sheets

    mcp-google-sheets

    Your AI Assistant's Gateway to Google Sheets!

    mcp-google-sheets is a Python-based MCP server that bridges MCP-compatible clients and the Google Sheets API. It enables seamless interaction with Google Spreadsheets, allowing for data manipulation, automation, and workflow creation driven by AI tools via a standardized protocol. The server can be quickly deployed using 'uvx', supports service account authentication, and integrates with AI clients like Claude Desktop. It offers a defined set of tools to streamline spreadsheet operations securely and efficiently.

    • ⭐ 502
    • MCP
    • xing5/mcp-google-sheets
  • Google Workspace MCP Server

    Google Workspace MCP Server

    A secure MCP server bridging Google Workspace and AI clients.

    Google Workspace MCP Server implements the Model Context Protocol to enable secure integration between Google Workspace services—such as Gmail, Calendar, and Drive—and any MCP-compatible AI client. It allows users to read, search, create, update, and delete Google Calendar events, emails, and Drive files directly through an AI agent interface. The tool ensures authentication via Google OAuth and provides a seamless setup process for both server and client sides. This makes it easier for AI-powered workflows to interact with Google Workspace data securely and contextually.

    • ⭐ 20
    • MCP
    • giuseppe-coco/Google-Workspace-MCP-Server
  • Google Workspace MCP Server

    Google Workspace MCP Server

    Full natural language control of Google Workspace through the Model Context Protocol.

    Google Workspace MCP Server enables comprehensive natural language interaction with Google services such as Calendar, Drive, Gmail, Docs, Sheets, Slides, Forms, Tasks, and Chat via any MCP-compatible client or AI assistant. It supports both single-user and secure multi-user OAuth 2.1 authentication, providing a production-ready backend for custom apps. Built on FastMCP, it delivers high performance and advanced context handling, offering deep integration with the entire Google Workspace suite.

    • ⭐ 890
    • MCP
    • taylorwilsdon/google_workspace_mcp
  • MCP Google Drive Server

    MCP Google Drive Server

    Seamlessly connect Google Drive and Sheets with MCP tools for file access and editing.

    The MCP Google Drive Server enables integration with Google Drive and Google Sheets, allowing users to search, read, and retrieve files, as well as interact with spreadsheets. It provides MCP-compatible tools for searching files, reading file contents, reading spreadsheet ranges, and updating spreadsheet cells. Files in Google Drive are made accessible through standardized resources, supporting multiple export formats for Google Workspace files. Designed for easy authentication and configuration with Google Cloud, the server streamlines interactions between external systems and Google Drive resources.

    • ⭐ 228
    • MCP
    • isaacphi/mcp-gdrive
  • Google Ads MCP Server

    Google Ads MCP Server

    Seamlessly connect Google Ads API to MCP clients with automatic authentication and querying.

    Google Ads MCP Server is a FastMCP-powered Model Context Protocol server designed to integrate Google Ads API with MCP clients such as Claude Desktop. It provides automatic OAuth 2.0 authentication, smart token management, GAQL query execution, and keyword research tools. The server enables users to manage accounts, run advanced queries, and generate keyword ideas while maintaining secure local token storage. Optimized for one-click setup, it offers robust features for advertisers and developers looking to leverage Google Ads data with MCP-compatible tools.

    • ⭐ 76
    • MCP
    • gomarble-ai/google-ads-mcp-server
  • mcp-gsuite

    mcp-gsuite

    MCP server for integrating Google Gmail and Calendar with AI tools

    mcp-gsuite enables seamless integration of Google Workspace products, such as Gmail and Calendar, with AI models via the Model Context Protocol (MCP). It supports multiple Google accounts, OAuth2 authentication, and a variety of email and calendar management functions. Users can retrieve, compose, and manage emails or calendar events, and provide rich contextual information to AI systems.

    • ⭐ 457
    • MCP
    • MarkusPfundstein/mcp-gsuite
    • View all Alternatives

    Didn't find tool you were looking for?

    Be as detailed as possible for better results