iflow-mcp_henilcalagiya_google-sheets-mcp

# Google Sheets MCP Server > Powerful tools for automating Google Sheets using Model Context Protocol (MCP) **mcp-name: io.github.henilcalagiya/google-sheets-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: Extrac…