All templates

Automated Pawn Loan Maturity Weekly Digest

Every Monday morning, WebRun opens PawnMaster, collects all loans maturing in the next seven days, groups them by days to maturity, logs the full list to a Google Sheet for compliance records, and posts a structured Slack digest so your team can plan the week's customer outreach before any loan expires unnoticed.

Runs on WebRun · Strict Lockdown policy
Every Monday at 7:30 AM WebRunorchestrates each step
1 PawnMaster collect loans maturing this week
2 Google Sheets log maturity details for compliance
3 Slack post weekly maturity digest to staff
In short

How do I get a weekly pawn loan maturity digest for my staff?

WebRun pulls every loan maturing in the next seven days from PawnMaster every Monday morning, groups them by urgency, logs the details to a Google Sheet compliance record, and posts a structured Slack digest to help staff plan the week's outreach. No customer is contacted by this workflow. It is a planning tool for your team only.

  • Managers start every week with a complete seven-day view of maturing loans
  • Outreach is planned ahead of time, not scrambled at the last minute
  • A compliance log in Google Sheets captures every weekly snapshot automatically

Built for pawn shop owners · pawn shop managers · pawnbroker compliance staff

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

  2. 1
    PawnMaster - collect loans maturing this week
    pawnmaster.com
    WebRun in PawnMaster: collect loans maturing this week
    WebRun opens PawnMaster to collect loans maturing this week.
    • Open PawnMaster and filter the active loan list for tickets with a maturity date in the next seven days
    • Capture ticket number, customer name, contact details, loan amount, interest outstanding, and exact maturity date for each
    • Count loans by day: how many mature today, tomorrow, in two to three days, and later this week

    Done when All loans maturing within seven days are collected and grouped by urgency tier.

  3. 2
    Google Sheets - log maturity details for compliance
    google.com
    WebRun in Google Sheets: log maturity details for compliance
    WebRun opens Google Sheets to log maturity details for compliance.
    • Open the loan maturity compliance log Google Sheet
    • Append a weekly snapshot row for each maturing loan with today's run date
    • Update the rolling seven-day and 30-day maturity totals at the top of the sheet

    Done when This week's maturing loans are logged to the compliance sheet and running totals are updated.

  4. 3
    Slack - post weekly maturity digest to staff
    slack.com
    WebRun in Slack: post weekly maturity digest to staff
    WebRun opens Slack to post weekly maturity digest to staff.
    • Post a structured weekly digest to the manager Slack channel with loans grouped by days to maturity
    • Highlight any loans maturing today that have not had a reminder sent yet
    • Include total loan value at risk this week and a link to the full Google Sheet

    Done when Staff have this week's loan maturity digest in Slack and can assign outreach tasks for each tier.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
www.pawnmaster.com
ScheduleRuns automatically on this cadence
Every Monday at 7:30 AM
DeliveryHow each run's result reaches you
Loan maturity digest · Slack
OutputWhat each run produces - A Google Sheet compliance log and a weekly Slack digest showing all loans maturing in the next seven days, grouped by urgency.
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 this digest send anything to customers?

No. The maturity digest is a purely internal report for your staff. It surfaces which loans need attention so your team can plan outreach. All customer-facing communication is handled separately and requires staff approval.

What is the difference between this digest and the daily loan renewal reminders?

The weekly digest is a planning tool: it gives your team a full seven-day view every Monday so outreach can be scheduled ahead of time. The daily reminder workflow then drafts and queues the individual customer messages each morning.

Can I include loans from multiple store locations in one digest?

Yes, if your PawnMaster setup covers multiple locations. WebRun can pull from all locations in a single run and group the digest by store so each manager sees the loans relevant to their location.

Put this on autopilot.

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