All templates

Automated Freight Factoring Application Status Digest

Every morning, WebRun opens OTR Solutions, checks the status of every pending carrier application, logs the stage and any missing documents to a Google Sheet, and posts a daily pipeline digest to Slack so your onboarding team has a clear picture of where each application stands without manual follow-up.

Runs on WebRun · Strict Lockdown policy
Every day at 8:00 AM WebRunorchestrates each step
1 OTR Solutions check status of pending carrier applications
2 Google Sheets log application stage and missing items
3 Slack post daily application pipeline digest
In short

How do I automatically track carrier factoring application status through the pipeline?

WebRun checks OTR Solutions every morning for all pending carrier factoring applications, logs each application's stage, missing documents, and days in stage to a Google Sheet, and posts a daily digest to Slack with any stalled applications highlighted and reviewers tagged so nothing sits unworked for days.

  • Every pending carrier application tracked from submission to approval
  • Stalled applications flagged and reviewers notified within 3 business days
  • Onboarding team starts each day with a current pipeline digest

Built for freight factoring onboarding teams · carrier account managers · trucking operations coordinators

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

  2. 1
    OTR Solutions - check status of pending carrier applications
    otrsolutions.com
    WebRun in OTR Solutions: check status of pending carrier applications
    WebRun opens OTR Solutions to check status of pending carrier applications.
    • Open OTR Solutions and navigate to pending or in-review carrier applications
    • For each application, record the carrier name, MC number, application date, current stage, and any items flagged as outstanding or missing
    • Note how many days each application has been in its current stage

    Done when All pending applications are listed with stage, missing items, and days in stage.

  3. 2
    Google Sheets - log application stage and missing items
    google.com
    WebRun in Google Sheets: log application stage and missing items
    WebRun opens Google Sheets to log application stage and missing items.
    • Update the application pipeline Google Sheet with today's status for each pending carrier
    • Add or update columns for carrier name, application date, current stage, missing items, days in stage, and assigned reviewer
    • Flag applications that have been in the same stage for more than 3 business days

    Done when The pipeline sheet reflects today's status for every pending application with stalled ones flagged.

  4. 3
    Slack - post daily application pipeline digest
    slack.com
    WebRun in Slack: post daily application pipeline digest
    WebRun opens Slack to post daily application pipeline digest.
    • Post the daily application digest to the onboarding Slack channel
    • Include total applications pending, breakdown by stage, and names of any stalled for more than 3 days
    • Tag the assigned reviewer for each stalled application

    Done when The onboarding team has today's application pipeline in Slack with stalled applications highlighted.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
client.otrsolutions.com
ScheduleRuns automatically on this cadence
Every day at 8:00 AM
DeliveryHow each run's result reaches you
Application digest · Slack
OutputWhat each run produces - A daily application pipeline digest in Slack plus an updated Google Sheet tracking each carrier application's stage, missing items, and days in stage.
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

What stages does a carrier factoring application go through?

OTR Solutions application stages typically include submitted, documents under review, approved, and active. WebRun tracks the current stage and flags any application that has not moved in 3 or more business days.

Will it contact the applying carrier with status updates?

No. The digest is an internal tool for your onboarding team. Any communication to an applicant is a separate human-initiated step after reviewing the pipeline.

What triggers the stalled flag?

Any application that has been in the same stage for more than 3 consecutive business days is flagged as stalled. The assigned reviewer is tagged in Slack so the team can investigate.

Put this on autopilot.

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