Beginner's Guide for WordPress / Start your WordPress Blog in minutes

How to Connect Google Sheets with WooCommerce (in 5 minutes)

Do you want to connect Google Sheets with WooCommerce?

Connecting Google Sheets with WooCommerce lets you easily manage order and customer data and share it with the rest of your team.

In this article, we’ll show you how to easily connect Google Sheets with WooCommerce.

How to connect Google Sheets with WooCommerce (in 5 minutes)

Why Connect Google Sheets with WooCommerce in WordPress?

Google Sheets is a very popular free spreadsheet software from Google. By connecting Google Sheets and WooCommerce, you can easily record and manage your orders and customer data.

You can also share this information with your team, even if they don’t have access to the WordPress dashboard. For example, you can easily send this data to your suppliers, marketing departments, or other team members.

Once the information is in a Google Sheet, you can easily filter it based on things like the order total, the customer’s location, coupons used, and more.

You can even turn this data into charts and graphs. All of this makes it easier to analyze the information and then use this insight to fine-tune your business and get even more sales.

That being said, let’s take a look at how to connect Google Sheets with WooCommerce.

Video Tutorial

Subscribe to WPBeginner

If you’d prefer written instructions, just keep reading.

Setup Your WooCommerce Store and Google Sheets

Before we start, you need to have set up a WooCommerce store. If you’re still building your store, then see our step-by-step guide on how to start an online store.

Pro Tip: You’ll also want to make sure you’re using high quality WooCommerce hosting and a WooCommerce theme so that your store looks great and loads fast.

WooCommerce store example

Next, you’ll need to create a Google Sheets spreadsheet where you’ll send the WooCommerce store data.

Head over to the Google Sheets website and click ‘Blank’ to create a new spreadsheet.

Add new Google Sheet

You’ll now need to add columns for the different data you want to collect.

In the following image, we’ve created a column for the customer’s name, email address, phone number, the products they ordered, and the order total.

WooCommerce to Google Sheets spreadsheet

You can import all kinds of WooCommerce data, including location, coupons used, the order status, time of the order, and much more, so you can create any columns you want.

Install and Activate the Uncanny Automator Plugin for WordPress

The easiest way to connect Google Sheets to WooCommerce is by using Uncanny Automator, which is the best WordPress automation plugin.

It acts as a bridge so you can get different WordPress plugins talking to each other. For example, you can use Uncanny Automator to automatically add people to your Activecampaign email list when they submit one of your WPForms.

Uncanny Automator

It’s like Zapier for WordPress websites without the high costs of Zapier.

Uncanny Automator is very easy to use and comes with all kinds of automated workflows that you can set up in a couple of clicks, with no coding needed.

There is a free version of the plugin available so you can try Uncanny Automator and see whether it’s right for you. However, we’ll be using Uncanny Automator Pro for this guide as it has the Google Sheets integration we need.

To help you get started, see our guide on how to create automated workflows in WordPress with Uncanny Automator.

Connect Your Google Account with Uncanny Automator

First thing you need to do is install and activate the Uncanny Automator plugin. For more details, see our step by step guide on how to install a WordPress plugin.

Upon activation, go to Automator » Settings and enter your license key.

Entering the Uncanny Automator license

You can find this information under your account on the Uncanny Automator website.

After activating the license, you need to connect Uncanny Automator to your Google account by clicking on the ‘Premium Integrations’ tab.

In the left-hand menu, select ‘Google Sheets’ and then clic ‘Sign in with Google.’

How to connect Google Sheets with WooCommerce

Uncanny Automator will now ask for access to your Google account.

Simply click on the email address that you want to link to Uncanny Automator.

Giving Uncanny Automator access to your Google Sheets data

On the next screen, you’ll see all of the information and services that Uncanny Automator will have access to, and the actions it can perform.

Although they’re not checked by default, you’ll need to give Uncanny Automator the following permissions: ‘See, edit, create, and delete all of your Google Drive files’ and ‘See, edit, create, and delete all your Google Sheets spreadsheets.’

Giving Uncanny Automator access to your Google data

When you’re happy to go ahead, click on the ‘Continue’ button.

After a few moments, you should see a ‘Your account has been connected successfully’ message. Uncanny Automator can now communicate with your Google Sheets account.

Creating an automated workflow for WooCommerce

Connect WooCommerce to Google Sheets with Uncanny Automator

The next step is connecting your online store to the spreadsheet you created earlier.

Uncanny Automator uses “recipes” to create automated workflows that connect apps and plugins together. There are two different parts to each recipe: the trigger and the action.

The trigger is the event that starts the recipe, and the action is the task that runs when the action is triggered.

To create your first recipe, go to Automator » Add new.

You’ll be asked whether you want to create a ‘Logged-in’ recipe or an ‘Everyone’ recipe. Logged-in recipes can only be triggered by logged-in users, but anyone can trigger ‘Everyone’ recipes.

We want to create a recipe that runs every time someone makes an order, so select ‘Everyone’ and then click ‘Confirm.’

Select Everyone as the recipe type

Next, give the recipe a name by typing into the ‘Title’ field. This is just for your reference so you can use anything you want.

Uncanny Automator will now show all the integrations you’ve already installed on your site. You can go ahead and select ‘WooCommerce.’

Select WooCommerce as the integration

Next, you need to choose the trigger.

For this recipe we’ll select ‘A guest completes, pays for, lands on a thank you page for an order with a product.’

Choose a guest completes the order trigger

After that, you need to choose the trigger condition.

We want to trigger the automation when the customer completes a purchase, so select ‘Completes’ from the dropdown menu. Then, click on ‘Save.’

Set trigger condition to complete

Next, you need to choose whether the Uncanny Automator workflow should run when a customer buys a particular product, or any product. We’re going to record information about every order, so we’ll use the default setting, which is ‘Any product’.

After that, simply go ahead and click on ‘Save.’

Select any product trigger

Now, you can move onto the ‘Actions’ section.

Here, click on ‘Add action.’

Adding actions to your WooCommerce automated workflow

Uncanny Automator will now show a list of all the integrations.

Simply click on ‘Google Sheets.’

Choosing Google Sheets as your integration

In the dropdown that appears, select ‘Create a row in a Google Sheet.’

Once you’ve done that, open the ‘Spreadsheet’ dropdown and select the Google Sheet spreadsheet you created earlier.

Recording WooCommerce data to a Google Sheet automatically

Next, open ‘Worksheet’ and choose the worksheet where you’ll record the information. By default, this is ‘Sheet 1.’

Once you’ve done that, click on ‘Get Columns.’

Recording customer information to a Google Sheet automatically

Uncanny Automator will now show a list of all the columns in the spreadsheet. Your next task is mapping each column to a type of WooCommerce data.

To start, click on the ‘Asterix’ next to the first field.

Mapping WooCommerce customer data to a Google Sheet worksheet

In the dropdown menu, click on the condition under ‘Triggers’ to see all of the information that Uncanny Automator can record.

Simply click on any of these options to map it to the field.

Choosing WooCommerce as the automated trigger

For example, in the following image we’re mapping the Billing First Name to a column called ‘First Name.’

We’re also mapping Billing Last Name to a column called ‘Last Name.’

Automatically adding a customer's name to a Google worksheet

Simply repeat these steps to map the right data to each column in your spreadsheet. When you’re happy with how the recipe is set up, click on ‘Save.’

After that, you can go ahead and make the recipe active. In the ‘Recipe’ box, click the ‘Draft’ switch so that it shows ‘Live’ instead.

Publishing WooCommerce customer data to a row

Your new recipe is now active, and it will automatically record each new WooCommerce order in your Google Sheet spreadsheet.

At this point, it’s a good idea to test your automation to see that the recipe triggers and performs the right action.

If you want to add even more automation to your WooCommerce store, then see our guide on how to send Twilio SMS notifications from WooCommerce.

We hope this article helped you learn how to connect Google Sheets with WooCommerce. You may also want to see our expert picks of the best WooCommerce plugins for your store and how to create a WooCommerce popup to increase sales.

If you liked this article, then please subscribe to our YouTube Channel for WordPress video tutorials. You can also find us on Twitter and Facebook.

Disclosure: Our content is reader-supported. This means if you click on some of our links, then we may earn a commission. See how WPBeginner is funded, why it matters, and how you can support us.

The Ultimate WordPress Toolkit

Get FREE access to our toolkit – a collection of WordPress related products and resources that every professional should have!

Reader Interactions

2 CommentsLeave a Reply

    • You would still want to make those changes through WooCommerce as the Google sheet would only be for keeping track of sales and not making changes to WooCommerce.

      Admin

Leave A Reply

Thanks for choosing to leave a comment. Please keep in mind that all comments are moderated according to our comment policy, and your email address will NOT be published. Please Do NOT use keywords in the name field. Let's have a personal and meaningful conversation.