How to Connect Shopify Orders to Google Sheets

how to connect shopify orders to google sheets

When fulfillment or manufacturing processes require that your customer’s order details are organized into a spreadsheet for their machines to read, the answer is often a manual task that can take up many hours each week. However, this can be easily turned into an automated workflow using Mesa.

In this tutorial, we’re going to send line-item property data from our product options app, Infinite Options, into a new row on Google Sheets.

Step 1: Build Your Workflow

On the Mesa dashboard, we’ll select “Infinite Options” from the Connect This… menu, followed by “Order Created” in the When this happens… dropdowns. In the With this one… menu, we’ll select “Google Sheets” as our output and then “Row Add” in the Then do this… dropdowns.


Click Make My Automation. Now you’ll be taken to the builder page that will look like this:


Step 2: Get Line Item Properties

Since we are organizing line-item properties into Google sheets, we need to add one more step to this automation before we fill in the details. We need to place an iterator before the Transform section. We use an iterator here because a line item property will often have more than one piece of data stored in it. The iterator tells Mesa to continue rerunning this step until each piece of data in the property has been included.

So click the plus sign between the Transform section and the trigger. Choose Mesa Iterator

automation builder

Within the iterator, you must specify which property Mesa needs to continue to relook at. In this case, it’s the line item property, so choose {{source.line_items}} from the Insert dropdown.

automation builder

Step 3: Add Line Items to Google Sheets

Up next we need to specify which pieces of data are going to go in which column of the Google sheet. In the Transform section, the Key refers to the column the data will be placed in, while the Value refers to which piece of order data will be put in that column. You will need to add a row for each distinct piece of data you want to organize into the sheet.

For my example order, you can see that I’ve included columns for the order’s shipping details as well as item details.

data mapping

Step 4: Customize Your Workflow

The final step in this workflow is to tell Mesa which spreadsheet to output this data to. If you haven’t authenticated your Google account credentials, you’ll need to do that first. Once that’s done, you can search for your spreadsheet by name in the search bar. My spreadsheet is called My Orders.


You can see that once the automation’s enabled, the result appears in my sheet like this: 

google sheets example

Workflow Wrap Up

This workflow can be altered for any Shopify app that affects your order details, as well as for whichever spreadsheet type you’d like to output to.

Have unique needs? Our team of experts is available to meet the custom requirements of your business. Contact us.

If you enjoyed this workflow tutorial, you may like these other workflow templates: