Business growth
Customer Database (CRM) for Small Businesses in India — Start Free With a Notebook, Sheet or App
Why every local business needs a simple customer list, what to record, free tools to use (Google Sheets, WhatsApp labels, billing apps), privacy basics under India's DPDP Act, and 10 ways to use the data to grow sales.
By Chamko Research Team Updated 4 min read
Quick answer
A CRM is simply an organised list of your customers and what they bought. Start with a Google Sheet (or a billing app) recording name, phone, last purchase, date and notes; add WhatsApp Business labels for active orders. Ask permission before sending offers, keep the data private, and use it for follow-ups, reminders, birthday wishes and win-back messages. Ten minutes a day of updating can noticeably increase repeat sales.
Quick answer: A CRM is simply an organised list of your customers and what they bought. Start with a Google Sheet (or a billing app) recording name, phone, last purchase, date and notes; add WhatsApp Business labels for active orders. Ask permission before sending offers, keep the data private, and use it for follow-ups, reminders, birthday wishes and win-back messages. Ten minutes a day of updating can noticeably increase repeat sales.
"CRM" sounds like expensive corporate software. For a local business it's much simpler: knowing who your customers are, what they like and when they'll need you again. The kirana owner who remembers that Mrs. Mehta buys sugar-free biscuits every Friday is running a CRM in his head. This guide helps you put that memory on paper — so it scales.
Why a customer list matters
- Repeat sales: remind customers when they'll need you again.
- Better service: know their preferences and history.
- Win-back: spot regulars who haven't returned.
- Smarter marketing: send offers only to people likely to care.
- Reviews: a list makes it easy to send review requests after each purchase.
What to record
Keep it minimal; you can always add more later.
| Field | Example | Why |
|---|---|---|
| Name | Priya Shah | Personal touch |
| Mobile | 98xxxxxx21 | WhatsApp follow-ups |
| First visit | 12 Jan 2026 | Tenure |
| Last purchase | AC service, 3 Oct | Next reminder |
| Spend (approx.) | ₹2,400 | Find best customers |
| Preferences | Prefers morning slots | Better service |
| Source | Google Maps | Which marketing works |
| Consent for offers | Yes | Privacy |
Free tools to start
1. Notebook (day one)
Write every customer's name, number and purchase. Transfer to a sheet weekly.
2. Google Sheets (recommended)
Free, works on phone, shareable with staff. Add filters for "last purchase older than 60 days". See Google Sheets for small shops.
3. WhatsApp Business labels
Label chats: New enquiry, Order confirmed, Paid, Delivered, Follow up. It's a mini-CRM for conversations.
4. Billing / POS apps
Many Indian billing apps save customer details automatically with each bill and can send SMS or WhatsApp receipts. See billing software.
5. Dedicated CRM apps
When you have staff and hundreds of customers, a simple CRM with reminders and pipelines saves time. Start free; upgrade only when you outgrow sheets.
Privacy basics (DPDP Act)
India's Digital Personal Data Protection Act, 2023 sets rules for handling personal data. For a small business, practical good habits are:
- Collect only what you need (name, phone, purchase details).
- Tell customers why ("to send your bill and service reminders").
- Get consent for marketing messages and honour opt-outs.
- Keep it secure: password-protect sheets; don't share lists outside your business.
- Delete on request.
This isn't legal advice; consult a professional for your situation.
10 ways to use your customer list
- Thank-you message after each purchase.
- Review request to every customer after service.
- Service reminders (AC, vehicle, salon, dental check-ups).
- Refill reminders (medicines, filters, pet food).
- Birthday/anniversary wishes.
- Festival pre-orders to past festival buyers.
- Win-back offers for customers inactive 60–90 days.
- VIP early access for top spenders.
- New product launch to customers who bought related items.
- Feedback surveys to improve (surveys guide).
A 10-minute daily routine
- Add today's new customers (name, phone, purchase).
- Send follow-ups for yesterday's purchases.
- Check reminders due this week.
- Reply to enquiries labelled "Follow up".
A 10-column starter sheet
| Column | Example |
|---|---|
| Name | Priya Mehta |
| Phone (WhatsApp) | 98XXXXXX21 |
| Area | Navrangpura |
| First visit | 12-Mar-2026 |
| Last visit | 02-Oct-2026 |
| Total visits | 7 |
| Usual purchase | Hair colour, spa |
| Birthday/anniversary | 14-Nov |
| Consent for messages | Yes |
| Notes | Prefers Saturday mornings |
That's enough to run birthday wishes, win-back messages and service reminders.
Three campaigns from one sheet
- Win-back: filter "last visit more than 60 days ago" → send a friendly "we miss you" WhatsApp.
- Birthday: filter by month → send wishes with a small gift on their next visit.
- Service reminder: filter by usual purchase → "your AC service is due" or "time for your next root touch-up".
Keeping data safe
- Limit who can see the full list.
- Use a strong password and two-step verification on the Google account.
- Delete data on request, and never sell or share customer lists — India's data protection law (DPDP Act) expects consent and care.
When to move to proper CRM software
When you have more than one location, more than 2,000 customers, or several staff entering data, a dedicated CRM or billing software with customer history becomes worth it. See our billing software guide.
Frequently asked questions
Do I need paid CRM software?
Not at first. A well-kept Google Sheet works for hundreds of customers.
Can I add customers to WhatsApp broadcast lists?
Only people who saved your number and agreed to receive messages will reliably get broadcasts — and only with their consent.
What's the most valuable column?
"Last purchase date" — it tells you who to remind and who to win back.
How does a customer list help Google ranking?
It makes review requests systematic, which grows fresh reviews every month.