All templates
For freight forwarders, logistics finance teams & accounts receivable

Chase overdue freight forwarding invoices before they age further

Every Monday, WebRun opens Magaya, finds all unpaid invoices past their due date, logs them in a Google Sheet ranked by aging and amount, and drafts a polite payment reminder in Gmail for each client, leaving every draft unsent for your team to review before anything goes to a customer.

  • No credit card
  • Under $0.01 per run
  • Cancel anytime
14,115 templates Safe automation No code
Every Monday at 9:00 AM WebRun
1 Magaya find invoices past their due date
2 Google Sheets log overdue invoices ranked by aging
3 Gmail draft payment reminder for each client
Run a sample
In short

How do I automatically chase overdue freight forwarding invoices from Magaya?

WebRun opens Magaya every Monday, finds all unpaid invoices past their due date, and logs them in a Google Sheet ranked by aging and amount. It then drafts a polite payment reminder in Gmail for each client. Your team reviews every draft before sending, so no overdue balance is missed and no reminder goes out without approval.

  • Every overdue invoice chased weekly without manual effort
  • Google Sheet gives finance a live ranked view of outstanding balances
  • Payment reminder drafts personalized with the exact invoice number and amount

Built for freight forwarders · logistics finance teams · accounts receivable · freight operations managers

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

  2. 1
    Magaya - find invoices past their due date
    magaya.com How to Automate Magaya
    WebRun in Magaya: find invoices past their due date
    WebRun opens Magaya to find invoices past their due date.
    • Open Magaya and navigate to the Accounts Receivable module
    • Filter invoices to those with a due date in the past and a status of unpaid
    • Capture the invoice number, client name, client email, amount due, due date, and days overdue for each

    Done when Every overdue invoice is listed with its aging, amount, and client contact details.

  3. 2
    Google Sheets - log overdue invoices ranked by aging
    google.com How to Automate Google Sheets
    WebRun in Google Sheets: log overdue invoices ranked by aging
    WebRun opens Google Sheets to log overdue invoices ranked by aging.
    • Open the accounts receivable Google Sheet
    • Update the overdue invoice log with this week's findings, sorted by days overdue descending
    • Mark any invoices that have since been paid as resolved

    Done when The Google Sheet has a current ranked list of all overdue invoices.

  4. 3
    Gmail - draft payment reminder for each client
    gmail.com How to Automate Gmail
    WebRun in Gmail: draft payment reminder for each client
    WebRun opens Gmail to draft payment reminder for each client.
    • Draft a polite, on-brand payment reminder for each client with an overdue invoice
    • Reference the specific invoice number, amount, and due date in each email
    • Save every email as a Gmail draft addressed to the client, leaving it unsent for team review

    Done when One ready-to-review Gmail payment reminder draft exists for each client with an overdue invoice.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
app.magaya.com
ScheduleRuns automatically on this cadence
Every Monday at 9:00 AM
DeliveryHow each run's result reaches you
Overdue invoice log · Google Sheets
OutputWhat each run produces - A Google Sheet of ranked overdue invoices plus one Gmail draft payment reminder per client, each referencing the specific invoice details.
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

Will it email clients about overdue invoices on its own?

No. Every payment reminder is saved as a Gmail draft for your team to review before sending. Nothing is sent to a client without human approval.

Does it skip clients who are on a payment plan?

If a payment arrangement is noted in the Magaya invoice record or the aging status reflects it, WebRun will flag the invoice for manual review rather than treating it as a standard overdue item.

Can I set a minimum invoice amount to chase?

Yes. A minimum amount threshold can be configured at setup so WebRun skips invoices below the value you choose and focuses on balances that matter most.

Put this on autopilot.

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