All templates

Automated nCino Covenant Compliance Tracking

Every morning, WebRun opens nCino, reads the covenant conditions on every active loan, identifies any covenant test or reporting deadline due within 30 days, logs the status in a Google Sheet, and posts an alert to the lending team in Slack so relationship managers can act before a borrower falls out of compliance.

Runs on WebRun · Strict Lockdown policy
Every day at 7:30 AM WebRunorchestrates each step
1 nCino read covenant conditions on active loans
2 Google Sheets log compliance status and due dates
3 Slack alert the team to upcoming covenant deadlines
In short

How can I automatically track loan covenant compliance in nCino?

WebRun opens nCino every morning and reads every covenant condition on active loans, flags anything due within 30 days, and updates a Google Sheet compliance log. It then posts a ranked Slack digest to the lending team so relationship managers can contact borrowers and collect covenant deliverables before any deadline is missed.

  • No covenant deadline slips past 30 days without a team alert
  • Relationship managers start each day knowing exactly which borrowers need a call
  • The compliance log stays current without manual data entry

Built for commercial relationship managers · credit analysts · community banks · commercial lenders

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

  2. 1
    nCino - read covenant conditions on active loans
    ncino.com
    WebRun in nCino: read covenant conditions on active loans
    WebRun opens nCino to read covenant conditions on active loans.
    • Open nCino and navigate to the loan portfolio
    • For each active loan, read the covenant conditions and their next due dates
    • Flag any covenant test, financial statement delivery, or reporting requirement due within 30 days
    • Note the borrower, relationship manager, covenant type, and days remaining

    Done when Every covenant condition due within 30 days is captured with its details and assigned owner.

  3. 2
    Google Sheets - log compliance status and due dates
    google.com
    WebRun in Google Sheets: log compliance status and due dates
    WebRun opens Google Sheets to log compliance status and due dates.
    • Open the covenant compliance tracker Google Sheet
    • Update the status column for any covenant received or cleared since the last run
    • Add any newly flagged covenants as new rows with the due date and owner

    Done when The Google Sheet reflects today's covenant compliance picture across the entire portfolio.

  4. 3
    Slack - alert the team to upcoming covenant deadlines
    slack.com
    WebRun in Slack: alert the team to upcoming covenant deadlines
    WebRun opens Slack to alert the team to upcoming covenant deadlines.
    • Post a daily digest to the lending team channel listing covenants due within 30 days, sorted by urgency
    • Highlight any covenant already past due in a separate alert

    Done when The team has today's covenant compliance digest in Slack with all upcoming deadlines visible.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
app.ncino.com
ScheduleRuns automatically on this cadence
Every day at 7:30 AM
DeliveryHow each run's result reaches you
Covenant log · Google Sheets · Slack
OutputWhat each run produces - A Google Sheet covenant compliance log updated daily, plus a Slack digest of upcoming and overdue covenant deadlines across the portfolio.
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 contact borrowers when a covenant deadline is approaching?

No. WebRun posts an internal digest to Slack and updates the Google Sheet for your team to act on. Any borrower outreach is initiated by the relationship manager, not the automation.

How far ahead does it flag covenant deadlines?

It flags all covenant conditions due within 30 days by default, and escalates anything already past due in a separate Slack alert so nothing is overlooked.

What types of covenants does it track?

It reads all covenant condition types in nCino, including financial statement delivery, DSCR tests, liquidity ratios, and any custom covenant fields your institution has configured.

Put this on autopilot.

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