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.
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.
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.
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.
You’ll now need to add columns for the different data you want to collect.
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
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.
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.
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.’
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.
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.’
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.
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.’
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.’
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.’
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.’
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.’
Now, you can move onto the ‘Actions’ section.
Here, click on ‘Add action.’
Uncanny Automator will now show a list of all the integrations.
Simply click on ‘Google Sheets.’
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.
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.’
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.
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.
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.’
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.
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.