Leads are perishable. If you don't follow up quickly and consistently, you're losing money. The problem is that manual follow-ups are inconsistent, slow, and impossible to scale.
Here's how we built a fully automated lead follow-up system that nurtures prospects, books calls, and stays active 24/7, without hiring a sales team or relying on memory.
Step 1: Capture the Lead
It all starts with a form, whether it's Typeform, Gravity Forms, or your site's native form builder. The moment a visitor submits their info, that data is sent to:
- Google Sheets as a central database
- Our CRM (Pipedrive)
- An automation trigger via Zapier or Make
Bonus tip: use hidden fields to capture UTM parameters, referrers, or source campaigns for better attribution.
Step 2: Qualify Automatically
We run the lead through a Google Apps Script connected to our sheet to calculate:
- Deal size, based on company size and selected services
- Lead score, based on behavioral and demographic factors
- Custom tags (e.g. "high urgency", "return visitor")
This score determines what kind of follow-up sequence they get.
Step 3: Trigger the Right Follow-Up Flow
Depending on the score, one of several actions happens:
- Hot leads: auto-book a Calendly call link and send an immediate Slack alert to a human rep
- Warm leads: kick off a 3-email drip via ActiveCampaign offering a case study or testimonial
- Cold leads: receive a 5-part nurture sequence over 3 weeks
All emails are dynamically personalized with the data they submitted. No human input, no manual sorting.
Step 4: Monitor and Nurture Over Time
Every few days, a script runs that checks engagement (opens and clicks), moves leads between segments, and triggers win-back campaigns for inactive leads.
We also generate a weekly report showing new leads, booked calls, and conversion percentages, emailed automatically to the sales team every Monday at 8am.
Tools We Used
- Google Sheets: lightweight CRM and data layer
- Zapier: glue between apps (form, email, CRM)
- ActiveCampaign: email automation
- Calendly: auto-scheduling
- Slack: instant alerts
- Google Apps Script: custom logic for lead scoring and routing
Results
- Response time cut from 1 day to under 2 minutes
- 3x increase in booked calls
- Zero follow-up tasks on anyone's to-do list
It's the equivalent of hiring a full-time assistant who never sleeps, except we built it once and it runs on autopilot.
We're sharing a free blueprint with setup steps, scripts, and templates in our newsletter. Subscribe to start building your own lead machine that works while you sleep.
0 comments