Automated Portable Sanitation Unit Inventory Report
Every Monday, WebRun opens ServiceCore, pulls the full unit inventory status including deployed, idle, and out-of-service counts by unit type, logs the snapshot to Google Sheets for trend tracking, and posts an availability and utilization summary to Slack so management can make informed deployment and purchasing decisions.
How do I automatically track portable sanitation unit inventory and utilization?
Every Monday, WebRun opens ServiceCore and pulls a full snapshot of deployed, idle, and out-of-service unit counts by type. It logs the data to Google Sheets for trend tracking and posts a utilization summary to Slack so management can see capacity, flag over-deployed unit types, and plan procurement before inventory runs short.
- Management sees deployed versus idle unit counts by type in Slack every Monday
- Unit types near full capacity are flagged automatically before inventory constraints become a problem
- Weekly snapshots build a trend history in Google Sheets for forecasting and purchasing decisions
Built for portable sanitation owners · sanitation fleet managers · porta-potty operations directors · field service inventory managers
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.servicecore.comin a real browser with your saved login - no setup, no API keys. -
1
ServiceCore - pull unit inventory and utilization snapshot
servicecore.com
WebRun opens ServiceCore to pull unit inventory and utilization snapshot. - Open ServiceCore and navigate to the unit inventory or assets section
- Pull the count of deployed, idle, and out-of-service units by unit type such as standard, ADA, flushable, and restroom trailers
- Identify any units flagged for maintenance or past their last service interval
- Calculate the utilization rate as deployed units divided by total available units for each type
Done when Full inventory snapshot with deployed, idle, out-of-service, and utilization rate is captured.
-
2
Google Sheets - log weekly inventory snapshot to tracking sheet
google.com
WebRun opens Google Sheets to log weekly inventory snapshot to tracking sheet. - Open the unit inventory tracking sheet in Google Sheets
- Append a new dated row with deployed count, idle count, out-of-service count, and utilization rate per unit type
- Flag any unit types with a utilization rate above 90 percent as a capacity warning
Done when Weekly inventory snapshot is logged to Google Sheets with date stamp and utilization rates.
-
3
Slack - post utilization summary to management channel
slack.com
WebRun opens Slack to post utilization summary to management channel. - Post the weekly utilization summary to the Slack management channel
- Show deployed versus idle counts and utilization rate per unit type
- Highlight any unit types at or near full capacity and any units flagged for maintenance
Done when Management has the weekly inventory and utilization summary in Slack.
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 report on all unit types or just one?
It covers all unit types tracked in ServiceCore including standard portable toilets, ADA units, flushable units, and restroom trailers, with deployed versus idle counts for each.
How does it handle units out for maintenance?
Units flagged as out of service or in maintenance in ServiceCore are counted separately from idle units and surfaced in the Slack summary so management knows true available inventory.
Can it warn me when a unit type is running low on available inventory?
Yes. Unit types with a utilization rate above 90 percent are flagged as a capacity warning in both the Slack summary and the Google Sheet so you can plan deliveries or procurement in advance.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.