A simple CRM for a small business in India can be a Google Sheet that automatically receives every lead from your website, WhatsApp, calls and ads, with columns for status and next follow-up date, plus a daily WhatsApp reminder of who to contact. It costs almost nothing to run, takes a few days to set up with a tool like n8n, and covers what most businesses under 10 people actually use a CRM for.
What does a small business actually need from a CRM?
Strip away the features and a small business needs four things: every inquiry recorded in one place, a status for each (new, contacted, quoted, won, lost), a reminder when a follow-up is due, and a monthly view of where leads came from and how many closed. Big CRMs do much more, and most small teams abandon them because updating them feels like extra work.
Why use Google Sheets as a CRM?
- Everyone already knows how to use it, including on a phone.
- It's free and easy to share with staff.
- Automation tools can write to it and read from it.
- You can move to a proper CRM later without losing data.
The limits show up past a few thousand leads a year or when you need detailed permissions. Until then, a sheet with the right automation is plenty. Related: simple dashboards can replace messy spreadsheets.
What columns should the CRM sheet have?
| Column | Example |
|---|---|
| Date | 17 Sep 2026 |
| Name / Phone | Anjali Mehta / 98XXXXXXXX |
| Source | Website form, Google Ads, Missed call |
| Requirement | Wedding makeup package |
| Status | New / Contacted / Quoted / Won / Lost |
| Next follow-up | 19 Sep 2026 |
| Value | ₹18,000 |
| Notes | Wants trial first |
How does the automation work?
- Website forms, ad lead forms and missed calls are sent to n8n.
- n8n adds a row, removes duplicates by phone number, and sends the lead an instant WhatsApp reply.
- Every morning at 9, it reads the sheet and messages you the list of follow-ups due today.
- Leads untouched for 3 days get flagged.
- On the 1st of each month you get a summary: leads by source, won, lost, revenue.
If n8n is new to you, start with what is n8n.
When should you move to a paid CRM?
Move up when you have a sales team with separate pipelines, need call recording or email sequences built in, or handle thousands of leads a month. Because the data is already structured in a sheet, importing into Zoho, HubSpot or a custom system later is straightforward.
Want this set up for your business? I build websites and automations for clinics and small businesses across India. Tell me about your project or message me on WhatsApp for a free quote.