How to Connect Woocommerce to Google Sheets

How to connect Woocommerce to Google Sheets
Reading Time: 4 minutes

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:

  1. Install the Amigo Data extension
  2. Connect Woocommerce to Amigo Data
  3. Select data to import to Google Sheets
  4. 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.

Amigo Data in Google Workspace Marketplace

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.

Launching Amigo Data

Select Woocommerce from the list of sources.

Select the source to connect

Setting up a connection

On clicking the Authorize button you’ll be redirected to a new page. Click the Approve button.

Approving the connection

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.

The created connection

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.

Woocommerce dashboard in Amigo 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.

Specifying the date range

Fields are the data sets that are available under the selected data type. Select all that you want to import to Google Sheets.

Fields values

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.

Selected field values and sorting and filtering options

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.

Preview of the data

The Woocommerce will be imported into Google Sheets in a moment.

The imported data

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:

Import Data from Google Search Console to Google Sheets

Export Google Ads Data To Google Sheets

Export Facebook Ads Data to Google Sheets