owen_folio

Apollo → HubSpot Lead Handoff Automation

🎯 VIEW LIVE DASHBOARD ← Click to see interactive lead pipeline

Built for Voxitech (Sri Lankan AI startup) to automatically sync qualified leads from Apollo cold outreach into HubSpot CRM.

The Problem

Voxitech was running cold outreach via Apollo.io to break into the US market, but:

Result: Lost deals because we were too slow to follow up.

The Solution

Python script that automatically:

  1. ✅ Fetches leads who replied to Apollo sequences
  2. ✅ Scores lead quality (0-100) based on:
    • Company size (ideal: 50-500 employees)
    • Funding stage (prefer Series A-C)
    • Tech stack match (uses AI/ML tools)
    • Response sentiment (positive = higher score)
  3. ✅ Auto-creates HubSpot contacts for qualified leads (score ≥40)
  4. ✅ Sets lead status: “QUALIFIED” (≥70) or “UNQUALIFIED” (40-69)

Results

Interactive Demo

→ Open the dashboard to see:

Note: Dashboard uses ABC Company mock data for demonstration. Lead scoring algorithm is production-ready.

How to Use

# Install dependencies
pip install requests

# Add your API keys
# Edit sync_leads.py and replace:
# APOLLO_API_KEY = "your_key_here"
# HUBSPOT_API_KEY = "your_key_here"

# Run sync (can be automated via cron)
python sync_leads.py

Lead Scoring Logic

Criteria Points Notes
Base score 50 Everyone starts here
Company size (50-500) +20 Sweet spot for mid-market
Funding (Series A-C) +15 Has budget, not too corporate
Tech stack (AI/ML) +15 Already using relevant tools
Positive reply +10 “Interested” > “Maybe later”

Total possible: 100 points

Automation Options

Option 1: Cron job (Mac/Linux)

# Run every hour
0 * * * * cd /path/to/apollo-hubspot-handoff && python sync_leads.py

Option 2: Zapier webhook

Tech Stack


Built by Owen McCormick LinkedIn Full Portfolio