The Automation Flow
- Reads existing leads from Google Sheets on a schedule
- Router sorts each lead into 3 paths
- Has website: ChatGPT writes a site-referencing email
- No website: ChatGPT writes a different angle
- Missing email: Apify scrapes to recover it
- Gmail sends every outreach automatically
- Google Sheets row updated with outreach status
Ideal For
Tools Used
About This Automation
This automation reads your existing leads from Google Sheets on a schedule and intelligently routes each lead through a 3-path router: leads with a website get one version of the AI-personalised email that references their online presence; leads without a website get a different angle; and leads with a missing email are sent through Apify to scrape and recover the email before updating the sheet. Every outreach is sent via Gmail and every row is updated with its new status — no manual work required.
What We Set Up
- Ready-to-import automation workflow file
- Step-by-step setup guide (PDF)
- Google Sheets leads tracker template (with required column headers)
- Two ChatGPT prompt templates (with website / without website)
- Apify actor configuration for email recovery
Common Questions
Form submission → instant WhatsApp reply → CRM entry → team notification.
View →Plan content in Notion → auto-post to Instagram, Facebook, and LinkedIn.
View →New lead → 5-email sequence over 7 days → CRM updated at each step → Slack alert on reply.
View →Want Lead Outreach from Pre-existing Data for your business?
We build and install this for you as part of our automation plans, from $249. Typically live within 72 hours of kickoff on Starter, once we have your content.