No prescription lost in compounding
Log WhatsApp prescriptions, track compounding status and notify customers when orders are ready, using Google Sheets and WhatsApp.
These are examples. Connect the tool your company already uses for the same job, your own system, or any other app through MCP or API.
Needs
- SpreadsheetGoogle Sheets, Excel, Airtable or your own system (MCP or API)
- MessagingWhatsApp, Instagram, Telegram, website chat or your own system (MCP or API)
The problem and the goal
Organizes prescriptions that arrive on WhatsApp, tracks compounding status and notifies the customer when a prescription is ready.
The team turns every prescription that arrives on WhatsApp into a record with number, customer, formula, quantity and deadline, using the WhatsApp Business API and Google Sheets. A board keeps each prescription's status (received, compounding, ready, delivered) and sends the person in charge a summary every morning. When a prescription is ready, the customer gets a WhatsApp message, and a weekly report shows intake, deliveries, delays and average compounding time.
The team in this Circle
Turns every prescription that arrives on WhatsApp into a record with number, customer, formula, quantity and deadline.
Keeps the status board for each prescription (received, compounding, ready, delivered) and sends the morning summary.
Messages the customer on WhatsApp when a prescription is ready and follows up on delayed ones.
Closes the week with how many prescriptions came in, how many were delivered, how many were late and the average compounding time.
No prescription lost in compounding
How do I stop prescriptions from getting lost in the pharmacy's WhatsApp?
Each prescription becomes a record with number, customer, formula, quantity and deadline, and gets a visible status. What still needs compounding no longer depends on a whiteboard or memory.
Can customers be notified automatically when a compound is ready?
Yes. The team sends a WhatsApp message when a prescription moves to ready and also follows up on delayed ones, using the data stored in the sheet.
How can I see how many prescriptions were delayed this week?
The weekly report consolidates how many prescriptions came in, how many were delivered, how many were late and the average compounding time, based on the records in Google Sheets.
