Bad Lead Filter Automation

Automatically clean up your CRM database by filtering invalid, duplicate, and inactive leads

Runs Daily at 2:00 AM

Workflow Flowchart

Daily 2AM Trigger

Extract All Leads

Validate Email Addresses

Check for Duplicates

Verify Company Status

Quality Check

Fails 2+ checks

Move to Bad Leads

Passes

Keep in Active DB

Generate Report

Send Team Notification

Process Complete

How It Works

Extract Leads

Pulls all contacts from your HubSpot CRM via API

Validate Emails

Checks each email with ZeroBounce for deliverability

Find Duplicates

Identifies duplicate entries by email and phone number

Verify Companies

Checks if company domains are still active

Clean & Report

Moves bad leads to a separate list and sends a summary

Configure Your Automation

Before You Start

1. HubSpot account with API access - Get your private app token
2. ZeroBounce account for email validation - Get your API key
3. Slack webhook URL (optional) - Create incoming webhook

HubSpot API Key ?

Found in HubSpot Settings > Integrations > Private Apps

ZeroBounce API Key ?

Get it from ZeroBounce dashboard

Slack Webhook URL ?

Leave empty to skip Slack notifications

Bad Leads List ID ?

Create a static list in HubSpot and copy its ID from the URL

Failure Threshold ?

Lead fails 2+ checks = marked as bad (1-3 recommended)

Notification Email ?

Where to send the daily cleanup report

Run Mode

Dry Run Mode

Preview changes without actually moving leads

🔒

We don't store any of your data. Everything you enter stays in your browser and the generated script runs locally on your machine.

Your Automation Code

bad-lead-filter.py