Skip to main content
All CollectionsStart Tracking
Automate Your Container Tracking: Send a Spreadsheet via Email
Automate Your Container Tracking: Send a Spreadsheet via Email
Bethany Morrill avatar
Written by Bethany Morrill
Updated over 2 months ago

We’re excited to announce that you can now send tracking requests through email. This eliminates the need to create and manually upload spreadsheets to track containers.


The main goal of this feature is to enable you to never have to manually upload a spreadsheet to OpenTrack again.

Instead, you can automatically send a spreadsheet from your TMS via email, and OpenTrack will track your containers – all without you lifting a finger. Here’s how it works.

How it works

  1. You can now send an email to a dedicated OpenTrack email address with your tracking spreadsheet attached.

  2. Set up these emails to automatically send to OpenTrack from your TMS, completely removing the need for manual spreadsheet tasks to start your track & trace workflow.

  3. OpenTrack will automatically extract the containers and any custom fields you specify from your spreadsheet and track them in your account.

💡 Set up inbox rules in Outlook (click for instructions) or Gmail (click for instructions) to automatically forward spreadsheets to OpenTrack.

By automating spreadsheet uploads, you can save time on manual data entry and focus more on your core operations.

How to get started

  1. Decide on your spreadsheet template. Two options: A) Send us the email template you plan to use, or B) confirm you can use our standard template.
    Access our template by navigating to Start Tracking page in the OpenTrack web app's left navigation > Click on Bulk Upload > Click on Download Bulk Import CSV Template.

  2. We activate it for your account, and give you the signal when your account is ready.

  3. Start sending emails to imports+tracking@opentrack.co. If your spreadsheet is set up correctly and contains valid shipments, OpenTrack will track them automatically.
    Need help automating reports out of your TMS? Talk to us, we may be able to help.

  4. Save time on manual spreadsheet uploads, and spend that time doing something more valuable.

💡 Alternatively, we can directly pull data from your server through a secure SSL connection. Let us know if you’d prefer this option.

Have questions or feedback? Don't hesitate to reach out to us at support@opentrack.co, we're here to help you automate your workflows.

Did this answer your question?