All templates

Automated Zoobook Program Fee Reminders

Every Monday, WebRun opens Zoobook Systems, finds patients behind on their weekly or daily program fee, logs each balance and days overdue to a Google Sheet, and drafts a short payment reminder text through Twilio for billing staff to review and send, so no patient gets an unreviewed message about their balance.

Runs on WebRun · Strict Lockdown policy
Every Monday at 9:00 AM WebRunorchestrates each step
1 Zoobook Systems find patients behind on fees
2 Google Sheets log balances and days overdue
3 Twilio draft the payment reminder text
In short

How do I follow up on overdue opioid treatment program fees?

WebRun checks Zoobook Systems every Monday for patients behind on their program fee, logs the balance and days overdue to a Google Sheet, and drafts a short payment reminder text through Twilio for billing staff to review. Nothing is sent automatically, so every patient facing a balance conversation gets a message a human actually approved first.

  • Overdue balances are logged every Monday instead of at month end
  • Patients on an approved payment plan are never sent a reminder
  • No payment reminder reaches a patient without billing staff approval

Built for OTP billing staff · methadone clinic office managers · OTP program directors · cash pay clinic administrators

Step by step

What does WebRun do on every run?

The exact actions WebRun takes, in order - in plain language, so you can adjust anything.

  1. WebRun signs in and gets to work

    Opens app.zoobooksystems.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    Zoobook Systems - find patients behind on fees
    zoobooksystems.com
    WebRun in Zoobook Systems: find patients behind on fees
    WebRun opens Zoobook Systems to find patients behind on fees.
    • Open Zoobook Systems and pull the active patient roster with fee balances
    • Filter for patients behind on their weekly or daily program fee
    • Capture the balance owed and days overdue for each
    • Exclude anyone on an approved payment plan or fee waiver

    Done when Every patient behind on their program fee is listed with balance and days overdue.

  3. 2
    Google Sheets - log balances and days overdue
    google.com
    WebRun in Google Sheets: log balances and days overdue
    WebRun opens Google Sheets to log balances and days overdue.
    • Open the Program Fee Balance tracker
    • Add a row for each overdue patient with balance, days overdue, and payment plan status
    • Sort by balance, largest first

    Done when The tracker reflects this week's full overdue balance list, sorted by size.

  4. 3
    Twilio - draft the payment reminder text
    twilio.com
    WebRun in Twilio: draft the payment reminder text
    WebRun opens Twilio to draft the payment reminder text.
    • Draft a short, polite payment reminder text for each overdue patient
    • Leave every reminder unsent in the queue for a staff member to review
    • Never send a reminder on its own. billing staff must approve and send it

    Done when A draft reminder text is queued for every overdue patient, with none sent automatically.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
app.zoobooksystems.com
ScheduleRuns automatically on this cadence
Every Monday at 9:00 AM
DeliveryHow each run's result reaches you
Balance list · Google Sheets
OutputWhat each run produces - A Google Sheet row per overdue balance and a draft payment reminder text queued in Twilio for staff review.
Spreadsheet + draft text
Setup & safety

Secure by default

Connect once, stays signed in

WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.

Your credentials stay in your own private environment - WebRun never stores your passwords.
Strict Lockdown

Every action is checked against this policy before it runs.

Domains ALLOWLIST
Typed input ALLOW
Shell command BLOCK
File uploads BLOCK
Runs in a contained environment More on policies
Good to know

Questions, answered

Will it text patients about their balance without approval?

No. WebRun only drafts the payment reminder text in Twilio and leaves it unsent. Billing staff review and send every reminder, so no patient gets a message on its own.

Does it exclude patients already on a payment plan?

Yes. Anyone with an approved payment plan or an active fee waiver on file in Zoobook Systems is excluded from the overdue list and never gets a reminder drafted.

What if a patient paid over the weekend?

It reads the live fee balance in Zoobook Systems each Monday, so anyone who already paid drops off the overdue list and no reminder is drafted for them.

Put this on autopilot.

Turn it on in minutes - or have our team set it up for you.