Notion Pipeline

Use when the night-shift agents need to validate Notion env, query a Notion database, create or update pages, or append blocks in the idea-factory databases.

Use the helper script at {baseDir}/scripts/notion_api.mjs for all low-level Notion operations. Use {baseDir}/scripts/factory_ops.mjs for higher-level factory workflows such as signal writes, librarian reviews, idea writes, evaluations, approvals, and HPD project packs. Local runtime env is loaded from /Users/dellymac/.openclaw/secrets/notion.env when present.

Expected env

• OPENCLAW_NOTION_TOKEN
• OPENCLAW_NOTION_DB_RESEARCH_SIGNALS
• OPENCLAW_NOTION_DB_PROJECT_IDEAS
• OPENCLAW_NOTION_DB_PROJECTS
• OPENCLAW_NOTION_DB_NIGHTLY_RUNS

See {baseDir}/references/env-vars.md for alias names and usage.

Commands

OPENCLAW_NOTION_TOKEN=... node {baseDir}/scripts/bootstrap_factory.mjs
node {baseDir}/scripts/notion_api.mjs check-env
node {baseDir}/scripts/notion_api.mjs query-db research
node {baseDir}/scripts/notion_api.mjs query-db ideas filters.json
node {baseDir}/scripts/notion_api.mjs create-page research payload.json
node {baseDir}/scripts/notion_api.mjs update-page <page-id> payload.json
node {baseDir}/scripts/notion_api.mjs append-blocks <page-id> blocks.json
node {baseDir}/scripts/notion_api.mjs retrieve-page <page-id>
node {baseDir}/scripts/factory_ops.mjs write-signals signals.json
node {baseDir}/scripts/factory_ops.mjs list-signals trend inbox
node {baseDir}/scripts/factory_ops.mjs apply-signal-reviews reviews.json
node {baseDir}/scripts/factory_ops.mjs list-archived-signals mechanical
node {baseDir}/scripts/factory_ops.mjs write-ideas ideas.json
node {baseDir}/scripts/factory_ops.mjs list-ideas 2026-03-27
node {baseDir}/scripts/factory_ops.mjs apply-evaluations evaluations.json
node {baseDir}/scripts/factory_ops.mjs handle-approval approve <ideaId>
node {baseDir}/scripts/factory_ops.mjs record-report-delivery report_delivery.json
node {baseDir}/scripts/factory_ops.mjs get-project <projectId>
node {baseDir}/scripts/factory_ops.mjs update-project-pack <projectId> pack.json

Rules

• Fail fast if OPENCLAW_NOTION_TOKEN is missing.
• Use bootstrap_factory.mjs to create or recover the 4 factory databases under an accessible parent page and persist the IDs into the local env file.
• Prefer database aliases research, ideas, projects, and runs.
• Keep payload files in JSON.
• Return the raw JSON response and inspect it before claiming success.
• If required env is missing, report only the missing variable names and stop. Do not invent setup commands.