Do we need a proper CRM, or is a spreadsheet enough?

A spreadsheet is enough until multiple people need to update it at once, or until you need reminders and automatic capture. Most businesses outgrow it eventually, but starting with a spreadsheet is far better than starting with a CRM nobody fills in. The discipline is the asset; the software just makes an existing discipline easier.

What is the most common reason a CRM fails at a small company?

Nobody enters the data, because entering it is extra work with no immediate reward for the person doing it. The fix is automatic capture — leads flowing in without anyone typing — plus making the list genuinely useful to the salespeople, not just to management.

Should every lead source feed into one place, even offline ones?

Yes, and offline ones matter most, because they are the ones no platform reports. Exhibition contacts, walk-ins and referrals are invisible to every digital dashboard — if they are not in your own list, they are not in any measurement you have.

How far back should we bother reconstructing old leads?

Usually not far. Reconstructing history is a large effort for data that is already cold. Start clean from today, get capture working properly, and spend the effort you would have used on archaeology on contacting the recent uncontacted instead.

Automation

You cannot automate a mess

Every enquiry you have ever received is somewhere. That is the problem — somewhere is not one place, and no software can automate a pipeline it cannot see.

31 August 20266 min read

Where the leads actually live

Ask most growing businesses where their enquiries are and the honest answer is a list, not a place.

Some in a WhatsApp thread. Some in a personal inbox. A few on a notepad on someone's desk. Some in the website's form-submission emails that nobody has opened in a month. The ones from the exhibition are in a folder of photographed visiting cards.

Every one of these is a real enquiry from a real person who was interested enough to make contact. Collectively they are not a pipeline. They are debris.

Why automation gets sold as the fix

The pitch is appealing: install a tool, and follow-up happens by itself.

It is true for the part that lives inside the tool. It is completely untrue for everything outside it — and in most businesses, most of the leads are outside it. A tool cannot chase what was never entered. Automation multiplies whatever process you already have; if the process is "somebody remembers", the multiplier applies to forgetting too.

This is the sequence that wastes money: buy the software, discover the data is not in it, spend three months on manual entry that nobody has time for, and quietly stop using it.

The unglamorous thing that has to happen first

Every enquiry, in one place, with four fields.

Not a sophisticated CRM. Not a workflow engine. One list — a shared spreadsheet is genuinely enough to begin — where every enquiry from every source lands:

That is it. Four columns. It is boring, it feels like admin, and it is the difference between a business that can be automated and one that cannot.

Who — name and number
When — the date it arrived
Where from — website, WhatsApp, exhibition, referral, walk-in
What happened — contacted, quoted, won, lost, and when

What it immediately tells you

The list starts paying for itself before any automation exists:

Which sources actually produce business — not enquiries, business. Most companies discover the ranking is not what they assumed, and that a channel they were proud of produces volume nobody converts.

How long follow-up actually takes — the gap between the "when" and the "what happened" column. This is usually the most expensive number in the business, and nobody knows it until it is written down.

How many were never contacted at all — the row with a date and nothing after it. In most first audits, this number is uncomfortable, and it is also the cheapest revenue available: people who already raised their hand.

Then automate — in this order

Once the list exists and is genuinely being filled:

1. Capture — website form, WhatsApp, and ad-platform leads flowing in automatically, so entry is not a person's discipline

2. Acknowledgement — an instant reply so nobody waits overnight

3. Assignment — every lead has an owner the moment it arrives, not "whoever picks it up"

4. Reminders — nudges for follow-ups that have gone quiet

Notice that none of the first three are clever. They remove the places where things fall through. That is what automation is genuinely good at, and it is a different thing from what it is usually sold as.

The test before buying anything

Pick a week from three months ago. Find every enquiry that came in that week, from every source, and say what happened to each one.

If that takes more than a few minutes, no tool will fix it — the tool will simply have the same gaps, faster and with a subscription. That test is where every automation conversation should start.

Questions people ask

Do we need a proper CRM, or is a spreadsheet enough?: A spreadsheet is enough until multiple people need to update it at once, or until you need reminders and automatic capture. Most businesses outgrow it eventually, but starting with a spreadsheet is far better than starting with a CRM nobody fills in. The discipline is the asset; the software just makes an existing discipline easier.
What is the most common reason a CRM fails at a small company?: Nobody enters the data, because entering it is extra work with no immediate reward for the person doing it. The fix is automatic capture — leads flowing in without anyone typing — plus making the list genuinely useful to the salespeople, not just to management.
Should every lead source feed into one place, even offline ones?: Yes, and offline ones matter most, because they are the ones no platform reports. Exhibition contacts, walk-ins and referrals are invisible to every digital dashboard — if they are not in your own list, they are not in any measurement you have.
How far back should we bother reconstructing old leads?: Usually not far. Reconstructing history is a large effort for data that is already cold. Start clean from today, get capture working properly, and spend the effort you would have used on archaeology on contacting the recent uncontacted instead.