Shata Solutions
← Back to marketplace
Healthcare

Prescription Reminder

Medication adherence reminders with refill alerts synced to pharmacy dates.

Automation overview

What this automation does

This automation starts when prescription added to patient record with frequency and end date. It whatsapp scheduled, then daily morning for chronic meds, refill alert 7 days before end with pharmacy phone click-to-call link, missed 3 days adherence flags nurse outreach task, patien.

Trigger
Prescription added to patient record with frequency and end date
Main actions
WhatsApp scheduled
Final outcome
daily morning for chronic meds, refill alert 7 days before end with pharmacy pho…
Execution time
30–90 seconds
Apps used
2 integrations
AI-powered
No
Difficulty
Intermediate
Intermediate
Workflow diagram

End-to-end scenario flow

Read-only visualization of how data moves from trigger to final result.

Trigger
Google Sheets
Event detected
Step 1
WhatsApp
Scheduled
Result
WhatsApp
Workflow complete
Step-by-step

How each step runs

  1. 1
    Google SheetsTrigger
    Event detected

    Prescription added to patient record with frequency and end date

  2. 2
    WhatsApp
    Scheduled

    Provider adds prescription end date and frequency to Sheets patient record triggers scheduled WhatsApp reminders

  3. 3
    WhatsApp
    Workflow complete

    daily morning for chronic meds, refill alert 7 days before end with pharmacy phone click-to-call link, missed 3 days adherence flags nurse outreach task, patien

Apps used

Connected applications

Google Sheets

Scheduled

WhatsApp

Scheduled

Summary

Automation summary

Trigger
Prescription added to patient record with frequency and end date
Inputs
Prescription added to patient record with frequency and end date, Business Name, Notification Email, Timezone
Outputs
daily morning for chronic meds, refill alert 7 days before end with pharmacy phone click-to-call link, missed 3 days adherence flags nurse outreach task, patien, WhatsApp scheduled
Business goal
Automate prescription reminder end-to-end with accurate app routing.
Execution frequency
Real-time on event
Estimated runtime
30–90 seconds
Error handling
Failed steps retry up to 3 times with exponential backoff; persistent failures notify your configured channel and log to the run history.
Dependencies
Google Sheets, WhatsApp
Benefits

Why use this automation?

Save ~2 hours/week

Remove repetitive steps from Prescription Reminder so your team focuses on high-value work.

Reduce manual work

Connected apps sync data automatically instead of copy-paste between dashboards.

Prevent human errors

Standardized logic runs the same way every time, with retries on failure.

Requirements

What you need to get started

Required apps

  • Google Sheets
  • WhatsApp

Required accounts

  • Active Google Sheets workspace with API access
  • Active WhatsApp workspace with API access
  • Shata Automation workspace (free tier supported)

Required API keys

  • OAuth tokens for each connected integration

Permissions

  • Read access on trigger sources (forms, sheets, webhooks, or CRM objects)
  • Write access on destination apps (email, chat, CRM, or storage)

Estimated setup time

  • 45 min including app authorization and test run
  • Difficulty: Intermediate

Automation runtime

Activate this template

Live

Connect required apps via OAuth or API keys. Credentials are encrypted server-side. Dev test runs mock external actions when connections are missing.

Draft
0%
Activation readiness

Est. setup time: ~3 min

Required connections

  • Google Sheets(required)
    Missing
  • Missing connection: Google Sheets
Manage all connections →View all installations →

Workflow summary

Trigger
Prescription added to patient record with frequency and end date
Steps
3 nodes
Required apps
1
Optional apps
1

Trigger

Manual trigger

Run workflows on demand via Test run or Live test. Activate to enable scheduled/webhook triggers on other templates.

Run history

No runs yet. Install the template and run a test, or activate to receive webhook/schedule runs.

FeaturedFreeIntermediateLive45 min setup4.57.9k installs · 393 reviews
Customize for My Business
Analytics

Template performance

16.4k
Views
7.9k
Installs
360
Favorites
4.5
Avg rating
48%
Conversion
45 min
Setup time
96%
Success rate
83
Trending score
Most used integrations
Google SheetsWhatsApp

Provider adds prescription end date and frequency to Sheets patient record triggers scheduled WhatsApp reminders—daily morning for chronic meds, refill alert 7 days before end with pharmacy phone click-to-call link, missed 3 days adherence flags nurse outreach task, patient reply `TAKEN` logs adherence.

Required apps
Google SheetsLive
Optional apps
WhatsAppPreview
All integrations
Google SheetsWhatsApp
Workflow preview

How Prescription Reminder runs

1
Trigger
Configure reminder schedule
2
Process
Rule engine
3
Action
google-sheets
4
Notify
Alert & log
Google SheetsWhatsapp
Setup steps

Get started in 5 steps

  1. 1
    Connect patient records

    Sheets/EHR prescriptions, Twilio WhatsApp, Slack nursing tasks.

  2. 2
    Configure reminder schedule

    QD, BID, TID timing from frequency code; timezone patient locale.

  3. 3
    Track adherence

    TAKEN replies log; silent days trigger nurse review.

  4. 4
    Refill workflow

    7-day alert includes pharmacy map link and reorder script request form.

  5. 5
    Test BID schedule

    Two daily messages fire on correct times 7 days.

Variables

Configurable settings

VariableTypeDefaultRequired
Business NametextYour BusinessYes
Notification EmailemailYes
TimezoneselectYes
Google Sheet IDtextNo
Sheet RangetextSheet1!A:ZNo
FAQ

Frequently asked questions

Controlled substances?

No dose details in message body; generic take medication reminder.

Caregiver proxy?

Caregiver phone receives reminders for pediatric geriatric patients.

Drug interactions?

Workflow does not clinical check; provider responsibility at prescribe.

Multi-language?

Arabic reminder templates available.

Get started

Customize Prescription Reminder for your business

Our team can adapt this template to your exact workflow, apps, and brand requirements.