sheets-mcp

A simple Streamable HTTP MCP server that indexes Google Sheets and provides grep search functionality.

Setup

1. Install dependencies:

bun install

2. Set the Google Sheet ID environment variable by putting it in .env, or alternatively:

export SHEET_ID="your_google_sheet_id_here"

3. Run the server:

bun run start

The server will automatically index all tabs in the Google Sheet on startup and provide MCP tools for searching and retrieving data.

Tools

• grep: Search across all indexed tables using regex
• list_tables: List all indexed table names
• get_table: Retrieve the full contents of a specific table
• index_sheets: Re-index all sheets from the Google Sheet

MCP Configuration

Add to your MCP client configuration:

{
  "mcpServers": {
    "sheets": {
      "command": "bun",
      "args": ["run", "/path/to/sheets-mcp/index.ts"],
      "env": {
        "SHEET_ID": "your_sheet_id"
      }
    }
  }
}