How to Connect Shopify to Google Sheets

Jen Sparks
Last Updated September 1, 2022

In this post, we’re going to show you how to connect Shopify to Google Sheets. Then, saving Shopify orders to Google Sheets, for example, is easy. Then you can unify more data sources using the same workflow.

When your business requires that your customer’s order details are organized into a spreadsheet, the answer is often a manual task that can take up many hours each week.

But with MESA, Shopify to Google Sheets is as simple as just a few clicks!

Start with a workflow template: Shopify to Google Sheets

Watch: Shopify to Google Sheets Tutorial

Video Tutorial: Connect Shopify to Google Sheets

Time needed: 10 minutes.

Follow these step-by-step instructions to connect Shopify orders to Google Sheets. Be sure to install MESA on your Shopify store before proceeding.

Locate the workflow template “Send orders to Google Sheets”.
On the MESA Discover page, type in “Send orders to Google Sheets” in the Search field and select the template below by clicking on the “Try It” button.
Add your credentials for Google Sheets.
Click the button “Add New Credential”. If you already have created a credential, select an existing one in the Existing Credentials drop-down menu.
Choose the type of Google app to authenticate your credentials.
We recommend using the “MESA Google App” to authenticate with Google. For advanced users, you can set up your own custom Google app. Click the “Authenticate with Google” button to start to log in and authorize Google Sheets access.
Create a new Google Sheet spreadsheet (recommended).
Add a name for the new spreadsheet then click the button “Create Spreadsheet”. You’ll notice MESA automatically configures the spreadsheet with the most common order data from Shopify.

For advanced users, you can choose an existing spreadsheet to match the data and spreadsheet columns. You can also click “Add Column” to bring additional Order details you may need.
Finish configuring your Google Sheet spreadsheet.
After creating your spreadsheet, you’ll have the option to open and view the newly created file and format it however you choose. When you’re ready, click the “Done” button to complete this workflow setup step.

Important Note: if you change any columns in your spreadsheet, you’ll need to return to this workflow and click the “Update Spreadsheet Columns” button.
Save and Enable your automation.
Be sure to click the “Save” button and turn your automation to “On”. Your automation will run every time a new Shopify order is created. MESA will proudly celebrate your achievement by popping confetti in your honor. Congratulations!

Workflow Wrap Up

Now, every time you receive an order, the data will save to your Google Sheets spreadsheet.

Every step in this workflow is 100% customizable. As you can see from this tutorial if you want to adjust the formatting later, you can easily do so. Or, if you want to extend the functionality of this workflow to do more, simply add another workflow step.