Outreach Sequencer — Multi-Step Personalized Campaigns

Design, schedule, and execute multi-step outreach sequences across LinkedIn and email. Each message is personalized per lead using their profile data from DuckDB.

Sequence Templates

Template 1: LinkedIn Connection + Message

CODEBLOCK0

Template 2: Cold Email Sequence

CODEBLOCK1

Template 3: Multi-Channel

CODEBLOCK2

Personalization Engine

Each message is generated per-lead using their DuckDB profile data. Use these variables:

Variable	Source	Example
INLINECODE0	Name field (split)	"Jane"
INLINECODE1

Company field | "Acme Corp" |
| {title} | Title field | "CTO" |
| {mutual} | Shared connections/background | "Stanford" |
| {trigger} | Why reaching out now | "saw your Series A" |
| {value_prop} | What you offer them | "AI-powered analytics" |
| {pain_point} | Their likely challenge | "scaling engineering team" |

Personalization Rules

• - Never use generic openers like "I hope this finds you well"
• Reference something specific: recent post, company news, shared background
• Keep LinkedIn messages under 300 chars (connection note limit)
• Keep cold emails under 150 words (respect attention)
• Vary language across leads — don't send identical messages to people at the same company
• Match tone to seniority: C-suite gets concise/strategic, ICs get technical/peer-level

Message Generation Pattern

CODEBLOCK3

Execution

LinkedIn Messages (via Browser)

CODEBLOCK4

Email (via gog CLI)

CODEBLOCK5

For follow-ups (reply to thread):
CODEBLOCK6

Sequence Status Tracking

Track in DuckDB with these status fields:

Field	Values	Notes
Outreach Status	Queued, Sent, Replied, Converted, Bounced, Opted Out	Main status
Sequence Step

1, 2, 3, 4 | Current step in sequence |
| Last Outreach | date | When last message was sent |
| Next Outreach | date | When next step is due |
| Outreach Channel | LinkedIn, Email, Both | Active channel |
| Reply Received | boolean | True if they responded |
| Thread ID | text | Gmail thread ID for email chains |

CODEBLOCK7

Cron Integration

Set up automated sequence execution:

CODEBLOCK8

Cron Job Setup (for OpenClaw)

CODEBLOCK9

Safety & Compliance

• - Daily send limits: Max 50 LinkedIn connection requests/day, 100 messages/day
• Email limits: Max 100 cold emails/day (avoid spam flags)
• Opt-out handling: If someone replies "not interested" / "unsubscribe", immediately set status to "Opted Out" and never contact again
• Bounce handling: If email bounces, mark as "Bounced" and try alternate email patterns
• CAN-SPAM compliance: Include sender identity, physical address option, and opt-out mechanism in emails
• LinkedIn ToS: Keep connection notes professional, don't spam InMails
• Cool-down: If a lead hasn't replied after full sequence, wait 90 days before any re-engagement

Analytics

After each sequence run, track:
CODEBLOCK10