All templates

Automated WellSky Daily Workload Digest

Every morning, WebRun opens WellSky, totals yesterday's treatment volume, therapist productivity, and open orders by shift, logs the full breakdown to a Google Sheet, drafts a Twilio text summary for the department manager to review, and posts the same digest to the Microsoft Teams channel for the whole team.

Runs on WebRun · Strict Lockdown policy
Every day at 6:45 AM WebRunorchestrates each step
1 WellSky total treatment volume and productivity by shift
2 Google Sheets log the full daily breakdown
3 Twilio draft a text summary for the manager
4 Microsoft Teams post the digest to the department channel
In short

How do I get a daily digest of my respiratory department's workload?

WebRun opens WellSky every morning, totals yesterday's treatment volume, therapist productivity, and any open orders by shift, and logs the full breakdown to Google Sheets. It drafts a Twilio text summary for the manager to review and posts the same digest to Microsoft Teams, so the whole department starts the day informed.

  • The whole department starts the day with yesterday's numbers already summarized
  • Productivity is tracked by shift, not just a single daily headcount
  • Week to date trends sit next to yesterday's totals automatically

Built for respiratory therapy department managers · hospital RT directors · charge respiratory therapists · acute care operations teams

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

  2. 1
    WellSky - total treatment volume and productivity by shift
    wellsky.com
    WebRun in WellSky: total treatment volume and productivity by shift
    WebRun opens WellSky to total treatment volume and productivity by shift.
    • Open WellSky and pull yesterday's completed treatments, missed treatments, and open orders
    • Total treatment volume and productivity per therapist and per shift
    • Note any shift that finished with open orders past their window

    Done when Yesterday's full department activity is totaled by therapist and shift.

  3. 2
    Google Sheets - log the full daily breakdown
    google.com
    WebRun in Google Sheets: log the full daily breakdown
    WebRun opens Google Sheets to log the full daily breakdown.
    • Open the Daily Workload Digest sheet and append yesterday's totals as a new row
    • Break out treatment volume, productivity, and open orders by shift
    • Carry forward the week to date trend for comparison

    Done when The digest sheet reflects yesterday's totals and the week to date trend.

  4. 3
    Twilio - draft a text summary for the manager
    twilio.com
    WebRun in Twilio: draft a text summary for the manager
    WebRun opens Twilio to draft a text summary for the manager.
    • Draft a short text summarizing total treatments, busiest shift, and any open order carryover
    • Queue the draft in Twilio for the department manager to review and send
    • Never send the summary text without the manager's approval

    Done when A review ready summary text is queued for the department manager.

  5. 4
    Microsoft Teams - post the digest to the department channel
    microsoft.com
    WebRun in Microsoft Teams: post the digest to the department channel
    WebRun opens Microsoft Teams to post the digest to the department channel.
    • Post the same digest to the respiratory department Teams channel
    • Highlight the busiest shift and any therapist who closed out under target
    • Link to the full Google Sheet for the detailed breakdown

    Done when The whole department has yesterday's digest in Teams with a link to the full detail.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
wellsky.com
ScheduleRuns automatically on this cadence
Every day at 6:45 AM
DeliveryHow each run's result reaches you
Workload digest · Microsoft Teams
OutputWhat each run produces - A daily Google Sheets row of department totals, a drafted Twilio summary for the manager, and a Teams post for the whole team.
Digest + log
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

Does the manager's text summary send on its own?

No. WebRun drafts the summary and queues it in Twilio. The manager reviews and sends it, nothing reaches a phone unapproved.

What counts toward productivity per therapist?

It totals each therapist's completed treatments and assigned patient volume from WellSky, broken out by shift, so productivity reflects the actual workload carried, not just a headcount.

Can the digest include a week over week trend?

Yes. The Google Sheet carries forward each day's totals, so the week to date trend sits next to yesterday's numbers automatically.

Put this on autopilot.

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