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

Want to connect Google Sheets with WooCommerce?

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

In this tutorial, we’ll show you how to connect Google Sheets with WooCommerce, step by step.

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

Why Need to Connect Google Sheets with WooCommerce in WordPress?

Google Sheets is a very popular free spreadsheet tool from Google. Connecting Google Sheets with WooCommerce helps you simply manage and analyze your store order and customer data.

You can also share this data with your team without having them log in to your WordPress dashboard.

Connecting Google Sheets and WooCommerce can help your online store in many ways.

  • Easily analyze and sort customer order data
  • Quickly present store data in charts and graphs
  • Sort and filter data by total, location, coupons used, etc
  • Give team access to data without creating a separate login

Now, let’s take a look at how to connect Google Sheets with WooCommerce, in just 5 minutes.

Setup Your WooCommerce Store and Google Sheets

First, you need to have a fully functioning WooCommerce store set up.

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

WooCommerce store example

Then, you’ll need to create a Google Sheets spreadsheet to which you’ll send WooCommerce store data.

Go to the Google Sheets website and click ‘Blank’ to add a new spreadsheet.

Add new Google Sheet

Next, when adding columns to your spreadsheet, you want these to match the type of WooCommerce data you want to collect.

In this example, we have a spreadsheet with the customer’s name, email, phone, the products they ordered, and the total price.

WooCommerce to Google Sheets spreadsheet

You can import all kinds of WooCommerce data, including location, coupons used, the status of the order, time of the order, etc.

Install and Activate the Uncanny Automator Plugin for WordPress

To connect Google Sheets to WooCommerce, we’re going to be using an automation plugin.

The best WordPress automation plugin is Uncanny Automator. It is like a connector between your WordPress website and other apps, so they can talk to each other without having to write any code.

Uncanny Automator

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

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

Note: there is a free version of the plugin available, but we will use the Pro version for this tutorial since it has the Google Sheets integration we need.

Connect Your Google Account with Uncanny Automator

Upon activation, you need to connect Uncanny Automator to your Google account.

First thing, navigate to Automator » Settings and click on the ‘Google’ menu item.

Connect Google Account

After that, click on the ‘Connect an account’ button. This takes you to a screen where you can authorize your Google account.

Next, choose the Google account you want to connect and click the ‘Allow’ button.

Give Uncanny Automator permission

Then, you need to click ‘Allow’ one more time to authorize your account and confirm your choices.

This will take you back to the Google settings page in your WordPress admin panel.

Google Account connection success

That’s all, you have successfully connected your WordPress site to Google Sheets using Uncanny Automator.

Connect WooCommerce to Google Sheets with Uncanny Automator

Now, you’re ready to connect your online store to the Google Sheets spreadsheet you created earlier.

Uncanny Automator uses “recipes” to make automation and link apps and plugins together. There are two different parts to each recipe, the trigger, and the action.

The trigger is the event that will start the recipe, and the action is the task that will run when the action is triggered.

First thing, you’ll need to do is go to Automator » Add new, click the ‘Everyone’ option, and then click ‘Confirm.’

Select Everyone as the recipe type

The Everyone recipes can be triggered by any user, while logged-in recipes can only be triggered by logged-in users.

You need to select the type of recipe based on your needs and then click the ‘Confirm’ button.

For this tutorial, we’ll be creating an Everyone recipe that automatically sends WooCommerce order data to Google Sheets the moment an order is completed.

Now, you need to give your recipe a name. This won’t be visible to your users, but it will help you identify the different recipes you create.

Then, you need to choose ‘WooCommerce’ in the ‘Trigger’ meta box.

Select WooCommerce as the integration

Next, you can choose the trigger.

We’ll pick the first option from the drop-down menu since this lets you send WooCommerce data once an order is complete.

Choose a guest completes the order trigger

Now, you need to choose the trigger condition.

Select the ‘Completes’ option from the drop-down menu to trigger the automation when a customer completes a purchase and then click ‘Save.’

Set trigger condition to complete

After that, you can select a specific product or any product from your WooCommerce store to run the trigger on.

Select the ‘Any product’ option and then click ‘Save’ to choose any product in your store.

Select any product trigger

After that, you can move onto the Actions section. You’ll see different options depending on if you chose an everyone or logged-in recipe.

If you chose an Everyone recipe above, then you need to create a new subscriber user in WordPress first. This new user will be used to send the form data through.

To start, continue and click on the ‘Add action’ button under the Actions meta box.

Add action for WooCommerce and Google Sheets

Then, select ‘Automator’ from the list of integrations.

Choose Automator

Now, you may choose ‘Call a custom function/method’ from the options.

Select Call a custom function

You’ll now see a popup appear, which will show you that the action will run on a WordPress user and require the user’s data. Simply click on the ‘Set user data’ button to continue.

Allow set user data

Then, select the ‘Existing user’ option in the ‘Actions’ meta box.

Select existing user

This shows a popup to choose the new subscriber user role you just created and enter the user ID.

If you don’t know the user ID, then you can find this by visiting Users » All Users and editing the user profile.

Then, in the URL, you can find the user ID.

Find user ID

Next, select ‘Subscriber,’ enter the ID, and select ‘Do nothing’ for existing users.

Then, click the ‘Save’ button to continue.

Select do nothing and save

After that, click the ‘Add action’ button once more.

Now, select ‘Google Sheets’ from the list of integrations.

Select Google Sheets

Once you’ve done that, select the ‘Create a row in a Google Sheet’ option located in the ‘Select an action’ box.

Create a row in Google Sheets

This will show a drop-down menu where you can select the spreadsheet you created earlier.

Now, select the ‘Spreadsheet’ and ‘Worksheet.’

Select spreadsheet and worksheet

Then, you need to click the ‘Get columns’ button.

This will import the rows from your spreadsheet.

Select get columns

You need to map your spreadsheet columns to the WooCommerce order data by clicking the ‘Asterisk’ icon and choosing the WooCommerce field from the drop-down list.

Match order and spreadsheet columns

After you’ve matched up all of your fields, it will look similar to the settings below.

You can choose WooCommerce shipping information. However, we decided to use the WooCommerce billing information since the contact information can be more accurate.

WooCommerce to Google Sheets columns

Be sure you click ‘Save’ once you’re done creating your recipe.

Now, you can view the full automation summary to be sure it looks right. After that, it’s time to make your recipe live.

At the top of the recipe editor, in the’ Recipe’ box, switch the Draft toggle to ‘Live.’

Publish the WooCommerce to Google Sheets recipe

Your new recipe will now be active, and you’ll automatically send new WooCommerce order data to Google Sheets once a purchase is complete.

Make certain to test your automation to see that the recipe is triggered and the correct action is performed.

We hope this article has helped you learn how to connect Google Sheets with WooCommerce.

Tags: No tags

Leave A Comment

Your email address will not be published. Required fields are marked *