How to Export Delivered Orders Details into Google Sheets

Tracktor and Google Sheets

Mesa is an ecommerce automation platform with solutions for every aspect of your business, from inventory management to customizing order notes. Seamlessly connect your Shopify store and accompanying apps to a free template library of popular workflows within minutes.

*** Before reading on, if you haven’t downloaded Mesa already, click here to install and enjoy the benefits of a 14-day free trial. ***

###

Using Mesa, this tutorial will show how to export delivered order and fulfillment details from our order tracking app, Tracktor, into Google Sheets in a few quick steps.

Start with our workflow template:

Step-by-step instructions:

1. On your Mesa dashboard, type in “Export Order And Fulfillment” in the Search apps and templates field and select the template from the drop-down menu. 

automation

On the next page, click the green Start with this template button in the top right-hand corner.

automation

Confirm that you want to Install the template, once loaded you’ll now be able to View the New Workflow.

automation

2. Under Setup Instructions, click the View this Google Sheet and Make A Copy on the next window.

automation

Now might also be a good time to change the title of your Google Sheet from “Copy of Order and Fulfillment Details of Delivered Orders,” to something more specific to your brand. You’ll need to reference it later.

automation

The first step in the workflow will trigger when a Tracktor order has been delivered.

automation

In the next step, the Shopify order associated with the delivered product is retrieved. 

automation

3. You’ll now need to create a Credential and Authenticate it with Google in the Google Sheets Create Row – Fullfilments step. Under Configuration, you’ll update the Spreadsheet* with the title you choose in Step 2 and also assign the Sheet Name* to “Fulfillments”.

automation

Almost there! For the Google Sheets Create Row – Orders step, you’ll need to do similar to what you did for Google Sheets Create Row – Fullfilments, except this time you’ll input “Orders” for the Sheet Name*.

automation

Last Step: The most important

4. Once complete, scroll back up to the top of the page and click the Enable button in the top right-hand corner. 

Built-in Analytics

This workflow comes with some major added benefits. You’ll now be able to dig into order and fulfillment analytics previously unavailable. Filter orders by the number of days and view graphs of shipping by country, state, or province:

analytics

The workflow can even break down the number of fulfillments by each carrier and the average number of days to delivery by carrier:

analytics

Workflow Wrap Up

Now each delivered product in Tracktor will have a new row added in Google Sheets with order details. Every step in the workflow is 100% customizable. Change an event, add a step before/after or adjust the default settings. With Mesa, anything is possible!

Contact our team of automation experts if you need help getting started; tailor any template to meet your business needs.

Want to learn more? Here are some other popular workflow templates from our free Mesa library:

Get Mesa – 14 Day Free Trial

Master productivity instantly by automating any repeatable task or process with the ease of Mesa’s point-and-click setup. Our Customer Success team is here 24/7 to help set up and configure any workflows so you can get more done today.