← All work Productized system · Lead data · 2026

4,535 rows in. 2,953 real people out.

The lead engine behind our outbound, built to white-label. It takes any export, maps the columns, removes duplicates, researches every company, writes the opener and puts it all in one dashboard.

TypeWhite-label internal tool
We didPipeline, dedupe, AI research, dashboard
TimelineMay to Aug 2026
StackPython · pandas · Flask · Claude
2,953unique leads after dedupe
4,535lead rows merged across 20 files
4niches across the US and Canada
$0.07model cost to research and write for 100 leads
The short version

Clean first. The AI comes last.

The whole idea in 60 seconds, one product decision at a time.

01Ingest anything

Every source speaks a different dialect.

Apollo, Google Maps and directory scrapes all name their columns differently. A normaliser maps them to one schema before anything else runs.

Apollo CSVApify Google MapsApify directory actorsAny CSV with an email
02Dedupe

Same person, three lists, one row.

Emails are trimmed and lowercased into a match key. Matches merge, role inboxes get flagged, and domains are grouped to catch guessed addresses.

03Research + grade

Seven stages, one click, five minutes.

A logged run of 100 leads: 85 homepages read, 82 summarised by Claude Haiku, 77 specific lines, 23 fallbacks, $0.065 in model cost.

Checkpoint every 10 leadsResume from any stage5 parallel scrapersRun report per batch
04Personalise at scale

An observation, then a bridge from the same pain.

Each line is sorted into a pain family by free rules, and the bridge comes from that family's approved bank. The line and the pivot always agree.

05Built to hand over

A tool a non-coder can run.

No terminals. Every job has a web screen, and an assistant can do file work for you with guardrails.

Real screen · Dedup engine

Sent history on the left, new export on the right.

Drop the files, run it, get a clean CSV that skips anyone already contacted.

localhost · /dedup
The real Dedup Engine screen: two drop zones for already-sent leads and a new batch, a Run dedup button and a download destination.
Assistant with tools

Ask in plain English.

Claude calls file tools to count, compare, dedupe and rename lists.

Remove everyone we already emailed from the new clinic list.

dedupe_csvs(existing=2, new=1)

Removed 41 already contacted and 3 internal duplicates. 286 ready to send.

Guardrails

Nothing is ever hard-deleted.

File work is sandboxed to the project, and "delete" moves the file to a dated trash folder.

Crash-proof

Progress saved every 10 leads.

A dropped connection mid-run resumes where it stopped. Restart or jump to any stage with one flag.

Light to run

CSV files, no database.

Python, pandas and Flask on a laptop. The only paid call is the model, a few cents per hundred leads.

PythonpandasFlaskBeautifulSoupClaude HaikuClaude Sonnet (QA pairs)ApifyApolloInstantly export

Want a lead engine that runs under your brand?

We build the pipeline, the dedupe and the dashboard around your sources and your offer, then hand it over or run it for you. Start with a free 20-minute call.