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.

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

Installation

npm install

Build

npm run build

Deployment

Deploy to Google Cloud Functions:

npm run deploy

Or manually:

gcloud functions deploy google-sheets-mcp \
  --gen2 \
  --runtime=nodejs20 \
  --trigger-http \
  --allow-unauthenticated \
  --entry-point=mcpHandler \
  --source=.

Environment Variables

API Endpoints

Local Development

With stdio transport (for local MCP clients)

MCP_STDIO=true npm run dev

With HTTP/SSE transport

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:

{
  "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