Connect Woocommerce to Google Sheets and get the most out of your business by minutely tracking orders and transactions–and thus reduce leakages. Woocommerce can be easily connected to Google Sheets with Amigo Data, a Google Sheets extension with which you can automatically retrieve any data from Woocommerce.
In this article, we’ll learn how to connect Woocommerce to Google Sheets and import Woocommerce data to Google Sheets using Amigo Data.
Below are the steps to connect Woocommerce to Google Sheets:
- Install the Amigo Data extension
- Connect Woocommerce to Amigo Data
- Select data to import to Google Sheets
- Import Woocommerce data to Google Sheets
How to connect Woocommerce to Google Sheets and import data to Google Sheets
Install the Amigo Data extension in Google Sheets
Before we proceed, install the Amigo Data add-on so that the following steps will be much easier to follow–and more fun.
You can get it from the Google Workspace Marketplace. Install and give the permissions.
Click here to install.
Alternatively, you can get it from within Google Sheets itself.
- Open a Google Sheets document
- Go to Extensions→Add-ons→Get add-ons
- Search for Amigo Data and install
Once the installation is complete, the Amigo Data add-on should appear in your Extensions tab.
Create a connection
Launch Amigo Data from Google Sheets. Click Extensions→Amigo Data→Connect.
Select Woocommerce from the list of sources.
On clicking the Authorize button you’ll be redirected to a new page. Click the Approve button.
Select the type of data to import
Go back to the Google Sheets tab where Amigo Data is opened and click on the connection you’ve just created listed under Connections.
On clicking the connection you’ll be taken to the Woocommerce dashboard in Amigo Data. Here, you’ll find various options such as the type of data that can be imported, the date range for the data to import, and options to sort and filter the data.
Select the shop (if you have multiple shops added) from which to retrieve the data.
Select the type of data to import–Orders or Products–from the dropdown menu.
Fields are the data sets that are available under the selected data type. Select all that you want to import to Google Sheets.
Add the sorting and filtering options. You can sort the data by one of the fields data selected and by date or values. For example, to sort the data in reverse chronological order–ie, latest to the oldest–select Date as the Order By Field value and Desc.
The Status option lets us further filter the data allowing us to retrieve only specific type of transactions–any, completed, failed, pending, cancelled, etc.
Import Woocommerce data to Google Sheets
After selecting the fields and adding the sort and filter options, click the PREVIEW button. And then click IMPORT.
The Woocommerce will be imported into Google Sheets in a moment.
If you forgot to include some fields or want some removed, you can edit the report and make the changes you want instead of starting anew the process of importing the data.
Click the View Reports option. Then select the report that you want to modify and click the Edit button.
To have the data updated automatically and have them sent to your inbox or to Slack so that you can simply sit back and watch, set a refresh schedule and set up alert in Amigo Data. Follow this link to learn how to set a refresh schedule.
Amigo Data acts as a bridge between Woocommerce and Google Sheets allowing you to seamlessly and effortlessly import Woocommerce data to Google Sheets. Connect Woocommerce to Google Sheets and optimise your business operations.
There are several other data sources that you can connect to Google Sheets and automatically pull the data to Google Sheets with Amigo Data. Visit our blog to find out more.
Some recommended articles: