Catch overdue accounts before the compliance risk grows
Every Monday, WebRun opens QuoteIQ, compares each account's calculated next due date against today, logs every account already past its NFPA 96 interval to a Google Sheet with days overdue and last cleaning date, and sends the owner a Telegram alert ranking the worst offenders first.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I find kitchen exhaust accounts that are overdue for their required cleaning?
WebRun compares every account's calculated NFPA 96 next due date against today in QuoteIQ each Monday, logs anyone already past their interval to a Google Sheet with days overdue, and sends the owner a Telegram alert on the five worst offenders first. Nothing is sent to the customer, so overdue accounts surface as an internal risk list before the exposure grows.
- The worst compliance risks surface every Monday instead of getting buried in the account list
- A running Google Sheet gives a full overdue history for insurance or audit questions
- Accounts already booked to fix the gap are called out so nothing gets double worked
Built for kitchen exhaust cleaning company owners · hood cleaning compliance coordinators · field service operations managers · commercial cleaning account managers
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
myquoteiq.comin a real browser with your saved login - no setup, no API keys. -
1
QuoteIQ - find accounts past their next due date
myquoteiq.com How to Automate QuoteIQ
WebRun opens QuoteIQ to find accounts past their next due date. - Open QuoteIQ and list every active account with its calculated next due date
- Compare each next due date against today and capture how many days past due it is
- Note the account's classification and whether a job is already booked to fix it
Done when Every account past its NFPA 96 interval is identified with days overdue.
-
2
Google Sheets - log the overdue list with days overdue
docs.google.com How to Automate Google Sheets
WebRun opens Google Sheets to log the overdue list with days overdue. - Open the compliance risk tracker in Google Sheets
- Add or update a row for each overdue account with days overdue, classification, and last cleaning date
- Sort the sheet with the longest overdue accounts at the top
Done when The compliance risk tracker reflects every overdue account, sorted by days overdue.
-
3
Telegram - alert the owner on the worst offenders
telegram.org How to Automate Telegram
WebRun opens Telegram to alert the owner on the worst offenders. - Send the owner a Telegram alert listing the five most overdue accounts with days overdue
- Note which of those already have a job booked versus which still need one
- Link to the full Google Sheet for the complete list
Done when The owner has a Telegram alert on the worst overdue accounts every Monday.
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 this contact the overdue customer directly?
No. It only logs the overdue accounts to a Google Sheet and alerts you on Telegram. Reaching out to the customer to get them rebooked is still your team's call.
How is overdue calculated?
It is the account's NFPA 96 classification, quarterly, semiannual, or annual, applied to its last cleaning date in QuoteIQ. Once today's date passes that calculated next due date, the account shows up on the list.
What if an overdue account already has a job booked?
It still appears on the tracker so you have a full compliance record, but the Telegram alert notes that a job is already on the books, so you know it's already being handled.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.