All templates

Automated Submittable Application Status Digest

Every morning, WebRun opens Submittable, counts applications by stage across all active programs, including received, under review, awaiting decision, and awarded or declined, logs a snapshot to a Sheets dashboard, and posts a concise digest to Slack so your team and leadership know the pipeline status at a glance.

Runs on WebRun · Strict Lockdown policy
Every day at 8:30 AM WebRunorchestrates each step
1 Submittable count applications by stage and program
2 Google Sheets log daily pipeline snapshot
3 Slack post status digest to team channel
In short

How do I get a daily digest of grant application status across all Submittable programs?

WebRun opens Submittable every morning, counts applications at each stage across all active grant programs, logs a dated snapshot to a Google Sheets dashboard, and posts a concise digest to Slack. Leadership and program staff see the full pipeline, flagged bottlenecks, and a link to the detailed breakdown, all before 9 AM.

  • Leadership sees a complete pipeline count every morning without logging into Submittable
  • Review bottlenecks are flagged before they delay decisions for applicants
  • A growing Sheets history enables trend analysis on review velocity over time

Built for grantmakers · foundation leadership · grant program managers · nonprofit grants directors

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

  2. 1
    Submittable - count applications by stage and program
    submittable.com
    WebRun in Submittable: count applications by stage and program
    WebRun opens Submittable to count applications by stage and program.
    • Open Submittable and navigate to the submissions dashboard
    • For each active program, count applications in each stage: received, in review, awaiting decision, awarded, and declined
    • Note any program where the review queue has grown or where decisions are overdue compared to the prior day

    Done when Application counts by stage are captured for every active program.

  3. 2
    Google Sheets - log daily pipeline snapshot
    google.com
    WebRun in Google Sheets: log daily pipeline snapshot
    WebRun opens Google Sheets to log daily pipeline snapshot.
    • Open the grant pipeline dashboard sheet
    • Append a dated snapshot row for each program with counts per stage
    • Flag any program where the ratio of reviewed to received applications has dropped below 80 percent

    Done when Today's pipeline snapshot is logged to the dashboard sheet for trend tracking.

  4. 3
    Slack - post status digest to team channel
    slack.com
    WebRun in Slack: post status digest to team channel
    WebRun opens Slack to post status digest to team channel.
    • Post a daily digest to the grants team channel summarizing total applications received, under review, and decided across all programs
    • Highlight any program where decisions are overdue or the review queue has grown significantly
    • Include a link to the Sheets dashboard for the full breakdown

    Done when The team has today's pipeline digest in Slack with a link to the dashboard.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
app.submittable.com
ScheduleRuns automatically on this cadence
Every day at 8:30 AM
DeliveryHow each run's result reaches you
Pipeline digest · Slack
OutputWhat each run produces - A daily application pipeline snapshot in Google Sheets plus a Slack digest with counts by stage across all active programs.
Text
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 applicants or share any application data externally?

No. The digest is posted only to your internal Slack channel and logged to your internal Google Sheet. No application data is shared with anyone outside your organization.

Can it cover multiple grant programs in the same digest?

Yes. It reads all active programs in Submittable in a single run and produces a unified digest that shows counts per stage for each program side by side.

How far back does the Sheets dashboard go?

It appends a dated snapshot each morning, so the dashboard builds a running history from the day you set it up. You can use the historical rows to track review velocity over time.

Put this on autopilot.

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