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

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.

Create a workflow for line-item properties on Shopify order to Google Sheets

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

Edit a workflow for line-item properties on Shopify order to Google Sheets

Step 2

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

Add an iterator to a workflow for line-item properties on Shopify order to Google Sheets

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.

Close-up of Mesa iterator

Step 3

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.

Mapping the properties in a Shopify order to Google Sheet columns

Step 4

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.

Selecting a Google Sheet account and spreadsheet from a Mesa step

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

Example of a Shopify order on a Google Sheet spreadsheet

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.

Start a free trial

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

How to Protect Your Shopify Store with a Federal Trademark
How to Send an Email for a Shopify Order Containing a Customized Product
How to Send an Email for a Shopify Order Containing a Customized Product