Aesthetic Clinics Prospecting Pipeline
Names, phones, verified emails, owner names, and ad sophistication buckets for med spas across four states, all in one Google Sheet.
The problem
"Manual prospecting for med spa outreach was eating a full day per city. We needed clinic name, website, verified owner email, and some read on how sophisticated their marketing already was, all without touching a single site by hand."
The solution
One flow. Every input type.
The workflow builds every state, city, and search-term combination up front (four states, ten cities each, five search terms), then batches through Google Places Text Search with a strict field mask so only the fields we need come back. Results are flattened, deduped by place_id, and filtered for a working website and at least three reviews. Each qualified website is scraped, its HTML stripped to ~8k characters, and Claude Haiku 4.5 extracts owner or medical director info as structured JSON. The domain is derived from the site URL and paired with the extracted name for a Findymail verified-email lookup. A parallel Meta Ad Library call (behind a feature flag until the developer account is approved) scores ad sophistication on a 0 to 10 ladder from active ads, average days running, total ads in 90 days, and platform count. Everything appends to a Google Sheet ready for outbound.
Results
Industry
B2B Sales / Med Spa Vertical
Service type
Client Automation
Timeline
2 weeks
Tools used