HVAC Lead Enrichment Pipeline

A lead enrichment pipeline that turns a raw spreadsheet of HVAC companies into contactable decision-makers.

The problem. The sales list was company names and little else. Someone had to open each one, find the owner, hunt for an email, check LinkedIn — then do it again for the next row. The list was always half-finished, and the sales team was doing research instead of selling.

What I built. A pipeline that reads the sheet and fills in the gaps: owner name, email address, LinkedIn profile and contact details, written back into the same sheet the sales team already works in. Rows that cannot be enriched are flagged rather than silently left blank, so nobody wastes time calling an empty record.

How it is built. n8n workflows calling enrichment and verification APIs, with rate limiting, retries and deduplication so the same company is not processed twice and a slow API does not stall the run. The output is validated before it is written back, which is the difference between an enriched list and a list full of guesses.