Flashrev Mailer Notion Tracker
Use this skill whenever emails are sent or dry-run previewed via the flashrev-mailer CLI and you need to log, track, or audit those emails in Notion. Triggers on requests to log sent emails to Notion, track flashrev campaign sends, record email history, audit outreach campaigns, or view and query past sends. Always invoke after a flashrev-mailer send or dry-run step completes. Also use when the user asks to check what emails were sent, view campaign logs in Notion, or search past outreach.
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)
cd scripts && npm install && cd ..
Step 2 — Push after every send batch
After each flashrev-mailer send or --dry-run completes, run:
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
🔗 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
node scripts/notion-push.js --campaign CAMPAIGN_ID --query-only
Integration sequence with flashrev-mailer
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 output | Tell the user |
|---|---|
NOTION_TOKEN is not set | Add NOTION_TOKEN in OpenClaw settings |
NOTION_DATABASE_ID is not set | Add NOTION_DATABASE_ID in OpenClaw settings |
Could not find send-log | flashrev-mailer send has not completed yet — check the CLI output |
API token is invalid | NOTION_TOKEN is wrong or expired — regenerate it in Notion |
Could not find database | NOTION_DATABASE_ID is wrong, or integration not shared with database |
Property does not exist | Database 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
Related skills
- Downloads
- Security audit
- Pass
- Last updated
- 6mo ago
- Current version
- v1.0.1
- License
- MIT-0
