Automated Grant Delinquency Risk Worklist
Every Monday, WebRun opens Submittable, scans all active awards for delinquency signals including missed report deadlines, overdue drawdown requests, and extended periods with no applicant activity, scores each grant by risk level, logs the worklist to Google Sheets, and posts the highest-risk cases to Slack for immediate action.
How do I identify at-risk grant awards before they become compliance issues?
WebRun scans every active grant award in Submittable each Monday for delinquency signals such as missed reports, late drawdown requests, and extended inactivity, then scores each by risk level. It logs a ranked worklist to Google Sheets and posts the top high-risk cases to Slack so your grants team can intervene before a compliance problem develops.
- High-risk awards surface every Monday before they escalate into compliance findings
- Program officers see only the top cases in Slack, not a wall of data
- Risk scores update automatically as grantees resolve flagged items in Submittable
Built for grantmakers · foundation compliance officers · grant program managers · nonprofit grants directors
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
app.submittable.comin a real browser with your saved login - no setup, no API keys. -
1
Submittable - scan awards for delinquency signals
submittable.com
WebRun opens Submittable to scan awards for delinquency signals. - Open Submittable and navigate to active award records
- For each award, check for: overdue progress or final reports, missing scheduled drawdown requests, and periods of 30 or more days with no grantee activity
- Score each award as high, medium, or low risk based on the number and type of signals found
- Capture the award name, grantee, program, risk score, and specific signals flagged
Done when Every active award has been scanned and assigned a risk level with the specific signals documented.
-
2
Google Sheets - log ranked risk worklist
google.com
WebRun opens Google Sheets to log ranked risk worklist. - Open the grant delinquency risk worklist sheet
- Update each award's row with the current risk score, signals flagged, and last activity date
- Sort the list so high-risk awards appear at the top
- Mark any award that moved from medium to high risk since last week
Done when The worklist is updated and sorted by risk level for this week's review.
-
3
Slack - alert team to highest-risk cases
slack.com
WebRun opens Slack to alert team to highest-risk cases. - Post the top 5 highest-risk awards to the grants team channel with the grantee name, risk signals, and days since last activity
- Include a link to the full worklist in Google Sheets
- Tag the responsible program officer for each high-risk case
Done when The grants team has this week's top at-risk cases in Slack for immediate follow-up.
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 contact grantees directly when a risk flag is raised?
No. WebRun posts an internal Slack alert and updates the worklist for your grants team. Any outreach to grantees about at-risk awards is handled separately and requires human approval.
How does it define a high-risk award?
It flags an award as high risk when two or more delinquency signals are present: for example, an overdue report combined with no drawdown activity for 30 or more days.
What if a grantee resolves a delinquency between runs?
It reads live award data from Submittable each Monday, so resolved items are removed from the high-risk list automatically and the risk score is recalculated.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.