- A CRM is simply one place where every lead and customer is recorded, with what happens next.
- A well-built Google Sheet is enough for many small businesses. Move to a CRM when the team or the volume grows.
- Whatever you use, every new enquiry should land there automatically.
An electrician gets enquiries from his website, WhatsApp, Facebook and phone calls. Some are written in a notebook, some stay in WhatsApp, some live in his email.
A customer calls back: “I asked about a quote two weeks ago.” He can’t find the message.
Every business needs one place where every lead is recorded. That place is a CRM, and it doesn’t have to be expensive. It is also the backbone of every lead follow-up system we build.
What is a CRM?
CRM stands for customer relationship management. In plain words, it is a list of people who have asked about your service or bought from you, with what happened and what happens next.
A good CRM answers three questions at a glance:
- Who asked, and how do we reach them?
- What do they want?
- What is the next step, and when?
When is a Google Sheet enough?
A spreadsheet works well when:
- one to three people handle leads
- you get a manageable number of enquiries each week
- you mostly need a list, a status and a next step
Google Sheets is free, shared, and works on a phone. A single spreadsheet can hold up to 20 million cells, far more than a small business needs.
These columns cover most needs:
| Column | Example |
|---|---|
| Date | 12 Oct 2026 |
| Name | Sara Ahmed |
| Phone or email | +44 … |
| Channel | |
| What they want | Rewire a kitchen |
| Status | New / Quoted / Booked / Lost |
| Next step | Send quote |
| Next step date | 14 Oct |
| Notes | Prefers mornings |
Make Status a drop-down with a few fixed options. Free-typed statuses (“quoted??”, “sent quote”) make the sheet impossible to sort.
When should you move to a CRM?
Consider a CRM when:
- several people work on the same leads and step on each other
- you want every email and call recorded on the customer automatically
- you need different access for different staff
- the sheet has become slow or messy
Free CRMs exist. HubSpot, for example, offers a free CRM with no time limit, and paid plans add more. Many other CRMs have free or low-cost starter plans. Pick one that connects to the tools you already use.
| Google Sheet | Free CRM | |
|---|---|---|
| Cost to start | Free | Free plan, paid upgrades |
| Setup | Minutes | An afternoon |
| Best for | One to three people | A growing team |
| Email and call tracking | Manual | Often built in |
| Access control | Basic sharing | Roles and permissions |
The part that matters most: getting leads in
The best CRM fails if people have to type every lead by hand. On a busy day, nobody does.
The fix is to send every enquiry into your sheet or CRM automatically. n8n, a tool that connects your apps and runs steps automatically, collects enquiries from your form, WhatsApp, Messenger and email. Claude, an AI model, writes a one-line summary of what each person wants.
The recipe
Automation recipe: every enquiry in one lead sheet
- When this happensA new enquiry arrives from your website form, WhatsApp, Messenger or email.
- The system doesThe system checks whether this person is already in the sheet, using phone or email.
- ThenNew people get a new row. Existing people get a note added to their row.
- ThenClaude writes a one-line summary of what they want and suggests a next step.
- ThenLeads with a next step due today appear in a short morning email to the team.
- You onlyDecide the next step for each lead, update the status, and handle the conversation.
- n8n
- Claude
- Google Sheets
- Gmail
- WhatsApp Cloud API
Common mistakes
One sheet per channel. A WhatsApp sheet and an email sheet mean two lists to check. Keep one.
No next step column. A list of names without next steps is a phone book, not a CRM.
Duplicates. The same customer appears three times. Check phone or email before adding a row.
Storing more than you need. Keep what helps you serve the customer. Don’t collect personal details you won’t use, and say how you use them in your privacy policy.
A simple next step
Make a sheet with the columns above today. Add every enquiry from the last two weeks. You will probably find at least one person who deserves a follow-up.
For what to send them, read lead follow-up: what to send on day 1, day 3 and day 7. For speed, see how fast you should reply to a new lead.
Want every enquiry to land in one place automatically? Book a free video call.
Sources
This guide was drafted with AI assistance, then reviewed, fact-checked and edited by MD Al Amin.
Quick questions
Is a spreadsheet a real CRM?
For a small team, it can do the main job - one list of leads with a status and a next step. It lacks features like automatic email tracking and permissions, which matter more as the team grows.
Is HubSpot's CRM really free?
HubSpot offers a free CRM with no time limit. Paid plans add more features. Check what the free plan includes today on HubSpot's own page before you decide.
Can I move from a sheet to a CRM later?
Yes. Most CRMs can import a spreadsheet. Clean, consistent columns make the move much easier.