How to Build a Lead Capture System with Google Forms and Sheets
Most early-stage businesses don't need a CRM. They need a way to collect inbound interest, sort it into "real leads" and "junk," notify the right person quickly, and not lose anything. Until you have ~100 active conversations going at once, Google Forms plus Google Sheets handles that workflow as well as a $50/month tool - and arguably better, because you can shape it to your exact process.
This post walks through a full lead capture pipeline using only Google's free tools, plus one or two lightweight add-ons. By the end you'll have a setup that captures form submissions, scores them automatically, routes hot leads to Slack, and keeps a clean searchable record in Sheets.
Why not just use a CRM from day one?
CRMs are designed for teams that already have a sales process. If you don't, the CRM forces you to invent one and then constrains you to it. Pipedrive's stages, HubSpot's deal properties, Salesforce's entire ontology - they all assume you know what a "qualified lead" looks like for your business. Until you've talked to a few dozen people, you don't.
A Google Sheet is the opposite. It starts as a list and becomes a process as you learn what matters. You can add columns when you discover them, change the workflow without a migration, and export everything to a real CRM the day you outgrow it. The cost is zero.
Step 1: Design the form to ask only what you'll act on
The most common lead form mistake is asking ten questions when three would do. Every extra field reduces submission rates - HubSpot's research consistently shows form completion rates drop sharply past 3-4 fields. For a lead capture form, the minimum useful set is:
- Name - so you can reply naturally
- Email - your only required communication channel
- Company or context - one field that helps you tell a buyer from a student or competitor
- What they want - either a free text field ("Tell us what you're trying to do") or a short multiple choice if you have well-defined offerings
That's it. Resist adding "phone number," "company size," "budget," and "timeline" on the first form. Ask those in the reply email if they matter.
In Google Forms, mark the first three required and leave the last optional. Add a brief intro that sets expectations: "We reply within one business day." Promises like that, kept consistently, do more for conversion than any form design tweak.
Step 2: Connect the form to a Google Sheet
Every Google Form has a "Responses" tab with a green Sheets icon. Click it and create a linked spreadsheet. From that moment, every submission shows up as a new row.
Rename the columns to be friendlier than the verbatim form questions ("Email" instead of "What's your email address?"). Then add these extra columns to the right of the form data:
- Status - dropdown: New / Contacted / Qualified / Closed / Spam
- Owner - dropdown of team members
- Notes - free text for context
- Score - a formula column we'll build in step 4
Set the Status and Owner columns as data validation dropdowns so the values stay clean. Pin row 1 with View > Freeze > 1 row so headers stay visible as you scroll.
Step 3: Verify emails on submission
Roughly 8-12% of email addresses entered into web forms are invalid - typos, fake addresses, or "[email protected]" from people who don't want marketing. If you reply to those, your sender reputation takes the hit. The cleanest fix is to verify each email as it comes in.
The VerifyEmail App add-on for Sheets does this in bulk on demand, and you can run it weekly against the new rows. If you want real-time verification at submission time, you can also use Apps Script with a webhook to a verification API. For most small operations, the weekly bulk pass is enough.
Step 4: Score leads with a simple formula
Not all leads are equal, but you don't need a machine learning model to sort them. A weighted formula in the Score column works fine for early-stage businesses. The general shape is:
=IF(REGEXMATCH(LOWER(C2), "@(gmail|yahoo|hotmail|outlook)\.com$"), 0, 2)
+ IF(LEN(F2) > 50, 2, 0)
+ IF(REGEXMATCH(LOWER(F2), "enterprise|team|company|business"), 1, 0)Reading that scoring rule: 2 points for a non-free-mail domain (likely a business email), 2 points for a thoughtful answer ("what they want" longer than 50 characters), 1 point if the answer mentions team/business context. Total score 0-5.
This isn't a model of buying intent. It's a triage signal: any lead with a score of 3+ probably deserves a personalized reply same-day. Anything 0-1 can wait for the daily batch. You'll refine the weights as you learn what predicts a real conversation.
Step 5: Route hot leads to Slack instantly
Email notifications from Google Forms arrive a few minutes late and bury easily in an inbox. A Slack message is faster to see and easier to action. There are two ways to wire it up:
The native way: Use a Google Workspace add-on like Formlinker for Slack to send a formatted notification to a channel every time someone submits the form. You pick which fields to include and which channel to post to. Setup takes about three minutes.
The flexible way: Use a workflow tool like n8n to receive form submissions via webhook and only send to Slack when the score is high. See our n8n + Google Forms guide for the wiring. This costs you setup time but lets you build any conditional logic you want - send to #sales-hot for enterprise leads, #sales-warm for everything else, and skip Slack entirely for spam.
Step 6: Build a daily ops view with a single QUERY
Create a second sheet tab called "Today" with one formula in cell A1:
=QUERY(Responses!A:K, "select A, B, C, F, J where I = 'New' order by J desc", 1)That's your daily worklist: every uncontacted lead, newest and highest-scored first. You can pin it as the default tab so anyone opening the sheet sees the queue immediately. As leads are contacted, update the Status column and they fall off this view automatically.
Step 7: Archive monthly to keep the active sheet fast
Google Sheets handles tens of thousands of rows fine, but the Forms response sheet feels sluggish past ~5,000 rows in our experience. Once a month, move rows older than 90 days with status "Closed" or "Spam" to an archive tab. A keyboard shortcut (Ctrl+Shift+End to select to the bottom, then cut/paste) is faster than building any automation here.
When it's time to graduate to a real CRM
You'll know it's time when one of these is true: you have more than one salesperson and they're double-replying to leads; you need to track multi-step deal pipelines; you want call recording, email tracking, or task assignments. Until then, a Sheet is enough.
When you do migrate, the Sheet exports cleanly to any CRM's CSV importer. You haven't wasted any structure - the columns map directly to standard CRM fields.