Google Sheets CRM for Eye Clinic: Stop Losing Follow-Ups
A Google Sheets CRM for eye clinic owners: capture every enquiry, automate follow-up reminders, and never miss a lens or surgery callback again.
It's 6:40 PM at the clinic. The optometrist has just finished the last refraction test, the front desk girl is closing the day's cash register, and somewhere in a WhatsApp chat from Tuesday, a patient is still waiting to hear whether their progressive lenses have arrived. Nobody remembers to check. The patient calls a competitor.
This is the ordinary way eye clinics lose money — not through big mistakes, but through enquiries that fall between a WhatsApp chat, a paper OPD register, and someone's memory. A cataract-surgery lead who asked about IOL pricing on Monday gets no call back by Thursday. A frame trial customer never gets told their order has arrived. None of this shows up as a "problem" until you tally how many people who called never became patients.
A google sheets crm for eye clinic use fixes exactly this leak — it is not a hospital management system, it is one place where every enquiry, patient, and pending follow-up lives, with automation nudging staff on who to call today. This guide walks through what it does, what it costs, and how it goes live in your clinic within 48 hours. Bharat AI Saathi builds these for opticals and eye hospitals across India.
What a CRM Setup actually does for a Eye Clinic
Strip away the jargon and here is what changes on the ground:
- Every channel lands in one sheet. Walk-in enquiries written down by the front desk, Instagram DMs asking "sir cataract surgery cost kitna hai," missed calls from the reception landline, and Google Business Profile messages — all get logged as one row each, instead of living in four different places.
- Follow-ups don't depend on memory. When someone asks about progressive lenses or asks to "think about it," the system tags a follow-up date. Staff get a WhatsApp or sheet-highlight reminder that morning, so "I'll call you back" from the doctor actually happens.
- Lens and surgery pipeline stages are visible. A lead moves from Enquiry → Eye Test Booked → Prescription Given → Lens Ordered → Delivered, or for surgical cases, Consultation → Pre-op Tests → Surgery Scheduled → Post-op Review. Anyone at the front desk can see where a patient is stuck.
- Repeat questions get answered without repeating them. "What's your frame price range," "do you have anti-glare lenses," "is Dr. available on Sunday" — these get auto-replied on WhatsApp/Instagram so the optometrist isn't interrupted mid-examination.
- A weekly view of what's pending. Instead of the manager asking "kitne log follow-up mein pending hain," the report tells them.
How it works, step by step
- Enquiry comes in — via WhatsApp Business number, Instagram, missed call, or a walk-in the receptionist logs manually.
- It's captured as a row in the Google Sheet (or Zoho module) automatically — name, phone, source, what they asked about, date.
- A first response goes out for common queries (fee, timings, lens brands stocked) without staff typing the same answer for the fifth time that day.
- The enquiry gets tagged with a stage — new lead, test booked, quote given, surgery scheduled, or lost.
- A follow-up date is set, either by staff or automatically (e.g., 3 days after "will think about it," 1 day after surgery for post-op check).
- Reminders fire each morning — the person responsible sees a short list: "Call these 6 people today."
- A monthly pipeline report shows enquiries by source, how many converted, how many are stuck, and where drop-offs happen — useful when deciding whether to spend more on Instagram ads or on walk-in signage.
Customer: Hi, I wanted to know the cost of cataract surgery with a premium lens Bot: Hello! Cataract surgery cost depends on the lens type — monofocal, multifocal, or toric. Our team can share exact pricing after a quick eye check. Would you like to book a consultation this week?
Customer: Bhaiya progressive lens ka price kya hai, aur kitne din mein ban jayega Bot: Progressive lenses ka price brand aur power ke hisaab se vary karta hai, generally 2 din mein ready ho jaate hain. Aap eye test ke liye kab aa sakte hain?
A typical week, before and after
| Situation | Before | After |
|---|---|---|
| Instagram DM asking lens price | Seen at night, replied next day if remembered | Auto-reply same minute, lead logged with source tagged "Instagram" |
| Patient said "I'll think about it" | Forgotten unless doctor happens to recall | Follow-up reminder appears 3 days later on the sheet |
| Post-op review due | Depends on patient remembering to come | Reminder call list includes them a day before |
| Manager asks "how many enquiries this month" | Guesswork from memory and paper register | Pulled straight from the monthly pipeline report |
| Front desk staff on leave (chhutti) | Enquiries written on loose paper, some lost | Same sheet accessible to anyone covering that day |
| Frame stock delivery arrives | Customer not informed unless someone remembers | Stage moves to "Delivered — call to collect," shows in daily list |
What it costs and what is included
| Item | Price | Notes |
|---|---|---|
| CRM setup (Google Sheets or Zoho) | ₹15,000 one-time | Includes lead capture, pipeline stages, follow-up automation |
| Monthly care plan | ₹2,500/month | Upkeep, tweaks, monthly pipeline report, support |
| Platform charges (Meta/Google/telecom) | Billed separately | WhatsApp API costs, ad spend, SMS/call charges as applicable |
| Lock-in | None | You can stop the care plan any month; the sheet and data remain yours |
The setup fee is a fixed one-time cost, and the monthly plan is optional upkeep, not a subscription trap. In plain terms — if it recovers even one cataract-surgery enquiry or one lens order a month that would otherwise have been forgotten, it has usually paid for itself. Everything else after that is just fewer things falling through the cracks.
Setup timeline
Day 0
You have a 20-minute call with us. We ask about your enquiry channels (WhatsApp number, Instagram, walk-ins), your typical patient journey (eye test → prescription → lens/surgery), and who on your staff will own follow-ups.
Day 1
We build the sheet or Zoho structure, connect your WhatsApp/Instagram, and set up the automated first-responses for your most common questions (fees, timings, lens brands, doctor availability).
Day 2
We test it with a few real enquiries alongside you, hand over access, and show your front desk staff how the daily follow-up list works. It's live.
What you need to have ready
- Your clinic's WhatsApp Business number (or willingness to set one up)
- A list of your 8-10 most repeated customer questions (fee ranges, lens brands stocked, doctor's OPD days)
- Names of staff who will handle daily follow-ups — usually the front desk and one optometrist
- Your current enquiry sources (Instagram, Google listing, walk-ins, referrals)
- Rough stages your patients go through (test → prescription → lens order, or consultation → surgery → post-op)
- Access to your Google account or Zoho login, if you already use one
Doing it yourself vs done-for-you
| Approach | Time cost | Common failure point | Our setup |
|---|---|---|---|
| Paper register + memory | Low upfront, high daily cost | Lost slips, staff on leave means gaps, no follow-up trigger | Sheet accessible to anyone, follow-ups auto-flagged |
| Plain Google Sheet, self-built | A few hours to set up | No reminders, no auto-reply, breaks when columns get renamed | Structured with automation and reminders built in |
| Generic CRM software (off-the-shelf) | Days of configuration, ongoing learning curve | Built for generic sales teams, not lens/surgery-stage workflows | Configured specifically around eye clinic patient stages |
| WhatsApp Business app alone | Minimal setup | No pipeline view, no report, replies still manual | Auto-replies plus a sheet tracking every stage |
If you're a small single-doctor practice with low enquiry volume, a well-kept paper register or a manually maintained sheet might genuinely be enough — this setup earns its cost once enquiry volume or staff turnover makes memory unreliable.
Mistakes eye clinics make with this
- Logging enquiries only when "free." Fix: capture at the point of contact — an Instagram auto-log, not an end-of-day memory dump.
- Treating all leads the same. Fix: separate "just browsing frame prices" from "wants cataract surgery quote" — the second needs faster follow-up.
- No owner for follow-ups. Fix: assign one specific person (usually front desk) to check the daily reminder list, not "whoever is free."
- Forgetting post-op patients. Fix: set an automatic reminder tied to surgery date, not manual recall.
- Switching staff without handover. Fix: since the sheet is shared, cover staff on chhutti days can see pending follow-ups without asking around.
FAQ
Will this replace our existing patient records or EMR?
No. This is for enquiries and follow-ups — leads, pipeline, and reminders. Your clinical records and EMR stay separate; we don't touch medical data.
Can it handle both lens/optical customers and surgical patients differently?
Yes. We set up separate pipeline stages for optical sales (test → prescription → lens order) and surgical cases (consultation → pre-op → surgery → review), since their follow-up timing is very different.
What if our front desk staff aren't comfortable with computers?
The sheet is deliberately kept simple — rows and columns, no new software to learn. We train your staff during the Day 2 handover, and the care plan includes ongoing support if something's confusing.
Do we need Zoho, or is Google Sheets enough?
Google Sheets works well for most single-branch clinics. Zoho makes sense if you have multiple branches or need more advanced permissions — we recommend based on your call on Day 0.
What happens if we stop the monthly care plan?
You keep the sheet and all your data — there's no lock-in. The care plan covers upkeep, tweaks, and the monthly report, but the CRM itself remains usable without it.
How is this different from just using WhatsApp Business's built-in labels?
WhatsApp labels don't survive a phone change, don't generate reports, and don't handle Instagram or walk-in enquiries in one place. This setup consolidates all your channels and adds automated reminders on top.
Next step
Message us on WhatsApp with your clinic name, city, and one sentence on where enquiries are currently leaking — Instagram, walk-ins, or follow-ups.
See the full scope on the offer page, and check how we work if you want to understand our process before the call.
CRM Setup & Automation for eye clinics
Platform charges billed to you directly. No lock-in. Live within 48 hours once your platform access and Meta verification are complete (Meta verification typically takes 3 to 10 business days). Global systems: 2 to 14 days.