Most small businesses run their leads on a spreadsheet, a few WhatsApp chats and somebody’s memory. It works, until a good customer waits nine days for a reply and buys from someone else. Here is how to tell when you have outgrown the spreadsheet, what a CRM does differently, a pipeline you can copy, and how to switch in a week.
What lead management really is
Lead management is everything that happens between “someone asked” and “someone paid”. It sounds like a big-company idea, but it comes down to five questions you should be able to answer about every lead, at any moment:
- Who is it, and how do we reach them?
- Where did they come from?
- What stage are they at?
- Who in the team owns them?
- What happens next, and when?
If any of the five lives only in someone’s head, that is where leads get lost. A lead system, however simple, exists to keep those five answers in one place and up to date.
Where the spreadsheet breaks
A spreadsheet is a fine place to start. It is free, everyone knows how to use it, and for one person with a handful of enquiries it is enough. The trouble is what a sheet cannot do.
- It only knows what someone types. The status column is as fresh as the last time somebody remembered to update it.
- The conversation is somewhere else. The sheet says “follow up”. The messages are in WhatsApp, the quote is in an email and the call was on someone’s phone.
- Nothing happens by itself. A sheet never reminds, never assigns, and never notices that a lead has waited three days.
- It has no memory. Overwrite a cell and the history is gone. You cannot see when a lead moved or who spoke to them last.
- It strains with a team. Two people, two versions, and “I thought you called them”.
Seven signs you have outgrown it
- More than one person handles enquiries.
- Enquiries arrive on more than one channel: WhatsApp, Instagram, your website, phone calls.
- A customer has had to chase you before you followed up with them.
- Someone has asked “did anyone reply to this?” in the team group.
- You cannot say how many enquiries came in last month, or how many became customers.
- The same lead appears twice, with two different statuses.
- Keeping the sheet up to date has become a job of its own.
What a CRM does differently
A CRM (customer relationship management system) is a shared record of every lead with the conversation attached, plus rules that move things along. The difference shows up in ordinary, daily tasks:
| You need to… | In a spreadsheet | In a CRM |
|---|---|---|
| See every lead and its stage | Scroll, filter and trust the status column | One list or board that is always current |
| Know what was said | Search WhatsApp, email and call logs | Emails, calls, notes and files on the lead |
| Follow up on time | Remember, or set phone alarms | Tasks, reminders and automatic nudges |
| Share leads across a team | Colour codes and initials | An owner on every lead, assigned by a rule |
| Know what is working | Count rows by hand | A dashboard by source, stage and owner |
| Keep the history | Lost when a cell is overwritten | Every change logged with its time |
One list, every stage
Every lead sits in one list you can search and filter. Switch to a board and each column becomes a stage, with a card for each lead that you drag forward as it progresses. One glance tells you how many leads are waiting for a first reply and which ones are close to buying.
The whole conversation on the lead
Open a lead and its history is there in order: created from the website form, a call that lasted four minutes, a note about budget, the email with the quotation attached, the customer’s reply. You write the email from that same screen and attach the quote there, and the answer comes back to the same place. Nobody has to ask “what did we tell them?”
Workflows that run by themselves
This is the part a spreadsheet can never do. A workflow is a small rule: when this happens, do that. You build it once from steps, and it runs for every lead afterwards.
A simple pipeline you can copy
Keep the stages few, and make each one mean something you can check.
| Stage | It means | Move forward when |
|---|---|---|
| New | An enquiry has arrived and nobody has replied yet | You send the first reply |
| Contacted | You have replied and are waiting | They answer |
| Replied | A real conversation is under way | You know their need, budget and timing |
| Qualified | A good fit, ready for a quote, visit or demo | They say yes and pay |
| Converted | They are a customer | Nothing more to do here |
| Lost | They said no, or went quiet after your last message | Note the reason and look again in a few months |
Six stages are plenty for most small businesses. If nobody can explain the difference between two stages, merge them.
Two rules make any pipeline work. Every lead has an owner. And every open lead has a next step with a date, even if the step is only “check in on Friday”.
Three workflows worth automating first
1. New lead: assign it and say hello
When a lead is created, give it to a salesperson, in turn so nobody is overloaded, and send a short welcome with your brochure or price list. The customer hears back within a minute and the lead already has an owner.
2. No reply: remind a person
If two days pass without an answer, create a call task for the owner. People forget. A task list does not.
3. Reply received: move the stage
When the customer replies, mark the lead Replied and alert its owner, so warm leads never sit forgotten under New.
Moving from a spreadsheet to a CRM in a week
- 1Day 1: tidy the sheet. One row per lead, with one column each for name, phone, email, source, status and owner. Remove duplicates.
- 2Day 2: agree the stages. Use the six above or your own, and write one line on what each one means.
- 3Day 3: import. A CRM reads your sheet as a CSV file and lets you match its columns. Map your old statuses to the new stages.
- 4Day 4: connect the channels. Your business email first, then WhatsApp, so new conversations land on the lead.
- 5Day 5: add two workflows. Start with assigning new leads and the no-reply reminder.
- 6Days 6 and 7: run both side by side, then stop updating the sheet. Keep it as a backup, not as a second source of truth.
What to look for in a CRM
- Your team will open it every day. Simple screens beat a long feature list.
- Email and WhatsApp live inside it, so the conversation is not somewhere else.
- You can change stages and fields yourself, because your process will change.
- Workflows need no developer. If adding a reminder takes a support ticket, it will not get added.
- Import and export are easy. Your leads are yours, and you should be able to take them with you.
- The price stays fair as you add people.
One honest caveat: a CRM will not fix a team that does not follow up. What it does is make following up the easiest thing to do, and make it obvious when nobody did.
How 99ai CRM fits
99ai CRM is the lead system we set up for small businesses. It covers everything described above:
- Leads and deals in a searchable list or a drag-and-drop board.
- Email written from the lead itself, with attachments and templates. Replies land on the same timeline.
- Tasks, notes and call logs on every lead.
- WhatsApp conversations alongside the rest.
- A visual workflow builder with triggers, waits and if/else steps.
- A live dashboard, custom fields and spreadsheet import.
Frequently asked questions
What is lead management?
It is everything between “someone asked” and “someone paid”: capturing each enquiry, giving it an owner, tracking its stage, following up on time and learning which sources bring customers.
Is Excel or Google Sheets good enough for managing leads?
For one person with a handful of enquiries, yes. Once leads arrive on several channels or more than one person handles them, a sheet falls behind, because it only knows what someone types into it.
When does a small business need a CRM?
When more than one person handles leads, when enquiries arrive on more than one channel, or when you cannot say how many enquiries came in last month and how many became customers.
How long does it take to move from a spreadsheet to a CRM?
About a week for a small team: a day to tidy the sheet, a day to agree the stages, then importing, connecting email and WhatsApp, and adding two simple workflows.
What is a sales pipeline?
The list of stages a lead passes through, from new enquiry to customer. Each stage should mean something you can check, such as “replied” or “quote sent”.
Can a CRM update lead statuses automatically?
Yes. A workflow can move a lead when something happens: for example, marking it Replied when the customer answers an email, or creating a call task when two days pass with no reply.