Automated Descartes Daily Clearance Report
Every evening, WebRun opens Descartes, retrieves all entries that received a final release status during the current business day, compiles them into a structured clearance report, and writes it to Google Sheets so management and clients have a complete, timestamped record of the day's customs throughput.
How do I automatically produce a daily customs clearance report from Descartes?
WebRun opens Descartes each evening and retrieves every entry that received a release status during the business day. It writes the full list with release times and duty totals to a Google Sheet, appending to a rolling log so management and clients have a complete, timestamped daily clearance record without any manual export.
- Management has a complete clearance report every evening without anyone pulling a manual Descartes export
- Rolling Google Sheets log gives instant access to historical clearance data for any date
- Entries still pending at end of day are flagged so follow-up can begin first thing in the morning
Built for customs brokers · brokerage operations managers · import compliance teams · logistics directors
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
www.descartes.comin a real browser with your saved login - no setup, no API keys. -
1
Descartes - retrieve today's cleared entries
descartes.com
WebRun opens Descartes to retrieve today's cleared entries. - Open Descartes and filter the entry workbench to entries that received a release status today
- Capture entry number, importer, port of entry, release time, entry type, and total duty paid for each cleared entry
- Also note any entries that were pending release at end of day but not yet released
Done when All entries released today are listed with clearance details, plus a note on any still pending.
-
2
Google Sheets - write the daily clearance report
google.com
WebRun opens Google Sheets to write the daily clearance report. - Open the daily clearance report Google Sheet
- Append today's cleared entries to the running log with the report date as a column
- Write a summary row at the top of today's section showing total entries cleared, total duty paid, and count still pending
- Apply formatting so each day's batch is visually separated from the previous
Done when Today's clearance report is written to Google Sheets with a summary row and full entry detail.
How is each run configured?
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.
Every action is checked against this policy before it runs.
Questions, answered
Does it modify any entries in Descartes?
No. WebRun reads clearance data from Descartes only. It never changes, files, or amends any entry.
Is the report cumulative or just today's data?
Both. Each day's entries are appended to a running log in Google Sheets, so you have a full rolling history. Today's batch is clearly separated with a date header and summary row.
Can I share the Google Sheet with clients to give them clearance visibility?
Yes. You can share individual Google Sheet tabs with clients using standard Google Sheets sharing controls, filtered to their entries only. WebRun writes the data; sharing is your choice.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.