Eye Clinic Lead Tracking Sheet: Stop Losing Enquiries

It's 11:40 am. The receptionist at the front desk is checking in a walk-in for a cataract consult, the phone rings twice and goes to voicemail, and a WhatsApp message pings on the doctor's personal number asking "sir progressive lens price kitna hai?" Nobody replies to the WhatsApp for six hours because it's buried under three other chats. By evening, that enquiry is gone — not lost on purpose, just lost in the gap between the front desk register, the phone, and WhatsApp.

This is the ordinary cost of not having an eye clinic lead tracking sheet that actually works across all three channels. It's not one big leak — it's five or six small ones a day, every day, across walk-ins, calls, WhatsApp, and Google/Meta ad enquiries. Over a month that adds up to real consults and real lens/frame sales that simply never got a callback. Bharat AI Saathi builds a fixed-scope CRM setup for eye clinics specifically to close this gap.

This guide covers what the setup actually does, how it works day to day, what a week looks like before and after, the exact cost, the 48-hour timeline, and where clinics usually go wrong trying to fix this themselves.

What a CRM Setup actually does for a Eye Clinic

At its core, this is one sheet (or Zoho CRM, if you prefer that over Sheets) that every enquiry lands in, no matter where it came from — a phone call your receptionist logs, a WhatsApp enquiry, a Meta ad lead form for your cataract or LASIK camp, or a Google Ads click from someone searching "eye specialist near me."

Specifically, it does four things:

• Pulls in leads automatically from your WhatsApp Business number, Meta lead ads, and Google Ads forms — no manual copy-pasting from ad dashboards into a register.
• Tags each enquiry by what it's actually about: cataract consult, LASIK enquiry, routine eye check-up, spectacle/lens purchase, or contact lens follow-up. This matters because a cataract lead needs a callback within hours, while a spectacle price enquiry can wait a day.
• Sends follow-up reminders to whoever's assigned — front desk, optometrist, or the doctor — so "I'll call them back" doesn't quietly become "I forgot."
• Generates a monthly pipeline report showing how many enquiries came in, how many converted to appointments, and where they dropped off (a lot of clinics discover most drop-off happens between "enquiry" and "appointment booked," not after the consult).

The point isn't a fancier spreadsheet. It's that the sheet becomes the single place your staff checks instead of three different apps.

How it works, step by step

1. Enquiry comes in on WhatsApp, a missed call, a walk-in, or an ad form (Meta/Google).
2. It lands automatically in the CRM row with name, number, source, and a first-guess tag (cataract, LASIK, routine check-up, glasses/lens).
3. A bot or your front desk replies on WhatsApp to answer the routine stuff — fees, timings, whether a doctor's available today — so patients get a fast answer even if staff are busy with an in-person patient.
4. Anything needing a human judgment call gets flagged — a cataract enquiry, an insurance/cashless question, a complaint — and routed to the right person with a reminder.
5. Follow-up reminders fire at set intervals (say, next morning if no response same day) so nobody falls off the list.
6. Staff work from the sheet each morning — it shows "call these 8 people today," not a scroll through yesterday's WhatsApp chats.
7. Monthly report goes out showing enquiry volume, conversion to booked appointment, and where the drop-off is heaviest — usually between enquiry and booking, not after.

Customer: Hi, I want to know the cost of cataract surgery, both eyes Bot: Hello! Cataract surgery cost depends on the lens type you choose — monofocal, multifocal, or toric. Our team will call you within the hour to explain the options and book a free consultation. Could you share your preferred date for a check-up?

Customer: Doctor available hai kya aaj? Beta ki eye checkup karani hai, thoda squint jaisa lag raha Bot: Ji haan, doctor aaj shaam 5 baje tak available hain. Squint check-up ke liye hum aapko slot confirm kar dete hain — kripya bacche ki age bata dijiye taaki sahi doctor assign ho sake.

A typical week, before and after

What it costs and what is included

The way to think about payback: if this recovers even one cataract or LASIK enquiry a month that would otherwise have gone cold, the ₹2,500 monthly care plan is already worth it — those are high-value consults, not spectacle sales. Everything else the sheet catches after that is a bonus, not the justification.

Setup timeline

Day 0

You have a 20-minute call with us. We ask about your current channels (WhatsApp number, whether you run Meta/Google ads, how walk-ins are currently logged) and your staff structure — who answers WhatsApp, who's at the front desk, whether the doctor wants to be looped in directly for cataract/LASIK leads.

Day 1

We build the sheet or Zoho instance, connect your WhatsApp Business number and ad accounts, set up the lead tags (cataract, LASIK, routine check-up, glasses/lens, contact lens), and configure the bot's first-response answers using your actual fee ranges and timings.

Day 2

We walk your front desk and optometrist through the sheet live — how to update status, how reminders show up, how to read the pipeline view. The system goes live. You run it for real that day with us watching for anything that misfires.

What you need to have ready

• Your WhatsApp Business number (not a personal number, if possible — makes automation cleaner)
• Login access to your Meta Ads Manager and Google Ads account, if you run enquiry ads
• A rough fee list — consultation charge, cataract surgery (by lens type), LASIK, common frame/lens price ranges — so the bot answers correctly instead of guessing
• Names of staff who'll use the sheet daily (front desk, optometrist, doctor if involved)
• Your current method of tracking walk-ins (register, notebook, nothing) so we know what we're replacing
• Clinic timings, including which days the doctor is off, so the bot doesn't book appointments on a chhutti

Doing it yourself vs done-for-you

If you're a single-doctor clinic getting five enquiries a week, a well-kept notebook plus a shared spreadsheet can genuinely be enough — don't over-engineer it. The DIY route stops working once you're running ads, have more than one staff member touching enquiries, or the doctor keeps asking "how many cataract leads did we get this month" and nobody has a clean answer.

Mistakes eye clinics make with this

• Treating WhatsApp as the CRM. Chats scroll, get buried under family messages if it's a personal number, and nobody can pull a report from a chat thread. Fix: route WhatsApp leads into the sheet automatically, keep chat as the conversation, not the record.
• Not tagging urgency at the point of entry. A cataract enquiry and a "what are your timings" question look the same in an untagged list. Fix: tag by enquiry type immediately so high-value leads surface first.
• One person owning all follow-ups. When that staff member is on leave, the whole pipeline stalls. Fix: assign leads in the sheet so anyone can pick up where someone left off.
• Running ads without connecting them to anything. Meta lead form data sits in Ads Manager and nobody checks it for days. Fix: auto-pull ad leads into the same sheet as walk-ins and calls.
• No monthly review of what's actually converting. Clinics keep spending on ads for LASIK camps without knowing if those leads ever booked a consult. Fix: use the pipeline report monthly, not just to track volume but conversion.

FAQ

Will this replace my receptionist?

No. It replaces the scattered notebook-plus-WhatsApp-plus-memory system your receptionist is currently forced to juggle. The bot handles repeat questions like fees and timings; your staff still handle the actual conversations that need judgment, like a nervous patient asking about surgery risks.

Can it work with Zoho if we already use it for something else?

Yes — we set the CRM up inside Zoho if you prefer that over Google Sheets, especially if you're already using Zoho Books or another Zoho product. If you're starting from scratch, Sheets is usually simpler for a small clinic team to adopt quickly.

What happens to leads from Meta or Google ads specifically?

They're pulled automatically from your ad account's lead forms into the same sheet as every other enquiry, tagged by campaign so you can see which ad actually drives bookings, not just clicks.

Do you manage our ad spend too?

No — we set up the automation and lead capture. Ad spend and campaign management on Meta/Google are billed and run separately; ask us if you want a referral for that side.

What if we stop the monthly care plan?

The sheet, the setup, and everything captured in it stay yours — there's no lock-in. You'd lose ongoing reminder upkeep and the monthly report, and you'd need someone in-house to maintain the automations if a channel connection breaks.

How is this different from just hiring one more front-desk person?

A person can get sick, forget, or leave. The sheet doesn't forget a follow-up date, and it works the same whether one staff member is out or the clinic is short-staffed during a busy season like winter cataract season.

Next step

Send us on WhatsApp: your clinic type and city, and what's currently leaking — missed WhatsApp replies, ad leads nobody follows up, or walk-ins that never get logged. Message us here: https://wa.me/917735268199

See the full offer details at the CRM Setup & Automation for Eye Clinics page, or read how we work before the call.