All templates
For roofing and siding distributors, branch managers & pricing and purchasing teams

Send branch managers a price change digest every week

Every Monday, WebRun opens DMSi Agility, pulls every roofing and siding SKU whose price or cost changed in the past week, cross checks each one against the item cost recorded in QuickBooks, logs any mismatch or notable margin shift in Google Sheets, and delivers a branch manager digest so a stale quote never goes out on an old price.

  • No credit card
  • Under $0.01 per run
  • Cancel anytime
14,115 templates Safe automation No code
Every Monday at 7:00 AM WebRun
1 DMSi Agility pull this week's SKU price and cost changes
2 QuickBooks cross check item costs for a mismatch
3 Google Sheets log the digest for branch managers
Run a sample
In short

How do I catch price and cost mismatches after a weekly update?

Every Monday, WebRun opens DMSi Agility and pulls every roofing and siding SKU with a price or cost change from the past week. It cross checks each one against the item cost in QuickBooks, logs any mismatch in a Google Sheets digest, and sorts mismatched SKUs to the top so branch managers catch a pricing error before a contractor is quoted wrong.

  • Price and cost mismatches surface every Monday instead of at a customer complaint
  • Branch managers see the full week of changes in one digest, not scattered alerts
  • Stale quotes drop because outdated prices get caught early

Built for roofing and siding distributors · branch managers · pricing and purchasing teams · accounting and controllers

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 www.dmsi.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    DMSi Agility - pull this week's SKU price and cost changes
    dmsi.com How to Automate DMSi Agility
    WebRun in DMSi Agility: pull this week's SKU price and cost changes
    WebRun opens DMSi Agility to pull this week's SKU price and cost changes.
    • Open DMSi Agility and pull every SKU with a price or cost change logged in the past 7 days
    • Capture the old price, new price, and the effective date for each change
    • Group the changes by manufacturer and product category

    Done when Every SKU changed this week is listed with its old and new price.

  3. 2
    QuickBooks - cross check item costs for a mismatch
    • Look up the item cost on file in QuickBooks for each changed SKU
    • Compare it against the new cost recorded in DMSi Agility
    • Flag any SKU where the two costs no longer match

    Done when Every changed SKU has its QuickBooks cost checked against DMSi Agility.

  4. 3
    Google Sheets - log the digest for branch managers
    google.com How to Automate Google Sheets
    WebRun in Google Sheets: log the digest for branch managers
    WebRun opens Google Sheets to log the digest for branch managers.
    • Log every changed SKU with old price, new price, percentage change, and whether the systems matched
    • Sort mismatched SKUs to the top of the digest
    • Deliver the digest as this week's tab so managers can compare pricing week over week

    Done when The weekly price digest is logged in Google Sheets with mismatches flagged.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
www.dmsi.com
ScheduleRuns automatically on this cadence
Every Monday at 7:00 AM
DeliveryHow each run's result reaches you
Price digest · Google Sheets
OutputWhat each run produces - A weekly Google Sheets digest of every SKU price or cost change with a QuickBooks mismatch flag for anything out of sync.
Spreadsheet
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 change prices in DMSi Agility or QuickBooks?

No. WebRun only reads price and cost data from both systems and logs the comparison. Correcting a mismatch is made by your team directly in DMSi Agility or QuickBooks.

What counts as a mismatch?

Any SKU where the cost recorded in QuickBooks no longer matches the current cost in DMSi Agility after this week's changes, which usually means one system was updated and the other was not.

How far back does each week's digest look?

It checks price and cost changes logged in DMSi Agility over the trailing 7 days, so every Monday's digest picks up exactly where the previous week's left off.

Put this on autopilot.

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