TSTracker Automated Tool Storage Location Log
Every night, WebRun opens TSTracker, checks the recorded storage location for every tool not currently on a press, cross references it against the master rack log in Google Sheets, flags any tool with a missing or stale location, and posts a Slack alert so the location gets corrected before that tool is needed.
How do I keep track of where every tool is stored between jobs?
WebRun checks TSTracker nightly for tools in storage, cross references the recorded location against the master rack log in Google Sheets, and flags any tool with a missing or stale entry. It posts a Slack alert prioritized by upcoming tryout or ship dates, so a tool is never hunted for at the last minute.
- No tool gets hunted for at the last minute before a tryout
- Missing or stale locations get flagged before they cause a delay
- The rack log spreadsheet stays current without a manual walk through
Built for tool and die shops · tool room attendants · mold shop production managers · die shop shipping coordinators
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
tst-software.comin a real browser with your saved login - no setup, no API keys. -
1
TSTracker - check each stored tool's recorded location
tst-software.com
WebRun opens TSTracker to check each stored tool's recorded location. - Open TSTracker and list every tool currently marked as in storage, not on a press or in build
- Capture the recorded storage location, rack, or cage for each tool
- Note any tool whose location field is blank or was last updated more than 60 days ago
Done when Every stored tool has its recorded location captured, including any that are missing or stale.
-
2
Google Sheets - keep the master rack log current
google.com
WebRun opens Google Sheets to keep the master rack log current. - Open the master rack log and update the row for every tool with a current TSTracker location
- Add a new row for any tool now in storage that wasn't logged before
- Mark rows where the TSTracker location is missing or stale so they stand out
Done when The rack log spreadsheet matches TSTracker's current storage records.
-
3
Slack - alert on any missing or stale location
slack.com
WebRun opens Slack to alert on any missing or stale location. - Post a Slack alert listing tools with a missing or stale storage location
- Prioritize any tool with an upcoming tryout or ship date that still lacks a confirmed location
- Tag the tool room lead so the location gets corrected before that tool is needed
Done when The tool room has a Slack list of every location gap that needs correcting.
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 move or relocate tools itself?
No. WebRun only reads and logs the storage location already recorded in TSTracker. Moving a tool and updating its location still happens on the shop floor.
What counts as a stale location?
A tool whose storage location in TSTracker has not been updated in more than 60 days. That threshold is adjustable to match how often your shop actually shuffles rack space.
Does it prioritize tools that are needed soon?
Yes. It checks each tool's upcoming tryout or ship date in TSTracker, so a tool with a missing location and a tryout next week gets flagged ahead of one that isn't needed for months.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.