google-sheet-mcp

# Google Sheets MCP Server A clean and focused Model Context Protocol (MCP) server that provides tools to read data from Google Sheets using the Google Sheets API. ## Features - **Read Google Sheets**: Extract data from Google Sheets using spreadsheet ID and sheet name/range - **Markdown Table Conversion**: Automatically convert sheet data to markdown table format - **Flexible Range Support**: Read specific ranges (e.g., 'Sheet1!A1:D10') or entire sheets - **Error Handling**: Comprehensive error handling for authentication and access issues - **Clean Architecture**: Minimal dependencies, focused only on Google Sheets functionality ## Setup ### Prerequisites 1. Python 3.10 or higher 2. A Google Cloud Project with Google Sheets API enabled 3. A service account with access to Google Sheets ### Installation #### From PyPI (Recommended) ```bash pip install google-sheet-mcp ``` #### From Source 1. Clone the repository: ```bash git clone https://github.com/yourusername/mcp-google-sheet.git cd mcp-google-sheet ``` 2. Install dependencies using uv (recommended): ```bash uv sync ``` Or using pip: ```bash pip install -e . ``` 2. Set up Google Service Account: - Create a service account in Google Cloud Console - Download the JSON key file - Enable Google Sheets API for the project - Share the Google Sheets you want to access with the service account email 3. Configure environment variables: **Option A: File Path (Local Development)** ```bash # Set the path to your service account JSON file export GOOGLE_SERVICE_ACCOUNT_INFO="/path/to/your/service-account-key.json" ``` **Option B: JSON Content (Server Deployment)** ```bash # Set the JSON content directly export GOOGLE_SERVICE_ACCOUNT_INFO='{"type":"service_account","project_id":"your-project",...}' ``` Or create a `.env` file in the project root: ```env # File path approach GOOGLE_SERVICE_ACCOUNT_INFO=/path/to/your/service-account-key.json # OR JS…