Skip to content

Do You Need a CRM? Tracking Leads Without the Bloat

By USA AI Corp · · 5 min read

The short answer

Most small businesses need lead tracking before they need a CRM. Whatever you use has to do four things: keep every lead in one place, show its status, name the next step with a date, and say who owns it. A shared spreadsheet does that well for a small team. A CRM pays off when several people work the same leads, conversations need logging automatically, or you need reports a sheet can't give.

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

  1. 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.
  2. 02Status. At a glance, you can see whether a lead is new, waiting on you, waiting on them, quoted, won or lost.
  3. 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.
  4. 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:

A lead-tracking sheet layout; one row per lead, never deleted.
ColumnExampleWhy it's there
Date inMar 4Shows how long leads wait
Name and contactJ. Alvarez, mobileSo anyone can follow up
SourceWebsite formTells you which channels bring work
RequestPergola, 12 × 16, photos in folderEnough to brief someone else
StatusQuotedOne of a fixed list, not free text
Next stepFollow up on quoteThe single next action
Next step dateMar 11Sort by this every morning
OwnerSamOne person, by name
Estimated value$[amount]Helps you prioritize
Outcome and reasonLost: timingWhat 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:

  1. 01Create the sheet with the columns above and freeze the header row.
  2. 02Turn the Status column into a dropdown with your fixed list, using the spreadsheet's data validation feature.
  3. 03Add conditional formatting that turns a row red when its next-step date has passed.
  4. 04Enter every lead still open from the last 30 days, each with a next step, a date and an owner.
  5. 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?

  1. StartLeads arrive by form, phone, email and social messages
  2. DecisionAre they all in one shared list today?
    No
    StepStart a shared sheet first; a CRM won't fix scattered habits
    Yes
  3. StepGive the list a month with statuses, next steps and owners
  4. DecisionIs it failing at even one of the five signs above?
    No
    StepStay on the sheet, and let automation add and update rows
    Yes
  5. StepWrite down exactly what the sheet can't do for you
  6. A personOwner trials a CRM on a month of real leads, checking that it fixes that
  7. DoneKeep it only if the team updates it without being chased
Any one of the five signs can justify a CRM on its own; the owner trials one on real leads before committing.

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

  1. 01Inquiry arrives as a text to one partner
  2. 02Photos land in the other partner's email
  3. 03Quote promised, but no date written anywhere
  4. 04Customer calls to chase; the job is lost

ResultNobody owned the next step

One list, kept current

  1. 01Text is logged as a row with source and time
  2. 02Photos attach to the same row automatically
  3. 03Next step “send quote” is due Friday, owner Sam
  4. 04Friday's digest lists it until it's done

ResultEvery open lead has a date and a name

The same inquiry, tracked in four places versus one list. The “after” assumes your forms and inboxes feed the sheet; without that, the same steps work by hand if someone logs each lead the day it arrives.

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.

Sources

Common questions

Quick answers.

Do I need a CRM for my small business?

Not necessarily. You need lead tracking: every lead in one place with a status, a dated next step and an owner. A shared spreadsheet does that well for a small team. A CRM becomes worth it when several people share leads, you want conversations logged automatically or you need reports a sheet can't produce.

Can I use Google Sheets or Excel as a CRM?

For many small businesses, yes. One row per lead, a fixed list of statuses, a next-step date and an owner column cover the essentials. Sort by next-step date each morning, and connect your forms and inbox so new leads and replies update the sheet without manual typing.

What should a lead tracking spreadsheet include?

Date in, name and contact, source, what they asked for, status, next step, next-step date, owner, estimated value, and outcome with a reason. Keep statuses to a fixed list so they can be sorted and counted, and never delete rows.

When should a small business switch from a spreadsheet to a CRM?

When the sheet keeps failing at something specific: handoffs between several people, logging calls and emails, long multi-step sales, or reports you rebuild by hand. Check whether your field-service or practice-management software already includes lead tracking before buying something new.

Put it to work

Automated lead follow-up

AI lead follow-up that replies to every inquiry within minutes, qualifies it and books the call, and keeps customers hearing from you on dates you approve.

See how it works

Most relevant for carpenters, law firms.

Keep reading

Ready when the work is.

Show us what is slowing your business down.

Book a call

Not ready to talk?

Written brief

Skip the call.
Send a brief.

A few sentences is plenty. We read every brief and reply by email within one business day.

Try it free. If you love it, keep it. If it's not for you, we take it back, no questions asked.

We only use this to reply to you. Privacy policy