Flashrev Mailer Notion Tracker

该 Skill 通过 Node 脚本把 flashrev-mailer 每次发送或试运行产生的邮件记录写入 Notion 数据库，每条含收件人、主题、正文预览、活动 ID、时间戳等 11 个字段，支持按活动 ID 去重与只读查询，并输出写入统计；需预先配置 Notion 集成令牌和数据库 ID 并共享数据库。

sawera557

热度 24.84

最近更新 2026-05-18 23:07:11

分类：协作依赖：代码执行 / 读写文件 / 第三方 API应用场景：CRM / 工作流

安装技能

复制下面的话术发给你的 Agent，它会通过 secure-skills 检索并安装该技能。

执行命令安装此 skill： npx secure-skills-cli add flashrev-mailer-notion-tracker

Metadata

name: flashrev-notion-tracker
description: 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.
license: MIT-0
metadata: {"openclaw":{"requires":{"bins":["node"],"config":["NOTION_TOKEN","NOTION_DATABASE_ID"]}}}

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