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": "sse"
    }
  }
}

Or use with any MCP client

MCP Endpoint: https://sheets.platphormnews.com/api/mcp
Transport: Server-Sent Events (SSE)

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_in_sheet
Search within a specific 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:

What were our top-selling products in Q4?

AI Agent:

Let me search the sales data for you...

Tool: search_sheets
Query: "Q4 sales products"

Tool: get_sheet  
ID: "abc123"
Columns: ["product", "units_sold", "revenue"]

Based on the Q4 Sales Report, the top 3 products were: 1. Enterprise Suite ($489,500) 2. Pro License ($378,000) 3. Basic Plan ($171,050)

Ready to connect?

Add sheets to start querying with your AI agent