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"

Step 4: Toggle Block Detection

Before building the page, check if toggle blocks work:

1. Create a test page with one toggle block via notion-create-pages
2. If it succeeds: use toggle blocks for provenance sections
3. If it fails or toggles aren't supported:
   • Fallback: Use H3 headings instead of toggle blocks
   • Provenance details go under H3 subheadings (always visible)
   • Add a note: "Toggle blocks not available — provenance shown inline"

Step 5: Chart Image Hosting

Charts must be reachable at an HTTPS URL for Notion to embed them.

Data handling rule: charts go only to the user's own Google Drive. Never upload charts or data to public file hosts; the analysis may contain confidential numbers.

Workflow:

1. Upload each chart to Drive via the chart-to-drive skill (.claude/skills/chart-to-drive/SKILL.md) and get the shareable URL
2. Insert image blocks using the Drive URL
3. If Google Drive tools are unavailable: create the page without images, list the chart file paths in the page so the user can add them by hand, and say so plainly

Step 6: Create the Page

Use mcp__notion__notion-create-pages with the structured content.

Build the page content as Notion blocks:

• heading_2 for section headings
• paragraph for body text
• bulleted_list_item for bullet lists
• numbered_list_item for numbered lists
• callout for data stamps and confidence badges
• toggle for provenance detail sections (with fallback to heading_3)
• code for SQL blocks (language: "sql")
• image for chart images
• divider for section separators

Step 7: Self-Check (6 Points)

After creating the page, read it back and verify:

1. Title correct — page title matches expected format
2. All findings present — count H2 sections matches finding count
3. Charts embedded — image blocks present for each chart
4. Data stamps present — callout blocks with data stamp text
5. Provenance sections exist — toggle or H3 blocks for each finding
6. No empty sections — no heading followed immediately by another heading

If any check fails, attempt one fix iteration (max 1 retry).

Step 8: Report

Analysis exported to Notion:
  URL: {page_url}
  Location: {Analysis Gallery / Standalone page}
  Findings: {N}
  Charts: {N} embedded
  Provenance: {toggle blocks / H3 sections}
  Self-check: {PASS / PASS with {N} fixes / {N} issues flagged}

---

Rules

1. Never duplicate content. If an Analysis Gallery entry already exists for this dataset + date, ask before creating a duplicate.
2. Data stamps on every finding. Even if provenance toggle blocks fail, the callout data stamps must be present.
3. Chart URLs must be accessible. Verify the image URL works before embedding. If upload fails, skip the image and note: "Chart not embedded — upload failed."
4. One fix iteration max. If the self-check fails after one retry, report issues and let the user fix manually.
5. Never expose secrets. Database connection strings, passwords, and API keys must not appear in the Notion page content.

Edge Cases

• No Notion MCP: Cannot export. Suggest: "Configure Notion MCP integration first."
• Toggle blocks unsupported: Fall back to H3 headings (always visible)
• No charts available: Create page without images, note in report
• Google Drive unavailable: Create the page without images, list chart paths for manual upload
• Large analysis (>10 findings): Split into sections with a table of contents at top
• Analysis Gallery has custom properties: Map to known properties, skip unknown ones