On this page
- What does CRM mean?
- What a CRM does, from new lead to follow-up
- The core parts of a CRM
- Google Sheets (or any spreadsheet) vs. a CRM
- A step-by-step example
- What to automate and what to keep human
- How to choose a CRM without over-buying
- Set up your CRM step by step
- Common mistakes
- Frequently asked questions
- Leads spread across forms, email and spreadsheets?
- Sources
If your leads live in WhatsApp chats, Instagram DMs, email threads and a notebook on your desk, you are not alone. When every follow-up depends on someone remembering it, some of them get missed.
This guide explains what a CRM actually does, from the moment a lead enters your business until the follow-up is done. You will see the parts of a CRM, how it differs from a spreadsheet, a step-by-step example, and what to automate and what to keep in human hands.
How this guide was made: descriptions of HubSpot, Zoho CRM and HighLevel come from each company's own documentation, linked in the text and at the end (checked 26 October 2026). Ai Spark has not published a hands-on test of these CRMs. The only workflow we built and ran ourselves used a Google Sheet as a simple lead log, not a CRM, and we explain below why that difference matters. The business example in this guide is made up for illustration.
Key takeaways
- A CRM connects each person to their deals, conversations and next steps, so the record shows what happened and what should happen next.
- The same idea has different names: HubSpot tracks deals, HighLevel tracks opportunities, and Zoho CRM starts with leads that can be converted into contacts, accounts and deals.
- A spreadsheet can work as a simple lead log. It becomes hard to manage when several people, follow-up tasks and full conversation history are involved.
- Automate the records and reminders. Keep prices, promises and final sales decisions human.
What does CRM mean?
CRM stands for Customer Relationship Management. In practice, a CRM is software that keeps track of the people and companies you deal with, the potential sales you are working on, and everything that happens between you.
HubSpot's documentation describes this with objects and records: a contact is any person who interacts with your business, a company is any business you deal with, a deal tracks a potential transaction, and a ticket stores a support request. Records can be associated with each other, so a deal can be linked to the contact and company it belongs to. Each record also has a timeline of activities, such as calls, meetings, emails, tasks and notes.
That linking is the real difference between a CRM and a list of names. You do not just know who someone is; you can see what they asked for, what you offered and what needs to happen next.
What a CRM does, from new lead to follow-up
Here is the life of a single lead inside a CRM. The names of each step differ between products, but the logic is the same.
Different CRMs model the early steps differently, which is worth knowing before you choose one:
| Product | What a potential sale is called | What the documentation says |
|---|---|---|
| HubSpot | Deal | Deals track the progress of a transaction and are associated with contacts and companies. |
| HighLevel | Opportunity | An opportunity sits in a pipeline and a stage; its status (open, won, lost or abandoned) is set separately from the stage. |
| Zoho CRM | Lead, then deal | A lead can be converted into a contact and an account (if it has a company name), with an optional deal. Conversion cannot be undone. |
The core parts of a CRM
Not every CRM has the same features or uses the same names, and some features depend on your plan. These are the common building blocks:
- Contacts: one record per person, with details such as phone, email, where they came from and notes.
- Companies (or accounts): the business a contact works for, useful when you sell to organisations.
- Deals or opportunities: each potential sale, linked to the contact.
- Pipelines and stages: the steps a deal moves through. In HubSpot each deal stage carries a probability used for a weighted amount, and a property can be made required at a stage. Zoho CRM allows separate pipelines for different sales processes. Our sales pipeline guide shows how to design the stages.
- Activities and notes: calls, emails, meetings and notes saved on the record, so anyone can read the history before replying.
- Tasks: next steps with a due date and an owner.
- Custom fields: your own fields, such as "Service interested in". HighLevel's help describes custom fields for storing extra information about contacts or opportunities.
- Automations: rules that act when something changes. Zoho CRM workflow rules can send email notifications, create tasks or update fields. HubSpot lists workflows on its Professional and Enterprise subscriptions, so check your plan. We cover ten patterns in CRM automation workflows.
- Reporting: answers such as how many leads arrived, from where, and how many were won. What is included differs by product and plan.
Google Sheets (or any spreadsheet) vs. a CRM
Many small businesses start with a spreadsheet, and that is a reasonable first step. The question is what the spreadsheet can and cannot do for you.
| Spreadsheet | CRM | |
|---|---|---|
| Contact storage | One row per lead | One record per contact, linked to deals and companies |
| Pipeline stages | A "Stage" column; a drop-down list keeps names consistent | A board with stages you move deals through |
| Ownership | An "Owner" column that someone must fill in | An owner field on each record or deal |
| Tasks | A "Next step" and "Due date" column | Tasks with due dates attached to the record |
| Reminders | None, unless you add a separate tool | Tasks with due dates; how reminders work depends on the product |
| History | A notes cell that gets longer and harder to read | A timeline of notes, calls and emails on the record |
| Reporting | Formulas and charts you build yourself | Built-in reports, which vary by product and plan |
| Automation | Possible with an automation tool connected to the sheet | Built-in rules on many plans, or an automation tool |
| Collaboration | Shared file; it is easy to overwrite someone's change | Several users on the same records, with a history on each record |
What we actually tested: a spreadsheet as a lead log
In our n8n lead follow-up tutorial, an n8n Form Trigger started the workflow with a test submission. The lead was saved to a Google Sheet first, a reply was prepared from the lead's answers, and a Gmail draft was created. No email was sent, and there was no AI step. The sheet recorded the lead and its status, but it did not create a deal, track a pipeline stage or remind anyone to follow up. That is the gap a CRM fills.
Signs a spreadsheet is no longer enough
There is no lead count at which you must switch. Watch for these signals instead:
- More than one person replies to leads, and you ask each other who answered whom.
- You search old chats and emails before every call to remember the history.
- Follow-ups depend on memory, and some are missed.
- Leads come from several channels and you cannot tell which ones become customers.
- You cannot quickly answer "which deals need action today?"
- You want reminders or automations that react when a deal changes stage.
A step-by-step example
ILLUSTRATIVE EXAMPLE — NOT A CLIENT CASE STUDY. A fictional local cleaning company receives an enquiry through its website form. Here is what happens to it inside a CRM.
| Step | What happens | Done by |
|---|---|---|
| 1. Lead arrives | A visitor asks for a quote for a weekly office clean. | The visitor |
| 2. Contact record created | Name, email and phone are saved to a new contact. | The form integration |
| 3. Source stored | The source field is set to "Website form". | The form integration |
| 4. Deal enters the pipeline | A deal is created in the "New enquiry" stage. | A rule or the owner |
| 5. Follow-up task created | "Call to confirm office size" is due the next working day. | A rule |
| 6. Owner reviews and replies | The owner calls, notes the details and sends a quote. | The owner |
| 7. Stage changes | The deal moves to "Quote sent", with a task to check back. | The owner |
| 8. Outcome recorded | The customer accepts (won), declines (lost, with a reason), or asks to talk again later (nurture). | The owner |
Notice where the person is involved: the call, the quote and the outcome. The CRM keeps the record and the reminders; the decisions stay with the business.
What to automate and what to keep human
| Task | Automate | Keep human | Why |
|---|---|---|---|
| Create or update a contact | Yes | Check duplicates | Every lead gets a record |
| Assign an owner | Yes, by simple rules | Exceptions | Someone is always responsible |
| Create a follow-up task | Yes | Doing the task | Next steps do not depend on memory |
| Move a stage | Only on a clear event, such as a booked meeting | Most stage changes | Stages should reflect what the buyer did |
| Reminders and notifications | Yes | Acting on them | Nothing waits unnoticed |
| Replies to customers | Draft only | Approve and send, especially sensitive replies | They are sent in your name |
| Custom pricing and promises | No | Yes | Mistakes cost money and trust |
| Refunds, contracts, exceptions | No | Yes | They need judgment |
| Final sales decision | No | Yes | Only you know the full context |
Automatic sending is not always the best choice. A draft that you check first is slower by a minute, but you stay in control of what your business says. If automation is new to you, start with What is AI automation?.
How to choose a CRM without over-buying
- List your channels. Where do leads reach you? If WhatsApp or SMS matter, check that the CRM supports them.
- Count your users. Pricing often depends on the number of users or seats, so check how each product charges.
- Decide what you need now. Contact and deal tracking only, or also email campaigns, booking calendars and landing pages?
- Check integrations. Your website form, email, calendar and any automation tool should connect.
- Check that you can export your data. You should be able to leave.
- Try it with real leads. Use a free plan or trial with your own process for a week.
A few examples, described only from their own pages:
- HubSpot: its CRM page describes a free CRM with contact management, deal pipelines and email tracking, and says the free tier covers up to two users and 1,000 contacts.
- Zoho CRM: starts with leads that you convert into contacts, accounts and deals, and supports multiple pipelines.
- HighLevel: organises potential sales as opportunities in pipelines, with custom fields and workflow triggers such as Pipeline Stage Changed. Our GoHighLevel guide for beginners covers the basics.
We have not tested these three CRMs hands-on, so we do not rank them. Plans and prices change; compare current details on each company's website.
Set up your CRM step by step
- Define your stages. Four to six stages that match how you actually sell. See how to build a sales pipeline.
- Choose a few key fields. Name, phone, email, source and service interested in. Add more only when you need them.
- Import your contacts. Export them from your spreadsheet, email or phone and upload them.
- Connect your lead sources. Link your website form so new leads arrive as records.
- Add one automation. A follow-up task for each new lead is a safe first choice. Our automation audit helps you pick what to automate next.
- Build the daily habit. Open the CRM each working day and clear today's tasks.
Common mistakes
- Too many fields. If adding a contact feels slow, people stop doing it.
- No owner. Someone must be responsible for keeping the CRM up to date.
- Not logging conversations. A CRM is only as useful as the information in it.
- Buying more than you need. Start with the features you will use this month.
- Automating before the process is clear. Decide your stages and next steps first.
Frequently asked questions
Is a CRM only for big companies?
No. Freelancers and one-person businesses can use one too, especially when follow-ups depend on memory. A spreadsheet may be enough at first; the signals above help you decide.
Can I start with a free CRM?
Some CRMs have free plans. HubSpot's CRM page, for example, describes a free tier for up to two users and 1,000 contacts. Check the limits of any free plan before you rely on it.
How long does it take to see results?
It depends on how consistently you use it. A practical check after a few weeks of daily use: can you see which deals need action today, and where your leads came from? If not, simplify your stages and fields.
What is the difference between a lead and a contact?
It depends on the CRM. In Zoho CRM a lead is a separate record that can be converted into a contact and an account. In HubSpot, a person is stored as a contact, and the potential sale is tracked as a deal.
Can a spreadsheet replace a CRM?
For one person with a handful of leads, a spreadsheet can work as a lead log, as our tested workflow shows. It lacks built-in tasks, reminders and linked history, which matter more as more people and deals are involved.
Leads spread across forms, email and spreadsheets?
If your leads arrive in several places and nobody is sure what happens next, you can get in touch with Ai Spark. We start by mapping your current process, then suggest what is worth putting in a CRM and what is worth automating.
Sources
- HubSpot Knowledge Base: How to use objects for business processes (checked 26 Oct 2026)
- HubSpot Knowledge Base: Manage your CRM database (checked 26 Oct 2026)
- HubSpot Knowledge Base: Set up and customize pipelines (checked 26 Oct 2026)
- HubSpot Knowledge Base: Create workflows (checked 26 Oct 2026)
- HubSpot CRM (checked 26 Oct 2026)
- Zoho CRM Help: Converting Leads (checked 26 Oct 2026)
- Zoho CRM Help: Multiple Sales Pipeline (checked 26 Oct 2026)
- Zoho CRM Help: Configuring Workflow Rules (checked 26 Oct 2026)
- HighLevel Help: Creating Opportunities (checked 26 Oct 2026)
- HighLevel Help: How to Create and Use Custom Fields (checked 26 Oct 2026)
- HighLevel Help: Workflow Trigger, Pipeline Stage Changed (checked 26 Oct 2026)
- Google Docs Editors Help: Create an in-cell dropdown list (checked 26 Oct 2026)