Automated Subbly Box Inventory Forecast Alerts
Every Monday, WebRun opens Subbly, counts how many active subscribers are due a box in the next cycle, checks stock levels for each product included in the box, calculates whether current inventory covers the full subscriber count, and posts a shortfall forecast to Slack with a detailed log in Google Sheets.
How do I forecast subscription box inventory shortfalls before my next fulfilment run?
Every Monday, WebRun opens Subbly to count active subscribers due a box in the next cycle and check each product's current stock. It calculates coverage per item, logs the full forecast to Google Sheets, and posts any shortfalls to Slack. Your team sees potential stockouts days before fulfilment, not the morning boxes should ship.
- Potential stockouts are flagged days before fulfilment, not the morning of
- Full per-product coverage ratios are logged to Google Sheets every Monday
- All-clear messages confirm the check ran when all products are covered
Built for subscription box product managers · subscription box fulfilment teams · e-commerce inventory planners
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
subbly.co/managein a real browser with your saved login - no setup, no API keys. -
1
Subbly - count active subscribers and check stock levels
subbly.co
WebRun opens Subbly to count active subscribers and check stock levels. - Open Subbly and count active subscribers scheduled for the next fulfilment cycle
- Navigate to Products and record the current stock quantity for each item included in the upcoming box
- Calculate coverage: divide current stock by subscriber count for each product
- Identify any product where coverage falls below 100 percent of subscriber demand
Done when Every product in the upcoming box has a coverage ratio and any shortfalls are identified.
-
2
Google Sheets - log the full forecast with shortfall details
google.com
WebRun opens Google Sheets to log the full forecast with shortfall details. - Open the inventory forecast Google Sheet
- Append a row for each product with this week's date, current stock, subscriber demand, coverage ratio, and shortfall quantity
- Highlight rows where coverage is below 100 percent in a flag column
Done when The Google Sheet has this week's forecast with all products and their coverage ratios.
-
3
Slack - post a shortfall summary to the team
slack.com
WebRun opens Slack to post a shortfall summary to the team. - Post a summary to the configured Slack channel listing only products with a shortfall
- Include the product name, current stock, demand, and units short
- If all products are covered, post a short all-clear message
Done when The team has a Slack summary of this week's inventory shortfalls, or an all-clear if none exist.
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
Does it place reorders when a shortfall is detected?
No. WebRun flags the shortfall in Slack and logs it to Google Sheets. Placing reorders with suppliers remains a human decision so you control spend.
What if my active subscriber count changes mid-week?
The forecast reflects the subscriber count at the time of the Monday run. For more frequent checks, you can schedule additional runs during the week.
Can it handle boxes with different contents per plan tier?
Yes. If different Subbly plan tiers include different products, WebRun calculates demand and coverage per product accounting for which tiers include each item.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.