Which integrations are available for this server?

Designed to run as a Google Cloud Function with support for Cloud Functions deployment and Secret Manager for credential storage. Exposes Google Sheets as queryable database tables with tools for listing sheets, retrieving column schemas, and fetching rows with pagination support.

How do I use Google Sheets MCP Server?

1. Click on "Install Server". 2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state. 3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@Google Sheets MCP Server list all sheets in spreadsheet 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms" That's it! The server will respond to your query, and you can continue using it as needed. Here is a step-by-step guide with screenshots.

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

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

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

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)

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

This server cannot be installed

-

security - not tested

F

license - not found

-

quality - not tested

How are these scores calculated?

Resources

Need Help?

Report Issue

Related Servers

Google Sheets MCP Server

Google Sheets MCP Server

Features

Available Tools

Installation

Build

Deployment

Environment Variables

API Endpoints

Local Development

With stdio transport (for local MCP clients)

With HTTP/SSE transport

Usage Example

Row Indexing

Resources

New MCP Servers

Latest Blog Posts

MCP directory API