# OpenSheets / PlatPhorm Sheets
> Canonical public-safe tabular intelligence and workbook/report matrix layer for PlatPhormNews.

Base URL: https://sheets.platphormnews.com
Version: 0.3.0-phase3
Server-indexed sheets: 0
Server-indexed rows: 0
Persistence: degraded (No DATABASE_URL is configured. Server APIs expose public read-only empty state; browser imports are saved as explicit local previews.)

## Purpose
Sheets turns tabular data into searchable, filterable, analyzable, exportable, agent-readable, trace-linked knowledge without mutating source spreadsheets.

## Public Access
- Homepage, browse/search UI, local browser sheet previews, discovery files, health summaries, and read-only MCP introspection.

## Protected Access
- Mutating, administrative, protected ingest, private export, network sync, test-triggering, and report generation require PLATPHORM_API_KEY.
- Accepted headers: Authorization: Bearer $PLATPHORM_API_KEY or X-PlatPhorm-API-Key: $PLATPHORM_API_KEY.

## Key Endpoints
- workbooks: https://sheets.platphormnews.com/api/v1/workbooks
- workbook: https://sheets.platphormnews.com/api/v1/workbooks/{id}
- workbookSheets: https://sheets.platphormnews.com/api/v1/workbooks/{id}/sheets
- sheets: https://sheets.platphormnews.com/api/v1/sheets
- sheet: https://sheets.platphormnews.com/api/v1/sheets/{id}
- rows: https://sheets.platphormnews.com/api/v1/sheets/{id}/rows
- columns: https://sheets.platphormnews.com/api/v1/sheets/{id}/columns
- summary: https://sheets.platphormnews.com/api/v1/sheets/{id}/summary
- charts: https://sheets.platphormnews.com/api/v1/sheets/{id}/charts
- quality: https://sheets.platphormnews.com/api/v1/sheets/{id}/quality
- schema: https://sheets.platphormnews.com/api/v1/sheets/{id}/schema
- duplicates: https://sheets.platphormnews.com/api/v1/sheets/{id}/duplicates
- lineage: https://sheets.platphormnews.com/api/v1/sheets/{id}/lineage
- provenance: https://sheets.platphormnews.com/api/v1/sheets/{id}/provenance
- search: https://sheets.platphormnews.com/api/v1/search
- ingestPaste: https://sheets.platphormnews.com/api/v1/ingest/paste
- ingestUrl: https://sheets.platphormnews.com/api/v1/ingest/url
- ingestUpload: https://sheets.platphormnews.com/api/v1/ingest/upload
- ingestJson: https://sheets.platphormnews.com/api/v1/ingest/json
- ingestMarkdown: https://sheets.platphormnews.com/api/v1/ingest/markdown
- queryPreview: https://sheets.platphormnews.com/api/v1/query/preview
- groupBy: https://sheets.platphormnews.com/api/v1/group-by
- pivot: https://sheets.platphormnews.com/api/v1/pivot-summary
- joinPreview: https://sheets.platphormnews.com/api/v1/join/preview
- computedPreview: https://sheets.platphormnews.com/api/v1/sheets/{id}/computed-columns/preview
- exportCsv: https://sheets.platphormnews.com/api/v1/sheets/{id}/export/csv
- exportJson: https://sheets.platphormnews.com/api/v1/sheets/{id}/export/json
- exportMarkdown: https://sheets.platphormnews.com/api/v1/sheets/{id}/export/markdown
- exportPdf: https://sheets.platphormnews.com/api/v1/sheets/{id}/export/pdf
- share: https://sheets.platphormnews.com/api/v1/sheets/{id}/share
- dashboards: https://sheets.platphormnews.com/api/v1/dashboards
- reportPacks: https://sheets.platphormnews.com/api/v1/report-packs
- integrations: https://sheets.platphormnews.com/api/v1/integrations
- health: https://sheets.platphormnews.com/api/health
- docs: https://sheets.platphormnews.com/api/docs
- openapi: https://sheets.platphormnews.com/openapi.yaml
- openapiJson: https://sheets.platphormnews.com/openapi.json
- mcp: https://sheets.platphormnews.com/api/mcp

## MCP
- Tools:
  - get_sheets_info
  - list_workbooks
  - get_workbook
  - list_sheets
  - get_sheet
  - search_sheets
  - search_rows
  - get_sheet_rows
  - get_sheet_columns
  - get_sheet_summary
  - get_data_quality
  - detect_schema
  - detect_duplicates
  - profile_columns
  - get_categories
  - filter_sheet
  - group_by_sheet
  - pivot_sheet
  - aggregate_sheet
  - preview_join
  - lookup_rows
  - find_unmatched_rows
  - query_sheet
  - explain_query
  - validate_rows
  - get_validation_results
  - get_sheet_lineage
  - list_sheet_snapshots
  - compare_sheet_snapshots
  - get_row_provenance
  - get_cell_provenance
  - get_column_provenance
  - create_share_view
  - get_share_view
  - create_report_pack
  - get_report_pack
  - create_dashboard_from_sheet
  - get_dashboard
  - analyze_sheet
  - compare_sheets
  - find_trends
  - summarize_sheet
  - generate_table_report
  - preview_ingest_from_url
  - validate_tabular_source
  - get_ingestion_status
  - get_integration_status
  - get_route_compliance
  - get_discovery_compliance
  - get_agent_policy
  - list_agent_platforms
  - get_public_access_summary
  - get_health
  - get_info
  - export_sheet_csv
  - export_sheet_json
  - export_sheet_markdown
  - export_sheet_pdf
  - ingest_sheet_from_paste
  - ingest_sheet_from_url
  - persist_sheet
  - delete_sheet
  - create_computed_column
  - create_pivot_view
  - create_join_view
  - create_docs_report
  - create_deck_summary
- Resources:
  - opensheets://workbooks
  - opensheets://workbook/{id}
  - opensheets://sheets
  - opensheets://sheets/{id}
  - opensheets://sheets/{id}/rows
  - opensheets://sheets/{id}/columns
  - opensheets://sheets/{id}/summary
  - opensheets://sheets/{id}/quality
  - opensheets://sheets/{id}/lineage
  - opensheets://sheets/{id}/provenance
  - opensheets://categories
  - opensheets://share/{id}
  - opensheets://ingestion-runs
  - opensheets://jobs
  - opensheets://reports
  - opensheets://report-packs
  - opensheets://dashboards
  - opensheets://integrations
  - opensheets://openapi
  - opensheets://llms
  - opensheets://trust-policy
  - agent-policy://summary
  - agent-policy://platforms
  - agent-policy://robots
  - agent-policy://ai-policy
  - agent-policy://trust-policy
- Prompts:
  - analyze_sheet
  - compare_sheets
  - find_trends
  - summarize_sheet
  - generate_table_report
  - explain_data_quality
  - create_sheet_handoff
  - create_report_matrix
  - create_docs_report_from_sheet
  - create_pivot_plan
  - create_join_plan
  - create_dashboard_plan
  - explain_sheet_lineage
  - human_machine_sheets_handoff

## Trust Policy
Web dashboard, public-safe discovery, browser-based operations, trusted-domain discovery, standard route
compliance, Vercel metadata capture, trace inspection, and agentic workflow discovery are intentionally
supported for public read-only debugging and operator workflows. Mutating, administrative, ingestion, replay,
fork, remediation, deployment, sync, test-triggering, reporting, and write actions require PLATPHORM_API_KEY.

## Integrations
- trace.platphormnews.com
- mcp.platphormnews.com
- docs.platphormnews.com
- evals.platphormnews.com
- browserops.platphormnews.com
- monitor.platphormnews.com
- decks.platphormnews.com
- sandbox.platphormnews.com
- webhooks.platphormnews.com
- api.platphormnews.com
- catalog.platphormnews.com

## Import And Export Status
- Paste: public preview parser available; protected persist requires PLATPHORM_API_KEY and DATABASE_URL
- CSV: real parser
- TSV: real parser
- Excel: browser XLS/XLSX parser via xlsx
- JSON: real public preview parser for arrays of objects or arrays
- XML: real public preview parser for repeated row/item nodes
- Markdown: real public preview parser for Markdown tables
- HTML: real public preview parser for HTML tables
- Google Sheets: public CSV export adapter where the sheet is publicly readable; private connector access is degraded
- CSV export: real browser CSV export for local sheets and server CSV export for persisted public sheets
- JSON export: server JSON export for persisted public sheets
- Markdown export: server Markdown table export for persisted public sheets
- PDF export: degraded until PDF renderer is wired

## Analysis Status
- Schema inference: deterministic column profiling with type confidence and warnings
- Data quality: deterministic missing value, duplicate, mixed type, PII/secret warning, and constant-column checks
- Computed columns: safe formula preview only; no arbitrary JavaScript, network, filesystem, or eval
- Pivots, joins, and query: bounded deterministic preview endpoints; SQL-style query mode is read-only and sheet-scoped
- Charts: deterministic chart data only when suitable columns exist

## platphormctl Examples
- platphormctl site inspect sheets --best-effort
- platphormctl mcp validate sheets --best-effort
- platphormctl sheets import csv sample.csv --dry-run
- platphormctl publish report <runId> --to sheets --dry-run

## Trace And Vercel Metadata Policy
- Trace headers are accepted and propagated for Sheets operations.
- x-vercel-ja4-digest is correlation-only metadata and must be redacted before public display.