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.
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.
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.
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.
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.
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.
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.
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.
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.’
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.
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.
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.’
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.
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.
Then, select ‘Automator’ from the list of integrations.
Now, you may choose ‘Call a custom function/method’ from the options.
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.
Then, select the ‘Existing user’ option in the ‘Actions’ meta box.
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.
Next, select ‘Subscriber,’ enter the ID, and select ‘Do nothing’ for existing users.
Then, click the ‘Save’ button to continue.
After that, click the ‘Add action’ button once more.
Now, select ‘Google Sheets’ from the list of integrations.
Once you’ve done that, select the ‘Create a row in a Google Sheet’ option located in the ‘Select an action’ box.
This will show a drop-down menu where you can select the spreadsheet you created earlier.
Now, select the ‘Spreadsheet’ and ‘Worksheet.’
Then, you need to click the ‘Get columns’ button.
This will import the rows from your spreadsheet.
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.
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.
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.’
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.