Search

MCP Integration

Connect AI agents directly to your spreadsheet data using the Model Context Protocol

Quick Start
Add OpenSheets to your MCP-compatible AI client

Claude Desktop Configuration

{
  "mcpServers": {
    "opensheets": {
      "url": "https://sheets.platphormnews.com/api/mcp",
      "transport": "http"
    }
  }
}

Or use with any MCP client

MCP Endpoint: https://sheets.platphormnews.com/api/mcp
Transport: HTTP JSON-RPC 2.0
Protected tools: Authorization: Bearer $PLATPHORM_API_KEY

Tools

Tools that AI agents can call to interact with spreadsheet data

list_sheets
List all available sheets with optional filtering
categorystring
limitnumber
get_sheet
Get sheet metadata and data by ID
idstring
limitnumber
columnsarray
search_sheets
Search across all sheets for matching data
querystring
categorystring
search_rows
Search rows within a server-indexed sheet
idstring
querystring
columnsarray
get_categories
List all sheet categories
get_sheet_summary
Get statistical summary of a sheet (counts, averages, etc.)
idstring
columnsarray

Resources

Direct access to spreadsheet data via resource URIs

opensheets://sheets

List of all available spreadsheets

opensheets://sheets/{id}

Full data and metadata for a specific sheet

opensheets://categories

List of all sheet categories

Prompts

Pre-built prompts for common spreadsheet analysis tasks

analyze_sheet

Analyze a sheet and provide insights

sheet_id
compare_sheets

Compare data across multiple sheets

sheet_ids
find_trends

Identify trends in time-series data

sheet_iddate_columnvalue_column
Example Conversation
How an AI agent might use OpenSheets MCP

User:

Summarize the public platform report once it is indexed in Sheets.

AI Agent:

Let me search the sales data for you...

Tool: search_sheets
Query: "route compliance"

Tool: get_sheet_summary
ID: "server-indexed-sheet-id"

If no durable server sheet exists yet, OpenSheets returns an honest degraded response and points the user to the browser-local viewer.

Ready to connect?

Add sheets to start querying with your AI agent