How to extract tracking references from selected Gmail messages
Tracking details are easier to review when the carrier and identifier stay linked to the relevant order. This tool organizes the shipping information supplied from selected Gmail content.
Start with the right material.
- What you provide
- a shipping email or thread opened in Gmail, with shipment details expanded and readable.
- The intended result
- Extract visible order IDs, carriers and tracking numbers from an opened Gmail shipping thread into CSV.
How the workflow works.
Distinguish a tracking number from an order number and preserve the carrier name where stated. Keep multiple packages as separate records when the message explicitly describes them.
What to check in the result.
Check each reference against the original message before using it. The email's shipment wording is historical evidence, so current delivery status still needs confirmation through the appropriate carrier source.
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: Order ID, Carrier, Tracking number, Tracking URL, Delivery estimate. 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.