A lead generation Google Sheet template you can build in an hour

    · 7 min read

    A lead generation Google Sheet template is the cheapest lead system you can run, and for a small team it's often the right one. The problem is that most downloadable versions are built for show: twenty-six columns, a dashboard tab, colour-coded everything. They look great on the landing page and then nobody fills them in.

    This one is built for leads that come to you, from a form, a lead magnet, a booking link or an enquiry email. If you're chasing people you found yourself, that's a different sheet, and I've covered it in my prospect tracker template. Here we're dealing with the pile that arrives on its own and needs sorting before it goes cold.

    Three tabs, not one giant sheet

    Everything goes wrong when capture, working and reporting live on the same tab. So split them.

    Inbox is where raw leads land. Nobody edits it by hand. If you use Google Forms, linking the form to a sheet creates a responses tab for you, and that tab is your Inbox. If you capture leads somewhere else, a paste or a Zapier-style connector can drop rows into the same place.

    Pipeline is where you work. One row per lead, cleaned, with a status and a next action. This is the only tab you open daily.

    Review is a small summary: leads this week by source, how many were contacted, how many went anywhere. Five cells, not a dashboard.

    Why bother splitting? Because raw form data is messy, and the moment you start typing into it you break the link between what came in and what you did about it. Keep the raw record untouched and you can always check what the lead actually said.

    The columns that earn their place on the Pipeline tab

    ColumnWhat goes in it
    Date inWhen the lead arrived, pulled from the Inbox timestamp.
    Name and emailOne row per person. Email is your unique key.
    CompanyBlank is fine for consumers, vital for B2B.
    SourceWhich form, magnet, page or campaign brought them in.
    FitA, B or C, set by you in ten seconds. Dropdown only.
    StatusNew, Contacted, Replied, Booked, Won, Lost, Parked. Dropdown only.
    Next actionA verb and an object, with a date next to it.
    Next action dateA real date. Never blank.
    NotesNewest first.

    Nine columns. If you want a tenth, make it earn the place by naming the decision it changes.

    Two of them do the heavy lifting, same as in any tracker. Source tells you which of your lead sources produces people who reply, which is the whole point of measuring lead generation. And next action date turns a list into a to-do list. Sort ascending and the top of the sheet is your morning.

    Formulas that save you from yourself

    You don't need much formula work. A few things are worth the ten minutes.

    Dropdowns for Fit and Status. Use data validation with a list. Free-text statuses turn into "Contacted", "contacted", "Contacted?" and "tried them" inside a fortnight, and then none of your counts work.

    Duplicate flagging. Add a helper column with =COUNTIF(B:B, B2) > 1 against the email column and colour any TRUE row with conditional formatting. Leads submit forms twice. They also arrive from two sources. You want to know before you email the same person twice.

    Overdue highlighting. Conditional formatting on the next action date column, with the custom formula =AND($H2<>"", $H2, turns overdue rows red. A red row is a broken promise to a real person, and it stings enough to get fixed.

    Source counts on the Review tab. One COUNTIFS per source and status gets you "leads in" and "leads contacted" without building a pivot table. If you want a unique list of sources, =UNIQUE(D2:D) builds it for you.

    Pulling from the Inbox. If you'd rather not copy and paste, =IMPORTRANGE or a simple =Inbox!B2 reference will bring rows across. I'd start by copying by hand for the first week, honestly. It forces you to read every lead, and reading every lead teaches you more than any formula does.

    Speed matters more than scoring

    People love adding a lead scoring formula, with points for job title, company size and email domain. I get the appeal, and I've built these. For a small team getting a few dozen leads a week, it's mostly decoration.

    A simple A, B, C fit rating you set yourself in ten seconds does the same job. The more useful number is how long a lead waits before the first reply. Add a "First reply" date column, subtract Date in from it, and look at the average once a month. If that number is days rather than hours, no formula will fix your pipeline.

    If you do get to the point where scoring is worth building properly, my post on B2B lead scoring goes through what to weigh and what to ignore.

    Where the sheet stops being enough

    A Google Sheet is genuinely better than a CRM at the start, because there's no friction between a thought and a record. It stops being better in a few predictable places.

    • Volume. Once you're past a few hundred live leads, filtering and sorting start to feel like work.
    • More than one person. Two people editing the same row, or nobody knowing who owns a lead, is where sheets break down.
    • Automation. Email sequences, reminders and routing are all things a sheet can fake and a CRM does properly.
    • History. A sheet shows the current state. It's weak on what happened and when.

    When two or three of those are true, move. Until then, I'd stay on the sheet and spend the time on follow-up instead. How to organise the pile once it grows is in organizing sales leads, and the follow-up side is in building a lead follow up system.

    What the sheet can't tell you about the download

    Here's the gap I keep running into. Your sheet records that a lead arrived and that you replied. If what you sent was a PDF, a guide, a proposal, a pricing document, the sheet has no idea whether they opened it, read it, or got past page two.

    That's the one place I'd add a tool. When I send a document to a lead, I use LiveDocument to share it as a single tracked link with a short video walkthrough on top, and the page-level analytics tell me what to say in the follow-up. It does one job, though: it's not a CRM or a lead store, so the sheet stays exactly where it is. The detail of how that tracking works is on the PDF tracking software page, and if you're deciding what to put behind a form in the first place, the lead magnet app is the place to start.

    Frequently asked questions

    Is there a free lead generation Google Sheet template?

    Building your own takes about an hour and costs nothing, and you end up with a sheet that fits how you work rather than someone else's idea of a pipeline. The tabs and columns above are the whole template. Copy them into a new sheet and you're done.

    Can I connect Google Forms to a lead generation Google Sheet?

    Yes. A Google Form can send its responses straight to a sheet, which becomes your Inbox tab. Keep that tab untouched and do your working on a separate Pipeline tab.

    How many columns should a lead tracking sheet have?

    As few as you'll actually fill in. Nine is plenty for most small teams. If a column doesn't change a decision you make, it's decoration.

    When should I move from a Google Sheet to a CRM?

    When volume, multiple owners or the need for automation start costing you more time than the sheet saves. For most small teams that's later than the CRM vendors suggest.

    If you're sending documents into that pipeline and never quite knowing what happened next, that's the problem I built LiveDocument to fix. It's at livedocument.com, and you can see how it works there.

    About the Author

    Cameron James

    Cameron is the founder of LiveDocument. He writes about sharing documents, PDFs, decks and contracts, and why pairing a video walkthrough with a document beats sending it cold.