Automated Camp Supply Reorder Alerts
Every Monday, WebRun opens your supply inventory Google Sheet, identifies items that have fallen below their reorder threshold, drafts purchase order emails to your preferred suppliers, and posts a reorder summary to your operations Slack channel for manager review.
How do I automatically track and reorder camp program supplies?
WebRun opens your camp supply inventory Google Sheet every Monday, finds items that have fallen below their reorder threshold, and drafts a grouped purchase order email for each supplier in Gmail. It then posts a reorder summary to your operations Slack channel so your manager can review the PO drafts and send them before any supply runs out mid-session.
- Low-stock supplies are flagged every Monday before they run out mid-session
- PO drafts are grouped by supplier so one email covers all that supplier's items
- Operations manager reviews ready-to-send drafts rather than writing POs from scratch
Built for camp operations managers · program directors · summer camp supply coordinators
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 supply inventory against thresholds
google.com
WebRun opens Google Sheets to check supply inventory against thresholds. - Open the camp supply inventory Google Sheet and compare current quantity on hand against the reorder threshold column for each item
- Flag any item at or below its threshold as needing reorder
- Calculate the suggested order quantity based on the reorder-quantity column and upcoming session counts
Done when Every supply item below its reorder threshold is listed with suggested order quantity and preferred supplier.
-
2
Gmail - draft supplier POs for manager review
gmail.com
WebRun opens Gmail to draft supplier POs for manager review. - Draft a purchase order email to each preferred supplier listing the items and quantities needed
- Group items by supplier so each email covers all that supplier's products in one message
- Save every PO email as a Gmail draft for the operations manager to review before sending. Do not send without approval
Done when Draft PO emails are saved in Gmail for every supplier with items below reorder threshold.
-
3
Slack - post reorder summary to operations
slack.com
WebRun opens Slack to post reorder summary to operations. - Post a weekly reorder summary to your operations Slack channel listing each item, current quantity, and the supplier being contacted
- Note how many Gmail draft POs are ready for manager review
Done when Operations manager has this week's reorder list in Slack and knows how many PO drafts are waiting.
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 send purchase orders to suppliers without someone approving them?
No. Every PO is saved as a Gmail draft and listed in the Slack summary. Your operations manager reviews each draft and sends only the ones they approve. No order goes to a supplier automatically.
How does it know which supplier to contact for each item?
It reads a preferred supplier column in your inventory Google Sheet. You set the supplier name and email address there once, and WebRun groups items by supplier when drafting the PO emails.
What if an item was restocked since the last inventory update?
WebRun reads the current quantity from the Google Sheet each Monday. If the sheet has been updated with new stock, the item will show above threshold and will not appear in that week's reorder list.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.