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
- 0-100
- Contact sources
- Skip-trace
- Output
- Excel + CRM + Email
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