Utilizes Google Cloud service accounts for secure authentication and API access to Google Sheets and Drive services.
Enables access to Google Drive API functionality as part of the Google Sheets integration, allowing management of spreadsheet files within the Drive ecosystem.
Provides full CRUD operations for Google Sheets and tables, enabling comprehensive spreadsheet automation including creating, reading, updating, and deleting sheets and their data.
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 (foruvx
command)- A Google Cloud project with a Service Account
- MCP-compatible client (e.g., Continue.dev)
Install uv:
Quick Start
1. Set Up Google Service Account
Step 1: Create a Google Cloud Project
- Go to Google Cloud Console
- Click "Select a project" → "New Project"
- Enter a project name (e.g., "my-sheets-automation")
- Click "Create"
Step 2: Enable Required APIs
- In your project, go to "APIs & Services" → "Library"
- Search for "Google Sheets API" → Click → "Enable"
- Search for "Google Drive API" → Click → "Enable"
Step 3: Create Service Account
- Go to "IAM & Admin" → "Service Accounts"
- Click "Create Service Account"
- Enter service account name (e.g., "sheets-mcp-service")
- Click "Create and Continue"
- Skip role assignment → Click "Continue"
- Click "Done"
Step 4: Generate JSON Key
- Click on your new service account email
- Go to "Keys" tab → "Add Key" → "Create new key"
- Choose "JSON" format → Click "Create"
- 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
(the long private key starting with "-----BEGIN PRIVATE KEY-----")client_email
(e.g., "sheets-mcp-service@my-sheets-automation-123456.iam.gserviceaccount.com")
2. Configure MCP Client
Extract these values from your Google service account JSON file:
project_id
→GOOGLE_PROJECT_ID
private_key
→GOOGLE_PRIVATE_KEY
client_email
→GOOGLE_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
- GitHub: @henilcalagiya
- LinkedIn: Henil C Alagiya
Support & Contributions:
- 🐛 Report Issues: GitHub Issues
- 💬 Questions: Reach out on LinkedIn
- 🤝 Contributions: Pull requests welcome!
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.
Tools
Your AI Assistant's Gateway to Google Sheets! 25 powerful tools for seamless Google Sheets automation via MCP
Related MCP Servers
- -securityFlicense-qualityProvides 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 -22JavaScript
- -securityAlicense-qualityEnables 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 -3PythonMIT License
- -securityAlicense-qualityA tool for manipulating Google Spreadsheet and Google Drive using MCP (Metoro Control Protocol).Last updated -10PythonMIT License
- -securityAlicense-qualityA 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 -84JavaScriptMIT License