Instead of manually uploading spreadsheets to the OpenTrack dashboard, your team can send tracking files directly from your TMS, ERP, or other internal systems. OpenTrack will process the file and automatically begin tracking the shipments in your account.
This helps eliminate manual uploads and allows shipment tracking to start automatically as part of your operational workflow.
How Email Tracking Works
You can send an email with a shipment spreadsheet attached to a dedicated OpenTrack email address.
Once the email is received:
OpenTrack processes the spreadsheet attachment
Extracts the shipment identifiers and any mapped fields
Automatically begins tracking the shipments in your account
Many teams configure their systems to automatically send shipment reports to OpenTrack so tracking begins without any manual work.
💡 Tip: This feature is commonly used to automate tracking directly from a TMS or ERP system.
Step 1: Request Email Tracking Setup
Email-based tracking must first be configured by the OpenTrack team.
If you are interested in automating tracking through email uploads, contact your OpenTrack support manager or email: support@opentrack.co
Our team will review your workflow and enable email ingestion for your account
Step 2: Provide Your Spreadsheet Format
Your shipment spreadsheet can be formatted in one of two ways.
Option 1: Use the OpenTrack Bulk Upload Template
You can use the same spreadsheet structure used for Bulk Upload.
The default fields include:
Master Bill
Container ID
Carrier SCAC
You can download this template from:
Start Tracking → Bulk Upload → Download Bulk Import CSV Template
Option 2: Use Your Existing System Export
If you plan to automate tracking from a TMS or ERP, you do not need to change your file format.
The OpenTrack team can map your existing spreadsheet structure to the required tracking fields.
This allows your system to send reports exactly as they are generated today.
💡 Set up inbox rules in Outlook (click for instructions) or Gmail (click for instructions) to automatically forward spreadsheets to OpenTrack.
Step 3: Start Sending Emails
Once email processor is activated, you will send emails to → imports+tracking@opentrack.co.
Send your shipment spreadsheet as an email attachment to that address.
OpenTrack will automatically process the file and begin tracking any valid shipments.
Step 4: Verify Your Shipments
After the file is processed, shipments will appear in the Tracked Containers view.
OpenTrack will automatically begin discovering containers and monitoring shipment milestones.
Need Help?
To start the process in setting up automated tracking or configuring your file format, contact: support@opentrack.co
Our team can help review your spreadsheet format and configure the automation workflow.
Next Steps
Now that you know how to automate shipment tracking, you can learn how to stop tracking shipments that are no longer needed.