Deciding 8 min read

CRM for a small business: when you need one and when automation is enough

You get a simple rule for when buying a CRM pays off and when a spreadsheet with automation is enough, plus a procedure for getting website enquiries into either one via n8n.

CRM for a small business: when you need one and when automation is enough
Author: Maksym Kamenchuk, Nexflow — Banská Bystrica Published Updated

You need a CRM if more than one person works with clients and the company has a repeatable sales process. Then everyone needs to see the communication history and deal status in one place.

A spreadsheet with automation is enough if you work with clients alone and the process is simple. Enquiries from a form can be written to Google Sheets automatically via n8n, and a message notifies you about a new enquiry.

The two paths are not mutually exclusive. If you move to a CRM later, the automation can be connected to it, for example to HubSpot or Pipedrive.

What is a CRM system and what does it bring you in practice?

CRM (Customer Relationship Management) is a tool for keeping records of customers and sales opportunities. In practice it comes down to four things: contacts, communication history, deals in progress, and tasks for what to do next.

Vendors describe their products in different ways. According to the n8n documentation, Pipedrive is a sales-focused CRM built around managing the sales pipeline, and it offers automations, email integration and partner integrations. HubSpot is described there as software for marketing and sales, including lead management and marketing automation. Pipedrive and HubSpot both have ready-made n8n integrations.

The main benefit of a CRM is not the software itself, but that client data is in one place and does not depend on one person's memory.

Which CRM features does a small business really need?

A little is enough to start with. Below is my recommendation of what is essential for a small business and what can wait.

FeatureAt the start
Contacts and contact detailsEssential
Communication history and notesEssential
Status of an enquiry or dealEssential
Tasks and reminders for the next stepEssential
Notification about a new enquiryUseful, solved by automation
Marketing campaigns and email sequencesCan wait
Complex reportsCan wait

Key idea: if the first four rows of the table are enough for you, you don't need a big product. You need order and a reliable way to get data into one place.

CRM or a spreadsheet with automation: how to decide?

I decide based on two questions, not on the number of clients: does more than one person work with the clients? And does the company have a repeatable sales process, meaning similar steps from enquiry to quote and closing?

SituationRecommendation
I work alone, the process is simpleSpreadsheet + automation
Several people work with the same clientsCRM
Repeatable sales process with stagesCRM
Enquiries come from the website and I just need to capture themSpreadsheet + automation

Google Sheets also has technical limits. According to Google's documentation, its API is free of additional charges under standard use, but it has a limit of 300 reads and 300 writes per minute per project, and 60 per minute per user. In my view, with a few enquiries a day these limits normally don't get in the way; you only need to think about them with large volumes at once. Details are on the Google Sheets API limits page.

The decision rule is my recommendation, not a generally valid standard. In a borderline situation it makes sense to start with a spreadsheet and move to a CRM when you begin to get lost in it.

How to connect enquiries from your website and e-shop to a CRM via n8n?

In n8n, the Webhook node is used to receive data from a form. According to the documentation, it creates webhooks that receive data from apps when an event occurs, and it is a trigger node that starts the whole workflow. The maximum payload size is 16 MB; when self-hosting, it can be changed with the N8N_PAYLOAD_SIZE_MAX variable.

  1. The form on the website sends the data to the webhook URL in n8n.
  2. The Webhook node receives the data and starts the workflow.
  3. Writing to Google Sheets or to a CRM, for example HubSpot or Pipedrive.
  4. Notification by email or via Telegram that a new enquiry has arrived.
  5. A person replies to the customer. The automation only prepares the data; decisions and communication stay with you.

When connecting a CRM via n8n, you usually need an API key or token from the account settings, with permissions for the data you want to work with. For the HubSpot integration, n8n states on its page that it can manage leads, track interactions and sync CRM data, and HubSpot can be connected to more than 2,000 other apps and services. A comparison of n8n and Make is in the article n8n vs Make.com.

More about this tool is on the page n8n automation. Enquiry handling is described in more detail in the article How much time an AI agent saves when handling enquiries.

What about customers' personal data in a CRM and GDPR?

Customer contacts are personal data, whether you keep them in a CRM or in a spreadsheet. So think about personal data protection when choosing a tool.

The Office for Personal Data Protection of the Slovak Republic (Úrad na ochranu osobných údajov SR) publishes templates and forms for download on its website, for example standard contractual clauses for a processor agreement and a template for records of processing activities: Templates and forms for download (in Slovak).

Nexflow does not provide tax or legal advice. Check your specific obligations against the current wording of the regulations with a lawyer or a data protection officer.

When not to introduce a CRM system?

The most common mistake is buying a CRM before you know what it should do. It pays to automate a process that is settled. See also the article What to automate in your company first.

In such a case it is better to start with simple automation: the enquiry is saved to a spreadsheet and you get a notification.

How to start: the order of steps before choosing a CRM

  1. Write down where enquiries come from (website, email, phone, e-shop) and who handles them today.
  2. Describe the steps from enquiry to closing the deal.
  3. Answer the two questions from the decision rule: more people with clients? a repeatable process?
  4. If you are on the fence, start with a spreadsheet with automation and leave the move to a CRM for later.
  5. If you are choosing a CRM, check whether it integrates with the tools you use.

My automations start at €390. What the price consists of is described in the article How much does AI automation cost for a small business?. A broader view is offered by the page Business process automation.

Frequently asked questions

What is a CRM system?

A CRM is a tool for keeping records of customers: contacts, communication history, deals in progress and tasks. Its purpose is to keep client data in one place so that everyone who works with clients has access to it.

Does a sole trader need a CRM system?

As a rule, no, if they work alone and have a simple process. A spreadsheet into which enquiries are written automatically is often enough. A CRM makes sense when another person joins or the sales process becomes repeatable and more complex.

Can a Google spreadsheet replace a CRM?

With a small number of clients and a simple process, yes. A spreadsheet can handle contacts, enquiry status and notes, and n8n can write into it automatically. When more people work with it and you stop being able to find your way around, it is time for a CRM.

Can a CRM be connected to a web form automatically?

Yes. The form sends the data to a webhook in n8n, and the workflow processes it and writes it to a CRM, for example HubSpot or Pipedrive, or to Google Sheets. You usually need an API key or token from that CRM's settings.

Can n8n serve as a CRM?

In my view, n8n does not replace a CRM. It is used for automatically transferring data between tools, for example from a form to a spreadsheet or a CRM. Keep the customer data itself stored in a spreadsheet or in a CRM.

Sources

Related services

ServiceBusiness process automation Servicen8n automation

Related articles

GuideWhat to automate in a company first PricingHow much does AI automation cost for a small business? From practiceHow much time an AI agent saves on handling enquiries

Not sure whether you need a CRM or automation is enough?

Write me a few sentences about how you currently keep track of enquiries and customers. I'll take a look and tell you what makes sense, even if it means you don't need a CRM yet.

Write to me