Automated Medical Supply Reorder
Every morning, WebRun opens your supply inventory Google Sheet, checks each item's quantity against its reorder threshold, drafts a purchase order email per supplier in Gmail for manager review, and posts a Slack alert listing everything that needs reordering so nothing runs out during an active patient week.
How do I automatically track and reorder home health medical supplies?
WebRun checks your supply inventory Google Sheet each morning and flags every item below its reorder threshold. It drafts a purchase order email per supplier in Gmail for manager review and posts a Slack low-stock alert with quantities and supplier details, so no medical supply runs out during an active patient week.
- No supply runs out mid-week because the reorder was not noticed in time
- Purchase order drafts are grouped by supplier so the manager approves one email per vendor
- Thresholds live in the Sheet so any team member can adjust them without touching the workflow
Built for home health operations managers · supply coordinators · home health agencies · clinical administrators
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
docs.google.com/spreadsheetsin a real browser with your saved login - no setup, no API keys. -
1
Google Sheets - check inventory against reorder thresholds
google.com
WebRun opens Google Sheets to check inventory against reorder thresholds. - Open the supply inventory Google Sheet
- Compare each item's current quantity column against its reorder threshold column
- Flag items at or below the threshold and note the supplier, item name, and quantity needed
Done when Every supply item below the reorder threshold is identified with supplier and quantity details.
-
2
Gmail - draft purchase order emails
gmail.com
WebRun opens Gmail to draft purchase order emails. - Group flagged items by supplier
- Draft a purchase order email for each supplier listing the items and quantities needed
- Save each email as a Gmail draft. Do not send any order without manager review and approval
Done when A Gmail draft purchase order exists for every supplier with items below threshold, held for review.
-
3
Slack - alert the manager
slack.com
WebRun opens Slack to alert the manager. - Post a low-stock alert to the operations Slack channel listing all flagged items by supplier
- Include the current quantity, threshold, and quantity to order for each item
- Ask the manager to review the Gmail drafts and approve before sending
Done when The manager has a full low-stock summary in Slack and knows the purchase order drafts are ready.
How is each run configured?
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.
Every action is checked against this policy before it runs.
Questions, answered
Will it place a supply order or send an email to a supplier without manager approval?
No. Every purchase order is saved as a Gmail draft and held for manager review. The manager sees the low-stock summary in Slack, opens the Gmail drafts, and sends only the orders they approve. No order goes out automatically.
How do I set reorder thresholds for each supply item?
Add a reorder threshold column to your inventory Google Sheet next to the current quantity column. WebRun reads the threshold from that column each morning. You can set different thresholds per item and adjust them any time by updating the Sheet.
What if the same item is stocked by more than one supplier?
You can add a preferred supplier column to the Sheet. WebRun will use the preferred supplier for the draft order. If no preference is set, it lists the item as unassigned in the Slack alert so the manager can choose the supplier before approving.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.