A small Indian business can start managing WhatsApp enquiries without buying a full CRM: keep customer conversations in the WhatsApp Business app, but record every genuine enquiry in one access-controlled Google Sheet with an owner, sales stage, last-contact date and next follow-up action. WhatsApp labels help organise chats; the sheet makes ownership and pending work visible. This guide shows how to build that routine, when to move to a paid CRM, and how to message customers in line with WhatsApp's current Business Messaging Policy.
1. Why a WhatsApp inbox is not yet a sales pipeline
A chat tells you what a customer said. It does not automatically tell the rest of the team whether the enquiry is qualified, who owns the next reply, whether a quotation was sent, or when the business should follow up. When those details live only in one person's memory, a busy day can bury a valuable enquiry.
This is a recurring theme in public small-business discussions. Indian founders have described leads buried in WhatsApp, follow-ups managed from memory, and difficulty getting a separate CRM adopted when the customer conversation still happens in WhatsApp. These Reddit posts are individual experiences, not a representative survey or a measurement of lost revenue. [8] [9] [10]
The fix is not necessarily a chatbot or a complex CRM. Start by separating two jobs: WhatsApp is the conversation channel; the lead tracker is the system of record for the next business action.
- Conversation: what the customer asked, what your team replied and what was promised.
- Lead record: who the customer is, what they need, where the enquiry came from and who owns it.
- Next action: the exact task, responsible person and due date.
- Outcome: won, lost, not a fit, or opted out—with a short reason where useful.
2. What the WhatsApp Business app can do before you buy a CRM
Meta's WhatsApp Business app documentation lists practical small-business tools such as a business profile, greeting and away messages, quick replies, labels and product or service catalogues. Labels organise and filter conversations; quick replies shorten repeated answers; away messages set expectations outside working hours. These features can support a disciplined manual process before a business adopts the WhatsApp Business Platform or a separate CRM. [1]
Use a small set of labels that describe the chat's current state. For example: New enquiry, Qualified, Quote sent, Follow-up due, Won, Lost and Do not contact. The exact label names are your operating convention, not a WhatsApp-mandated sales taxonomy.
Do not assume that a label creates a task, assigns an owner, records a sales forecast or guarantees a reminder. Those controls belong in your tracker or CRM. If several people handle the same number, agree who is responsible for updating the record after each meaningful interaction.
- Complete the business profile with the correct business name, description, hours and website or support contact.
- Set a greeting that acknowledges a new enquiry and explains when a person will respond.
- Use an away message to set an honest response expectation outside working hours.
- Create quick replies for repeated questions such as service area, required documents, appointment availability or quotation process.
- Use labels consistently; do not create a new label for every individual customer.
3. Choose the simplest tool level that solves the current problem
There are three practical levels. They are not interchangeable, and the lowest-cost option is not automatically the best option for every team.
WhatsApp Business app plus a shared sheet is suitable when one person or a very small team can maintain the tracker manually. It is inexpensive to operate if you already use these tools, but it does not automatically synchronise every chat or provide a true shared inbox.
A general CRM such as Zoho CRM provides structured leads, contacts, deals, activities and reporting. Zoho's India feature-and-pricing page currently lists a Free edition for up to three users and a Standard edition at ₹800 per user per month when billed annually; monthly billing is listed at ₹1,300 per user per month. Local taxes are additional. Check the current plan limits before choosing. [6]
A WhatsApp-focused CRM such as Interakt combines WhatsApp conversations with pipeline, team assignment and automation features. Its pricing page currently displays a ₹2,499 per month plan plus taxes with five sales agents included, and lists sales pipelines, lead assignment and centralised chats among the features. This is the vendor's subscription price, not a universal WhatsApp charge; check the current plan, Meta message charges and any add-ons before purchase. [7]
Meta describes WhatsApp Business Platform pricing separately from the app: Platform messages are priced per delivered message according to recipient market and message category. A solution provider may also charge its own software or service fee. Review Meta's current rate card and the provider's written quotation before moving to an API-based workflow. [3]
- App + Sheet: manual, low-complexity tracking for a small team that can follow one daily routine.
- General CRM: stronger lead, task, contact and pipeline management across multiple channels.
- WhatsApp CRM / Platform: shared inbox, assignment, automation and API-based workflows when WhatsApp is the core sales channel and the team needs those capabilities.
4. Build one lead tracker with the fields that drive action
Create one row per genuine prospect or buying requirement—not one row for every message. If the same customer makes a separate enquiry for a different product or project, decide whether it should be a new opportunity linked to the same contact.
A practical starter sheet can use the following columns. Keep the first version short enough that the team will actually update it.
- Lead ID — a simple sequential reference such as W-001.
- Date received and time — when the enquiry first arrived.
- Customer name and WhatsApp number — only the contact details needed to respond.
- Source — website, Google Business Profile, Instagram, referral, walk-in, event or repeat customer.
- Requirement — a short, non-sensitive summary of what the person asked for.
- Owner — the one person responsible for the next action.
- Stage — New, Contacted, Qualified, Quote sent, Negotiation, Won, Lost or Not a fit.
- Last contact date — when your team last had a meaningful interaction.
- Next follow-up date and next action — for example, call after the customer reviews the quotation.
- Permission / preference — record the relevant WhatsApp opt-in source and any opt-out request.
- Outcome or lost reason — price, timing, unavailable service, chose another provider or no response.
5. Use clear stages instead of vague labels such as interested
A useful pipeline describes what has happened and what must happen next. Agree on a short definition for every stage so two team members do not interpret the same word differently.
- New: enquiry received; no meaningful response has been sent yet.
- Contacted: the business has acknowledged the enquiry and is waiting for the customer's information or reply.
- Qualified: the requirement, location, timing and basic fit have been checked.
- Quote sent: a written estimate or proposal has been shared and the next review date is recorded.
- Negotiation: the customer is discussing scope, price, delivery or terms.
- Won: the customer has accepted and the business has recorded the agreed next operational step.
- Lost / Not a fit: the opportunity is closed with a brief reason.
- Do not contact: the customer has opted out or asked not to receive further WhatsApp messages.
6. Make follow-ups visible with a simple Google Sheets rule
Google Sheets supports in-cell dropdowns and data-validation rules, so a team can choose a stage or owner from a controlled list instead of typing slightly different versions of the same status. [4]
Assume your sheet uses column H for Stage, J for Next follow-up date and L for Permission / preference. Put this formula in a separate Follow-up flag column, such as M2, and fill it down:
- =IF(OR(H2="Won",H2="Lost",L2="Opted out"),"",IF(J2="","Set date",IF(J2<TODAY(),"Overdue",IF(J2=TODAY(),"Due today","Upcoming"))))
- Filter the sheet each morning for Overdue and Due today. Review New leads separately so an old follow-up does not hide a fresh enquiry.
- Use a date format for the follow-up column and a dropdown for the stage. If your spreadsheet locale uses a different formula separator, adjust commas to the locale's required separator.
- The formula flags work; it does not send a WhatsApp message, create a calendar event or guarantee that someone completes the task.
7. Give every enquiry one owner and a next action
A lead without an owner is everyone's responsibility and often nobody's responsibility. Assign one person, even if that person is the founder. Other team members can help, but the owner remains accountable for updating the next action.
Use a response standard that your team can consistently meet. For example, acknowledge new enquiries within one working hour during published business hours, or state a different realistic service level if the business is not staffed continuously. This is an internal operating target, not a guaranteed conversion benchmark.
A sample follow-up rhythm for a quotation-based service business might be: acknowledge the enquiry on Day 0; answer missing questions; send the quotation when ready; check once after the customer has had reasonable time to review it; and close the loop if there is no response after the agreed number of attempts. Adapt the timing to the buying cycle and stop when the customer says no.
- At first contact: confirm the requirement, location and preferred way to respond.
- After qualification: record the next document, call, visit or estimate required.
- After sending a quote: set a specific review date instead of writing only 'follow up'.
- After a customer replies: update Last contact, Stage and Next action before moving to the next chat.
- At closure: mark Won or Lost and record the reason; do not leave completed work in Follow-up due.
8. Use short, respectful message templates
Templates should reduce repetitive typing without making every customer feel they are receiving a bulk campaign. Personalise the requirement and only send messages the customer expects.
- First acknowledgement: "Thanks for contacting [Business]. I have received your enquiry about [requirement]. I will review it and respond by [realistic time]. Is there anything specific you would like us to consider?"
- After a quotation: "Hi [Name], I am checking whether you had a chance to review quotation [reference]. Would you like me to clarify the scope, delivery or pricing? If your requirement has changed, please let me know and I will update the record."
- Appointment or call confirmation: "Confirming our [date/time] call about [requirement]. Please reply if you need to reschedule."
- Opt-out acknowledgement: "Understood. We will not send further WhatsApp updates. Thank you for letting us know."
9. Capture website and social enquiries in the same pipeline
A lead tracker becomes more useful when it records where an enquiry came from. Use a consistent source list such as Website, Google Business Profile, Instagram, Facebook, Referral, Walk-in and Existing customer. If you run separate campaigns, add a campaign name or UTM source rather than creating a new spreadsheet for every campaign.
Google Forms can send response data to a linked Google Sheet. This can be a simple way to capture a website or event enquiry, provided the form asks only for information needed to respond and the linked spreadsheet is access-controlled. Google documents the option to link form responses to a spreadsheet. [5]
Do not make the customer fill in a long form just because the business wants more data. Ask only what is necessary to qualify the request, and make the next step clear. For website enquiries, keep the form and WhatsApp conversation connected by a reference or lead ID so staff can find the same record.
10. Follow WhatsApp's consent and messaging rules
Meta's WhatsApp Business Messaging Policy says a business may contact people only when they have provided their mobile number or username and given opt-in permission confirming they want subsequent messages or calls from that business. The policy also requires businesses to respect requests to block, discontinue or opt out of communications. This applies to WhatsApp Business services, including the app and Platform. [2]
Keep a simple record of when and how the person agreed to receive the type of WhatsApp messages you plan to send. A phone number appearing in a directory, an old spreadsheet or a purchased list is not a substitute for the required opt-in. Do not scrape numbers or send unsolicited bulk promotions.
The WhatsApp Business Platform has additional rules: businesses may initiate Platform conversations only with approved message templates, and free-form replies are permitted within the 24-hour customer-service window after the user's last message. Outside that window, use approved templates. These are Platform rules; do not assume every feature or billing condition is identical in the Business app. [2] [3]
Store only the information needed for the sales process. Restrict access to the sheet, avoid putting identity documents, bank details or other sensitive information in free-text notes, and remove access when a team member no longer needs it. For website enquiry privacy and data-handling context, see FIN.SWITCH's DPDP website-readiness guide. [11]
- Record the opt-in source and date where relevant to your messaging workflow.
- Keep service updates and promotional messages distinct in your process.
- Provide a clear way to stop receiving messages and update the tracker immediately when someone opts out.
- Review the latest Meta policy and Platform pricing before launching any automated or high-volume messaging workflow.
11. Measure the process every week—not just the number of chats
A high chat count does not prove that the sales process is healthy. Review whether enquiries are being answered, qualified, quoted and closed, and whether the team is completing its next actions.
- New enquiries: count of new lead records created in the period.
- First-response time: time from enquiry received to the first meaningful human response; review the median, not only the fastest reply.
- Qualification rate: qualified leads divided by new enquiries for the same cohort.
- Quote rate: qualified leads that received a quotation divided by qualified leads.
- Win rate: won opportunities divided by closed opportunities; do not mix open leads into the denominator.
- Overdue follow-ups: open leads whose next follow-up date has passed.
- Lost reasons: price, timing, scope mismatch, unavailable capacity, competitor or no response.
12. When is it time to move from a sheet to a CRM?
Upgrade when the manual routine creates more risk than value. Typical signals include two or more people editing the same lead, duplicate records across channels, no reliable assignment history, repeated missed reminders, the need for role-based access, or reporting that takes longer than the sales work itself.
Before purchasing, write down the exact problem: shared inbox, lead routing, follow-up reminders, pipeline reports, website integration, audit trail, WhatsApp templates or multi-channel capture. Ask vendors to demonstrate that specific workflow with your real process, not just show a feature list.
Zoho's model is primarily a general CRM subscription by user and edition. Interakt's reviewed plan combines a WhatsApp-oriented subscription with sales-agent seats and messaging-platform functionality. Meta's own Platform pricing is per delivered message by market and category. Compare the total cost, including taxes, message charges, provider fees, onboarding, integrations and internal time—not just the headline monthly plan. [3] [6] [7]
- Stay with App + Sheet while one owner can keep the data accurate and the process is visible.
- Evaluate a general CRM when leads come from several channels and the business needs structured tasks, deals, reports and user permissions.
- Evaluate a WhatsApp-focused CRM or Platform when a shared inbox, automatic assignment, approved templates, API integration or high-volume messaging is genuinely required.
- Do not buy automation before agreeing on the stages, owners, opt-in rules and escalation process that the automation must follow.
13. A seven-day rollout plan
- Day 1 — Define the stages, lead owner and response standard. Remove vague or duplicate statuses.
- Day 2 — Create the shared Sheet with the minimum columns, dropdowns and follow-up formula.
- Day 3 — Configure WhatsApp Business profile, greeting, away message, quick replies and labels.
- Day 4 — Enter only active enquiries and assign an owner and next action to every open lead.
- Day 5 — Connect a short website or event form to the Sheet and test that a new response appears in the correct place.
- Day 6 — Review overdue items, duplicate records, missing sources and opt-out handling with the team.
- Day 7 — Review the first week's metrics and decide whether the manual process is sufficient or a CRM evaluation is justified.
Frequently asked questions
Can WhatsApp Business be used as a CRM? It can support a basic customer-conversation workflow through labels, quick replies and away messages, but it is not a full CRM. Use a separate tracker for ownership, stages, follow-up dates and outcomes.
How do I track WhatsApp leads in Google Sheets? Create one row per enquiry, record the source and owner, choose a controlled stage, and enter a next follow-up date and action. Use dropdowns and a due-date formula to make pending work visible.
Do I need the WhatsApp Business API to manage leads? No. A small team can begin with the Business app and a manual tracker. The Business Platform becomes relevant when you need API-based integrations, templates, shared workflows or automation at scale.
Is WhatsApp Business App enough for a sales team? It may be enough for a small team with a clear owner and a disciplined tracker. If multiple people need shared inbox access, routing, permissions, history and reports, evaluate a CRM or WhatsApp-focused platform.
Can I message every phone number collected from a website or directory? No. Meta's policy requires the person to have provided their number or username and opted in to subsequent WhatsApp messages or calls. Respect opt-out requests and applicable law.
How often should I follow up? There is no universal schedule. Set the next contact date based on the customer's stated timeline, the buying cycle and what your team promised. Stop when the person opts out or clearly declines.
Are WhatsApp CRM subscriptions the same as Meta message charges? Not necessarily. A software provider may charge a subscription or service fee, while Meta Platform messaging is priced separately according to its current pricing rules. Read both rate cards and the contract.
What should a small business automate first? Start with low-risk reminders and record creation after the manual stages are stable. Keep a human responsible for customer-facing messages, quotations, exceptions and opt-out requests.
14. How FIN.SWITCH can help
If your enquiry process now spans website forms, Meta campaigns, WhatsApp chats and several team members, FIN.SWITCH can discuss whether a simple operating sheet, a reporting workflow or a custom dashboard is the right next step. The published CUSTOM Web App service covers custom UI, authentication, database, admin dashboard, APIs and automation; the actual scope and any WhatsApp integration would need to be assessed and agreed separately.
If you are still building the acquisition side, the Meta Ads Management service includes campaign optimisation, creative testing, audience refinement and reporting; ad spend is separate. Neither service guarantees a number of leads or sales. Start with the workflow you need to improve, then request a clear scope before committing.
- Explore the FIN.SWITCH CUSTOM Web App service for a scoped dashboard or workflow.
- Explore FIN.SWITCH Meta Ads Management if you need campaign execution and reporting.
- Contact FIN.SWITCH to describe your current enquiry process and the point where leads are getting stuck.
- [1] Meta — WhatsApp Business App features: labels, quick replies, away messages and catalogues
- [2] Meta — WhatsApp Business Messaging Policy: opt-in, opt-out and Platform messaging rules
- [3] Meta — WhatsApp Business Platform pricing and message categories
- [4] Google — Create in-cell dropdown lists in Google Sheets
- [5] Google — View and manage Google Forms responses, including linking to Sheets
- [6] Zoho CRM — Official editions, features and India pricing
- [7] Interakt — Official WhatsApp CRM pricing and features
- [8] Reddit — IndiaBusiness discussion about tracking WhatsApp leads and follow-ups
- [9] Reddit — Indian startup founder describing WhatsApp-first lead-management friction
- [10] Reddit — CRM discussion about labels, forgotten follow-ups and simple workflows
- [11] FIN.SWITCH — DPDP Act website-readiness guide
- FIN.SWITCH — CUSTOM Web App service
- FIN.SWITCH — Meta Ads Management service
- FIN.SWITCH — Contact
A WhatsApp chat is a conversation, not a pipeline. Keep the conversation in WhatsApp Business, but give every real enquiry a record, an owner, a stage and a dated next action. Start with a simple sheet if the team can maintain it; move to a CRM or WhatsApp Platform only when the workflow genuinely needs shared inboxes, routing, automation or stronger reporting.