All templates

Automated Fusion Web Clinic OT No-Show Report

Every evening, WebRun opens Fusion Web Clinic, finds all no-shows and cancellations from today's OT schedule, and logs them to a Google Sheet with patient name, therapist, appointment time, and cancellation reason so your team can track trends and fill the gaps.

Runs on WebRun · Strict Lockdown policy
Every day at 6:00 PM WebRunorchestrates each step
1 Fusion Web Clinic pull today's no-shows and cancellations
2 Google Sheets log each missed appointment to the tracker
In short

How do I automatically track OT no-shows and cancellations from Fusion Web Clinic?

WebRun opens Fusion Web Clinic each evening, finds every no-show and cancellation from the day's OT schedule, and appends the details to a Google Sheet tracker. Your front desk gets a clean daily log with patient name, therapist, time, and reason so rebooking decisions are always backed by data.

  • Every no-show and cancellation logged automatically, nothing slips through
  • Running Google Sheet gives month-over-month trend visibility
  • Front desk spends time on rebooking, not manual data entry

Built for OT front desk staff · occupational therapy practice managers · pediatric therapy clinics · outpatient OT practices

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 fusionwebclinic.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    Fusion Web Clinic - pull today's no-shows and cancellations
    fusionwebclinic.com
    WebRun in Fusion Web Clinic: pull today's no-shows and cancellations
    WebRun opens Fusion Web Clinic to pull today's no-shows and cancellations.
    • Open Fusion Web Clinic and navigate to today's schedule view
    • Filter appointments marked as no-show or cancelled
    • Capture patient name, therapist, appointment time, slot duration, and cancellation reason for each

    Done when All of today's no-shows and cancellations are listed with their details.

  3. 2
    Google Sheets - log each missed appointment to the tracker
    google.com
    WebRun in Google Sheets: log each missed appointment to the tracker
    WebRun opens Google Sheets to log each missed appointment to the tracker.
    • Open the OT No-Show Tracker sheet
    • Append each missed appointment as a new row with date, patient, therapist, time, and reason
    • Update the running totals in the summary tab for monthly trend tracking

    Done when Today's no-shows and cancellations are logged and the summary totals are updated.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
fusionwebclinic.com
ScheduleRuns automatically on this cadence
Every day at 6:00 PM
DeliveryHow each run's result reaches you
No-show log · Google Sheets
OutputWhat each run produces - A logged list of today's no-shows and cancellations by patient, therapist, and time slot, appended to your running tracker.
Report
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 send a message to the patient who no-showed?

No. WebRun only logs the appointment data internally to Google Sheets. Any patient outreach is left for your front desk to handle, so no messages go out without staff review.

Can it distinguish between late cancellations and true no-shows?

Yes. WebRun reads the status and cancellation reason recorded in Fusion Web Clinic, so late cancellations and no-shows are captured separately in your tracker.

How far back does each run look?

Each evening run captures only the current day's appointments, giving you a clean daily log. The Google Sheet accumulates the running history over time for trend analysis.

Put this on autopilot.

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