# 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:**
```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](https://console.cloud.google.com/)
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` (the long private key starting with "-----BEGIN PRIVATE KEY-----")
- `client_email` (e.g., "sheets-mcp-service@my-sheets-automation-123456.iam.gserviceaccount.com")
[Follow this guide if needed](https://console.cloud.google.com/apis/credentials)
### 2. Configure MCP Client
```json
{
"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_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](LICENSE) file for details.
## Author
**Henil C Alagiya**
- **GitHub**: [@henilcalagiya](https://github.com/henilcalagiya)
- **LinkedIn**: [Henil C Alagiya](https://www.linkedin.com/in/henilcalagiya/)
**Support & Contributions:**
- 🐛 **Report Issues**: [GitHub Issues](https://github.com/henilcalagiya/google-sheets-mcp/issues)
- 💬 **Questions**: Reach out on [LinkedIn](https://www.linkedin.com/in/henilcalagiya/)
- 🤝 **Contributions**: Pull requests welcome!
Raw data
{
"_id": null,
"home_page": null,
"name": "google-sheets-mcp",
"maintainer": null,
"docs_url": null,
"requires_python": ">=3.10",
"maintainer_email": null,
"keywords": "ai, automation, google-sheets, mcp, model-context-protocol, spreadsheets",
"author": null,
"author_email": "Henil C Alagiya <henilalagiya@gmail.com>",
"download_url": "https://files.pythonhosted.org/packages/ce/b6/fe1279414fd3ba9a96f03ecd6e4d631e6880c614d8c573a02dc88ae080d7/google_sheets_mcp-0.1.3.tar.gz",
"platform": null,
"description": "# Google Sheets MCP Server\n\n> Powerful tools for automating Google Sheets using Model Context Protocol (MCP)\n\n## Overview\n\nGoogle Sheets MCP Server provides seamless integration of Google Sheets with any MCP-compatible client. It enables full spreadsheet automation \u2014 including creating, reading, updating, and deleting sheets \u2014 through a simple and secure API layer.\n\n## Features\n\n- Full CRUD support for Google Sheets and tables\n- Works with Continue.dev, Claude Desktop, Perplexity, and other MCP clients\n- Secure authentication via Google Service Account\n- Comprehensive tools for Google Sheets automation\n- Automatic installation via `uvx`\n\n## Requirements\n\n- Python 3.10+\n- `uv` package manager (for `uvx` command)\n- A Google Cloud project with a Service Account\n- MCP-compatible client (e.g., Continue.dev)\n\n**Install uv:**\n```bash\n# macOS/Linux\ncurl -LsSf https://astral.sh/uv/install.sh | sh\n\n# Windows PowerShell\nirm https://astral.sh/uv/install.ps1 | iex\n```\n\n---\n\n## Quick Start\n\n### 1. Set Up Google Service Account\n\n**Step 1: Create a Google Cloud Project**\n1. Go to [Google Cloud Console](https://console.cloud.google.com/)\n2. Click \"Select a project\" \u2192 \"New Project\"\n3. Enter a project name (e.g., \"my-sheets-automation\")\n4. Click \"Create\"\n\n**Step 2: Enable Required APIs**\n1. In your project, go to \"APIs & Services\" \u2192 \"Library\"\n2. Search for \"Google Sheets API\" \u2192 Click \u2192 \"Enable\"\n3. Search for \"Google Drive API\" \u2192 Click \u2192 \"Enable\"\n\n**Step 3: Create Service Account**\n1. Go to \"IAM & Admin\" \u2192 \"Service Accounts\"\n2. Click \"Create Service Account\"\n3. Enter service account name (e.g., \"sheets-mcp-service\")\n4. Click \"Create and Continue\"\n5. Skip role assignment \u2192 Click \"Continue\"\n6. Click \"Done\"\n\n**Step 4: Generate JSON Key**\n1. Click on your new service account email\n2. Go to \"Keys\" tab \u2192 \"Add Key\" \u2192 \"Create new key\"\n3. Choose \"JSON\" format \u2192 Click \"Create\"\n4. The JSON file will download automatically\n\n**Step 5: Extract Required Values**\nOpen the downloaded JSON file and note these values:\n- `project_id` (e.g., \"my-sheets-automation-123456\")\n- `private_key` (the long private key starting with \"-----BEGIN PRIVATE KEY-----\")\n- `client_email` (e.g., \"sheets-mcp-service@my-sheets-automation-123456.iam.gserviceaccount.com\")\n\n[Follow this guide if needed](https://console.cloud.google.com/apis/credentials)\n\n### 2. Configure MCP Client\n\n```json\n{\n \"mcpServers\": {\n \"google-sheets-mcp\": {\n \"command\": \"uvx\",\n \"args\": [\"google-sheets-mcp@latest\"],\n \"env\": {\n \"GOOGLE_PROJECT_ID\": \"your-project-id\",\n \"GOOGLE_PRIVATE_KEY\": \"-----BEGIN PRIVATE KEY-----\\n...\\n-----END PRIVATE KEY-----\\n\",\n \"GOOGLE_CLIENT_EMAIL\": \"your-service@your-project.iam.gserviceaccount.com\"\n }\n }\n }\n}\n```\n\n**Extract these values from your Google service account JSON file:**\n- `project_id` \u2192 `GOOGLE_PROJECT_ID`\n- `private_key` \u2192 `GOOGLE_PRIVATE_KEY`\n- `client_email` \u2192 `GOOGLE_CLIENT_EMAIL`\n\n### 3. Share Your Google Sheet with the Service Account\n\n- Open your target Google Spreadsheet in your web browser.\n- Click the **Share** button.\n- Enter the **service account email** (e.g., `your-service@your-project.iam.gserviceaccount.com`) and assign **Editor** access.\n- Click **Send** to provide editor permissions.\n\n**\ud83c\udf89 You're all set!** Your MCP client will automatically install and run the package when needed.\n\n\n## License\n\nThis project is licensed under the MIT License - see the [LICENSE](LICENSE) file for details.\n\n## Author\n\n**Henil C Alagiya**\n\n- **GitHub**: [@henilcalagiya](https://github.com/henilcalagiya)\n- **LinkedIn**: [Henil C Alagiya](https://www.linkedin.com/in/henilcalagiya/)\n\n**Support & Contributions:**\n- \ud83d\udc1b **Report Issues**: [GitHub Issues](https://github.com/henilcalagiya/google-sheets-mcp/issues)\n- \ud83d\udcac **Questions**: Reach out on [LinkedIn](https://www.linkedin.com/in/henilcalagiya/)\n- \ud83e\udd1d **Contributions**: Pull requests welcome! ",
"bugtrack_url": null,
"license": null,
"summary": "Your AI Assistant's Gateway to Google Sheets! 25 powerful tools for seamless Google Sheets automation via MCP",
"version": "0.1.3",
"project_urls": {
"Homepage": "https://github.com/henilcalagiya/google-sheets-mcp"
},
"split_keywords": [
"ai",
" automation",
" google-sheets",
" mcp",
" model-context-protocol",
" spreadsheets"
],
"urls": [
{
"comment_text": null,
"digests": {
"blake2b_256": "9623be43d44abe4c66ba91c41ee75a80be1ee19e19e0e25f2fcd5f9f7da238a0",
"md5": "7389c1068cf6dda1b781d411e07b04bd",
"sha256": "61432aec609e557926a851cfe946c012e9481d97e40c46c39502ae08b48cfcc8"
},
"downloads": -1,
"filename": "google_sheets_mcp-0.1.3-py3-none-any.whl",
"has_sig": false,
"md5_digest": "7389c1068cf6dda1b781d411e07b04bd",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.10",
"size": 85822,
"upload_time": "2025-08-08T20:13:13",
"upload_time_iso_8601": "2025-08-08T20:13:13.325978Z",
"url": "https://files.pythonhosted.org/packages/96/23/be43d44abe4c66ba91c41ee75a80be1ee19e19e0e25f2fcd5f9f7da238a0/google_sheets_mcp-0.1.3-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "ceb6fe1279414fd3ba9a96f03ecd6e4d631e6880c614d8c573a02dc88ae080d7",
"md5": "e5858c9d3caaffc71e1ee08835cb5f78",
"sha256": "62cbe8708ed8b62b99b91256a3d6462d91e59fab4beac41efbc7a26719741acf"
},
"downloads": -1,
"filename": "google_sheets_mcp-0.1.3.tar.gz",
"has_sig": false,
"md5_digest": "e5858c9d3caaffc71e1ee08835cb5f78",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.10",
"size": 106433,
"upload_time": "2025-08-08T20:13:14",
"upload_time_iso_8601": "2025-08-08T20:13:14.584705Z",
"url": "https://files.pythonhosted.org/packages/ce/b6/fe1279414fd3ba9a96f03ecd6e4d631e6880c614d8c573a02dc88ae080d7/google_sheets_mcp-0.1.3.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2025-08-08 20:13:14",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "henilcalagiya",
"github_project": "google-sheets-mcp",
"travis_ci": false,
"coveralls": false,
"github_actions": true,
"lcname": "google-sheets-mcp"
}
JSON
