All templates
For customs brokers, import compliance managers & trade operations teams

Track importer bond expiries before they lapse

Every Monday, WebRun opens Descartes, checks bond records for importers whose continuous or single-transaction bonds are expiring within 60 days, updates a Google Sheets tracker with expiry dates and bond amounts, and posts a summary alert to Slack so your team can start renewal outreach before any bond lapses.

  • No credit card
  • Under $0.01 per run
  • Cancel anytime
14,115 templates Safe automation No code
Every Monday at 8:00 AM WebRun
1 Descartes identify bonds expiring within 60 days
2 Google Sheets update the bond expiry tracker
3 Slack post a weekly renewal alert
Run a sample
In short

How do I automatically track importer bond expiry dates and get renewal alerts?

WebRun checks Descartes every Monday for importer bonds expiring within 60 days, flags the most critical ones, and updates a color-coded Google Sheets tracker. It also posts a Slack summary calling out bonds expiring within 14 days by name, so your team starts renewal conversations before any bond lapses.

  • No importer bond lapses because a renewal deadline was missed
  • Critical bonds expiring within 14 days are called out by name in Slack every Monday
  • The Google Sheet gives the team a 60-day forward view of all renewal workload

Built for customs brokers · import compliance managers · trade operations teams · surety bond 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 www.descartes.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    Descartes - identify bonds expiring within 60 days
    descartes.com How to Automate Descartes
    WebRun in Descartes: identify bonds expiring within 60 days
    WebRun opens Descartes to identify bonds expiring within 60 days.
    • Open Descartes and navigate to the importer bond management section
    • Filter to bonds with an expiry date within the next 60 calendar days
    • Capture importer name, bond type (continuous or single entry), bond amount, surety company, and expiry date
    • Flag any bonds expiring within 14 days as critical

    Done when All bonds expiring within 60 days are listed with their details and urgency flag.

  3. 2
    Google Sheets - update the bond expiry tracker
    google.com How to Automate Google Sheets
    WebRun in Google Sheets: update the bond expiry tracker
    WebRun opens Google Sheets to update the bond expiry tracker.
    • Open the bond expiry tracker Google Sheet
    • Upsert each expiring bond by importer name, updating expiry date and status for existing records
    • Highlight rows in red where expiry is within 14 days and amber where expiry is 15 to 30 days away

    Done when The Google Sheet reflects all bonds due for renewal, with urgency color coding.

  4. 3
    Slack - post a weekly renewal alert
    slack.com How to Automate Slack
    WebRun in Slack: post a weekly renewal alert
    WebRun opens Slack to post a weekly renewal alert.
    • Post a weekly Slack summary listing the count of bonds expiring in each urgency tier
    • Call out by name any bonds flagged as critical (expiring within 14 days)

    Done when The team has a weekly bond expiry summary in Slack with critical cases named.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
www.descartes.com
ScheduleRuns automatically on this cadence
Every Monday at 8:00 AM
DeliveryHow each run's result reaches you
Bond expiry tracker · Google Sheets + Slack
OutputWhat each run produces - A color-coded Google Sheet of importer bonds expiring within 60 days, with urgency tiers, plus a weekly Slack summary.
Spreadsheet
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 initiate bond renewals or contact the surety automatically?

No. WebRun tracks and surfaces expiry dates only. All bond renewals must be initiated by your brokerage team directly with the surety company.

Does it track both continuous and single-entry bonds?

Yes. It captures both continuous importer bonds and single-transaction bonds recorded in Descartes, as both types can expire and cause clearance issues.

What happens when a bond is renewed and Descartes is updated?

The next Monday run re-reads Descartes and removes any bond from the tracker whose expiry date has been updated beyond the 60-day window.

Put this on autopilot.

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