All templates

Automated Equipment Asset List Intake Checks

As soon as a client uploads a new asset list, WebRun reads it in Google Sheets, checks every row for a serial number, hour meter reading, and location, cross checks each make and model against Rouse Services, and posts an intake checklist to Slack before the list moves to appraisal.

Runs on WebRun · Strict Lockdown policy
Runs within minutes of each upload WebRunorchestrates each step
1 Google Sheets read the new asset list
2 Rouse Services check make and model data
3 Slack post the intake checklist
In short

How do I catch incomplete equipment asset lists before an appraisal starts?

WebRun reviews every equipment asset list a client uploads, checking each row in Google Sheets for a serial number, hour meter reading, and location, then cross checks each make and model against Rouse Services for available comp data. It posts a Slack checklist of gaps within minutes, so an incomplete list never reaches the appraisal stage unnoticed.

  • Incomplete asset lists get caught before an appraiser starts work
  • Every asset is checked against Rouse Services comp data on intake
  • Your team sees a clear go or no go checklist within minutes of upload

Built for machinery appraisers · equipment valuation firms · appraisal office managers · asset management teams

Step by step

What does WebRun do on every run?

The exact actions WebRun takes, in order - in plain language, so you can adjust anything.

  1. WebRun signs in and gets to work

    Opens docs.google.com/spreadsheets in a real browser with your saved login - no setup, no API keys.

  2. 1
    Google Sheets - read the new asset list
    google.com
    WebRun in Google Sheets: read the new asset list
    WebRun opens Google Sheets to read the new asset list.
    • Open the newly uploaded asset list in Google Sheets
    • Check every row for a serial number, hour meter reading, and location
    • Mark rows missing any required field

    Done when Every row in the asset list has been checked for the 3 required fields.

  3. 2
    Rouse Services - check make and model data
    rouseservices.com
    WebRun in Rouse Services: check make and model data
    WebRun opens Rouse Services to check make and model data.
    • Look up each asset's make and model in Rouse Services
    • Flag any asset with no matching market data on file
    • Note the equipment category for assets that do have comps

    Done when Every asset has been checked against available comp data.

  4. 3
    Slack - post the intake checklist
    slack.com
    WebRun in Slack: post the intake checklist
    WebRun opens Slack to post the intake checklist.
    • Post an intake checklist listing rows with missing fields and assets with no comp data
    • Flag the asset list as ready for appraisal only once the checklist is clear

    Done when Your team has a clear go or no go on the new asset list.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
docs.google.com/spreadsheets
ScheduleRuns automatically on this cadence
Runs within minutes of each upload
DeliveryHow each run's result reaches you
Intake checklist · Slack
OutputWhat each run produces - An intake checklist listing incomplete rows and assets with no available comparable data.
Text
Setup & safety

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.

Your credentials stay in your own private environment - WebRun never stores your passwords.
Strict Lockdown

Every action is checked against this policy before it runs.

Domains ALLOWLIST
Typed input ALLOW
Shell command BLOCK
File uploads BLOCK
Runs in a contained environment More on policies
Good to know

Questions, answered

Does it fix the asset list for me?

No. It only flags rows with missing serial numbers, hours, or locations so someone on your team can fix them before the valuation starts.

What counts as a required field?

Serial number, hour meter reading, and equipment location. You can add more required fields once the workflow is set up.

What if an asset has no comparable data yet?

It flags it separately in the checklist rather than blocking the whole list, since the appraiser may still be able to value it another way.

Put this on autopilot.

Turn it on in minutes - or have our team set it up for you.