# Google Sheets MCP Server
An MCP (Model Context Protocol) server that provides tools for interacting with Google Sheets. Designed to run as a Google Cloud Function and proxies requests to the [sheets-db-api](../sheets-db-api).
## Features
- Full CRUD operations for sheets and rows
- Treats Google Sheets as a database with sheets as tables
- SSE transport for HTTP-based MCP communication
- No authentication required (proxies to authenticated sheets-db-api)
## Available Tools
| Tool | Description | Parameters |
|------|-------------|------------|
| `list_sheets` | List all sheets in the spreadsheet | `spreadsheet_id` |
| `create_sheet` | Create a new sheet | `spreadsheet_id`, `sheet_name` |
| `delete_sheet` | Delete a sheet | `spreadsheet_id`, `sheet_name` |
| `get_schema` | Get column headers | `spreadsheet_id`, `sheet_name` |
| `get_rows` | Get all rows from a sheet | `spreadsheet_id`, `sheet_name` |
| `get_row` | Get a specific row by index | `spreadsheet_id`, `sheet_name`, `row_index` |
| `create_row` | Add a new row | `spreadsheet_id`, `sheet_name`, `data` |
| `update_row` | Update an existing row | `spreadsheet_id`, `sheet_name`, `row_index`, `data` |
| `delete_row` | Delete a row | `spreadsheet_id`, `sheet_name`, `row_index` |
## Installation
```bash
npm install
```
## Build
```bash
npm run build
```
## Deployment
Deploy to Google Cloud Functions:
```bash
npm run deploy
```
Or manually:
```bash
gcloud functions deploy google-sheets-mcp \
--gen2 \
--runtime=nodejs20 \
--trigger-http \
--allow-unauthenticated \
--entry-point=mcpHandler \
--source=.
```
## Environment Variables
| Variable | Description | Default |
|----------|-------------|---------|
| `SHEETS_API_URL` | URL of the sheets-db-api | `https://sheetsapi-g56q77hy2a-uc.a.run.app` |
## API Endpoints
| Method | Endpoint | Description |
|--------|----------|-------------|
| GET | `/health` | Health check |
| GET | `/sse` | SSE connection for MCP clients |
| POST | `/message?sessionId=xxx` | Message endpoint for MCP communication |
## Local Development
### With stdio transport (for local MCP clients)
```bash
MCP_STDIO=true npm run dev
```
### With HTTP/SSE transport
```bash
npm run dev
```
## Usage Example
Once deployed, connect your MCP client to the SSE endpoint:
```
https://YOUR_CLOUD_FUNCTION_URL/sse
```
Then use the tools with your Google Spreadsheet ID:
```json
{
"tool": "list_sheets",
"arguments": {
"spreadsheet_id": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms"
}
}
```
## Row Indexing
- Row 1 contains headers
- Data rows start at index 2
- When using `get_row`, `update_row`, or `delete_row`, use indices >= 2
