MCA Lead Extraction — Automated Court Records to Daily Leads
Overview
An automated lead pipeline that turns public court filings into a daily book of qualified MCA leads across two states. In New York it works county by county, extracting cases from each county's court site and building a separate Excel file per county. In Florida it goes through Docket Alarm instead, searching against a maintained list of plaintiffs, with the rest of the process identical.
Reading the filings is the part that needed judgement rather than pattern matching: the OpenAI API extracts the lead's details out of the summons and its supporting documents, where the information sits in prose rather than in fields. Each extracted lead is then enriched with verified mobile and email contacts through AccurateAppend and Enformion, checked for consistency, and written back to a PostgreSQL store that exists specifically so the same lead is never extracted or sold twice.
A dashboard with user management sits over the whole thing, and a scheduler drives the runs — pending jobs are picked up by a pool of workers running in parallel, so a day's counties finish in the window rather than in sequence. The finished Excel files go out to the client by email every day.
Outcome
A day's court filings across New York's counties and Florida's dockets arrive as enriched, deduplicated Excel files in the client's inbox each morning — cutting manual case review by over 80% and improving contact accuracy for the outreach that follows.
Screens & Demos
Architecture & Pipeline
-
01
Scheduler (EST)
Timezone-aware runs
-
02
Parallel Workers
Pending jobs cleared at once
-
03
NY County Court Sites
County by county
-
04
Docket Alarm (FL)
Searched by plaintiff list
-
05
OpenAI Extraction
Summons + supporting files
- OpenAI
-
06
Keyword & Category Filter
Commercial contracts
-
07
PostgreSQL
Dedupe store · one lead once
- PostgreSQL
-
08
AccurateAppend / Enformion
Phone + email enrichment
-
09
Excel per County
Compliant outreach data
- Excel
-
10
Email Delivery
9 AM EST, every day
End-to-end flow, in order. Scroll sideways on a narrow screen.
Key Features
- New York worked county by county, with a separate Excel file built per county
- Florida covered through Docket Alarm, searched against a maintained plaintiff list
- OpenAI API extracting lead details from summons documents and their supporting files
- PostgreSQL store preventing the same lead from ever being extracted twice
- Contact enrichment for verified mobile and email via AccurateAppend and Enformion
- Dashboard with user management over the whole pipeline
- Scheduler driving runs, with a worker pool clearing pending jobs in parallel
- Case filtering on keywords and categories to isolate commercial contract cases
- Validation and consistency checks for data integrity
- Daily automated lead report emailed to the client at 9 AM EST