How to extract shipment details from a shipping email
Shipping messages usually combine order information with a carrier reference and delivery wording. Structured extraction helps organize those details without confusing an order number with a tracking number.
Start with the right material.
- What you provide
- an opened shipping confirmation email.
- The intended result
- Extract carrier, tracking number, stated ETA and tracking URL; no live tracking lookup.
How the workflow works.
Keep the carrier, tracking reference, order reference and stated status in separate fields. Preserve wording such as estimated delivery so an estimate does not become a guaranteed arrival date.
What to check in the result.
Compare the tracking identifier character by character and verify any current status with the carrier. The extracted email describes what that message said, not necessarily the shipment's latest position.
Import the CSV with a consistent delimiter and inspect text identifiers, dates and amounts before using spreadsheet totals. Keep the original file available while checking any automatic type conversion.
Learn from the worked example.
The downloadable CSV example uses these columns: Carrier, Tracking number, Stated ETA, Tracking URL. Compare a complete record with the source before sorting, combining or importing your own output.
The supplied example is illustrative. It is not a recorded run on your data.
Download the example ↓Use it with your own material.
- Open the source you want to work with and activate WebAct on that tab.
- Copy the task from the hero, add any required fields or preferences, and review the proposed actions.
- Compare the first result with your source. Ask for a specific correction or refinement where needed.