{
  "markdown": "# Google Sheets MCP Server\n\n> Powerful tools for automating Google Sheets using Model Context Protocol (MCP)\n\n**mcp-name: io.github.henilcalagiya/google-sheets-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 — including creating, reading, updating, and deleting sheets — 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\" → \"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\" → \"Library\"\n2. Search for \"Google Sheets API\" → Click → \"Enable\"\n3. Search for \"Google Drive API\" → Click → \"Enable\"\n\n**Step 3: Create Service Account**\n1. Go to \"IAM & Admin\" → \"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 → 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 → \"Add Key\" → \"Create new key\"\n3. Choose \"JSON\" format → 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_id` (e.g., \"a4ae73111b11b2c3b07cc01006e71eb8230dfa29\")\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- `client_id` (e.g., \"113227823918217958816\")\n- `client_x509_cert_url` (e.g., \"https://www.googleapis.com/robot/v1/metadata/x509/sheets-mcp-service%40my-sheets-automation-123456.iam.gserviceaccount.com\")\n\n**Example Google service account JSON structure:**\n```json\n{\n  \"type\": \"service_account\",\n  \"project_id\": \"your-project-id\",\n  \"private_key_id\": \"your-private-key-id\",\n  \"private_key\": \"-----BEGIN PRIVATE KEY-----\\n...\\n-----END PRIVATE KEY-----\\n\",\n  \"client_email\": \"your-service@your-project.iam.gserviceaccount.com\",\n  \"client_id\": \"your-client-id\",\n  \"auth_uri\": \"https://accounts.google.com/o/oauth2/auth\",\n  \"token_uri\": \"https://oauth2.googleapis.com/token\",\n  \"auth_provider_x509_cert_url\": \"https://www.googleapis.com/oauth2/v1/certs\",\n  \"client_x509_cert_url\": \"https://www.googleapis.com/robot/v1/metadata/x509/your-service%40your-project.iam.gserviceaccount.com\"\n}\n```\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        \"project_id\": \"your-project-id\",\n        \"private_key_id\": \"your-private-key-id\",\n        \"private_key\": \"-----BEGIN PRIVATE KEY-----\\n...\\n-----END PRIVATE KEY-----\\n\",\n        \"client_email\": \"your-service@your-project.iam.gserviceaccount.com\",\n        \"client_id\": \"your-client-id\",\n        \"client_x509_cert_url\": \"https://www.googleapis.com/robot/v1/metadata/x509/your-service%40your-project.iam.gserviceaccount.com\"\n      }\n    }\n  }\n}\n```\n\n**💡 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!\n\n**🔄 Backward Compatibility:** The server also supports the old `GOOGLE_` prefixed variable names (e.g., `GOOGLE_PROJECT_ID`) for existing configurations.\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**🎉 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- 🐛 **Report Issues**: [GitHub Issues](https://github.com/henilcalagiya/google-sheets-mcp/issues)\n- 💬 **Questions**: Reach out on [LinkedIn](https://www.linkedin.com/in/henilcalagiya/)\n- 🤝 **Contributions**: Pull requests welcome! ",
  "bytes": 5271,
  "sha": "0eda99becabc9b0634b17e2ac54d742dee9f23bd978d69cbf6286683a36f6178",
  "repo_slug": "henilcalagiya/google-sheets-mcp",
  "fonte": "repo",
  "truncated": false,
  "api": "https://agentalog.com/api/listings/mcp_io_github_henilcalagiya_google_sheets_mc_04bc2119/readme"
}