MCP Server

Expose your sheet APIs as MCP (Model Context Protocol) servers so AI assistants like Claude can query your data directly.

What is MCP?

The Model Context Protocol is an open standard that allows AI assistants to securely access external data sources and tools. Sheet Gurus API supports MCP natively, letting you connect your spreadsheet data to any MCP-compatible AI assistant.

Enable MCP for a Sheet

Navigate to your sheet's settings in the dashboard and toggle on MCP Server. This will generate an MCP endpoint URL for your sheet.

Create an MCP Token

MCP connections use separate tokens from API keys for additional security. Go to MCP Tokens in the dashboard to create a new token. You can scope tokens to specific sheets and set granular permissions (read, write, update, delete).

Connect to an AI Assistant

Add the Sheet Gurus API MCP server to your AI assistant's configuration. Here's an example configuration for Claude Desktop:

{
  "mcpServers": {
    "sheet-gurus": {
      "url": "https://api.sheetgurus.com/mcp/sse",
      "headers": {
        "Authorization": "Bearer YOUR_MCP_TOKEN"
      }
    }
  }
}

Available Tools

Once connected, the AI assistant will have access to the following tools:

  • list_sheets — List all sheets connected to your account
  • create_sheet — Create a new Google Sheet
  • read_sheet — Read data with optional filtering, pagination, and tab selection
  • write_rows — Add new rows to a sheet
  • update_row — Update a single row by ID
  • update_rows — Update multiple rows matching a where clause
  • delete_row — Delete a single row by ID
  • delete_rows — Delete multiple rows matching a where clause
  • add_columns — Add new columns to a sheet
  • list_tabs — List all tabs in a spreadsheet
  • create_tab — Create a new tab in a spreadsheet

Permissions

Each MCP token can be configured with specific permissions. The token's permissions are checked against the sheet's MCP permissions — both must allow the operation for it to succeed. This gives you fine-grained control over what AI assistants can do with your data.