Google Sheets MCP Server

1# Google Sheets MCP Server
2 
3> Powerful tools for automating Google Sheets using Model Context Protocol (MCP)
4 
5**mcp-name: io.github.henilcalagiya/google-sheets-mcp**
6 
7## Overview
8 
9Google 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.
10 
11## Features
12 
13- Full CRUD support for Google Sheets and tables
14- Works with Continue.dev, Claude Desktop, Perplexity, and other MCP clients
15- Secure authentication via Google Service Account
16- Comprehensive tools for Google Sheets automation
17- Automatic installation via `uvx`
18 
19## Requirements
20 
21- Python 3.10+
22- `uv` package manager (for `uvx` command)
23- A Google Cloud project with a Service Account
24- MCP-compatible client (e.g., Continue.dev)
25 
26**Install uv:**
27```bash
28# macOS/Linux
29curl -LsSf https://astral.sh/uv/install.sh | sh
30 
31# Windows PowerShell
32irm https://astral.sh/uv/install.ps1 | iex
33```
34 
35---
36 
37## Quick Start
38 
39### 1. Set Up Google Service Account
40 
41**Step 1: Create a Google Cloud Project**
421. Go to [Google Cloud Console](https://console.cloud.google.com/)
432. Click "Select a project" → "New Project"
443. Enter a project name (e.g., "my-sheets-automation")
454. Click "Create"
46 
47**Step 2: Enable Required APIs**
481. In your project, go to "APIs & Services" → "Library"
492. Search for "Google Sheets API" → Click → "Enable"
503. Search for "Google Drive API" → Click → "Enable"
51 
52**Step 3: Create Service Account**
531. Go to "IAM & Admin" → "Service Accounts"
542. Click "Create Service Account"
553. Enter service account name (e.g., "sheets-mcp-service")
564. Click "Create and Continue"
575. Skip role assignment → Click "Continue"
586. Click "Done"
59 
60**Step 4: Generate JSON Key**
611. Click on your new service account email
622. Go to "Keys" tab → "Add Key" → "Create new key"
633. Choose "JSON" format → Click "Create"
644. The JSON file will download automatically
65 
66**Step 5: Extract Required Values**
67Open the downloaded JSON file and note these values:
68- `project_id` (e.g., "my-sheets-automation-123456")
69- `private_key_id` (e.g., "a4ae73111b11b2c3b07cc01006e71eb8230dfa29")
70- `private_key` (the long private key starting with "-----BEGIN PRIVATE KEY-----")
71- `client_email` (e.g., "sheets-mcp-service@my-sheets-automation-123456.iam.gserviceaccount.com")
72- `client_id` (e.g., "113227823918217958816")
73- `client_x509_cert_url` (e.g., "https://www.googleapis.com/robot/v1/metadata/x509/sheets-mcp-service%40my-sheets-automation-123456.iam.gserviceaccount.com")
74 
75**Example Google service account JSON structure:**
76```json
77{
78  "type": "service_account",
79  "project_id": "your-project-id",
80  "private_key_id": "your-private-key-id",
81  "private_key": "-----BEGIN PRIVATE KEY-----\n...\n-----END PRIVATE KEY-----\n",
82  "client_email": "your-service@your-project.iam.gserviceaccount.com",
83  "client_id": "your-client-id",
84  "auth_uri": "https://accounts.google.com/o/oauth2/auth",
85  "token_uri": "https://oauth2.googleapis.com/token",
86  "auth_provider_x509_cert_url": "https://www.googleapis.com/oauth2/v1/certs",
87  "client_x509_cert_url": "https://www.googleapis.com/robot/v1/metadata/x509/your-service%40your-project.iam.gserviceaccount.com"
88}
89```
90 
91[Follow this guide if needed](https://console.cloud.google.com/apis/credentials)
92 
93### 2. Configure MCP Client
94 
95```json
96{
97  "mcpServers": {
98    "google-sheets-mcp": {
99      "command": "uvx",
100      "args": ["google-sheets-mcp@latest"],
101      "env": {
102        "project_id": "your-project-id",
103        "private_key_id": "your-private-key-id",
104        "private_key": "-----BEGIN PRIVATE KEY-----\n...\n-----END PRIVATE KEY-----\n",
105        "client_email": "your-service@your-project.iam.gserviceaccount.com",
106        "client_id": "your-client-id",
107        "client_x509_cert_url": "https://www.googleapis.com/robot/v1/metadata/x509/your-service%40your-project.iam.gserviceaccount.com"
108      }
109    }
110  }
111}
112```
113 
114**💡 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!
115 
116**🔄 Backward Compatibility:** The server also supports the old `GOOGLE_` prefixed variable names (e.g., `GOOGLE_PROJECT_ID`) for existing configurations.
117 
118### 3. Share Your Google Sheet with the Service Account
119 
120- Open your target Google Spreadsheet in your web browser.
121- Click the **Share** button.
122- Enter the **service account email** (e.g., `your-service@your-project.iam.gserviceaccount.com`) and assign **Editor** access.
123- Click **Send** to provide editor permissions.
124 
125**🎉 You're all set!** Your MCP client will automatically install and run the package when needed.
126 
127 
128## License
129 
130This project is licensed under the MIT License - see the [LICENSE](LICENSE) file for details.
131 
132## Author
133 
134**Henil C Alagiya**
135 
136- **GitHub**: [@henilcalagiya](https://github.com/henilcalagiya)
137- **LinkedIn**: [Henil C Alagiya](https://www.linkedin.com/in/henilcalagiya/)
138 
139**Support & Contributions:**
140- 🐛 **Report Issues**: [GitHub Issues](https://github.com/henilcalagiya/google-sheets-mcp/issues)
141- 💬 **Questions**: Reach out on [LinkedIn](https://www.linkedin.com/in/henilcalagiya/)
142- 🤝 **Contributions**: Pull requests welcome!