Automated Waste Container Inventory Report
Every Monday, WebRun opens AMCS and reads the current status of every container in your fleet including those deployed at customer sites, sitting in the yard, and overdue for retrieval. It logs the full inventory to a Google Sheet and posts a summary to your ops Slack channel.
How can I get an automated weekly container inventory report for my waste fleet?
WebRun opens AMCS every Monday and reads the status of every container in your fleet, logging the full inventory to Google Sheets and posting a summary to your ops Slack channel. Deployed, available, and overdue counts are always up to date, and your team can see the full history in one Sheet.
- Full container fleet status logged to Google Sheets every Monday automatically
- Overdue containers flagged in Slack before the week starts
- Multi-depot inventory visible in a single weekly report
Built for waste hauling operations managers · fleet managers · roll-off container companies · commercial waste contractors
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
portal.amcsgroup.comin a real browser with your saved login - no setup, no API keys. -
1
AMCS - read container and asset status
amcsgroup.com
WebRun opens AMCS to read container and asset status. - Open AMCS and navigate to the container or asset tracking module
- Read the status of each container including deployed at site, available in yard, and overdue for retrieval
- Capture the container ID, size, type, customer site, deployment date, and current status for each
Done when Every container in the fleet is listed with its current status and location details.
-
2
Google Sheets - log full inventory to tracking sheet
google.com
WebRun opens Google Sheets to log full inventory to tracking sheet. - Open the container inventory tracking Google Sheet
- Append the full current inventory snapshot to the weekly log with today's date
- Update summary counts for total deployed, available, and overdue containers
Done when This week's full container inventory is logged in Google Sheets with summary counts updated.
-
3
Slack - post inventory summary to ops channel
slack.com
WebRun opens Slack to post inventory summary to ops channel. - Post the weekly container inventory summary to the ops channel in Slack
- Include total containers, deployed count, available count, and overdue count
- List any containers flagged as overdue for retrieval with their site address and days outstanding
- Link to the Google Sheet for the full inventory
Done when Ops team has this week's container summary and overdue list 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 this contact customers about overdue containers?
No. The report is internal only. It flags overdue containers in Slack for your ops team to follow up. Any customer communication is a separate step your team takes.
Can it track containers across multiple depots or regions?
Yes. WebRun reads all containers visible in your AMCS account, so multi-depot operations are all included in the same weekly report.
How far back does the inventory history go?
Each weekly run appends a new snapshot to the Google Sheet, so your history grows automatically. You can look back at any week's counts directly in the Sheet.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.