Franchise Lead Intelligence Pipeline
Built for a franchise consulting firm
Overview
An automated lead intelligence pipeline for a franchise consulting firm. Scrapes Bing News, Franchise Times, and PR Newswire for franchise expansion signals. GPT-4o-mini extracts structured owner information (name, title, company, location, open date). Includes 3-layer date validation, LinkedIn profile URL lookup, SQLite dedup database, and Apollo-compatible CSV export. Auto-scheduled monthly via macOS launchd with email delivery.
The Problem
The franchise consulting firm needed a steady stream of expansion-ready prospects but had no scalable way to find franchise owners planning new locations.
My Approach
Built a Python scraper using Playwright and BeautifulSoup to pull franchise news. GPT-4o-mini extracts structured lead data. 3-layer date validation (LLM + regex + post-filter) ensures freshness. LinkedIn lookup enriches profiles. SQLite prevents duplicates. Claude drafts 4-message LinkedIn outreach sequences per lead over 14 days. Human-in-the-loop for actual sending (TOS compliance).