Loading
Loading
  • Home

  • Automation with Zapier

  • Zapier tutorials

Zapier tutorials

6 min read

How to integrate Google Sheets with Shopify

By Elena Alston · August 15, 2023
Hero image of Shopify and Google Sheets on a bolt background

When running an online store, you know that your business depends on a suite of tools to do things like list your products, take payments, and keep track of orders. 

If you use Shopify to promote and sell your stuff, and Google Sheets to log important order information, you're already on the right track. But you can still run into petty annoyances. For example, trying to log a massive amount of orders manually makes it hard to keep up-to-date and accurate records—and leaves you wide open to human error. Instead, you need to find a way to scale those orders faster as your business grows. 

Fortunately, Zapier can help you connect these apps and do the heavy lifting for you. Using Zaps—what we call automated workflows—you can automate the busywork that comes with connecting Google Sheets with Shopify

Shopify is a premium app—available on Zapier's paid plans. Learn more about premium apps.

Table of contents

To get started with a Zap template—what we call our pre-made workflows—just click on the button. It only takes a few minutes to set up. You can read more about setting up Zaps here.

Popular ways to integrate Google Sheets with Shopify

There are plenty of ways to integrate Google Sheets and Shopify. If you use both these business-critical apps, you'll want to find a way for them to play together so you can make the most out of them. Here are some of the most popular ways to automate Google Sheets and Shopify. 

Add Shopify orders to a Google Sheet

You've done the hard part. You've set up your Shopify store and you've started taking orders. But now that you have a running business, you need a way to keep track of your sales so you can refer back to them when you need to. 

However, you won't want to copy and paste every new order into a spreadsheet, nor will you want to manually download CSV files on the fly. It's easy to let things slip through the cracks that way. Instead, you can create a Zap—what we call automated workflows—that creates a spreadsheet row for every new Shopify order. 

Add new paid Shopify orders to Google Sheets rows

Add new paid Shopify orders to Google Sheets rows
  • Shopify logo
  • Google Sheets logo
Shopify + Google Sheets

Keep track of abandoned carts

Everyone, for one reason or another, ends up adding a product to their cart only to abandon the purchase halfway through. A good business strategy is following up on these instances and sending those users a targeted outreach of emails or ads. 

But first you'll want to log details of those abandoned carts somewhere—so you can keep an up-to-date log to refer back to. This makes it much easier when you want to add those leads to Facebook Offline Conversions or your email marketing app.

Create items in Shopify from Google Sheets

We've covered how to add Shopify orders to Google Sheets, but what about the other way round? 

If you log important information in your Google Sheet, you can easily transfer that data—be it customers, orders, or products—into Shopify and make sure you're fully up to date across both platforms.

Update Shopify from Google Sheets

Now let's say that you need to make updates to any products you have listed in Google Sheets. Instead of manually locating that product in your Shopify account and updating it yourself, you can set up a Zap that will do it automatically whenever anything is changed in your Google Sheets log. 

Any changes you make will be reflected in Shopify immediately, keeping both platforms in sync and up to date. 

Connect Google Sheets with Shopify

As you can see, there are a lot of ways to integrate Google Sheets and Shopify using Zapier. For the sake of this tutorial though, we're going to focus on one of the workflows we mentioned above—adding new Shopify orders to Google Sheets. But you can use these same steps to connect Google Sheets to Shopify in tons of different ways.

Before you begin

Before you create a Zap that integrates Google Sheets with Shopify, you'll need to create a Zapier account if you don't have one already. Don't worry, creating an account is easy and free. Just head right here. You'll also need a Google account and a Shopify account. Remember, Shopify is a premium app, which requires a paid Zapier plan to use in a Zap.  

Once you're signed in, you can create new Zaps using the "Create Zap" button or by going to zap.new.

Step 1: Set up your trigger app and event

A Zap always consists of two parts:

  1. The trigger: an event that starts a Zap, like a new purchase in Shopify. 

  2. The action: an event a Zap performs after it's triggered, like logging that purchase in Google Sheets. A single Zap can perform more than one action.

Depending on the workflow you're setting up, your trigger app could be Shopify or Google Sheets. Search for and select your trigger app. In our example, we'll search for Shopify.

Screenshot of trigger step in Zap editor

Then select your trigger event. If your trigger app is Shopify, your Zap can trigger when a new cart is abandoned, a new customer is created, a new order is made, a new paid order is made, and more. 

Screenshot of Shopify action in Zap editor

If your trigger app is Google Sheets, your Zap can trigger when a new spreadsheet is created, a new spreadsheet row is added or updated, when a new worksheet is created, and more. 

Select your trigger event and click Continue. We're going to select New Paid Order for our example.

Screenshot of Shopify paid order trigger

Next, connect your trigger app account to Zapier by clicking on the dropdown menu and selecting +Connect a new account. We'll connect Shopify in our example. You'll need to give Zapier permission to access your account. Once you've connected your account, select it from the dropdown menu and click Continue.

Screenshot of Shopify account in Zap editor

Now it's time to test your Shopify trigger so Zapier can create a test event to make sure the trigger is working properly. In our case, Zapier will find an existing paid order in my Shopify account. Once the test runs successfully, click Continue with selected record. 

Screenshot of Shopify test

Step 2: Connect your action app

In this next step, you'll set up the action—the event your Zap will perform once it's triggered. Start by searching for and selecting your action app. We'll use Google Sheets in our example. 

Screenshot of Google Sheets action in Zap editor

Next, choose your action event. If your action app is Google Sheets, your Zap can copy a worksheet, create multiple spreadsheet rows, create a spreadsheet row, and more.

Screenshot of Google Sheet events in editor

Select your action event and click Continue. We're going to select Create Spreadsheet Row for our example.

Screenshot of Google Sheets action in editor

Next, connect your action app account to Zapier by clicking Sign in. In our example, we'll connect Google Sheets. You'll need to give Zapier permission to access your app account. Once you've connected your account, select it from the dropdown menu and click Continue.

Screenshot of Google Sheets account in editor

Next, set up your action by filling in the action step fields. Depending on your action app and event, you'll have different fields to customize. In our example, we'll add which Google Sheets drive, spreadsheet, and worksheet we want to create a row in. 

Screenshot of Sheets action

You can also customize your action step with data from your trigger step. For example, to add data from your Shopify step—like the order details and customer info—click in the different spreadsheet fields you've set up and select the data you'd like to use from the Insert data dropdown.

Screenshot of Shopify fields in action step

Once you're happy with your action step, click Continue

Now it's time to test your action. When you click Test & Review or Test & Continue, Zapier will send test data to your action app. In our example, Zapier will send the Shopify paid order to our Google Sheets account according to how we set up the action step. We always recommend testing your Zap to check if your step looks ok. But if you'd rather skip the test, just click Skip Test in the bottom-right corner. 

Screenshot of successful test in editor

This is what our test sample looks like in Google Sheets: 

Screenshot of shopping orders test in Google Sheets

Turn your eCommerce store into a powerhouse

While we've covered some of the most popular ways to automate Shopify and Google Sheets together, this is only the start of what you can do. Whether you want to make sure you always have an up-to-date log of your orders, or you want to build an entire workflow to solve abandoned cart issues, there are tons of ways to make the most of your Shopify store. Try what works best for your business and start experimenting today. 

Get productivity tips delivered straight to your inbox

We’ll email you 1-3 times per week—and never share your information.

tags
mentioned apps

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.

Sign up
A Zap with the trigger 'When I get a new lead from Facebook,' and the action 'Notify my team in Slack'