Pharmacy Lead Tracking Sheet: Stop Losing WhatsApp Enquiries

It's 8:40 PM, closing time, and your counter staff is cashing out while three WhatsApp messages sit unread — one asking if you have Telma 40 in stock, one asking for a home delivery of insulin, one from a regular checking if their monthly diabetes strip order is ready. By the time someone replies tomorrow morning, two of those three have already ordered from the pharmacy two lanes down that answered in five minutes.

This is the leak that never shows up in your cash register but shows up in your footfall. A pharmacy in India handles enquiries across three or four channels at once — WhatsApp, phone calls, walk-ins, sometimes Instagram DMs from a younger relative asking on behalf of an elderly parent — and nobody at the counter has time to write these down consistently, let alone follow up. A proper pharmacy lead tracking sheet fixes this by pulling every enquiry into one place and reminding your staff who to call back, every single day, without anyone having to remember.

This guide walks through what that setup actually does, how it works day to day, what it costs, and what you need before you start. If you want to see the exact package first, it's here: CRM Setup & Automation for Pharmacies.

What a CRM Setup actually does for a Pharmacy

Think of it as the notebook your senior counter staff used to keep under the billing counter — except it never gets misplaced, nobody has to decipher someone else's handwriting, and it pings someone when a follow-up is due.

Concretely, for a pharmacy this means:

• Every enquiry lands in one sheet or CRM — whether it came in as a WhatsApp text asking "Do you have Augmentin 625?", a missed call from a regular customer, or a walk-in whose medicine wasn't in stock that day.
• Stock-out enquiries get flagged automatically so when a customer asks for something you don't have, that's logged as a follow-up the moment it's back in stock — instead of relying on staff memory or a torn paper chit.
• Chronic medicine customers get a recurring reminder slot — someone on BP or diabetes medication who orders monthly gets tracked so your staff calls or messages them a few days before they're likely to run out, rather than waiting for them to remember.
• Home delivery requests are separated from counter enquiries so your delivery person's list for the day is clear, instead of buried in a general enquiry list.
• A daily "who to call today" list gets generated automatically, so whoever is on shift — even if it's not the usual pharmacist — knows exactly who's waiting on a callback.
• A monthly pipeline report shows how many enquiries came in, how many converted to sales, and how many went cold — useful when you're deciding whether to stock a slow-moving item based on repeated demand.

This isn't a full pharmacy billing or inventory system — it sits alongside whatever billing software or register you already use, and just makes sure no enquiry silently disappears.

How it works, step by step

1. You send us your enquiry channels on WhatsApp — which numbers customers message, whether you also get calls on a landline, and if you use Instagram or Facebook for the shop.
2. We set up the sheet or CRM (Google Sheets for most single-outlet pharmacies, Zoho CRM if you have 2+ branches or want automation triggers beyond what Sheets can do).
3. We connect your WhatsApp Business number so incoming messages get logged automatically, tagged by type — stock enquiry, delivery request, general question, price check.
4. We set up the follow-up reminder logic — for example, stock-out enquiries get a reminder tag for when that item is restocked, and chronic-medicine customers get a recurring monthly reminder.
5. Your staff gets a short walkthrough (15-20 minutes, over call or WhatsApp video) on how to check the daily "call today" list and mark enquiries as done.
6. The system runs quietly in the background — new WhatsApp enquiries auto-populate the sheet, no one needs to manually copy-paste chat screenshots.
7. You get a monthly report — how many enquiries, how many turned into sales, which items were asked for but not in stock, so you can decide what to add to your next order.

Here's what a logged conversation looks like in practice:

Customer: Hi, do you have Metformin 500mg, need 2 strips Bot: Yes, Metformin 500mg is available. Would you like home delivery or will you pick it up from the store?

Customer: Bhaiya insulin ka delivery ho sakta hai kya, thoda urgent hai Bot: Ji haan, delivery ho jayegi. Please apna address aur pin code bhej dijiye, hum 45 minute mein deliver kar denge.

Both of these get logged automatically — item asked, delivery or pickup, whether it converted — without your staff typing anything into a separate sheet.

A typical week, before and after

What it costs and what is included

The plain-terms version: if this setup helps you catch even one or two customers a month who would otherwise have gone to a competitor after an unanswered WhatsApp message — a regular reordering their monthly BP medicine, or a stock-out enquiry you'd have otherwise forgotten to follow up on — it typically pays for the care plan on its own. The rest is upside.

Setup timeline

Setups usually go live within 48 hours of a 20-minute call with you.

Day 0

You have a short call with us — mainly to tell us your WhatsApp Business number, whether you have multiple outlets, and what your busiest enquiry hours are (usually morning opening rush and evening 6-9 PM). We ask for a sample of the kind of enquiries you get most.

Day 1

We build the sheet or CRM structure, connect your WhatsApp number, and set up the follow-up and reminder logic for stock-outs and chronic medicine customers. We test it with a few sample enquiries.

Day 2

We do the staff walkthrough, hand over login access, and the system goes live. You start seeing your first "who to call today" list.

What you need to have ready

• Your WhatsApp Business number (or willingness to switch your enquiry number to WhatsApp Business if you're currently using a personal number)
• A rough list of your top 15-20 fast-moving or frequently asked-for medicines, so we can set up stock-out tagging correctly
• Names of 2-3 staff members who handle customer enquiries, so we know who needs access
• If you have chronic medicine customers you already track informally (a register, a diary), a rough list to seed the reminder system
• Access to your Google account (for Sheets) or Zoho account details, if you already have one

Doing it yourself vs done-for-you

If you're a single-outlet pharmacy with low WhatsApp volume and you enjoy maintaining your own systems, a spreadsheet you build yourself is genuinely fine. The done-for-you setup earns its cost once volume or staff turnover makes manual tracking unreliable.

Mistakes pharmacies make with this

• Using a personal WhatsApp number for the business. This blocks any automation and makes handover to new staff harder. Fix: move enquiries to a dedicated WhatsApp Business number.
• Tracking chronic medicine customers only in memory. Staff who "just remember" leave or get busy, and the customer quietly switches pharmacies. Fix: log every chronic medicine customer's reorder cycle, not just the ones you happen to recall.
• Not logging stock-out enquiries at all. If a customer asks for something you don't have and you don't write it down, you lose both the sale and the data on what to stock next. Fix: log it every time, even when it feels not worth the trouble.
• Multiple staff replying to the same enquiry differently. Without a shared log, two staff members can both promise different delivery times. Fix: one shared sheet, visible to everyone on shift.
• Treating the monthly report as optional. Owners who skip reviewing it miss the pattern of repeated stock-out requests that could justify a new stock line. Fix: spend 10 minutes on it each month — it's built specifically to surface this.

FAQ

Do I need Zoho CRM, or is Google Sheets enough?

For a single-outlet pharmacy with moderate enquiry volume, Google Sheets with automation is usually enough and keeps your monthly cost lower. If you run multiple branches or want more advanced automation triggers, Zoho CRM is the better fit — we'll recommend based on your call in Day 0.

Will this work with my existing WhatsApp Business number?

Yes, we connect to your existing number rather than asking you to create a new one, so your customers don't notice any change on their end.

What happens to stock-out enquiries once we restock an item?

They get flagged automatically so your staff can follow up with that specific customer once it's back — instead of relying on someone remembering who asked.

Can my staff use this without technical training?

Yes, the walkthrough is 15-20 minutes and focused on the daily "who to call" list — most pharmacy staff pick it up in one session since it doesn't require learning new software beyond WhatsApp and a sheet.

What if I want to stop the monthly care plan later?

You can stop any month with no penalty. The sheet or CRM stays yours, along with all the logged data — there's no lock-in.

Does this replace my billing or inventory software?

No, it sits alongside whatever billing system you already use. It's focused purely on enquiries, follow-ups, and customer tracking, not billing or stock management.

Next step

Send us on WhatsApp: your pharmacy name, city, and what's leaking right now — missed WhatsApp enquiries, forgotten chronic medicine reorders, or lost stock-out follow-ups. Message us here: WhatsApp.

See the full setup details on the offer page, or read how we work before you decide.