notion-export

Skill: Notion Export

Purpose

Export analysis results to Notion as a well-structured page with charts, data stamps, and provenance. Supports both standalone pages and Analysis Gallery database entries.

Invocation

/export notion — export the latest analysis to Notion

Instructions

Step 0: Check Notion MCP Availability

Check if mcp__notion__* tools are accessible:

1. Attempt mcp__notion__notion-search with a test query
2. If tools available: Proceed to Step 1
3. If tools unavailable: "Notion MCP is not configured. Set up the Notion integration first."

Step 1: Find Source Material

Same as the main export skill — find the latest narrative, charts, validation, and close-the-loop outputs. Also gather:

• Provenance blocks (from cross-verification YAML + provenance assembler)
• Query log (for receipt-level detail)
• Confidence grade and score

Step 2: Auto-Detect Analysis Gallery

Search for an "Analysis Gallery" database in the user's Notion workspace:

mcp__notion__notion-search(query="Analysis Gallery", filter={"value": "database"})

If found:

• Create a new page within the database
• Set properties: Title, Date, Dataset, Confidence Grade, Status
• Use the database's property schema for structured metadata

If not found:

• Create a standalone page
• Inform the user: "No Analysis Gallery database found. Creating a standalone page. To organize analyses, create a Notion database called 'Analysis Gallery' with properties: Title (title), Date (date), Dataset (text), Confidence (select: A/B/C/D/F), Status (select: Draft/Final)."

Step 3: Build Page Structure

Page Title

{Analysis Title} — {Dataset} ({Date})

Page Icon

Use the confidence grade as the icon:

• A: green circle
• B: yellow circle
• C: orange circle
• D/F: red circle

Content Structure

Callout block: Confidence badge
  "Confidence: {grade} ({score}/100) — {interpretation}"

H2: Executive Summary
  Paragraph: 3-5 sentence overview
  Bulleted list: Key findings (max 3)

H2: Finding 1 — {title}
  Callout block (gray): Data stamp
    "{row_count} rows | {date_range} | {primary_table} | {grade} ({score})"
  Paragraph: Insight and evidence
  Image block: Chart (if available)
  Toggle block: "Show methodology & SQL"
    Paragraph: Methodology details
    Code block (sql): Full SQL query
    Paragraph: Cross-verification result

H2: Finding 2 — {title}
  ... (repeat pattern)

H2: Recommendations
  Numbered list: Action items

H2: Data Quality & Limitations
  Paragraph: Validation summary
  Bulleted list: Caveats

Divider

H3: Provenance
  Toggle block: "Full provenance for F1"
    ... (full provenance block content)
  Toggle block: "Full provenance for F2"
    ...

H3: Analysis Receipt
  Paragraph: "Full audit trail available at: outputs/analysis_receipt_{DATASET}_{DATE}.md"