How to export Shopify orders to Google Sheets when they’re delivered

Using MESA, this tutorial will show how to export Shopify orders and fulfillment details from the order tracking app, Tracktor, into Google Sheets in a few quick steps. Since Shopify isn’t aware of fulfillment status, we need to use the Tracktor app to start this workflow, not Shopify. However, another great tutorial is learning how to simply export orders from Shopify to Google Sheets if that’s all you’re after.

Start with the pre-made workflow template:

Step-by-step instructions: Export Shopify orders to Google Sheets

Time needed: 15 minutes

These step-by-step instructions will connect Shopify fulfillments to Google Sheets. Install MESA on your Shopify store before proceeding.

  1. First, add the workflow template

    From the MESA Discovery tab, type in “export order” in the search field and select the template from the drop-down menu. export-fulfilled-shopify-orders

  2. Next, add your Google Sheets credentials

    Select from the dropdown list or click the Add New Credential button to save your login details.
    export shopify order to google sheets authentication

  3. View and Copy this Google Sheet sample file

    View this Google Sheet and make a copy to your Google Sheets account.Copy Google Sheets sample

  4. Optionally, change the title of your sample Google Sheets file.

    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.
    Google Sheets sample

  5. Return to your workflow, choose the newly copied Google Sheets file for Fulfillments.

    Under the Google Sheets – Create Row – Fulfillments step, select the existing file that was just copied to your account and choose Fulfillments on the Sheet Name field. Click Done when completed.
    Google Sheets selected fields

  6. Next, choose the newly copied Google Sheets file for Orders

    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*.
    google sheets orders fields

  7. Lastly, Save and Enable your automation.

    Click the “Save” button to keep the existing or any optional configuration changes to this workflow.

    Finally, be sure to enable this automation by turning it “On” so this automation runs every time a new fulfillment status is updated. MESA will proudly celebrate your achievement by popping confetti in your honor. Congratulations!export shopify order to google sheets automation

More 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:

Shopify Orders Analytics
Shopify Orders Analytics

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

Shopify Fulfillment Analytics
Shopify Fulfillment Analytics

Workflow Wrap Up

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

So, what's next?

  1. Add MESA from the Shopify App Store. Enjoy a 7-day free trial to start.
  2. Ask the experts if you need help personalizing any workflow, or ask us to build one for you. We're happy to help!
  3. Discover pre-made, customizeable automation templates.
We literally wrote the book on Shopify automation

Learn how to make Shopify work easier with your business processes.

Get the playbook - Free!

shopify automation playbook PDF