How to Connect Shopify to Google Sheets

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!

4 easy steps to connect Shopify to Google Sheets

Being able to save your Shopify data into Google Sheets is actually very simple despite not being a native feature within the Shopify admin. Once these two are connected, you can easily move your data between them. The results can be hugely time-saving.

1. Add the MESA app to your Shopify store.

You’re going to need a third-party app from the Shopify App Store. We like MESA because it’s perfect for making custom integrations like this one.

2. From MESA, create a new workflow. Then, choose the Google Sheets app.

This will automatically add the Google Sheets Row Created event as the first step of your workflow.

New workflow using Google Sheets

3. Next, click “Sign in with Google”.

This will prompt the oAuth window from Google. Choose the Google email address associated with the spreadsheet you’ll want to use.

google sheets oauth window

4. Next, click “Allow” from the Google permissions window.

This will allow the MESA app on your Shopify store to connect with your Google Sheets account.

google sheets permissions

You’re done! Pretty easy, right?

google sheets authenticated with shopify

With Google Sheets authenticated, you can now connect your Shopify data to a Google Sheets spreadsheet. Now, when new rows are added to a spreadsheet, you can connect that data back to Shopify.

Let’s look a popular workflow to connect Shopify to Google Sheets.

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.

  1. 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. shopify orders to google sheets - discover

  2. 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.shopify orders to google sheets - credentials

  3. 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.shopify to google sheets - authorization

  4. 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.
    shopify to google sheets - create spreadsheet

  5. 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.
    shopify to google sheets - configure

  6. 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!
    shopify to google sheets - complete

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.

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