You've got a lead's name scrawled on the back of a gas receipt, another buried in a text thread, and a third living only in your head from a call last Tuesday. Somewhere in that pile is a job worth a few thousand dollars. You just can't remember whether you called the person back.
At some point someone told you the fix was a CRM, which stands for customer relationship management software, the thing that's supposed to keep every lead and follow-up in one tidy place. So you signed up, burned a Sunday afternoon setting it up, and haven't logged in since March. That's not a discipline problem. Most of these tools are built for a sales team of thirty, not a crew of four who are all on job sites by seven.
Good news: a pipeline for a small operation really only needs to track about five things, and you can run the whole thing from a spreadsheet with a little automation doing the typing. Let's walk through what matters and what you can safely ignore.
What your pipeline actually needs to track
Strip away the dashboards and the deal scoring and what's left is short. A lead is just a person who wants something, and you need to know enough to move them toward a yes without dropping them.
Here's the whole list:
- Who they are. Name and one way to reach them. Phone, for most trades.
- What they want. One line. "Kitchen faucet replace" or "quote for spring cleanups." Enough that future-you remembers the call.
- Where they came from. Google, a referral from Dave, the sign on your truck. This one tells you where to spend your money later.
- Status. New, quoted, waiting, won, or dead. Five words, no more.
- Next step and when. "Call back Thursday" beats every fancy feature in every expensive tool. This is the field that actually makes you money.
A value estimate makes a fine sixth column if you want to know what your pipeline is worth in a given week. Everything past that (custom stages, probability percentages, activity logs) is weight you'll carry and never read.
Why the big tool sits there unused
Enterprise CRMs don't fail because they're bad software. They fail because they assume someone whose whole job is entering data. Every lead means a form with fifteen fields, and half of them don't apply to you.
When the tool costs you two minutes per lead, you stop entering leads. Then the data is half there, you can't trust it, and you drift back to the shoebox and your own memory. We've watched it happen a dozen times. The tool wasn't the problem, the friction was.
Small shops win on speed and follow-through, not on reporting. You don't need your quarterly close rate broken out by lead source. You need to know who to call before lunch. A system you'll actually open every day beats a powerful one you avoid.
Let AI handle the data entry
This is the part where the new tools genuinely earn their keep, because the miserable half of any CRM is the typing, and that's exactly what software can now do for you.
Two sources cover most of it:
- Calls. A transcription tool (software that turns speech into text) can listen to a voicemail or a recorded call, pull out the name, the number, and what the person wanted, then drop a clean row into your sheet. You check it in ten seconds instead of typing for two minutes.
- Emails. When a lead comes in through your website form or your inbox, AI can read it and fill the same fields on its own. A new message becomes a new row while you're still up on the ladder.
Be honest with yourself about the limits, though. AI mishears names, especially over a bad connection or with an accent it hasn't met much. It guesses at what someone wanted and sometimes guesses wrong. So treat it as a fast assistant that fills in the blanks, not a clerk you never double-check. A ten-second glance at each row catches the mistakes, and that's still a sliver of the time doing it by hand would cost.
One more limit worth naming: AI won't decide who to prioritize for you. It can flag that a message sounds urgent, but the call on which forty-dollar job to skip and which four-thousand-dollar one to chase is yours. That's fine. That judgment is the part of the business only you can make.
The spreadsheet that beats the software
Open a Google Sheet or an Excel file. Make the first row your header with those columns: Name, Contact, What They Want, Source, Status, Next Step, Date, Value. That's your CRM. It cost nothing and it opens on your phone.
Some habits keep it useful:
- Sort by the Date column so today's follow-ups float to the top.
- Use a color or a dropdown for Status so you can scan the whole thing from the truck.
- Never delete a dead lead. Mark it dead and keep it. Six months later a quick "just checking in" wins jobs, and you'll want the history.
- Keep it to one sheet. The minute you start adding tabs and formulas, you're rebuilding the thing you were trying to escape.
Will a spreadsheet scale to fifty employees? No, and when you get there you'll know it, and you'll pick a real tool with your eyes open. Until then it does the job for a shop your size, and it does it today.
Two automations that keep it alive
Pipelines die when nobody looks at them. Two small pieces of automation fix that without asking you to change how you work.
First up is a daily nudge. Have something scan the Next Step and Date columns each morning and text or email you the two or three people you owe a call today. Now the sheet reaches out to you instead of waiting to be opened.
Second is a weekly summary. Once a week an automation can read the whole sheet and hand you a short rundown: new leads, still waiting, gone quiet for two weeks. Ten minutes on a Friday and nothing slips through the cracks over the weekend.
Neither of these is fancy, and that's the point. Wiring them up is a couple of hours once, and after that the system runs whether or not you remember it exists. If that setup isn't your idea of a good afternoon, it's the sort of thing we handle for folks around here without much fuss.
Worth doing this week
You don't need to overhaul anything. Start small and let it prove itself.
- Build the eight-column sheet today. Fifteen minutes, phone or laptop.
- Pour in every lead you can find right now: texts, emails, the sticky notes on the dash. Get them in one place.
- Fill the Next Step and Date fields for every open lead. This alone will surface a job or two you forgot about.
- Pick one AI helper to test, either call transcription or email parsing, and let it fill rows for a week before you judge it.
- Turn on the daily reminder so the sheet starts nudging you instead of the other way around.
Do that, and by next Friday you'll have a pipeline you actually trust, built from tools you already own. No login you dread, no fields you'll never fill in. Just the five things that matter and a little help with the typing.