Real Estate Lead Hunter: Automated property prospecting
n8n workflow that automates real estate prospecting (wholesalers/investors). Distressed property search via BatchData, intelligent lead scoring, skip-tracing for owner contacts, then Excel export + HubSpot push + automated email.
Lead score
Contact sources
Output
Context
Real estate wholesalers and investors look for 'distressed' properties (absentee owners, long ownership, tax delinquent) because those are the most motivated sellers. The manual work: hours on public databases, identifying the right properties, skip-tracing for email/phone, then logging everything in the CRM. Expensive to outsource to freelancers or inhuman to do solo.
The challenge
Build a fully autonomous workflow that (1) searches properties by precise criteria (location, value, equity, status), (2) applies business rules (absentee owner + 5+ years owned + no recent sales), (3) scores each lead 0-100 across multiple factors, (4) auto-retrieves contacts via skip-tracing, (5) outputs leads to Excel + HubSpot CRM + summary email, daily and hands-free.
The solution
n8n workflow with dual trigger (daily Schedule + Manual). Set node configurable with criteria (city/state, propertyType, value range, status='distressed', equity min, limit). Calls BatchData /properties/search then JS code filters (absentee, 5+ years, no recent sales) and computes a lead_score 0-100 (base 50 + equity/2 + ownership years + tax_delinquent +10). Skip Trace API for email/phone/mobile. Final formatting that structures 30+ fields (property + owner + contact + scoring). Triple parallel output: Excel (`Property_Leads_DATE.xlsx`), HubSpot CRM, and email summary (total leads + highest score).
Key features
- 01Dual trigger: daily Schedule + manual Execute button
- 02Configurable search criteria (location, type, price, equity, status)
- 03BatchData /properties/search (up to 50 properties per run)
- 04Business filtering: absentee owner + 5+ years owned + no recent sales (3 years)
- 05Lead scoring 0-100: equity (max +25) + ownership years (max +15) + tax delinquent (+10)
- 06Auto sort by descending score (best leads on top)
- 07Automatic Skip Tracing: email + phone + mobile + alternate phone
- 0830+ fields formatting: property details, owner info, contact, scoring
- 09Triple parallel output: Excel + HubSpot CRM + Email
- 10Excel auto-named with current date (Property_Leads_YYYY-MM-DD.xlsx)
- 11Email summary report: total leads + highest score + execution date