FlashRev Notion Email Tracker#

Pushes every flashrev-mailer send attempt into your Notion database using the Notion API directly. Reads NOTION_TOKEN and NOTION_DATABASE_ID from OpenClaw config — no MCP, no extra setup beyond those two values.

---

One-time setup#

The user must add two values in OpenClaw settings before the skill works:

NOTION_TOKEN Notion → Settings → Connections → Develop or manage integrations → New integration → copy the Internal Integration Secret.

NOTION_DATABASE_ID Open your target Notion database → Share → Copy link → grab the 32-char ID from the URL: notion.so/workspace/ abc123... ?v=...

Then share the database with the integration: open the database → ... menu → Add connections → select your integration.

---

Running the tracker#

Step 1 — Install dependencies (first use only)#

bash

cd scripts && npm install && cd ..

Step 2 — Push after every send batch#

After each flashrev-mailer send or --dry-run completes, run:

bash

node scripts/notion-push.js --campaign CAMPAIGN_ID

Use the exact --campaign slug from flashrev-mailer (e.g. launch-001).

Step 3 — Read the output and report to user#

text

🔗 Connected to Notion database: FlashRev Tracker
📂 Loaded 48 entries (campaign: launch-001)
🔍 Deduplication: 2 already exist, 46 new
✓ Batch 1 / 5 — 10 written
...
✅ Done. 46 written · 2 skipped (dup) · 0 errors
🔗 https://notion.so/abc123...

Query without writing#

bash

node scripts/notion-push.js --campaign CAMPAIGN_ID --query-only

---

Integration sequence with flashrev-mailer#

text

1. flashrev-mailer  →  send --campaign X --limit 10 --dry-run --yes
2. this skill       →  node scripts/notion-push.js --campaign X
3. user approves live send
4. flashrev-mailer  →  send --campaign X --limit 10 --live --yes
5. this skill       →  node scripts/notion-push.js --campaign X
6. repeat 4-5 for each approved batch

---

Error messages#

Script outputTell the userNOTION_TOKEN is not setAdd NOTION_TOKEN in OpenClaw settingsNOTION_DATABASE_ID is not setAdd NOTION_DATABASE_ID in OpenClaw settingsCould not find send-logflashrev-mailer send has not completed yet — check the CLI outputAPI token is invalidNOTION_TOKEN is wrong or expired — regenerate it in NotionCould not find databaseNOTION_DATABASE_ID is wrong, or integration not shared with databaseProperty does not existDatabase is missing a column — add it manually in Notion

---

What gets logged (11 fields per email)#

Name · Recipient Email · Subject Line · Body Preview (300 chars) · Campaign ID · Send Timestamp · Validation Status · Sender Mailbox · Send Mode · Send Result · Error Detail