Whiskey Systems Automated Barrel Aging Inventory Report
Every Monday, WebRun opens Whiskey Systems and reviews the full barrel inventory across all rackhouse locations, calculates the current age and days to target maturity for each barrel or lot, logs the full aging report to a Google Sheet, and posts a Slack digest highlighting barrels entering their target age window so your production team can plan blending and bottling.
How do I automatically get a weekly barrel aging inventory report from my rackhouse?
Every Monday, WebRun pulls the complete barrel inventory from Whiskey Systems across all rackhouse locations, calculates current age and days to target maturity for each barrel, logs the full snapshot to a Google Sheet, and posts a Slack digest to the production team highlighting barrels entering their target age window so blending and bottling can be planned ahead.
- Production team sees every barrel approaching target age each Monday before planning the week
- Full rackhouse inventory snapshot logged to Google Sheets for trending and compliance reference
- Barrels without target ages flagged so none are forgotten in the aging inventory
Built for head distillers · craft distillery production managers · rackhouse managers · blending and bottling teams
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
app.whiskeysystems.comin a real browser with your saved login - no setup, no API keys. -
1
Whiskey Systems - pull full barrel inventory and aging data
whiskeysystems.com
WebRun opens Whiskey Systems to pull full barrel inventory and aging data. - Open Whiskey Systems and navigate to the Barrel Management or Rackhouse section
- Pull the full list of barrels across all storage locations including onsite and offsite rackhouses
- For each barrel or lot, capture the barrel number, spirit type, entry date, current age in months, warehouse location, and target age if set
- Calculate days remaining to target maturity and flag barrels within 30 days of their target age
Done when Full barrel inventory is captured with current age, location, and days to target maturity.
-
2
Google Sheets - log weekly aging report
google.com
WebRun opens Google Sheets to log weekly aging report. - Open the Barrel Aging Inventory Report sheet
- Append this week's snapshot as a dated section with all barrels, their ages, and warehouse locations
- Add columns for current age in months, target age, days remaining, and estimated angel's share percentage
- Sort within the snapshot by days remaining to target, closest first
Done when This week's full barrel aging snapshot is logged in the Google Sheet sorted by maturity proximity.
-
3
Slack - post target-age alert digest
slack.com
WebRun opens Slack to post target-age alert digest. - Post a rackhouse digest to the production Slack channel
- Lead with the total number of active barrels and the count entering their target age window in the next 30 days
- List the barrels or lots closest to target age with their barrel number, spirit type, location, and days remaining
- Link to the full Google Sheet for the complete aging inventory
Done when The production team has this week's barrel aging digest in Slack with a link to the full report.
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 schedule barrel pulls or blending sessions automatically?
No. WebRun reports which barrels are approaching target age but does not schedule any production activity automatically. All blending, gauging, and bottling decisions remain with your production team.
Can it track barrels across multiple offsite rackhouses?
Yes. Whiskey Systems supports both onsite and offsite rackhouse locations, and WebRun pulls from all locations in the system. Make sure offsite barrels are recorded with their warehouse in Whiskey Systems and they will appear in the report.
What if I do not set a target age for every barrel?
WebRun still includes all barrels in the Google Sheet report. Barrels without a target age are listed with their current age and flagged as no target set, so nothing is accidentally excluded from the inventory view.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.