All templates

PointClickCare Automated Daily Census Digest

Every morning, WebRun opens PointClickCare, reads the current census by unit and payor mix, appends the figures to a Google Sheet trend log, and posts a concise occupancy digest to the leadership Slack channel so administrators and DONs have today's numbers without running a report.

Runs on WebRun · Strict Lockdown policy
Every day at 7:00 AM WebRunorchestrates each step
1 PointClickCare read current census and occupancy by unit
2 Google Sheets append daily census to trend log
3 Slack post occupancy digest to leadership channel
In short

How can a skilled nursing facility automatically get a daily census and occupancy report?

Every morning, WebRun opens PointClickCare and reads the current census, occupancy rate, and payor mix for the facility and each unit. It appends the figures to a rolling Google Sheets trend log and posts a concise digest to the leadership Slack channel so administrators always have today's numbers without running a report.

  • Leadership sees today's census and payor mix in Slack by 7 AM without running a report
  • A 90-day trend log builds automatically for planning and reporting
  • Units below target occupancy are flagged in the same message

Built for skilled nursing facility administrators · SNF directors of nursing · long-term care leadership teams · SNF census managers

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

  2. 1
    PointClickCare - read current census and occupancy by unit
    pointclickcare.com
    WebRun in PointClickCare: read current census and occupancy by unit
    WebRun opens PointClickCare to read current census and occupancy by unit.
    • Open PointClickCare and navigate to the census or occupancy dashboard
    • Read total census, available beds, and occupancy percentage for the facility and each unit
    • Capture payor-mix breakdown including Medicare, Medicaid, and private-pay counts

    Done when Current census, occupancy rate, and payor mix are captured for the facility and all units.

  3. 2
    Google Sheets - append daily census to trend log
    google.com
    WebRun in Google Sheets: append daily census to trend log
    WebRun opens Google Sheets to append daily census to trend log.
    • Open the census trend log Google Sheet
    • Append a new row with today's date, total census, occupancy percentage, available beds, and payor mix counts
    • The trend log preserves a rolling 90-day history for reporting and planning

    Done when Today's census figures are appended to the trend log with date and payor breakdown.

  4. 3
    Slack - post occupancy digest to leadership channel
    slack.com
    WebRun in Slack: post occupancy digest to leadership channel
    WebRun opens Slack to post occupancy digest to leadership channel.
    • Post a formatted Slack message to the leadership channel with total census, occupancy rate, and available beds
    • Include the payor-mix breakdown so administrators see Medicare versus Medicaid versus private-pay at a glance
    • Add a one-line note flagging any unit below 85 percent occupancy

    Done when Leadership has today's census digest in Slack with occupancy and payor mix visible at a glance.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
pointclickcare.com
ScheduleRuns automatically on this cadence
Every day at 7:00 AM
DeliveryHow each run's result reaches you
Census digest · Slack
OutputWhat each run produces - A rolling census trend log in Google Sheets and a daily occupancy digest posted to the leadership Slack channel.
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

Is individual resident information included in the Slack digest?

No. The digest reports aggregate census counts and occupancy percentages by unit and payor type. No individual resident names or clinical details are included in the Slack post.

How far back does the trend log go?

The Google Sheet log keeps every daily row from the first run, giving you a full historical trend. You can use it to calculate 30-day, 60-day, or 90-day averages for reporting and planning.

Can it flag when census drops below a target?

Yes. You can set a target occupancy threshold and WebRun will add a flag to the Slack message on any day the facility or a unit falls below it, so leadership is alerted without having to monitor the numbers manually.

Put this on autopilot.

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