Home / Guides

Lead Tracking Spreadsheet for Small Business: A Simple Google Sheets Template (Columns, Statuses and Formulas)

Updated 2026-10-24 · AI Agent Starter Kit

Most small service businesses do not need a CRM yet. They need one place where every lead lands, a clear status for each one, and a way to see who is waiting on a reply. A Google Sheet does that well, costs nothing, and you already know how to use it.

This guide walks through the exact layout: the columns, the statuses, the formulas that answer "how fast do I reply?" and "who do I owe a follow-up today?", and how to stop typing leads in by hand.

When a spreadsheet is enough (and when it is not)

A spreadsheet works well when you get up to a few dozen leads a month, one person (you) handles them, and your sales process is "reply, quote, follow up, win or lose." That describes most solo consultants, trades, studios, bookkeepers and agencies.

It starts to strain when several people share the pipeline, you need call logging and email sync built in, or leads run into the hundreds. At that point a CRM earns its cost. Until then, a sheet keeps you honest without another subscription.

The columns

Create a new Google Sheet, name the first tab Leads, and add this header row:

Column Header What goes in it
A Received Date and time the lead arrived
B Name Person or company
C Contact Email or phone
D Source Website form, Email, Google, Referral, Directory, Other
E Service What they asked for, in their words
F Est. value Your rough job value, a number only
G Status One of the six statuses below
H First reply Date and time you first replied
I Minutes to reply Formula
J Next follow-up The date of your next planned touch
K Due Formula
L Notes Anything worth remembering

Then freeze the header (View, Freeze, 1 row) so it stays visible as the list grows.

Two shortcuts make manual entry quick. In Google Sheets, Ctrl + ; inserts today's date, and Ctrl + Alt + Shift + ; inserts the date and time (on a Mac, Cmd + ; and Cmd + Option + Shift + ;). Use the date-and-time version for columns A and H, because response time is measured in minutes, not days.

Six statuses are enough

Select column G, then choose Insert, Dropdown, and add these options:

  1. New: arrived, no reply yet
  2. Replied: first reply sent, waiting on them
  3. Quoted: price or proposal sent
  4. Won: they said yes
  5. Lost: they said no, went elsewhere, or never answered after your last follow-up
  6. Not a fit: wrong service, area or budget

Resist adding more. Every extra status is one more decision each time you update the sheet, and the sheet only works if you keep it current. "Lost" covers "went quiet after the Day 10 follow-up" too. That keeps your close rate honest.

The formulas

Minutes to first reply (column I)

In I2:

=IF(OR(A2="",H2=""),"",ROUND((H2-A2)*1440))

Sheets stores dates as days, so multiplying the difference by 1440 converts it to minutes. Copy the formula down the column.

Follow-up due flag (column K)

In K2:

=IF(AND(J2<>"",J2<=TODAY(),G2<>"Won",G2<>"Lost",G2<>"Not a fit"),"DUE","")

Any open lead whose follow-up date is today or earlier shows DUE. To make it impossible to miss, select the whole data range, open Format, Conditional formatting, choose "Custom formula is", enter =$K2="DUE", and pick a bold fill color. The full row lights up.

The summary tab

Add a second tab called Summary with these cells:

Label Formula
Leads this month =COUNTIFS(Leads!A:A,">="&(EOMONTH(TODAY(),-1)+1))
Still waiting on first reply =COUNTIF(Leads!G:G,"New")
Median minutes to reply =MEDIAN(Leads!I2:I)
Follow-ups due =COUNTIF(Leads!K:K,"DUE")
Open quote value =SUMIFS(Leads!F:F,Leads!G:G,"Quoted")
Close rate =IFERROR(COUNTIF(Leads!G:G,"Won")/(COUNTIF(Leads!G:G,"Won")+COUNTIF(Leads!G:G,"Lost")),"")

A few notes on why these and not others:

If you want to see what your reply time might be costing you, plug your numbers into the free lead response time calculator. For a full weekly scorecard that pulls these numbers together with your inbox and calendar, see the small business KPI dashboard in Google Sheets.

A 5-minute daily routine

The sheet only helps if you look at it. Once a day, ideally first thing:

  1. Sort or filter by Status = New. Reply to anything waiting. Fill in column H.
  2. Look for DUE rows. Send the follow-up, then set the next date in column J. If you need wording, the lead follow-up email templates give you a Day 2, Day 5 and Day 10 message.
  3. Update anything that changed. A quote went out, someone said yes, someone said no.

Once a week, glance at the Summary tab. If the median reply time is creeping up, that is usually the first sign you are too busy to catch new work, and it is worth fixing before it costs you jobs.

The weak spot: typing leads in by hand

Every manual tracker has the same failure. On a busy day, a lead comes in, you reply from your phone, and it never makes it into the sheet. A week later the sheet says you have no open leads, and you have no idea who you forgot.

The fix is to have leads write themselves into the sheet:

Two details matter once rows are added automatically. Dedupe: the same person filling out your form twice should update one row, not create two. Timestamps: record the received time from the form or email itself, so your reply-time numbers stay accurate.

Go one step further: draft the reply too

Once every lead lands in the sheet automatically, the natural next step is to have the first reply ready when you look. That is the idea behind speed-to-lead for solo businesses: the lead arrives, an AI drafts a personal reply using their own words, and you review and send it from your phone in under a minute.

The important part is that it stays a draft. An automated reply that guesses a price or gets a name wrong does more harm than a reply that took an hour.

Skip the build

The Speed-to-Lead Follow-Up Kit is a ready-made n8n workflow built around exactly this kind of sheet. It catches leads from your website form and your Gmail, removes duplicates, logs every lead to a Google Sheet pipeline with timestamps and status, drafts a personal first reply within about 5 minutes, and prepares Day 2, Day 5 and Day 10 follow-up drafts that stop the moment the lead replies. It includes the sheet template, the prompts and a 30-minute setup guide. Nothing is ever sent without you. Get the kit

If your inbox is as busy as your lead flow, the Inbox + Leads Starter Pair adds the Inbox Chief of Staff Kit, which sorts every email and drafts replies for the rest of your mail.

Ready-made n8n kit

Speed-to-Lead Follow-Up Kit

A personal first-reply draft within 5 minutes of every new lead, plus Day 2/5/10 follow-ups that stop when they answer.

Get the kit ($29)
Bundle: best value

Inbox + Leads Starter Pair

Inbox Chief of Staff plus Speed-to-Lead, for inbox triage and lead follow-up together.

Get the bundle ($45)
Free weekly email

One tested AI workflow a week

Short, practical n8n and Gmail automations for one-person businesses. Drafts-only, human-in-the-loop, no hype. Unsubscribe anytime.

Subscribe free

More guides