Notion Operations

All commands are invoked via Bash:

node ../../../../.founderOS/scripts/notion-tool.mjs <command> [args]

All output is JSON to stdout. Errors are structured JSON to stderr with exit code 1.

Workspace Discovery

Before performing operations, understand the workspace structure. This is critical when the user references pages by name rather than URL.

Discovery pipeline:

1. Search by name — run search with the page/database name the user provides.
2. Disambiguate — if multiple results match, present the user with a numbered list showing title, parent location, and last edited date. Ask them to pick.
3. Fetch details — once identified, run get-page to read page properties, or get-blocks for content.

Disambiguation rules:

• Present at most 5 candidates.
• Include the parent page/database name for context (e.g., "Meeting Notes" under "Q1 Planning" vs. "Meeting Notes" under "Team Wiki").
• If only one result matches, proceed without asking.
• If zero results match, suggest alternative search terms based on partial matches.

Page Operations

Creating Pages

Translate the user's natural language description into a page creation call.

Creation pipeline:

1. Determine parent — if --parent=NAME is provided, search for and resolve the parent page. If omitted, create at workspace root.
2. Parse content — extract the page title and body content from the user's description.
3. Format content blocks — convert plain text into Notion block types:
   • Paragraphs → paragraph blocks
   • Bullet lists → bulleted_list_item blocks
   • Numbered lists → numbered_list_item blocks
   • Headings → heading_1, heading_2, heading_3 blocks
   • Code blocks → code blocks
   • Checkboxes/to-dos → to_do blocks
4. Create — run create-page with the parent ID, --properties for title, and --content for content blocks.
5. Confirm — report the created page title and URL.

Reading Pages

Fetch and present page content in a readable format.

1. Run get-page with the page URL or ID.
2. Extract the title from the Title property.
3. Extract body content, preserving block structure (headings, lists, paragraphs).
4. For database entries, extract all properties as key-value pairs above the body content.

Updating Pages

Map natural language change descriptions to property updates or content modifications.

Update pipeline:

1. Find the page — search by title or accept a URL. Disambiguate if needed.
2. Fetch current state — read the page to understand existing properties and content.
3. Parse changes — determine what the user wants to change:
   • Property updates: "set status to Done", "change priority to High", "update the date to next Friday"
   • Content append: "add a section about X", "append these notes"
   • Content replacement: "change the title to Y", "update the description"
4. Map to API calls — translate changes into update-page CLI parameters.
5. Confirm before executing — show a summary of planned changes. Proceed only after user confirms.
6. Execute and report — apply changes, then show a before/after summary.

Property value mapping:

• "Done", "complete", "finished" → Status property: "Done"
• "High", "urgent", "important" → Select property: "High"
• "next Friday", "March 15" → Date property: parse to ISO date
• "yes", "true", "checked" → Checkbox property: true
• "tag it as X" → Multi-select property: add "X"

Consult skills/notion/notion-operations/references/workspace-patterns.md for the full property value mapping table and advanced update patterns.

Database Operations

Creating Databases

Database creation is handled jointly with the notion-database-design skill (see skills/notion/notion-database-design/SKILL.md). This skill provides the operational execution; the design skill provides schema translation.

1. Resolve the parent page (databases must have a parent page).
2. Receive the property schema from the design skill or from a template.
3. Run create-database with parent ID, --title, and --properties for property definitions.
4. Confirm creation with the database title, URL, and property summary.

Querying Databases

Translate natural language questions into database queries with filters and sorts.

Query pipeline:

1. Identify the database — search by name using search, or accept --db=NAME flag.
2. Fetch schema — run query <database-id> --page-size 1 to discover properties, or get-page <database-id> for the schema.
3. Translate question to filter — map the user's natural language to filter conditions:
   • "overdue tasks" → Due Date before today AND Status is not "Done"
   • "high priority items" → Priority equals "High"
   • "tasks assigned to me" → Assignee contains current user
   • "created this week" → Created after Monday of current week
4. Apply sort — infer sort order from the question:
   • "latest" / "newest" / "recent" → sort by date descending
   • "oldest" / "first" → sort by date ascending
   • "highest priority" → sort by priority descending
   • Default: sort by last edited descending
5. Execute query — run query <database-id> --filter '<json>' --sorts '<json>'.
6. Format results — present as formatted cards with key properties.

Result card format:

### [Title]
- Status: [value]
- Priority: [value]
- Due: [date]
- [other relevant properties]
→ [Notion URL]

Limit results to --limit=N (default 10). If more results exist, note the total count.

Consult skills/notion/notion-operations/references/workspace-patterns.md for NL-to-filter translation examples and complex filter patterns.

Search Strategies

Notion search has specific behaviors that affect how queries should be constructed.

Key behaviors:

• Search is title-weighted — page titles match more strongly than body content.
• Boolean operators (AND, OR, NOT) are not supported — use simple keyword phrases.
• Short queries (2-4 words) perform better than long phrases.
• Database entries and pages both appear in results.

Search approach by intent:

Empty result handling:

1. Retry with a shorter query (drop adjectives and qualifiers).
2. Try common synonyms for the key terms.
3. If still empty, report "No matching pages found" and suggest the user check that the content has been shared with the Notion integration.

Content Block Formatting

When creating or appending content, convert user text to appropriate Notion block types.

Detection rules:

• Lines starting with - or * → bulleted_list_item
• Lines starting with 1. , 2. → numbered_list_item
• Lines starting with [ ] or [x] → to_do
• Lines starting with # → heading_1, ## → heading_2, ### → heading_3
• Lines wrapped in triple backticks → code
• Lines starting with > → quote
• Horizontal rules (---) → divider
• All other text → paragraph

Preserve inline formatting: bold, italic, code, strikethrough, links.

Graceful Degradation

• Notion CLI unavailable: Report clearly that the Notion connection is not available. Check that $NOTION_API_KEY is set. Run /founder-os:setup:notion-cli for setup. Do not attempt any Notion operations.
• Page not found: After search returns empty, suggest the user verify the page name or provide a direct URL.
• Permission errors: Report that the integration may not have access to the requested page. Suggest sharing the page with the Notion integration.
• Rate limits: If a rate-limit error occurs, wait briefly and retry once. If it persists, report the issue and suggest trying again in a moment.

Additional Resources

Reference Files

For detailed patterns and advanced techniques, consult:

• skills/notion/notion-operations/references/workspace-patterns.md — NL-to-filter translation examples, property value mapping tables, complex query patterns, and multi-block content construction examples