Skip to main content
Glama

google-sheets-mcp

Google Sheets MCP Server

Powerful tools for automating Google Sheets using Model Context Protocol (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:

# 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:

Follow this guide if needed

2. Configure MCP Client

{ "mcpServers": { "google-sheets-mcp": { "command": "uvx", "args": ["google-sheets-mcp@latest"], "env": { "GOOGLE_PROJECT_ID": "your-project-id", "GOOGLE_PRIVATE_KEY": "-----BEGIN PRIVATE KEY-----\n...\n-----END PRIVATE KEY-----\n", "GOOGLE_CLIENT_EMAIL": "your-service@your-project.iam.gserviceaccount.com" } } } }

Extract these values from your Google service account JSON file:

  • project_idGOOGLE_PROJECT_ID
  • private_keyGOOGLE_PRIVATE_KEY
  • client_emailGOOGLE_CLIENT_EMAIL

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!
Install Server
A
security – no known vulnerabilities
F
license - not found
A
quality - confirmed to work

remote-capable server

The server can be hosted and run remotely because it primarily relies on remote services or has no dependency on the local environment.

Your AI Assistant's Gateway to Google Sheets! 25 powerful tools for seamless Google Sheets automation via MCP

  1. Overview
    1. Features
      1. Requirements
        1. Quick Start
          1. 1. Set Up Google Service Account
          2. 2. Configure MCP Client
          3. 3. Share Your Google Sheet with the Service Account
        2. License
          1. Author

            Related MCP Servers

            • -
              security
              F
              license
              -
              quality
              Provides SEO automation with tools for keyword research, SERP analysis, and competitor analysis through Google Ads API integration, enabling AI assistants to access these capabilities via MCP.
              Last updated -
              22
              JavaScript
            • -
              security
              A
              license
              -
              quality
              Enables AI assistants to interact with and manage Google Cloud Platform resources including Compute Engine, Cloud Run, Storage, BigQuery, and other GCP services through a standardized MCP interface.
              Last updated -
              3
              Python
              MIT License
              • Linux
              • Apple
            • -
              security
              A
              license
              -
              quality
              A tool for manipulating Google Spreadsheet and Google Drive using MCP (Metoro Control Protocol).
              Last updated -
              10
              Python
              MIT License
              • Linux
              • Apple
            • -
              security
              A
              license
              -
              quality
              A Model Context Protocol (MCP) connector that allows AI agents to directly interact with Google Sheets, enabling creation, reading, and modification of spreadsheets through natural language.
              Last updated -
              84
              JavaScript
              MIT License

            View all related MCP servers

            MCP directory API

            We provide all the information about MCP servers via our MCP API.

            curl -X GET 'https://glama.ai/api/mcp/v1/servers/henilcalagiya/google-sheets-mcp'

            If you have feedback or need assistance with the MCP directory API, please join our Discord server