A two-person carpentry shop keeps its leads in four places: the owner's text messages, her partner's email, the shop's Facebook inbox and a notebook that lives on the truck's dashboard. On a Wednesday a homeowner calls, polite but cool: “You said you'd send the pergola quote last week.”
Each partner thought the other had it. Nobody can find the photos the homeowner sent. The quote goes out that night, and the homeowner signs with someone else on Friday.
The usual reaction is to shop for a CRM. Sometimes that's right. More often the problem isn't the lack of software; it's that leads have no single home, no status and no owner. Fix that first and you'll know whether you need anything more.
What lead tracking has to do
- 01One place. Every lead from every channel ends up in the same list, including the ones that started as a text to someone's personal phone.
- 02Status. At a glance, you can see whether a lead is new, waiting on you, waiting on them, quoted, won or lost.
- 03Next step and date. Each open lead says what happens next and when. A lead with no next step is a lead you're quietly losing.
- 04Owner. One named person is responsible for that next step. “We” is not an owner.
Add a fifth if you can: why it was lost. A month of “lost: price” or “lost: no reply” tells you more about your sales than any dashboard.
The shared spreadsheet that works
A shared sheet in Google Sheets or Excel covers all four jobs for many small teams. The columns that matter:
| Column | Example | Why it's there |
|---|---|---|
| Date in | Mar 4 | Shows how long leads wait |
| Name and contact | J. Alvarez, mobile | So anyone can follow up |
| Source | Website form | Tells you which channels bring work |
| Request | Pergola, 12 × 16, photos in folder | Enough to brief someone else |
| Status | Quoted | One of a fixed list, not free text |
| Next step | Follow up on quote | The single next action |
| Next step date | Mar 11 | Sort by this every morning |
| Owner | Sam | One person, by name |
| Estimated value | $[amount] | Helps you prioritize |
| Outcome and reason | Lost: timing | What you learn from at month end |
Fix the status list so everyone uses the same words: New, Contacted, Qualified, Visit booked, Quoted, Won, Lost, No reply. Then keep three habits: sort by next-step date each morning, update the row the moment you touch the lead, and spend ten minutes on Friday looking for rows with no next step.
Setting it up takes an afternoon:
- 01Create the sheet with the columns above and freeze the header row.
- 02Turn the Status column into a dropdown with your fixed list, using the spreadsheet's data validation feature.
- 03Add conditional formatting that turns a row red when its next-step date has passed.
- 04Enter every lead still open from the last 30 days, each with a next step, a date and an owner.
- 05Share it with edit access only for the people who actually work leads.
Keep the column names and the status list stable once you've set them. If you outgrow the sheet, those columns map cleanly onto a CRM's fields, which makes starting with a sheet a low-regret choice.
For a law firm, the same sheet works for intake with two changes. Add a column for conflict-check status, and keep the request column to what a conflict check needs until a lawyer clears the matter. Restrict who can open the file.
Under ABA Model Rule 1.18, a lawyer may not use or reveal what a prospective client shared even when the firm never takes the matter, so treat even a list of names and opposing parties as confidential. That's general information rather than legal advice; your state's ethics rules control.
When a CRM pays off
A CRM earns its cost when the sheet starts failing at something specific. Watch for these signs:
- Several people work the same leads each week, and handoffs keep slipping because the sheet doesn't show who said what.
- You need conversations logged automatically. Emails, calls and texts attached to the lead without anyone pasting them in.
- Long, multi-touch sales. A remodel or a legal matter with a consult, a proposal, a revision and a signature benefits from a timeline per lead.
- Reports you keep rebuilding by hand, such as pipeline value by month or win rates by source.
- More than one location or team, each with its own leads and its own manager.
Before buying, check what you already pay for. Field-service, construction-management and legal practice-management software may already include lead or intake tracking that nobody switched on.
If you do shop, check five things before paying:
- It imports your sheet as a CSV file and keeps your status list as it is.
- Its phone app works for someone on a job site or in a courthouse hallway, not just at a desk.
- It connects to the email, phone and texting tools you already use, or you know exactly what it won't log.
- You can export all your data, including notes and history, if you leave.
- You've multiplied the per-user price by everyone who'll need a login, plus any add-ons for texting or automation.
Flowchart
Do you need a CRM yet?
- StartLeads arrive by form, phone, email and social messages
- DecisionAre they all in one shared list today?NoStepStart a shared sheet first; a CRM won't fix scattered habitsYes
- StepGive the list a month with statuses, next steps and owners
- DecisionIs it failing at even one of the five signs above?NoStepStay on the sheet, and let automation add and update rowsYes
- StepWrite down exactly what the sheet can't do for you
- A personOwner trials a CRM on a month of real leads, checking that it fixes that
- DoneKeep it only if the team updates it without being chased
How automation keeps either one current
Spreadsheets and CRMs fail the same way: they go stale. Someone is busy for a week, rows stop being updated, and the team quietly goes back to texts and memory. The fix is to stop relying on people for the clerical part.
- Every form, email, missed call and message creates a row, with the source and time filled in.
- The first automatic reply sets the status to Contacted and a next-step date.
- Customer replies are attached to the row and flip the status, so nobody has to remember.
- A morning digest lists every lead with a step due today, by owner.
- Rows with no next step, or a date in the past, are flagged on Friday.
People still make every judgment: whether a lead is worth a visit, what to quote, when to call it lost. Automation just makes sure the list reflects reality.
Before and after
The pergola lead, before and after
Four inboxes and a notebook
- 01Inquiry arrives as a text to one partner
- 02Photos land in the other partner's email
- 03Quote promised, but no date written anywhere
- 04Customer calls to chase; the job is lost
ResultNobody owned the next step
One list, kept current
- 01Text is logged as a row with source and time
- 02Photos attach to the same row automatically
- 03Next step “send quote” is due Friday, owner Sam
- 04Friday's digest lists it until it's done
ResultEvery open lead has a date and a name
Pitfalls
- Buying before deciding your statuses. Software can't tell you what “qualified” means in your business.
- Too many fields. Every required field is one more reason not to update the record. Start with the ten columns above.
- No owner. Shared responsibility means no responsibility, in a sheet or a CRM.
- Open sharing. Check who can view and edit, especially for client or patient details, and keep a backup copy.
Once the list exists, follow-up is where it pays: see how to follow up on a quote and why reply speed matters. Our lead follow-up service creates and updates those rows for you, on a sheet or in a CRM; there are examples for carpenters and law firms on their industry pages.