Automated Comparable Data Prep
Every morning, WebRun opens Google Sheets to read your MLS comp exports, organizes each comparable by address, sale date, price, and square footage, cross-references the order details in ACI, and posts a Slack note when the worksheet is refreshed and ready to use.
How do I automatically organize MLS comparable data for appraisal reports?
WebRun reads your MLS comp exports in Google Sheets each morning, organizes each comparable by address, price, size, and sale date, cross-checks the subject property details from ACI, flags any incomplete rows, and posts a Slack confirmation when the worksheet is ready for you to use in the report.
- Comp worksheet organized and ready before you open the report form
- Missing data fields flagged before they cause a revision
- Subject property details from ACI cross-referenced automatically
Built for residential appraisers · appraisal firms · commercial appraisers · review appraisers
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
sheets.google.comin a real browser with your saved login - no setup, no API keys. -
1
Google Sheets - read and organize MLS comp data
google.com
WebRun opens Google Sheets to read and organize MLS comp data. - Open the MLS comp data worksheet in Google Sheets
- Read each comparable row and verify the required fields are present: address, sale date, list and sale price, square footage, bedroom and bathroom count, and days on market
- Flag any row with missing data so you can fill it in before drafting the report
Done when Every comp row is reviewed and complete, or flagged where data is missing.
-
2
ACI - cross-reference active orders
aciweb.com
WebRun opens ACI to cross-reference active orders. - Open ACI and look up the active order matching the subject property address
- Confirm the property type, neighborhood, and gross living area from the ACI order record
- Note any appraiser comments or client requirements that affect comp selection
Done when The subject property details from ACI are recorded alongside the comp worksheet.
-
3
Slack - notify when worksheet is ready
slack.com
WebRun opens Slack to notify when worksheet is ready. - Post a Slack message confirming the comp worksheet is refreshed and ready
- List how many comps are organized and flag any rows with missing fields that still need attention
- Include a link to the Google Sheets file
Done when You have a Slack confirmation that the comp worksheet is ready to use for your report.
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 pull MLS data automatically, or do I need to export it first?
You export the MLS comps to Google Sheets in your usual format, and WebRun takes it from there. It organizes, checks, and cross-references the data so you can focus on analysis rather than data wrangling.
What if a comparable is missing square footage or a sale date?
WebRun flags the incomplete row in the worksheet and calls it out in the Slack notification, so you know exactly which fields to fill in before the data is used in a report.
Can it handle multiple active orders at once?
Yes. WebRun cross-references each worksheet tab or row set against the matching active order in ACI, so comps for different properties stay organized and do not get mixed together.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.