Do you want to connect Google Sheets with WooCommerce?
Connecting Google Sheets with WooCommerce lets you easily record and manage customer data and share it with the rest of your team.
In this article, we will 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 information about your customers and orders.
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, customer service staff, and 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 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.
If you’d prefer written instructions, just keep reading.
Set Up Your WooCommerce Store and Google Sheets
Before we start, you need to set up a WooCommerce store. If you are still building your store, then see our step-by-step guide on how to start an online store.
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.
You will now need to add columns for the different data you want to collect.
In the following image, we have created a column for the customer’s name, email address, phone number, the products they ordered, and the order total.
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 that 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.
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.
Connect Your Google Account With Uncanny Automator
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.
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 that, click on ‘Activate license.’
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.’
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 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.’
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.
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.’
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.’
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.’
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.’
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.’
Now, you can move on to the ‘Actions’ section.
Here, click on ‘Add action.’
Uncanny Automator will now show a list of all the integrations available on your WordPress blog or website.
Simply click on ‘Google Sheets.’
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.
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.’
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.
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.
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.’
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.’
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.
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 for the best WooCommerce plugins for your store and learn how to create a WooCommerce popup to increase sales.