The problem
A veterinary clinic vaccinates a dog, and the annual booster date passes unnoticed a year later. Owners simply forget; animals miss protection and the clinic loses its most natural repeat visit.
The solution, step by step
- After each visit, the assistant logs in Google Sheets: owner, phone, animal, act performed, next due date (booster, rabies, antiparasitic).
- A Zapier zap scans the sheet daily for dates at J-14 and J-3.
- The owner receives a WhatsApp Business message naming the pet — "Rex is due for his rabies booster" — with two proposed slots.
- Confirmations write into the clinic calendar; a reminder fires the day before.
- Seasonal campaigns (tick treatments before summer) reuse the same file with one filtered send.
- 50 to 70% of reminded owners book the visit.
- Vaccination follow-up becomes a steady revenue base for the clinic.
- Owners perceive real care continuity — the strongest loyalty driver in this business.