Google Sheets CRM for Pharmacy: Stop Losing Enquiries on WhatsApp

It's 7:40 PM. Your counter has three walk-ins waiting for billing, your compounder is checking stock for an insulin brand, and your phone buzzes with a WhatsApp message: "Do you have Telma 40? Need for my father, urgent." You glance at it, mean to reply in two minutes, and then a customer at the counter asks about a substitute for a Cipla brand that's out of stock. By the time you look back at WhatsApp, four more messages have stacked up — a repeat customer asking if their monthly diabetes strip refill is ready, someone asking about home delivery for an elderly parent, a query about a Covaxin-era leftover thermometer warranty. Some of these you'll answer tonight. Some you won't remember by morning.

This is the leak. Not lost stock, not billing errors — lost enquiries that never got a reply, or got a reply so late the customer bought from the pharmacy next door. For a pharmacy doing decent walk-in volume plus a WhatsApp/phone tail, this usually means a handful of missed follow-ups every week: repeat medicine orders that quietly move to a competitor, home-delivery requests that never got confirmed, availability questions left on "seen" during rush hour. A google sheets crm for pharmacy fixes exactly this — it captures every enquiry the moment it comes in, tags what medicine or service it's about, and reminds you who still needs a callback today, instead of relying on memory or a notebook by the billing counter.

This guide walks through what such a setup actually does for a pharmacy, how it works from the customer's first message to your daily follow-up list, what a typical week looks like before and after, the exact cost, and the mistakes most pharmacy owners make when they try to solve this themselves. If you want to see the packaged version of this, it's on our offer page.

What a CRM Setup actually does for a Pharmacy

For a pharmacy, "CRM" doesn't mean a sales pipeline with deal stages — it means never losing track of who asked what and whether you replied. Concretely, the setup gives you:

• One inbox for every channel. WhatsApp Business messages, missed calls, and Google/Justdial enquiry form submissions all land as rows in one sheet (or Zoho CRM if you prefer a proper app), instead of living in three different apps.
• Auto-tagging by query type. "Do you have X" becomes an availability query, "can you deliver" becomes a delivery request, "when will my order be ready" becomes a pickup follow-up. This matters because a pharmacy's queries are repetitive and predictable — you're not guessing at categories, you're capturing the same 6-7 question types your counter staff already hear every day.
• Repeat-customer recognition. Someone who orders the same BP or diabetes medication monthly gets flagged, so when they message again on day 25-28 of their cycle, your staff already knows it's a refill, not a fresh enquiry.
• A daily call-back list. Every morning (or at shift start), whoever's manning the counter sees a short list: "these 4 people are still waiting for a reply, these 2 orders need a delivery confirmation."
• A monthly pipeline report. How many enquiries came in, how many converted to a sale, how many went cold — useful when you're deciding whether to add a delivery boy or extend WhatsApp hours during a dengue/flu season spike.

None of this replaces your billing software or your stock system. It sits next to them, focused purely on "did this person get answered."

How it works, step by step

1. Customer messages your pharmacy — on WhatsApp, a missed call, or a Google Business enquiry form. This is the only channel; no new app for the customer to learn.
2. The message auto-logs into your CRM sheet with timestamp, customer number, and the message text — before anyone at the counter even sees it.
3. A quick auto-reply goes out acknowledging the message so the customer knows they've been received, even during a rush.
4. The query gets tagged — availability, delivery, refill, general — based on keywords in the message.
5. Your staff replies from the same WhatsApp number as usual; the reply and status (answered/pending) update in the sheet automatically.
6. Unanswered queries older than your set window (say 30 minutes) trigger a reminder to whoever's assigned as the follow-up person for that shift.
7. Each morning, the shift-in-charge opens the sheet (or Zoho dashboard) and sees a short list of pending items and today's expected refill customers — that's the daily operating rhythm.

Here's what a real exchange looks like once this is running:

Customer: Do you have Glycomet SR 500 available? Need 2 strips. Bot: Yes we usually stock this. Please confirm and our pharmacist will hold 2 strips for pickup or arrange delivery — reply with your address if delivery needed.

Customer: Bhaiya paracetamol ka syrup hai bacche ke liye? Ghar pe deliver ho sakta hai kya, main bahar hoon abhi Bot: Haan available hai. Address bhej dijiye, hum 1 ghante mein deliver kar denge. Cash ya UPI dono chalega.

Neither of these replaces your pharmacist's professional judgment on medicine — the bot only handles logging, acknowledgment and routing. The actual medical conversation still happens with your staff.

A typical week, before and after

What it costs and what is included

The payback logic here is simple, not projected: if this setup helps you catch even one or two refill customers a month who'd otherwise have quietly switched to a nearby pharmacy, or one delivery request that doesn't get missed during a rush, the ₹2,500/month is already justified. You're not buying growth — you're buying against a leak you already know exists.

Setup timeline

Day 0

You have a 20-minute call with us. We ask about your WhatsApp number, current enquiry volume, staff shift pattern, and what query types you get most (availability, delivery, refills). You don't need to prepare anything technical — just be ready to describe your busiest hours.

Day 1

We build the sheet or Zoho instance, set up the WhatsApp/call/form integrations, and configure the tagging rules based on your actual query types. You review a test version and flag anything that doesn't match how your pharmacy actually operates.

Day 2

The system goes live. We do a short walkthrough with whoever will check the daily list (usually the shift-in-charge or owner), and monitor the first day's real messages to catch any tagging misses.

What you need to have ready

• Your WhatsApp Business number (the one customers already message)
• A rough list of your 5-6 most common customer questions (availability, delivery radius, timings, refill process)
• Names of staff who'll check the daily follow-up list each shift
• Your usual delivery area/radius, if you offer home delivery
• Login access to your Google Business listing, if enquiries come through there too
• Roughly how many WhatsApp/call enquiries you get on a normal day vs. a busy day (season, month-end, etc.)

Doing it yourself vs done-for-you

DIY is genuinely fine if you're a small, single-owner pharmacy with low WhatsApp volume and you personally check every message. It stops working once you have shift staff, multiple channels, or enough volume that things fall through during rush hours.

Mistakes pharmacies make with this

• Treating WhatsApp as informal and not worth tracking. Fix: log it like any other sales channel — it's often your highest-intent channel since customers only message when they need something specific.
• No handover process between shifts. Fix: make the pending-queries list part of the shift handover, not an afterthought.
• Tagging too many categories. Fix: stick to 5-6 real categories that match how your customers actually ask questions, not a generic CRM template.
• Ignoring the monthly report. Fix: actually look at answered-vs-pending trends once a month — it tells you if you need another person on WhatsApp duty during peak hours.
• Assuming automation replaces the pharmacist's advice. Fix: the bot only logs and acknowledges; medicine-specific conversations still go through your staff.

FAQ

Does this work with my existing WhatsApp Business number?

Yes. You keep the same number your customers already have saved; we connect it to the CRM in the background so nothing changes from the customer's side.

Will this replace my billing or stock software?

No. This is purely for enquiry and follow-up tracking. It sits alongside your existing billing/stock system without touching it.

What if I get very few WhatsApp enquiries — is this worth it?

If your enquiry volume is genuinely low and one person handles everything personally, a simpler setup or even DIY may suffice. This setup pays off once you have shift staff or enough volume that things get missed.

Can I switch from Google Sheets to Zoho CRM later?

Yes. We can migrate your data across if your needs grow — there's no lock-in either way.

Who pays for the WhatsApp API or Meta charges?

Those are billed directly to you by Meta/Google/telecom based on your usage; our setup fee and care plan don't include those charges.

What happens if I stop the monthly care plan?

The sheet or CRM stays yours and keeps working; you just won't get ongoing monitoring, tagging adjustments, or the monthly report from us.

Next step

Message us on WhatsApp with three things: your pharmacy's location (city), your rough daily enquiry volume, and where you feel enquiries are slipping through (WhatsApp rush hours, missed calls, refill follow-ups). See the full scope on the offer page or check how we work before you decide. Reach out directly at WhatsApp.