All templates

Automated Urgent Care Supply Reorder Alerts

Every morning, WebRun opens your Google Sheets inventory log and identifies supplies that have fallen below their reorder thresholds. It then checks recent visit volume in Experity to gauge consumption urgency, drafts a prioritised purchase order list for the office manager to review and submit, and posts a reorder alert to Slack so nothing runs out during a busy shift.

Runs on WebRun · Strict Lockdown policy
Every day at 7:30 AM WebRunorchestrates each step
1 Google Sheets identify supplies below reorder thresholds
2 Experity check recent visit volume for urgency context
3 Slack post reorder alert and draft purchase order summary
In short

How do I get automated medical supply reorder alerts for my urgent care clinic?

WebRun scans your Google Sheets inventory log every morning for supplies below reorder thresholds, then checks recent Experity visit volume to prioritise urgency. It drafts a ranked purchase order list and posts it to Slack for the office manager to review and submit. No order is ever placed automatically. Your team approves every reorder before anything is sent to a supplier.

  • No supply runs out unexpectedly because the office manager gets a prioritised reorder list every morning
  • Visit volume from Experity ensures high-consumption items are flagged as urgent before they run out
  • Staff approve every purchase order before it is submitted, keeping full control over clinic spending

Built for urgent care office managers · urgent care clinic administrators · urgent care operations staff · urgent care clinic owners

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

  2. 1
    Google Sheets - identify supplies below reorder thresholds
    google.com
    WebRun in Google Sheets: identify supplies below reorder thresholds
    WebRun opens Google Sheets to identify supplies below reorder thresholds.
    • Open the inventory tracking sheet and scan each supply row for current stock levels
    • Identify all items where the current quantity falls at or below the reorder threshold column
    • Capture the supply name, current quantity, reorder threshold, preferred supplier, and unit cost for each flagged item
    • Note items that are already on a pending order so they are not duplicated in the draft

    Done when All supplies at or below their reorder threshold are listed with supplier and cost details.

  3. 2
    Experity - check recent visit volume for urgency context
    experityhealth.com
    WebRun in Experity: check recent visit volume for urgency context
    WebRun opens Experity to check recent visit volume for urgency context.
    • Open Experity and check the visit volume for the past seven days
    • Identify high-traffic visit types that consume specific supplies quickly, such as wound care or respiratory visits
    • Use the volume data to assign urgency levels to flagged supplies: high urgency for items tied to high-volume visit types, standard urgency for others
    • Note if volume is trending upward so the office manager can order a larger quantity if appropriate

    Done when Each flagged supply has an urgency level informed by recent visit volume and visit type trends.

  4. 3
    Slack - post reorder alert and draft purchase order summary
    slack.com
    WebRun in Slack: post reorder alert and draft purchase order summary
    WebRun opens Slack to post reorder alert and draft purchase order summary.
    • Post a reorder alert to the office manager Slack channel listing all flagged supplies with their urgency level, current quantity, and suggested reorder amount
    • Include a note that this is a draft purchase order list for review. Do not place or submit any order automatically
    • Flag high-urgency items at the top of the list so the office manager knows what to order first

    Done when The office manager has a prioritised draft reorder list in Slack, ready to review and submit.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
docs.google.com/spreadsheets
ScheduleRuns automatically on this cadence
Every day at 7:30 AM
DeliveryHow each run's result reaches you
Draft PO · Slack
OutputWhat each run produces - A prioritised draft purchase order list posted to Slack, ready for the office manager to review and submit. No orders are placed automatically.
Draft purchase order + 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 WebRun place supply orders automatically?

No. WebRun drafts a prioritised reorder list and posts it to Slack for the office manager to review. No purchase order is submitted or sent to a supplier without explicit staff approval. Your team controls every purchasing decision.

How does Experity visit volume affect the reorder list?

WebRun checks recent visit counts and visit types in Experity to assign urgency levels to flagged supplies. Items tied to high-volume visit types, such as wound care supplies during a busy week, are ranked higher so the office manager can prioritise them.

What if a supply is already on a pending order?

WebRun checks the Google Sheets inventory log for a pending order flag on each item and skips those from the draft list, so the office manager does not accidentally double-order supplies already in transit.

Put this on autopilot.

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