Spreadsheet vs CRM: tracking leads at a small trade shop
2026-10-03 · 7 min read
It's Tuesday night and you're at the kitchen table with the laptop open to the lead sheet. Forty-one rows. Name, phone, address, what they called about, quote amount, and a status column that says "sent" on about half of them. You sort by date and scroll. The water heater in row 23 was quoted three weeks ago. Did anyone call her back? The note says "left VM," with no date and no initials. Row 31 is a sump pump job that your tech says the customer "basically approved" on site. Nobody wrote down whether that turned into a booking.
Every lead is in the sheet. But it only knows what someone typed, and it only tells you something when you open it and go looking.
The short answer
If you get a handful of leads a week and one person handles all of them, a spreadsheet works, as long as someone owns it and opens it every day. Once two or three people are touching leads, or quotes are going out faster than you can remember them, you need something that notices a quote has gone quiet and tells you. Some CRMs can do that, and so can a spreadsheet with a small automation attached. Most CRMs do it only after somebody sets it up.
So before you compare tools, figure out who at your shop notices when a lead stalls. If the answer is nobody, a new tool won't change that by itself.
Where a spreadsheet stops working
A spreadsheet is a list. Here's where that runs out.
Nothing happens on a date. A quote that's been out for a week looks the same as one that went out this morning unless somebody does the math in their head. Follow-up depends on a person remembering to look, on a day when they have time to look.
Two people can't share it cleanly. The office manager updates the row from the phone call while the tech is still in the truck, and nobody updates it from his conversation in the driveway. Before long the sheet says "sent" on a job that's already booked, or "booked" on one that fell through.
Leads get in only when someone types them in. The web form lands in an inbox. The missed call lives in someone's call log, and the Facebook message sits in an app nobody checks on a job. Whatever doesn't get copied over never gets followed up.
A CRM bought off the shelf has the same weak spots if nobody sets it up to act on its own. Any list that waits for a person to open it will drop leads on a busy week.
What a CRM adds, and what it doesn't
A CRM is a customer list that knows about time and stages. A lead moves from new to quoted to won or lost, each move gets a date, and the better ones can send a reminder or a follow-up when a lead sits in one stage too long.
The catch is that buying one doesn't turn those things on. Somebody has to decide the stages and write the follow-up messages, and somebody has to get every lead source feeding into it. If that doesn't happen, the shop ends up with a nicer-looking spreadsheet it pays for every month.
If you already use field service software, check what you're paying for before you shop. Jobber's pricing page (checked October 3, 2026) lists a "Client manager (CRM)" and quoting on every plan, but "Automated follow-ups" and "Automated invoice follow-ups" only start at the Connect plan. Plenty of shops already have the list and are missing the part that chases. I broke the plans down in Jobber pricing.
Side by side
| Spreadsheet | CRM, as bought | Either one, with follow-up wired in | |
|---|---|---|---|
| Where leads come from | Whoever types them in | Some sources connect, the rest get typed in | Form, missed calls and texts land on their own |
| Knows a quote is aging | No | Only if someone sets up the rules | Yes, by day count you choose |
| Follow-up | A person remembers | Templates, if someone writes them | Goes out on schedule, stops when they reply or book |
| Two or three people using it | Rows go stale | Works, if everyone logs the call | Status updates when the job books |
| Monthly cost | Free | Varies, check the vendor's own page | Your tool plus the automation |
| Who keeps it accurate | You | You | Mostly the system, you handle exceptions |
Look at the right-hand column. The follow-up is what gets a quiet quote answered, and it can sit on top of a Google Sheet just as well as on a CRM you already pay for.
What adding follow-up looks like
At a small shop the setup goes in this order.
- Every lead lands in one place. Web form submissions, missed calls and texts become a row or a record on their own, stamped with the time they came in, and nobody copies anything over.
- Each lead has a stage and a date: new, quoted, booked, lost. Moving a lead is one tap, from the office or the truck.
- A quiet quote triggers a message. Two days after a quote goes out with no answer, the customer gets a short text or email in your words asking if they have questions. A week later they get a second one. After that the lead goes on a call list for a person.
- A reply stops the sequence. The moment a customer answers or books, the automatic messages stop, so nobody gets nagged about a job that's already on the calendar.
- You get one list each morning with the leads that need a human today, sorted by how long they've waited.
I built this kind of lead capture and tracking for a Chicago-area pool service company, along with their website and Stripe payments. The first job there was getting every lead in through the same door, so that following up didn't depend on someone remembering to check.
For the wording of the follow-ups themselves, the quote follow-up email templates post has examples you can copy.
What stays human
The system can notice that a quote went quiet. It can't tell why. The customer might be getting two other quotes, waiting on a tax refund, or upset about something the tech said in the driveway. A person makes that call.
You also decide which leads are worth chasing. A $9,000 furnace replacement gets a phone call from the owner on day five. A $150 faucet swap probably doesn't. Those rules come from you, and you'll adjust them during the first month.
The notes from the site visit stay yours too: what the basement looked like, what the customer was worried about, what you promised. The system can store them, but someone who was standing in that basement has to write them down.
Which one to pick
If you're one person with a few leads a week, keep the spreadsheet and set a daily reminder to open it. If you're already paying for field service software, look at what your plan includes before buying anything else. If you're past that point, with several people and leads coming in from four places, put the follow-up in place first and choose the tool second. More on what usually gets automated in a shop like yours is on the plumbing contractor page. Builds start at $500 one time, then a flat monthly from $99 after an included run-in period, cancellable.
Start with your last twenty leads
The free 20 minute process audit starts with your last twenty leads: where each one came from, when it was quoted, and where it went quiet. If follow-up is where you're losing jobs, you'll see it in the first five. Book it here.