You can automate lead follow-up by logging new leads in a Google Sheet, then using n8n or Make.com to check the sheet daily and send the next email in a pre-written sequence based on how many days since the lead was added. The workflow stops automatically when a lead is marked "Converted" or "Unsubscribed."
Most small businesses lose 80% of potential customers not through bad products — but through inconsistent follow-up. Research consistently shows that 80% of sales require 5 or more follow-up contacts, yet 44% of salespeople give up after just one attempt. An automated sequence closes this gap permanently.
This guide shows you how to build a 5-email lead follow-up sequence that runs automatically using free tools: n8n or Make.com, Google Sheets, and Gmail.
What makes a good lead follow-up sequence?
The best automated follow-up sequences share three characteristics:
- Relevance: Each email provides value, not just "following up" noise. Value can be a tip, a case study, a comparison, or a free resource.
- Correct timing: Immediate on Day 1 (while interest is highest), then spaced further apart over 2 weeks. Too frequent = unsubscribes. Too infrequent = forgotten.
- A clear stop condition: The sequence must stop when someone converts or asks to stop. Sending Email 4 to someone who already bought is a conversion killer.
What does a 5-email lead follow-up sequence look like?
Email 1 — Welcome + what to expect
Goal: Establish trust, confirm they made a good decision reaching out. Content: Thank them for getting in touch, briefly explain what you do, set expectations for next steps, and ask one qualifying question. This is your highest-open email — most people read it within minutes.
Email 2 — Useful content / education
Goal: Demonstrate expertise and keep your name top of mind. Content: A short tip, how-to insight, or common mistake relevant to what the lead is trying to solve. No hard sell. This email builds authority and goodwill. Soft CTA: "If you're ready to explore, reply to this email."
Email 3 — Social proof / case study
Goal: Reduce risk and build confidence. Content: A short story from a similar customer — what their problem was, what you did, and what changed. 100–150 words maximum. If you don't have a case study, a specific result quote works. This email often triggers replies from hesitant leads.
Email 4 — Direct offer / CTA
Goal: Convert. Content: Clear, direct, one specific offer. No hedging. "Here's how to work with us: [link / reply / book a call]." Explain what they get and what it costs. This is your conversion email — everything before it was warming up to this moment.
Email 5 — Final follow-up / breakup
Goal: Trigger a response from undecided leads. Content: Short, personal, honest. "I don't want to keep filling your inbox — is this still something you're interested in? If not, just reply 'not right now' and I'll stop." Breakup emails consistently get the highest reply rates in the entire sequence — often 2–4× the previous email.
How do you build the lead follow-up automation — step by step?
Create your lead tracking spreadsheet
Create a Google Sheet with these columns: Lead Name, Email, Source, Date Added, Sequence Step, Status, Last Email Date, Notes.
The Sequence Step column tracks which email they last received (0 = none, 1 = Email 1, 2 = Email 2, etc.). The Status column has three values: Active, Converted, Unsubscribed. New leads start as Active with Sequence Step = 0.
Write all five emails before building the workflow
Write your 5 email drafts in a document first. Building the workflow without copy is slower — you end up writing and testing at the same time. Each email should be: concise (100–200 words maximum), personalised with the lead's first name, and end with one clear action (not several options).
Set up the workflow logic in n8n or Make.com
The workflow runs on a schedule (daily, at 9am). It reads the Google Sheet and for each row where Status = Active, calculates how many days have passed since Date Added. If the days match the next email's send day (Day 1, 3, 6, 10, or 14) and Sequence Step is one behind — send that email and increment the Sequence Step counter.
In n8n: Schedule Trigger → Google Sheets (Read All) → Filter node (Status = Active) → Function node (calculate days elapsed) → Switch node (route by step) → Gmail nodes (one per email) → Google Sheets (Update row).
Add stopping rules
Before each Gmail node, add a check: if Status ≠ Active, skip. This prevents emails from being sent after a lead has converted or unsubscribed. To mark a lead converted manually: change their Status cell to "Converted." To handle unsubscribe requests from email replies, update Status to "Unsubscribed" when they reply asking to stop.
Test with yourself as a lead
Add your own name and email to the sheet as a new lead, Status = Active, Sequence Step = 0, Date Added = today. Manually trigger the workflow. Email 1 should send within seconds. Advance the Date Added backward by 2 days and re-run — Email 2 should send. Verify each email sends correctly and updates the Sequence Step. Then activate the daily schedule.
How do you automatically add leads from a contact form?
Connect your lead capture form directly to the Google Sheet to make the process fully hands-off:
| Form Tool | How to Connect | Automation Needed |
|---|---|---|
| Typeform | Use Typeform's Google Sheets integration (built-in) | None — maps directly to sheet |
| JotForm | JotForm → Google Sheets integration in Integrations tab | None |
| Tally | Tally → Google Sheets integration in form settings | None |
| WordPress / contact form | Use n8n or Make.com webhook trigger from the form plugin | Simple workflow to map fields |
| Any HTML form | Submit to a Make.com or n8n webhook endpoint | Webhook receiver → Sheets append |
When a new submission comes in, the form automatically adds a row to your sheet with Name, Email, Date, Source, Status = Active, and Sequence Step = 0. The next time the daily follow-up workflow runs, it picks up the new lead and sends Email 1.
What email metrics should you track?
Add these calculated columns to your Google Sheet to measure performance over time:
- Emails sent (total): Count of rows where Sequence Step ≥ 1
- Conversion rate: Converted ÷ Total leads × 100
- At which step did they convert: Compare Sequence Step at time of conversion across leads
- Unsubscribe rate: Unsubscribed ÷ Total leads × 100 (aim to keep below 2%)
Key insight: Most conversions happen at Email 1 (immediate interest) and Email 5 (breakup triggers a decision). Email 4 (the direct offer) converts the second-highest group. If you find Email 4 is underperforming, the issue is usually with the offer itself — price, clarity, or trust — not the sequence structure.
Should you use a CRM or Google Sheets for this?
For most small businesses handling under 200 leads per month, Google Sheets is perfectly sufficient — it's free, flexible, and integrates natively with n8n and Make.com with no extra configuration.
Upgrade to a CRM when you need: pipeline stage tracking, multiple team members logging calls and notes, two-way email sync (seeing replies in the CRM), or advanced reporting. HubSpot CRM Free and Zoho CRM Free are the best starting points — both have n8n and Make.com integrations.
Lead Follow-Up Automation Template — Coming Soon
We're building a plug-and-play Lead Follow-Up Automation template — complete workflow JSON for n8n and Make.com, all 5 email templates, Google Sheets tracker, and setup guide. One-time purchase, runs forever.
In the meantime, check out our live automation templates: