All templates
For hospital capacity managers, nursing administration & bed control coordinators

Start every shift with a clear capacity picture

Every morning, WebRun opens Care Logistics, records staffed, occupied, and open bed counts for every unit plus the ED boarder count, logs the full snapshot to a Google Sheet next to yesterday's numbers, and posts a capacity digest to Microsoft Teams naming the tightest units so leadership starts the day informed.

  • No credit card
  • Under $0.01 per run
  • Cancel anytime
14,115 templates Safe automation No code
Every day at 6:00 AM WebRun
1 Care Logistics pull unit by unit census
2 Google Sheets log the capacity snapshot
3 Microsoft Teams post the capacity digest
Run a sample
In short

How do I get a daily bed capacity snapshot across every unit?

WebRun opens Care Logistics every morning, records staffed, occupied, and open bed counts for every unit plus the ED boarder count, and logs the full snapshot to a Google Sheet next to yesterday's numbers. It then posts a capacity digest to Microsoft Teams naming the tightest units, so leadership starts the day knowing exactly where the pressure points are.

  • Leadership sees hospital wide open bed counts before the first huddle
  • The two tightest units are named automatically every morning
  • A full day over day trend builds with zero manual logging

Built for hospital capacity managers · nursing administration · bed control coordinators · hospital operations leadership

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

  2. 1
    Care Logistics - pull unit by unit census
    carelogistics.com How to Automate Care Logistics
    WebRun in Care Logistics: pull unit by unit census
    WebRun opens Care Logistics to pull unit by unit census.
    • Open the CareEdge command center dashboard
    • Record total staffed beds, occupied beds, and open beds for every unit
    • Note units above 90 percent occupied and units with the most open beds
    • Capture the ED boarder count and any pending admissions waiting on a bed

    Done when Every unit's staffed, occupied, and open bed counts are captured for this morning.

  3. 2
    Google Sheets - log the capacity snapshot
    google.com How to Automate Google Sheets
    WebRun in Google Sheets: log the capacity snapshot
    WebRun opens Google Sheets to log the capacity snapshot.
    • Open the Daily Capacity Snapshot sheet
    • Append today's date with each unit's counts as new rows
    • Carry forward yesterday's totals in an adjacent column for quick comparison

    Done when The sheet has today's full snapshot logged next to yesterday's for comparison.

  4. 3
    Microsoft Teams - post the capacity digest
    microsoft.com How to Automate Microsoft Teams
    WebRun in Microsoft Teams: post the capacity digest
    WebRun opens Microsoft Teams to post the capacity digest.
    • Post the hospital wide open bed count and the tightest two units to the leadership Teams channel
    • Call out the ED boarder count if it is above your usual morning range
    • Link to the Google Sheet for the full unit by unit breakdown

    Done when Leadership has this morning's capacity digest posted in Teams with a link to the full sheet.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
www.carelogistics.com
ScheduleRuns automatically on this cadence
Every day at 6:00 AM
DeliveryHow each run's result reaches you
Capacity digest · Microsoft Teams
OutputWhat each run produces - A logged row per unit with staffed, occupied, and open beds, plus a Teams digest of the tightest units.
Spreadsheet + digest
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 this share any patient information outside the hospital?

No. The snapshot only reports bed and unit counts, never patient names or clinical details, and it stays inside your own Google Sheet and internal Teams channel.

How does it decide which units to call out?

It flags any unit at or above 90 percent occupied and separately surfaces the two units with the fewest open beds, so the tightest spots are named without anyone scanning every row.

What if a unit's numbers change right after the morning check?

The snapshot reflects Care Logistics at the moment it runs. Set it to run again midday if your team wants a second check point later in the shift.

Put this on autopilot.

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