Email

Email automation via Resend. Send one-off emails, bulk blasts to contact lists, or run multi-step drip campaigns.

Config

From ~/.claude/.env:

• RESEND_API_KEY - Resend API key
• RESEND_FROM - Sender name and email (e.g. Your Name <you@yourdomain.com>)
• RESEND_REPLY_TO - Reply-to email address

Contact Sources

The skill can send to:

• Individual emails - via --to email@example.com for one-off sends
• Skool members - via the skool_members SQLite table (synced by the skool skill), with filters for free/premium/vip
• Resend Contacts - contacts synced to Resend dashboard for broadcasts and segments

Database

SQLite at ~/.claude/skills/skool/data/skool.db. Uses a normalized 3-table design:

email_campaigns - defines campaigns (name, trigger_type, trigger_filter, active) email_campaign_steps - steps in each campaign (step_number, delay_hours, subject_template, html_template, tag) email_sends - log of every email sent (campaign_id, step_number, member_id, email, sent_at, mailgun_id, opened_at)

The campaign runner matches contacts against the campaign's trigger_filter SQL, checks email_sends for what step they're on, and sends the next one if enough time has passed.

What to Do Based on User Request

"send email" / "send an email to"

Send a single email to a specific address.

1. Ask for: recipient, subject, body content
2. Draft the HTML email and show it to the user
3. Get confirmation
4. Run: python3 ~/.claude/skills/email/send_email.py --subject "..." --html-file /tmp/email.html --to recipient@email.com

"blast email" / "email members" / "email everyone"

Bulk email to all contacts (or a filtered subset).

1. Ask for: subject, email body content (or a topic to draft from)
2. Draft the HTML email and show it to the user
3. Ask which contacts to target (all, free only, premium only, or a custom filter)
4. Show recipient count and get confirmation
5. Run: python3 ~/.claude/skills/email/send_email.py --subject "..." --html-file /tmp/email.html [--filter free|premium|vip|all] [--batch-size N] [--batch-offset N]

"drip campaign" / "welcome emails" / "email campaign"

Run campaign checker. Finds contacts due for their next step and sends it.

1. Run: python3 ~/.claude/skills/email/email_campaign.py [--campaign name]
2. Report what was sent (or that no one is due)

"campaign status" / "email status"

Check without sending.

1. Run: python3 ~/.claude/skills/email/email_campaign.py --dry-run
2. Show who is due for which step

"list campaigns"

Show all campaigns, their steps, and send counts.

1. Run: python3 ~/.claude/skills/email/email_campaign.py --list

"sync contacts" / "update resend contacts"

Sync local contacts to Resend Contacts (create, update, delete).

1. Run: python3 ~/.claude/skills/email/sync_contacts_resend.py
2. Report creates, updates, and deletes

Current Campaigns

new_member_welcome (auto, 3 steps):

• Step 1 "Welcome" - +1h after approval (templates/welcome.html)
• Step 2 "Getting Started" - +24h after approval (templates/getting_started.html)
• Step 3 "Self-Hosting" - +72h after approval (templates/self_hosting.html)

Adding a New Campaign

To add a campaign, insert into email_campaigns and email_campaign_steps:

INSERT INTO email_campaigns (name, description, trigger_type, trigger_filter, active, created_at, updated_at)
VALUES ('campaign_name', 'description', 'auto|manual', 'SQL WHERE clause for contacts', 1, datetime('now'), datetime('now'));

INSERT INTO email_campaign_steps (campaign_id, step_number, delay_hours, subject_template, html_template, tag)
VALUES (campaign_id, 1, 0, 'Subject with {first_name}', 'templates/template.html', 'tag_name');

Templates

HTML templates at ~/.claude/skills/email/templates/. Use {first_name} as placeholder.

Rules

• Always show email content and get confirmation before sending
• Never auto-send without user approval
• No em dashes in any email content
• Tag emails with their type for Resend tracking
• All sends are logged in email_sends (both campaign and one-off blasts)