MCA Court Case Automation
Overview
A Python automation that identifies and processes Merchant Cash Advance (MCA) cases from public court databases. The system filters for relevant cases, enriches them with verified business contacts, and delivers daily lead reports by email. Outcome: Delivered a hands-off lead generation pipeline producing verified MCA business leads daily at 9 AM EST.
Architecture & Pipeline
flowchart LR
n0["Daily Scheduler9 AM EST"]
n1["Public Court DatabasesSource records"]
n2["MCA FilterCase classification"]
n3["Contact EnrichmentPeople-search APIs"]
n4["Excel ReportLead summary"]
n5["Email DeliverySMTP"]
n0 --> n1
n1 --> n2
n2 --> n3
n3 --> n4
n4 --> n5
classDef step0 fill:#f1f5f9,stroke:#64748b,color:#1e293b,stroke-width:2px,rx:10,ry:10;
classDef step1 fill:#ecfeff,stroke:#06b6d4,color:#1e293b,stroke-width:2px,rx:10,ry:10;
classDef step2 fill:#f0fdfa,stroke:#0d9488,color:#1e293b,stroke-width:2px,rx:10,ry:10;
classDef step3 fill:#ecfdf5,stroke:#10b981,color:#1e293b,stroke-width:2px,rx:10,ry:10;
classDef step4 fill:#fffbeb,stroke:#f59e0b,color:#1e293b,stroke-width:2px,rx:10,ry:10;
class n0 step0;
class n1 step1;
class n2 step2;
class n3 step2;
class n4 step3;
class n5 step4;
End-to-end flow derived from this project's scope and tech stack. Tap View Fullscreen for a larger view, or scroll horizontally on small screens.
Key Features
- Automated court case extraction with MCA-specific filtering
- People-search API integration for contact enrichment
- Daily scheduled runs on a server (9 AM EST)
- Excel email reports with built-in error handling
- Tech Stack:** Python, Requests, Pandas, SMTP