Trusted WordPress tutorials, when you need them most.
Beginner’s Guide to WordPress
WPB Cup
25 Million+
Websites using our plugins
16+
Years of WordPress experience
3000+
WordPress tutorials
by experts

How to Connect Google Sheets With WooCommerce (in 5 Minutes)

Editorial Note: We earn a commission from partner links on WPBeginner. Commissions do not affect our editors' opinions or evaluations. Learn more about Editorial Process.

Do you want to connect Google Sheets with WooCommerce?

If you use Google Sheets to record your WooCommerce store orders, you may find it tedious to update your data manually. Connecting the two platforms lets you automatically renew this data.

In this article, we will 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. If you use it to record your WooCommerce store data, then connecting the two platforms will allow you to update your spreadsheet automatically.

So, instead of manually updating the spreadsheet every time there’s a new order, WooCommerce will automatically send this data over to Google Sheets.

What’s more, you can share this spreadsheet with team members who don’t have access to your WordPress dashboard.

For example, you can easily send this data to your suppliers, marketing departments, customer service staff, and other team members.

The great thing about Google Sheets is that you can easily filter the data based on things like the order total, the customer’s location, coupons used, and more.

Additionally, you can turn this data into charts and graphs using data visualization plugins. 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, then just keep reading.

Step 1: Set Up Your WooCommerce Store and Google Sheets

If you are reading this tutorial because you are still planning to set up your WooCommerce site, then this is your first step. For step-by-step instructions on building your store, read our guide on how to start an online store.

WooCommerce store example

Pro Tip: To provide a great shopping experience for your users, make sure you are using high-quality WooCommerce hosting and a WooCommerce theme. This way, your store is easy to use and loads fast.

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

Head over to the Google Sheets website and click ‘Blank’ to create a new spreadsheet. Or, just type in ‘https://sheets.new’ in your browser.

Add new Google Sheet

Now, go ahead and add columns for the different data you want to collect.

For the sake of example, we have 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.

Step 2: 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 on the market.

Uncanny Automator

An automation plugin essentially acts as a bridge between different WordPress plugins. This way, when one plugin performs an action, that action will trigger another action in a different plugin.

For example, you can use Uncanny Automator to automatically add people to your ActiveCampaign email list when they submit one of your WPForms.

The 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.

Note: 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 will be using Uncanny Automator Pro for this guide because it has the Google Sheets integration we need.

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

Activating the Uncanny Automator Pro license key

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

After that, click on ‘Activate license.’

Step 3: Connect Uncanny Automator to Google Sheets

Your next task is connecting Uncanny Automator to your Google account.

To get started, click on the ‘App Integrations’ tab. Then, select ‘Google Sheet’ and click on ‘Sign in with Google.’

How to connect Uncanny Automator to Google Sheets

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 will see all the information and services that Uncanny Automator will have access to and the actions it can perform.

Although they are not checked by default, you will 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 are 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.

Connecting WordPress, Uncanny Automator, and Google Sheets

Step 4: Connect WooCommerce to Google Sheets With Uncanny Automator

The next step is connecting your online marketplace or 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 will 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.

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

Select Everyone as the recipe type

Next, give the recipe a name by typing it 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 have already installed on your WordPress website. You can go ahead and select ‘WooCommerce.’

Select WooCommerce as the integration

Next, you need to choose the trigger.

For this recipe, 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.

To trigger the automation when the customer completes a purchase, 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. To record information about every single order, select ‘Any product.’

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

Select any product trigger

Now, you can move on to 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 available on your WordPress blog or website.

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 have 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 will record the information. By default, this is ‘Sheet 1.’

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

Recording customer information to a Google Sheet automatically

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

To start, click on the ‘*’ 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 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 are 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 are happy with how the recipe is set up, click on ‘Save.’

Publishing the Uncanny Automator recipe for the WooCommerce-Sheets integration

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

Your new recipe is now active and 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.

Bonus Tip: Connect Your WordPress Forms to Google Sheets

Besides connecting your Google Sheets to WooCommerce, it’s also a good idea to integrate it with your WordPress forms.

If you get tons of data every day from your forms, then you’ll need a user-friendly platform like Google Sheets to manage them all.

We have a full guide talking about how to connect your WordPress forms to Google Sheets. In the article, we use Uncanny Automator and WPForms, the easiest form builder for WordPress.

With 1200+ premade form templates, WPForms makes it easy to create various types of forms for any business. Examples range from quotation requests and contact forms to appointment bookings and surveys.

The WPForms website

We hope this article helped you learn how to connect Google Sheets with WooCommerce. You may also want to see our expert picks for the best WooCommerce plugins and learn 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. Here's our editorial process.

Editorial Staff

Editorial Staff at WPBeginner is a team of WordPress experts led by Syed Balkhi with over 16 years of experience in WordPress, Web Hosting, eCommerce, SEO, and Marketing. Started in 2009, WPBeginner is now the largest free WordPress resource site in the industry and is often referred to as the Wikipedia for WordPress.

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

3 CommentsLeave a Reply

  1. Syed Balkhi says

    Hey WPBeginner readers,
    Did you know you can win exciting prizes by commenting on WPBeginner?
    Every month, our top blog commenters will win HUGE rewards, including premium WordPress plugin licenses and cash prizes.
    You can get more details about the contest from here.
    Start sharing your thoughts below to stand a chance to win!

    • WPBeginner Support says

      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 to Jonathan Cancel 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.

WPBeginner Assistant
How can I help you?

By chatting, you consent to this chat being stored according to our privacy policy and your email will be added to receive weekly WordPress tutorials from WPBeginner.