\r \r

FlashRev Notion Email Tracker\r

\r 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.\r \r ---\r \r

One-time setup\r

\r The user must add two values in OpenClaw settings before the skill works:\r \r NOTION_TOKEN\r Notion → Settings → Connections → Develop or manage integrations → New integration → copy the Internal Integration Secret.\r \r NOTION_DATABASE_ID\r Open your target Notion database → Share → Copy link → grab the 32-char ID from the URL:\r notion.so/workspace/abc123...?v=...\r \r Then share the database with the integration: open the database → ... menu → Add connections → select your integration.\r \r ---\r \r

Running the tracker\r

\r

Step 1 — Install dependencies (first use only)\r

cd scripts && npm install && cd ..\r
```\r
\r
### Step 2 — Push after every send batch\r
After each `flashrev-mailer send` or `--dry-run` completes, run:\r
```bash\r
node scripts/notion-push.js --campaign CAMPAIGN_ID\r
```\r
Use the exact `--campaign` slug from `flashrev-mailer` (e.g. `launch-001`).\r
\r
### Step 3 — Read the output and report to user\r
```\r
🔗 Connected to Notion database: FlashRev Tracker\r
📂 Loaded 48 entries (campaign: launch-001)\r
🔍 Deduplication: 2 already exist, 46 new\r
✓ Batch 1 / 5 — 10 written\r
...\r
✅ Done. 46 written · 2 skipped (dup) · 0 errors\r
🔗 https://notion.so/abc123...\r
```\r
\r
### Query without writing\r
```bash\r
node scripts/notion-push.js --campaign CAMPAIGN_ID --query-only\r
```\r
\r
---\r
\r
## Integration sequence with flashrev-mailer\r
\r
```\r
1. flashrev-mailer  →  send --campaign X --limit 10 --dry-run --yes\r
2. this skill       →  node scripts/notion-push.js --campaign X\r
3. user approves live send\r
4. flashrev-mailer  →  send --campaign X --limit 10 --live --yes\r
5. this skill       →  node scripts/notion-push.js --campaign X\r
6. repeat 4-5 for each approved batch\r
```\r
\r
---\r
\r
## Error messages\r
\r
| Script output                        | Tell the user                                                        |\r
|--------------------------------------|----------------------------------------------------------------------|\r
| `NOTION_TOKEN is not set`            | Add NOTION_TOKEN in OpenClaw settings                                |\r
| `NOTION_DATABASE_ID is not set`      | Add NOTION_DATABASE_ID in OpenClaw settings                          |\r
| `Could not find send-log`            | flashrev-mailer send has not completed yet — check the CLI output    |\r
| `API token is invalid`               | NOTION_TOKEN is wrong or expired — regenerate it in Notion           |\r
| `Could not find database`            | NOTION_DATABASE_ID is wrong, or integration not shared with database |\r
| `Property does not exist`            | Database is missing a column — add it manually in Notion             |\r
\r
---\r
\r
## What gets logged (11 fields per email)\r
\r
Name · Recipient Email · Subject Line · Body Preview (300 chars) · Campaign ID · Send Timestamp · Validation Status · Sender Mailbox · Send Mode · Send Result · Error Detail