Flexport Automated FTA Eligibility Flags
Every Monday, WebRun reviews shipments booked in Flexport over the coming week, checks each product's HTS code and country of origin against active free trade agreements, and builds an FTA eligibility flags list in Google Sheets. It then posts a Slack summary showing the potential duty savings your team can claim before the shipment is filed.
How do I automatically identify shipments eligible for FTA duty savings?
WebRun reviews upcoming Flexport shipments every Monday, checks each product's HTS code and country of origin against active free trade agreements, and builds an FTA eligibility flags list in Google Sheets with estimated duty savings. A Slack summary shows the week's total savings opportunity so your team can claim every available preference before filing.
- Every qualifying shipment flagged for FTA preference before it is filed at standard rates
- Estimated duty savings quantified in Google Sheets each week
- Documentation gaps identified so origin certificates can be obtained in time
Built for trade compliance managers · customs brokers · import directors · procurement teams · supply chain finance teams
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
app.flexport.com/shipmentsin a real browser with your saved login - no setup, no API keys. -
1
Flexport - identify upcoming shipments and product details
flexport.com
WebRun opens Flexport to identify upcoming shipments and product details. - Open Flexport and filter upcoming shipments booked for the next 10 days
- For each shipment, pull the product HTS codes, country of origin, and declared value
- Identify the trade lanes and check which active FTAs apply (e.g. USMCA, CPTPP, USKOR)
Done when All relevant shipment and product details are captured for FTA analysis.
-
2
Google Sheets - build the FTA eligibility flags list
google.com
WebRun opens Google Sheets to build the FTA eligibility flags list. - Append each potentially eligible shipment to the FTA Eligibility Flags sheet with HTS code, origin, applicable FTA, standard duty rate, and potential preferential rate
- Calculate the estimated duty saving per shipment
- Flag items where origin documentation must be obtained to claim the preference
Done when The FTA eligibility list is populated with estimated savings and documentation requirements.
-
3
Slack - post the weekly duty savings summary
slack.com
WebRun opens Slack to post the weekly duty savings summary. - Post a weekly FTA savings summary to the trade compliance Slack channel
- Show the total potential saving across flagged shipments and list the top opportunities
- Link to the full Google Sheets list for the team to action
Done when The team has the weekly FTA savings summary in Slack.
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 automatically file the FTA preference claim with customs?
No. WebRun flags the opportunity and queues the shipment for your team. Claiming preferential duty rates requires your broker to file the appropriate declaration, which must be verified and approved by a human.
Which free trade agreements does it check?
It checks the trade lanes and country of origin on each Flexport shipment against the active FTAs relevant to your import country. Your team should confirm the specific agreements configured match your regulatory environment.
What if the origin documentation is not yet in hand?
The Google Sheets list includes a column flagging when origin certificates or supplier declarations are still needed to substantiate the claim. Your team can use this to chase the supplier in advance.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.