For many small businesses in India, WhatsApp is the shop window, the sales counter and the customer service desk all at once. Enquiries arrive all day. Some get answered right away. Some get answered later. And some disappear under newer chats, never to be seen again.
If you scroll back through your chats, you will probably find people who asked about prices, said they were interested, and then heard nothing more. Each one is a lead you have already paid for, in time or advertising, and then lost.
The good news is that you can turn this chaos into a clean lead list in one afternoon. Here is how.
Set aside two to three hours
Pick a quiet afternoon. Put your phone on silent for other apps, open WhatsApp Business on a laptop using WhatsApp Web if you can, because a bigger screen makes this much faster. Have a spreadsheet open next to it.
Step 1: create the list
Make a simple sheet with these columns:
- Name
- Phone number
- Date of first message
- What they asked about
- Status: New, Replied, Quote sent, Won, Lost, No reply
- Next step and date
Keep it to these columns for now. You can add more later.
Step 2: go through chats from the last 60 days
Older enquiries are usually cold, so start with the last two months. Go through each chat that looks like a customer enquiry. For each one, add a row with the details. Skip personal chats, suppliers and spam.
Be quick. One line describing what they asked is enough. The goal is a complete list, not perfect notes.

Step 3: use labels as you go
WhatsApp Business lets you add labels to chats. As you add each enquiry to your list, also label the chat, for example New lead, Quote sent, Won or Follow up. This means that next time, you can filter chats by label instead of scrolling.
Step 4: decide the next step for each
Once the list is complete, go through each row and decide what should happen next. Most will fall into one of these groups:
- Never replied to: send a reply today, with an apology for the delay.
- Quote sent, no answer: send a short check-in.
- Said they would think about it: send a helpful follow-up.
- Clearly not interested or bought elsewhere: mark as Lost.
Hello [CUSTOMER NAME], I am sorry for the late reply to your question about [PRODUCT OR SERVICE]. If you are still looking, here are the details: [SHORT ANSWER]. Happy to help with anything else.
An honest apology for a slow reply is usually well received, and some of these leads will still be interested.
Step 5: send the messages
Now work through the list and send the messages. Personalise each one with the person's name and what they asked about. Update the status column as you go. By the end of the afternoon, every lead from the last two months will have a status and a next step.
Keep it clean from now on
The afternoon clean-up is a one-time fix. To stop the chaos from building up again, add two simple daily habits:
- Add every new enquiry to the list on the same day, with a label in WhatsApp.
- Each morning, check the "next step and date" column and do what is due.
Five to ten minutes a day keeps the list current.
Let new enquiries add themselves
Doing this by hand works well while message volume is modest. As it grows, the copying becomes the bottleneck. A simple setup can capture each new WhatsApp enquiry into your lead list automatically, with the date and phone number, and remind you when a follow-up is due. You only add the details that need a person.
Common questions
Is it too late to reply to an enquiry from weeks ago?
Not usually. A short, honest reply with an apology for the delay is far better than no reply. Some people will have bought elsewhere, and that is fine. Others will still be looking.
Can several people work on the same lead list?
Yes, as long as it is one shared list and everyone uses the same status words. Agree who owns each lead, so two people do not reply to the same customer.
Where to start
Choose your afternoon and do the clean-up. If you would like new WhatsApp enquiries to land in your lead list by themselves, with reminders for each follow-up, book a free 15-minute check and we will show you how that could work.



