git:20260827.7ff2e25 to git:20260915.a64dd2a

- 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

- 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

- ### 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}

- ---

-

- 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