mcp-registry/mcp-google-sheets

    ==================
      
       /// MCP ///
      /// MCP ///
        
    ==================
        
    [server:online]
    [protocol:ready]

mcp-google-sheets

by xing5

Python MCP server that exposes a rich set of tools for manipulating Google Sheets/Drive via Google APIs so any MCP-compatible client (e.g. Claude Desktop) can read, write, share and manage spreadsheets through natural-language commands.

271
63
Open Source
GitHub

Installation

1. Prerequisites
• Python 3.9+
• A Google Cloud project with both “Google Sheets API” and “Google Drive API” enabled.
2. Clone the repository
git clone https://github.com/xing5/mcp-google-sheets.git
cd mcp-google-sheets
3. Create & activate a virtual-environment (recommended)
python -m venv .venv
source .venv/bin/activate # Windows: .venv\Scripts\activate
4. Install Python dependencies
pip install -r requirements.txt
# or directly from GitHub without cloning:
# pip install git+https://github.com/xing5/mcp-google-sheets.git
5. Obtain Google credentials
• In Google Cloud Console create an "OAuth Client ID" (Desktop type).
• Download the JSON file (client_secret_*.json).
• Save it inside the project directory (or any safe location).
• Export the path so the SDK can locate it:
export GOOGLE_APPLICATION_CREDENTIALS="/absolute/path/client_secret.json"
6. First-time authentication
python tools/auth_flow.py # Opens browser, prompts for consent, saves token.json
7. Run the MCP server
python -m mcp_google_sheets.server --host 0.0.0.0 --port 8080
8. Reverse-proxy (optional)
If you need HTTPS, place Nginx/Caddy/Traefik in front and proxy to 127.0.0.1:8080.
The server is now reachable by any MCP client.

Documentation

# Transform Your Development Workflow with Google Sheets Integration

**Turn Augment Code into your data powerhouse.** This MCP server connects Augment directly to Google Sheets, enabling you to manipulate spreadsheets, analyze data, and automate reporting workflows through natural language commands while coding.

## Supercharge Augment Code with Spreadsheet Superpowers

Imagine asking Augment to "create a test results spreadsheet, populate it with our latest API test data, and share it with the QA team" – all while staying in your coding flow. This Google Sheets MCP server makes that reality. With 15+ powerful tools including batch operations, sharing controls, and real-time data manipulation, you can transform spreadsheets into a seamless extension of your development process.

**Setup is effortless**: Configure your Google Cloud credentials, add the server to Augment's MCP settings, and start commanding spreadsheets through natural language. Whether you're tracking bugs, generating reports, managing configurations, or analyzing performance metrics, Augment can now create, update, and share spreadsheets instantly – no context switching required.

## Real-World Development Scenarios

**Data-Driven Development**: Ask Augment to "analyze our API response times from the monitoring spreadsheet and create a performance summary sheet" while debugging performance issues. **Testing Workflows**: Generate test data sets, track test results, and automatically update QA dashboards with "create test scenarios for the user auth flow and log results in our testing tracker." **Project Management**: Maintain sprint boards, update task statuses, and generate progress reports with commands like "update my project tasks spreadsheet with completed features and create a demo summary for stakeholders."

The server supports both service account (automated) and OAuth (personal) authentication, handles complex batch operations, and integrates seamlessly with your existing Google Drive workflows. Your development process becomes more organized, data-driven, and collaborative – all through Augment's natural language interface.
License: MIT License
Updated 7/15/2025

Table of Contents