Draft Freight Claims Automatically
Every morning, WebRun checks UPS for shipments flagged as damaged or lost, pulls the shipment details and invoice values from your tracking sheet, drafts a formal claim letter as a Gmail draft, and logs the claim status so you can review and submit with full documentation.
How can I automatically draft freight claims for damaged or lost shipments?
Every morning, WebRun checks UPS for shipments flagged as damaged or lost, pulls the shipment details and invoice values from your tracking Google Sheet, drafts a formal claim letter as a Gmail draft, and logs the claim status — so every valid claim is documented and ready to submit with full evidence.
- Every damaged or lost shipment has a draft claim ready by morning
- Full documentation pulled automatically from tracking records
- Claim status logged in Google Sheets for follow-up tracking
Built for logistics managers · ecommerce operators · supply chain teams · freight procurement managers
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.ups.com/us/en/business-solutions.pagein a real browser with your saved login — no setup, no API keys. -
1
UPS — identify damaged and lost shipments
- Open UPS My Choice for Business and filter tracking results to Exception status
- Identify shipments marked as Damaged, Lost, or Delivery Exception requiring follow-up
- Capture tracking number, service type, ship date, and the exception description
Done when All damaged and lost shipments are identified with their exception details.
-
2
Google Sheets — pull shipment value and evidence
google.com
WebRun opens Google Sheets to pull shipment value and evidence. - Open the Shipment Value sheet and look up the declared value and contents for each exception tracking number
- Note the shipper reference, recipient, and any damage photos already on file
- Add a Claims Log row for each new claim with status set to Draft
Done when Shipment values and claim details are matched and logged for every exception.
-
3
Gmail — draft the formal claim letter
gmail.com
WebRun opens Gmail to draft the formal claim letter. - Draft a formal claim letter for each shipment including tracking number, declared value, exception description, and requested reimbursement
- Attach a note listing what documentation to add (photos, invoice) before submitting
- Save as a Gmail draft addressed to the carrier claims team — do not send yet
Done when A complete claim draft exists in Gmail for every damaged or lost shipment, ready for your review.
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
Will it submit claims to the carrier automatically?
Never. Every claim is saved as a Gmail draft and logged for your review. Submission is always a deliberate human action — WebRun just does the paperwork prep.
What documentation do I need to add before submitting?
Each draft includes a checklist: photos of damage, original invoice, packaging description, and shipper/recipient details. The draft flags exactly what is still missing.
Can it handle DHL or FedEx claims too?
Yes — add the relevant carrier as an additional flow node and it will check that portal and draft claims in the same run.
Related templates
Put this on autopilot.
Turn it on in minutes — or have our team set it up for you.