notion-export git:20260827.7ff2e25A

Immutable. This exact content is served forever at /api/v1/blob/94ca0b46bbd0c18b.

---
name: notion-export
description: |
  Export analysis results to a Notion page with proper structure, embedded charts, data stamps, and provenance toggle blocks. Use this skill whenever the user says "/export notion", "export to Notion", "create a Notion page", "share this in Notion", "put this in Notion", "send to Notion", or mentions wanting analysis outputs in their Notion workspace. Also trigger when the user mentions their Analysis Gallery or wants to add analysis results to a Notion database. This skill handles Notion MCP authentication, page structure decisions (toggle blocks vs H3 fallback), chart image hosting, provenance embedding, and Analysis Gallery database integration. The skill auto-detects whether toggle blocks are supported and falls back gracefully.
---

# 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