Automated Auto Lending Dealer Covenant Tracker
Every Monday, WebRun opens the Dealer Covenant tracker in Google Sheets, pulls the latest dealer performance metrics from RouteOne such as funded volume and delinquency rate, compares each metric against the required covenant threshold, and posts a prioritized breach-risk alert to your Slack credit team channel.
How do I automatically track dealer covenant conditions and flag breach risks each week?
Every Monday, WebRun reads your dealer covenant thresholds from Google Sheets, pulls current performance metrics from RouteOne for each dealer, and calculates the variance against every condition. Dealers approaching or in breach of a covenant are surfaced in a Slack alert to your credit team so action is taken before a formal breach occurs.
- Covenant breach risks are surfaced the week before they become formal violations
- The credit team has a complete dealer-by-dealer covenant status in Slack every Monday without a manual spreadsheet pull
- At-risk dealers are ranked by severity so the most urgent relationships are addressed first
Built for auto lenders · credit teams · dealer relationship managers · indirect lending 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
docs.google.com/spreadsheetsin a real browser with your saved login - no setup, no API keys. -
1
Google Sheets - read covenant thresholds and current metric values
google.com
WebRun opens Google Sheets to read covenant thresholds and current metric values. - Open the Dealer Covenant Schedule sheet and read the covenant conditions for each dealer: minimum funded volume, maximum delinquency rate, and any other agreed thresholds
- Note the measurement period and the breach consequence for each condition
- Identify which metrics need to be refreshed from RouteOne for this week's check
Done when The covenant thresholds for every active dealer are loaded and ready for comparison.
-
2
RouteOne - pull latest dealer performance metrics
routeone.com
WebRun opens RouteOne to pull latest dealer performance metrics. - Open RouteOne and pull funded volume, application count, and approval rate for each dealer for the current measurement period
- Capture delinquency rates and outstanding contract counts where applicable
- Compare each metric to the corresponding covenant threshold and calculate the variance
Done when Every dealer's current performance metrics are compared against their covenant thresholds with variances calculated.
-
3
Slack - post covenant breach-risk alert to credit team
slack.com
WebRun opens Slack to post covenant breach-risk alert to credit team. - Post a covenant risk alert to the credit team Slack channel listing dealers in breach and those within 10 percent of a threshold
- Include the dealer name, the specific condition at risk, the current metric value, and the required threshold for each
- Post internally to the credit team channel only, never contact the dealer about a covenant breach directly
Done when The credit team has this week's covenant breach-risk alert in Slack with at-risk dealers listed by severity.
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
Will it notify the dealer about a covenant breach automatically?
No. WebRun posts only an internal Slack alert to your credit team. Any communication with the dealer about a covenant condition is made by a relationship manager after reviewing the alert.
Where do I store the covenant thresholds for each dealer?
You maintain the covenant schedule in a designated Google Sheet, with one row per dealer and columns for each condition and threshold. WebRun reads from that sheet each week and you update it whenever terms change.
Can it track covenants with quarterly measurement periods, not just weekly?
Yes. You configure the measurement period for each covenant condition in the Google Sheet, and WebRun only triggers a comparison for conditions whose measurement window falls within the current week.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.