Stop Losing Leads: Automate Follow-Up With Gmail and Sheets

Someone Enquired About Your Business Three Days Ago. Have You Replied Yet?

A lead comes in through your website form. It lands in Gmail. You glance at it between jobs, meetings, or calls, and think "I'll reply properly tonight."

Tonight becomes tomorrow. Tomorrow becomes the weekend. By Monday, fifteen other emails have buried it.

The lead did not go cold because you did not care. It went cold because nothing forced you to act on it in time.

Automation fixes exactly this - without forcing you into a CRM you will never fully set up.

Free Lead Workflow Review → Get a custom automation plan within 48 hours.

Book your free review

The Problem

Speed matters more than most small business owners realise.

Companies that respond to a lead within five minutes are roughly 21 times more likely to qualify that lead than those who wait even 30 minutes. Yet the average business takes around 47 hours to reply to an inbound enquiry, and more than half take five days or longer. Some studies suggest that well over half of leads never get a response at all.

For a small business owner juggling delivery, admin, and sales in the same day, this is not a discipline problem. It is a systems problem.

A typical manual process looks like this:

1. Lead submits a form or emails you directly.
2. Email sits in your inbox with everything else.
3. You reply when you get a spare five minutes - sometimes same day, sometimes three days later.
4. No reply from the lead. You mean to follow up but forget.
5. A week passes. You vaguely remember the lead but cannot find the email.
6. Lead has since booked with a competitor who replied faster.

The After-Hours Gap

Enquiries do not stop at 5pm. A lead who messages you at 8pm on a Tuesday is comparing you against every competitor who responds before they go to bed. Whoever replies first usually wins the job.

No System to Track Who Needs a Follow-Up

Without a CRM, leads live in your inbox as unread messages, sent replies, and mental notes. There is no single view of who has been contacted, who has gone quiet, and who needs a nudge.

Inconsistent Second and Third Touches

The first reply usually happens. The second and third rarely do. Most sales are lost not on the first contact, but on the follow-up nobody got around to.

Solution Overview

A lead follow-up automation watches your inbox, logs every enquiry, and runs a timed sequence of replies until the lead responds or you mark them won or lost.

It can:

• Detect new leads landing in Gmail or a web form
• Log each lead automatically into a Google Sheet
• Send an instant acknowledgement reply
• Schedule follow-up emails on Day 2, Day 5, and Day 10
• Draft personalised messages using AI, based on what the lead asked
• Stop the sequence the moment the lead replies
• Flag stale leads for you to review manually

You keep working. The system makes sure no enquiry sits untouched for more than a day.

It works with the tools most Australian small businesses already have.

Email and Storage

• Gmail
• Google Sheets
• Google Drive

Automation Platforms

• Zapier
• Make
• n8n

AI

• OpenAI API (personalised reply drafting)

Optional Add-Ons

• Google Calendar (auto-booking follow-up calls)
• Twilio (SMS escalation for hot leads)

For most Australian small businesses, Gmail, Google Sheets, and Make cover the whole build.

Example Workflow

Chloe runs a small interior design studio in Melbourne. Her average project value is $9,500.

Enquiries come through a contact form that emails straight into her Gmail. Before automation, she replied to most within a day or two - but follow-ups on quiet leads almost never happened.

Day 0 - Lead Arrives

A prospective client, Ben, submits an enquiry about a kitchen renovation. The automation logs Ben's details into Chloe's Google Sheet and sends an instant reply within two minutes.

Hi Ben,

Thanks for reaching out about your kitchen renovation. I'd love to hear more about what you're picturing.

I'll follow up personally within the next day, but in the meantime, feel free to reply with any photos or inspiration you have.

Talk soon, Chloe

Day 2 - No Reply From Ben

Chloe replied personally on Day 1 with a quote outline, but Ben has gone quiet. The automation drafts a follow-up:

Hi Ben,

Just checking in on the kitchen renovation quote I sent through. No pressure at all - happy to answer any questions or adjust the scope if needed.

Let me know if you'd like to lock in a time to chat.

Chloe

Day 5 - Ben Replies

Ben responds, apologises for the delay, and books a consultation. The automation detects the reply, moves Ben's row to "In Conversation," and stops the sequence.

That quarter, Chloe recovered three leads that would have otherwise gone quiet - worth $28,500 in new project value - simply because nobody had to remember to follow up.

How Long Does It Take?

Phase	Duration
Discovery call	30–60 min
Solution design	2–5 days
Build and test	1–2 weeks
Handover and training	1 hour

No changes to how your team currently works during the build. You keep using Gmail exactly as you do now. Full documentation is handed over so you always know what the system is doing.

No black boxes. You should understand every step the system takes on your behalf.

Estimated Costs

Starter

Item	Cost (AUD)
Google Workspace (already using)	$0 additional
Zapier or Make	Free – $30/month
OpenAI usage (reply drafting)	$5 – $15/month
Total	~$5 – $45/month

Growth

Item	Cost (AUD)
Automation platform (higher lead volume)	$30 – $100/month
Lightweight CRM layer (e.g. Streak)	$15 – $50/month
OpenAI usage	$15 – $50/month
SMS escalation (Twilio, optional)	$5 – $20/month
Total	~$65 – $220/month

These are estimated software costs only. Actual costs vary depending on volume and platforms already in use. Implementation costs are quoted separately.

If your average job value is $9,500 and this system helps you convert just one additional lead per month that would otherwise have gone cold, the automation pays for itself many times over.

FAQ

Do I need a CRM for this to work?

No. The system runs on Gmail and Google Sheets, which most small businesses already use. A CRM can be added later if you outgrow the spreadsheet.

Can I approve messages before they send?

Yes. You can set the system to draft replies for your review, or let routine follow-ups send automatically while flagging anything unusual for a human check.

Does it work with Gmail specifically, or only Google Workspace accounts?

It works with both personal Gmail and Google Workspace business accounts. Web form leads and forwarded enquiries are both supported.

What if my sales process doesn't follow a neat sequence?

The sequence adapts to your process, not the other way round. Branching logic can handle different lead types, sources, or urgency levels.

What happens if a lead replies mid-sequence?

The automation checks for a reply before sending each follow-up. If the lead has responded, the sequence stops immediately - no double messaging.

Can this escalate to SMS for urgent leads?

Yes, as an optional add-on. High-value or time-sensitive leads can trigger an SMS via Twilio if email goes unanswered.

Who Is This For?

This is useful if you are a:

• Sole trader or small business owner fielding your own enquiries
• Consultant, agency owner, or freelancer relying on Gmail as your inbox and CRM
• Real estate agent, designer, or trades business getting leads through a website form
• Small team without the time or budget for a full CRM rollout

If lead follow-up depends on someone remembering to check their inbox, this system is probably relevant.

Request a Free Process Review

Describe your problem. We'll tell you how to fix it - free.

You will receive:

• Current workflow assessment
• Automation opportunities
• Estimated software costs
• Suggested technology stack
• Recommended implementation approach

Get your free solution proposal