Automated lead capture funnel for coaching business

Most coaching businesses handle leads the same way. Someone fills out a form, the owner gets an email, the owner manually replies (maybe the same day, maybe a week later), and hopefully books a call. It works until it does not, and then leads quietly disappear.

OliviaGRE is a GRE tutoring business run by Olivia, a tutor who helps students prepare for graduate school admissions. GRE prep is a competitive, high-intent market. Students are actively searching for help, they have a deadline, and they will book with whoever responds first. That made the lead response problem especially expensive to ignore.

I built an automated funnel that handles everything from first contact to paid booking without anyone doing anything manually. Here is how it works and the numbers from about six months of it running.

40
New leads / week
75%
Email open rate
$0
Manual follow-up

How the funnel actually works

Most of the traffic comes from YouTube, where Olivia posts GRE vocabulary and strategy content. Someone watches a video, clicks through to the site, and lands on a homepage with a chatbot and a free lead magnet (a GRE study plan PDF). That lead magnet is where most email addresses come from.

1
Lead magnet captures the email
Visitors can download a free GRE study plan by entering their email. The chatbot on the homepage also offers it mid-conversation. Both paths feed the same system. One thing that took a while to get right: the chatbot originally directed people to a separate page to fill a form. That page had no form on it. Leads were falling through for months. The fix was keeping the email capture inside the chat itself rather than bouncing visitors elsewhere.
2
Email sequence delivers value and redirects to tutoring
The moment someone submits their email, an automated 5-email sequence kicks off. It delivers the study plan and GRE resources, then in later emails points toward the tutoring page. Open rate across 294 sends to date is 75.2% with a 63.9% click rate. That is high because the sequence delivers something the subscriber actually wanted, rather than being a thinly disguised sales pitch.
3
Tutoring page has its own interest form
The tutoring landing page has a short inquiry form where prospective students describe their situation and GRE goals. A lot of people fill this out directly without going through the lead magnet first. The form submission is what triggers the calendar booking step and logs the lead into the CRM.
4
Free trial call gets booked automatically
After submitting the interest form, prospects are directed to book a free 30-minute trial lesson via the calendar tool. A background sync tracks whether they actually showed up, marks no-shows automatically if no Zoom recording appears within a few hours of the scheduled slot, and logs the outcome. No manual checking.
5
Payments sync to the CRM
When a student purchases a tutoring package through Stripe, the payment is automatically written back to the CRM with the package type, amount, and customer details. Lifetime revenue across 7 paying customers as of May 2026 was $1,720. Every charge is attributed to the original lead source, so you can see which channel (YouTube, email, direct) produced the paying student.

What this replaced

Before this system, the workflow was manual at every step. Check email, find the inquiry, reply, send a calendar link, chase people who did not book, note whether they showed up, log payments by hand. Probably 3 to 4 hours a week at modest volume.

The bigger problem was not the time. It was the inconsistency. A lead that arrived on a Saturday afternoon might wait until Monday for a reply. By then the student had booked with someone else.

The most useful thing this system does is not save time. It removes the dependency on the owner's availability. A lead at 2am on a Sunday gets the same response as one on a Tuesday afternoon.

What it costs to build and run

The tool costs at this volume are essentially zero. Netlify, Google Sheets, MailerLite, and the calendar tool all have free tiers that cover a business doing under a thousand leads per month. Stripe takes a percentage of transactions only when money moves.

The build took a few weeks of part-time work over a couple of months. The trickiest part was not any individual piece but making everything talk to each other reliably and tracking which channel each lead came from. Attribution sounds straightforward and is not.

What does not work automatically

The system cannot close. Once someone books a trial lesson, the quality of that session determines whether they buy a package. A great call converts. A weak one does not. The CRM tracks the outcome but has no influence over it.

The longer nurture sequence (29 emails for subscribers who do not book quickly) has a 43.6% open rate but only a 2.2% click rate. People are reading but not acting. That is an email content problem. The calls to action in those emails are not compelling enough. Fixing that is human work.

Tools in this stack
  • Netlify serverless functions (no server to maintain)
  • Google Sheets as the CRM (flexible, free, accessible to the whole team)
  • MailerLite for email sequences
  • Cal.com for bookings and no-show tracking
  • Stripe for payments
  • Custom chatbot built on the Claude API

Frequently asked questions

How much does it cost to build an automated lead funnel for a coaching business?
At small scale, tool costs are near zero. Netlify, Google Sheets, MailerLite, and Cal.com all have free tiers that cover a coaching business doing under 1,000 leads per month. The cost is build time. A system like this takes 3 to 6 weeks of part-time work depending on complexity.
What is a realistic email open rate for an automated coaching sequence?
The OliviaGRE starter kit automation averages 75.2% open rate. That is unusually high. The reason is probably that subscribers opted in for a specific resource (the GRE study plan) and the first email delivers that resource immediately. Sequences tied to a specific lead magnet consistently outperform generic newsletters by a wide margin.
Does a chatbot convert better than a contact form?
In this case, yes. The main reason is that the chatbot captures the email inside the conversation. Sending visitors to a separate page adds friction and gives them more reasons to leave. Keeping the email field inside the chat session noticeably improved capture rate.

Want a lead funnel like this for your business?

I build these systems for service businesses and coaches. Book a free call to see what makes sense for your setup.

Book a Free Call →
Back to Resources