Automated AV Equipment ETA Tracking
Every morning, WebRun opens D-Tools to compare equipment ETAs against scheduled install dates, logs any at-risk or late items in a Google Sheets delay tracker, and posts a Slack alert to your project team so they can act before a missing part stops a job.
How do I track AV equipment ETAs and get alerted to delays before an install?
Every morning, WebRun checks D-Tools equipment ETAs against each project's install date, logs any at-risk or late items in a Google Sheets tracker, and posts a Slack alert to your team. Project managers know about a potential job stoppage hours before it becomes one.
- Equipment delays surface the morning they appear, not the day of the install
- Project managers get a grouped Slack alert sorted by urgency every morning
- The Google Sheets delay log gives a running record for supplier conversations
Built for AV installers · custom integrators · AV project managers · commercial AV 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
www.d-tools.comin a real browser with your saved login - no setup, no API keys. -
1
D-Tools - check equipment ETAs vs install dates
d-tools.com
WebRun opens D-Tools to check equipment ETAs vs install dates. - Open D-Tools and navigate to the product and equipment section
- Compare the expected arrival date for each ordered item against the scheduled install date of its linked project
- Flag any item where the ETA is within 3 days of or after the install start date
- Capture the item name, project name, ETA, install date, and supplier for each flagged item
Done when All equipment items with a late or borderline ETA are listed with project and supplier details.
-
2
Google Sheets - log delayed or at-risk items
google.com
WebRun opens Google Sheets to log delayed or at-risk items. - Open the equipment delay tracker Google Sheet
- Append a row for each flagged item with the date checked, project name, item description, ETA, install date, and delay risk level
- Mark resolved items as cleared so the tracker stays current
Done when All at-risk equipment items are logged in the delay tracker sheet with their current ETA and risk status.
-
3
Slack - alert project team to delays
slack.com
WebRun opens Slack to alert project team to delays. - Post a Slack message to the project management channel with the list of delayed or at-risk items
- Group alerts by project and include the supplier name and number of days at risk
- Flag any items where the install date is already past the ETA as urgent
Done when The project team has a Slack alert with all at-risk equipment, grouped by job and severity.
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 contact suppliers automatically about late orders?
No. WebRun flags delays internally in Google Sheets and Slack so your team can decide how to respond. Supplier outreach stays with your team, ensuring no unintended commitments or premature escalations.
How close to the install date does it start flagging items?
By default it flags any item arriving within 3 days of or after the scheduled install start. You can adjust that threshold to match your own lead-time requirements.
What if an ETA has already been updated in D-Tools?
WebRun reads live ETA data from D-Tools on each run, so items whose ETAs have been updated and are no longer at risk are automatically excluded from the day's alert.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.