Lead CSV to Qualified, Personalized Outreach
Turn a raw lead CSV into qualified, enriched outreach drafts with sourced icebreakers and clear review flags.
Before & after
Same prompt, same agent — the only difference is the skill.
Taking raw leads and turning them into a personalized campaign involves several steps—first you'd want to qualify which leads are worth reaching out to, then you'd need to enrich the data with additional information about them, and finally you'd want to personalize the messaging. Each of these steps is pretty involved. I could help you think through each phase, but you'd probably need to set up some tools to automate this. Do you have a sense of what your ideal customer profile looks like?
OUTBOUND PIPELINE: Raw Leads → Personalized Campaign
INPUT: 150 raw leads (CSV: name, company, email)
150 leads into /outbound_pipeline command
STAGE 1: QUALIFICATION (30 min, 15 API calls)
Rules applied:
- Revenue > 10M USD (Clearbit data)
- Industry in (SaaS, Tech, Financial Services)
- Founder or VP title level
- Located in US or UK
Output: 82 qualified leads (45% pass rate)
Removed: SMBs, wrong titles, EU (timezone complexity)
STAGE 2: ENRICHMENT (60 min, 82 Apify actors)
Data sources queried:
- LinkedIn URL extraction (profile, recent posts, followers)
- Company website scrape (latest news, funding stage, team size)
- Twitter/X sentiment score (engagement level)
- Recent job change detector (hiring expansion signal)
Enrichment fields added:
- recent_hiring (Yes/No)
- company_news (latest announcement + date)
- person_influence_score (1-10)
- estimated_budget (based on company size)
Output: 82 enriched lead records + 15 discarded (bad email, duplicate)
Active leads: 67
STAGE 3: PERSONALIZATION (45 min, icebreaker generation)
Template engine processes each lead:
- If recent_hiring=Yes → Personalize to hiring message
"Noticed Acme Corp just hired 8 salespeople; I help sales teams close 20% faster"
- Else if recent_news=Yes → Reference news
"Saw your Series B announcement in July; now's the time to optimize scaling"
- Else → Company pain point angle
"SaaS companies at your scale typically spend 15% of revenue on implementation; we cut that to 8%"
Subject line: First name + company mention (open rate +12% vs generic)
OUTPUT CSV: Ready-to-send campaign
Columns: email, first_name, company, icebreaker, subject_line, send_day (staggered)
67 personalized messages (3 templates, customized per lead)
Sending schedule: 10 per day over 7 days (avoid spam filters)
Tracking: UTM codes auto-inserted, reply rate target 5%
DELIVERABLE: campaign_2026_07_31.csv
Import into mail tool (Outreach, Salesloft)
Auto-send starting tomorrow morning
Expected replies: 3-4 (5% conversion)
Expected meetings: 1-2 (30% reply-to-meeting rate)About this skill
Your lead list passes through three separate steps, and somewhere between qualification, enrichment, and personalization the wrong rows get researched or the icebreakers turn generic. This workflow keeps those stages connected: qualify first, enrich only eligible leads, and draft each opener from a traceable fact.
What it does
- Converts your ICP into explicit pass, fail, and missing-evidence rules.
- Detects duplicate contacts and applies supplied suppression lists before enrichment.
- Carries stable record IDs through every stage so research and messages stay attached to the correct lead.
- Uses available, authorized enrichment sources and records the fact, source URL, and date behind each opener.
- Holds thin, ambiguous, or failed rows for review instead of filling them with invented personalization.
- Produces a campaign CSV with qualification reasons, enrichment status, icebreakers, and explicit outreach eligibility.
What you get
One campaign CSV that preserves your input fields and adds the pipeline results, plus a short reconciliation of qualified, rejected, duplicate, and held rows. Draft-ready messages are separated from records that still need evidence, contact checks, or review.
Best for
Outbound agencies, sales operations teams, and founders who repeatedly turn raw prospect lists into personalized campaign drafts and need reliable handoffs between research and copy.
SKILL.md preview
---
name: lead-csv-to-qualified-personalized-outreach
description: >-
… (sign up to view the full skill)Featured in
More sales skills
View all Sales skills →Sales Call Notes to CRM Entry
Turns messy call notes or transcripts into a paste-ready CRM entry with evidence-backed fields, verbatim objections, and dated next steps.
Cold Email Draft Diagnosis and Rewrite
Paste a cold email draft and get the one problem killing replies, a short single-ask rewrite, a better subject line, and a change log.
Partner Sign-or-Pass Review and 90-Day GTM Plan
Get a partner sign-or-pass recommendation, defensible revenue-share terms, and a measurable 90-day joint GTM plan.
RevOps Pipeline and CRM Rules Fixer
Fix lifecycle stages, lead routing, CRM hygiene, stage exit criteria, coverage and forecast accuracy math, and comp plan traps.