All templates
For SPD loaner coordinators, sterile processing technicians & central sterile managers

Chase down loaner trays before they go overdue

Every morning, WebRun opens Censis, finds loaner trays used in recent cases that have not yet been checked back in, logs each one to a Google Sheet with the vendor and expected return date, and posts your SPD team a Teams reminder ranked by how soon each loaner is due back.

  • No credit card
  • Under $0.01 per run
  • Cancel anytime
14,115 templates Safe automation No code
Every day at 7:00 AM WebRun
1 Censis find loaner trays not yet checked in
2 Google Sheets log each loaner with its return date
3 Microsoft Teams remind the team what's due back first
Run a sample
In short

How do I make sure loaner trays get checked in before the vendor pickup?

WebRun opens Censis every morning, finds loaner trays used in recent cases that have not been checked back in, and logs each one to a Google Sheet with its vendor and expected return date. It then posts your SPD team a Teams reminder ranked by urgency, so loaner trays get checked in, recounted, and returned before the vendor's pickup window.

  • Loaner trays get checked in before the vendor comes looking for them
  • Incomplete loaners get a full recount before they ship back
  • The check-in list is ranked by urgency every single morning

Built for SPD loaner coordinators · sterile processing technicians · central sterile managers · perioperative leaders

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

  2. 1
    Censis - find loaner trays not yet checked in
    censis.com How to Automate Censis
    WebRun in Censis: find loaner trays not yet checked in
    WebRun opens Censis to find loaner trays not yet checked in.
    • Open Censis (CensiTrac) and filter loaner trays to status Used, Not Checked In
    • Capture the vendor, case date, and the vendor's expected return date for each
    • Note any loaner already flagged incomplete at last count

    Done when Every unreturned loaner tray is listed with its vendor and return date.

  3. 2
    Google Sheets - log each loaner with its return date
    google.com How to Automate Google Sheets
    WebRun in Google Sheets: log each loaner with its return date
    WebRun opens Google Sheets to log each loaner with its return date.
    • Open the Loaner Tray Tracker sheet
    • Append or update a row for each unreturned loaner with days until its return date
    • Sort so the soonest return dates sit at the top

    Done when The tracker sheet reflects every loaner still out, sorted by urgency.

  4. 3
    Microsoft Teams - remind the team what's due back first
    microsoft.com How to Automate Microsoft Teams
    WebRun in Microsoft Teams: remind the team what's due back first
    WebRun opens Microsoft Teams to remind the team what's due back first.
    • Post the loaner check-in list to the SPD channel, soonest return date first
    • Flag any loaner that was marked incomplete at last count so it gets a full recount before it ships back
    • Link to the full tracker sheet

    Done when The team has today's loaner check-in list in Teams before the vendor pickup window.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
portal.censis.com
ScheduleRuns automatically on this cadence
Every day at 7:00 AM
DeliveryHow each run's result reaches you
Loaner check-in list · Microsoft Teams
OutputWhat each run produces - A tracker row per unreturned loaner tray and a Teams reminder ranked by how soon each is due back to the vendor.
Spreadsheet + alert
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 contact the vendor about the return?

No. It only reminds your own SPD team what is still out and when it is due. Any contact with the vendor is a call your team makes.

What if a loaner was already checked in?

It reads the live status in Censis each morning, so any loaner already checked back in drops off the list automatically.

Does it flag incomplete loaner trays too?

Yes. Any loaner still marked incomplete from its last count is called out separately so it gets a full recount before it goes back to the vendor.

Put this on autopilot.

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