Here's a workflow that handles the full inbound lead lifecycle without any manual intervention.Github code link in the body
Here's a workflow that handles the full inbound lead lifecycle without any manual intervention.
What it does:
- Form submission triggers validation and data normalization
- Hunter.io verifies the email (checks if it's valid, disposable, or webmail)
- A scoring algorithm assigns a lead tier — HOT, WARM, or COLD — based on email quality, company size, and industry
- Contact and deal are automatically upserted into HubSpot with the correct pipeline stage and deal value
- HOT/WARM leads fire instant alerts via Slack and Gmail
- All data streams into a Power BI real-time dashboard
There's also a second workflow on an hourly schedule that syncs updated HubSpot contacts and deals back into Power BI so the dashboard never goes stale.
Scoring breakdown:
- Valid email via Hunter → +20 pts
- Business (non-webmail) email → +15 pts
- Company size (enterprise/1000+) → +25 pts
- High-value industry (SaaS, fintech, healthcare, etc.) → +15 pts
- 70+ = HOT, 45–69 = WARM, below = COLD
Workflow JSON and full breakdown on GitHub: https://github.com/kevorklepedjian1/n8n-powerbi
Happy to answer questions about the scoring logic or the Power BI streaming dataset setup that part had some quirks worth discussing.