Find lab materials sitting unused before they expire or tie up cash
Every Monday, WebRun opens Evident, reads inventory movement records for the past 30 days, identifies all materials with zero consumption in that window, calculates the value of idle stock, and posts a slow-moving inventory report to Google Sheets and sends a summary to Telegram so your purchasing manager can reduce par levels, return stock, or shift materials to another project.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I track slow-moving dental lab inventory each week?
Every Monday, WebRun scans Evident for lab materials with zero consumption in the past 30 days, calculates the total idle stock value, and logs the report in Google Sheets. It sends a Telegram summary to the purchasing manager so slow-moving or near-expiry materials are visible before they tie up cash or spoil.
- Idle stock is visible every Monday before more of the same material is ordered
- Near-expiry slow movers are flagged before they become a write-off
- Trend data in Google Sheets shows which items are chronically slow-moving
Built for dental lab purchasing managers · dental lab owners · dental lab operations 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.evidentdigital.comin a real browser with your saved login - no setup, no API keys. -
1
Evident - scan inventory movement for slow-moving items
- Open Evident and navigate to Inventory Tracking
- Filter for materials with no recorded consumption in the past 30 days
- Capture the material name, quantity on hand, unit cost, and total idle value for each
- Note any materials also past their lot expiry date
Done when All materials with zero consumption in 30 days are listed with their idle value and any expiry flag.
-
2
Google Sheets - log the slow-moving inventory report
google.com How to Automate Google Sheets
WebRun opens Google Sheets to log the slow-moving inventory report. - Append the slow-moving item list to the inventory review sheet with today's date
- Include a running total of idle stock value
- Flag any item that has been on the slow-moving list for three consecutive weeks
Done when This week's slow-moving report is logged in Google Sheets with the cumulative idle value.
-
3
Telegram - send a summary to the purchasing manager
telegram.org How to Automate Telegram
WebRun opens Telegram to send a summary to the purchasing manager. - Send the purchasing manager a Telegram summary with the count of slow-moving items and total idle stock value
- List any items that are also near or past expiry
Done when Purchasing manager receives the slow-moving summary on Telegram.
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
How does it define slow-moving? Can I change the window?
By default, slow-moving means no consumption in the past 30 days. You can change the lookback window to 14, 60, or 90 days at setup, and WebRun applies it on every run.
Will it return or write off stock automatically?
No. WebRun only surfaces the list and its value in Google Sheets. Decisions about returning stock, adjusting par levels, or writing off materials are made by your purchasing team.
What if an item was just received and genuinely has not been used yet?
WebRun reads the received-on date from Evident. Items received within the past 14 days are excluded from the slow-moving flag to avoid false positives on new stock.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.