codex

@codex

Goal
Give me a single place in Notion where I can type natural-language commands and Maggie executes them (Stripe updates, Notion building, DALL·E image generation, RPA/browser steps). Also keep syncing my “Stripe Product Tracker – Active” DB.

Environment (already set in Vercel)
- NOTION_TOKEN
- NOTION_HQ_PAGE_ID
- NOTION_STRIPE_DB_ID  ← database ID of “Stripe Product Tracker – Active”
- STRIPE_SECRET_KEY
- BROWSERLESS_TOKEN
- CRON_SECRET

Build

A) Notion “Command Center”
1) Create (or ensure) a Notion database under NOTION_HQ_PAGE_ID titled **“Maggie Command Center”** with properties:
   - Command (title)
   - Arguments (rich_text)
   - Status (select: Pending, Running, Succeeded, Failed)
   - Output / Logs (rich_text)
   - Created (created_time)
   - Updated (last_edited_time)
   - Run Now (checkbox)
2) Add an API route: **POST /api/commands/run**
   - If body has {id} → run that Command row by ID.
   - If body has {command, args} → create a row then run it.
   - Respond JSON with {ok, id, status}.

B) Executor (natural-language → actions)
Create **lib/executor.ts** that routes common intents from “Command” to handlers:
   - **stripe.syncFromTracker** → reads NOTION_STRIPE_DB_ID rows and:
     * creates/updates Stripe Products & Prices
     * uploads image from Notion file property or fallback from “MM Stripe Images”
     * sets tax_behavior=exclusive, metadata (slug, tier, donation flags)
     * returns a summary table to Output / Logs
   - **notion.createTable** → creates a full-page Notion DB with given columns (e.g., “Create a Content Calendar with columns Title, Topic, Due Date, Platform, Status”)
   - **notion.appendPage** → creates a page, sets icon/cover, writes content blocks
   - **images.generate** → calls OpenAI Images/DALL·E using product reference images in Notion to match aesthetic; saves result back to Notion file property
   - **rpa.openAndClick** → uses Browserless to open a URL and perform a short script (login flow or one-off steps); save a viewer URL in Output / Logs
Implement a simple intent detector (regex / keywords). Log “Couldn’t route” when unknown.

C) Poller + buttons
1) API: **POST /api/commands/scan** (protected by x-mags-key: CRON_SECRET)
   - Finds Command Center rows where (Run Now=true OR Status=Pending), marks Status=Running, executes, writes Output/Logs, then sets Succeeded/Failed.
2) GitHub Action “mags-cron”:
   - Add a step to call /api/commands/scan every 2–5 minutes on schedule and via workflow_dispatch.
3) Small web UI:
   - Add a simple page at **/console** with a textbox (Command, Args), a “Run” button that POSTs to /api/commands/run, and a link to last 10 logs.

D) Stripe Tracker integration
- API: **POST /api/stripe/sync** (X-Worker-Key protected). This uses NOTION_STRIPE_DB_ID as source of truth:
  * expects columns: Product Name (title), Status (select), Price (number), Product Description (text), Image File (files), Stripe Link (url, optional)
  * when product created/updated, write Stripe Link and flip Status → “Added in Stripe”; set Date Updated = today (if column exists)
  * idempotent by slug derived from Product Name (kebab-case)

E) README
- Add “How to talk to Maggie” section with examples (see below).
- Add curl examples:
  curl -s -X POST "$API_BASE/api/commands/run" -H "content-type: application/json" -d '{"command":"stripe.syncFromTracker"}'
  curl -s -X POST "$API_BASE/api/commands/scan" -H "x-mags-key: '"$CRON_SECRET"'"

Deliverables
- New Notion DB creation, routes, executor, cron wiring, /console page
- Logs shown in Output / Logs and in server logs
- Safe, idempotent Stripe updates

Examples I will use
- “stripe.syncFromTracker”
- “Create a Notion table named ‘Content Calendar’ with columns Title (title), Topic (text), Due Date (date), Platform (select: TikTok, IG, YT), Status (select: Idea, Script, Record, Edit, Scheduled, Posted)”
- “Generate a pastel cottagecore product cover for ‘Full Soul Blueprint’ using the reference image in Stripe Tracker row; attach back to Image File”
- “Open Stripe login and wait; return the viewer link”