blog post

How to Move Woocommerce Ecommerce Data to Google Sheets Quickly and Easily

Florian Cabirol
April 21, 2023
How to Move Woocommerce Ecommerce Data to Google Sheets Quickly and Easily

In the fast-paced world of digital marketing today, it's important for any campaign to be efficient and accurate. As a digital marketer, it gets harder and harder to manage and analyze data, especially when working with Woocommerce and other e-commerce platforms. Integrating this data with powerful analytics tools like Google Sheets is essential for making good decisions and getting results. Automating the data transfer process from Woocommerce to Google Sheets not only saves time and effort, but also eliminates the risk of human error, ensuring that marketers have access to real-time, accurate, and organized data to fuel their strategies and outpace the competition.

Why Connect WooCommerce to Google Sheets

Connecting WooCommerce to Google Sheets offers several benefits for online store owners, such as:

Keeping track of products and their stock levels: When you connect WooCommerce to Google Sheets, you can keep a self-updating list of all your products and their different versions. This helps you monitor stock levels and quickly identify items that may be running out. 

Operating your store from within a spreadsheet: By syncing WooCommerce with Google Sheets, you can monitor the status of orders and analyze how quickly they're being fulfilled. This helps you track productivity and make improvements to your store's operations.

Analyzing long-term results and building forecasts: Gathering product reviews in one place allows you to react to customer feedback and plan improvements for your store. Additionally, historical data can help you anticipate seasonal trends and make the most of them. 

How to Move WooCommerce Ecommerce Data to Google Sheets with Add-on

Now that you understand the benefits of connecting WooCommerce to Google Sheets, let's dive into the step-by-step process of moving your ecommerce data using the Add-on.

Step 1: Install the Add-on for Google Sheets

To start exporting your Woocommerce data to Google Sheets, you need to install the Catchr add-on. You currently have two options :

Option A: Via the marketplace:

  1. Visit the Catchr Add-on page on the Google Workspace Marketplace and click "Install."
  2. Grant the necessary permissions for the add-on.
  3. Upon successful installation, open a Google Sheet to proceed.
Connect Google Sheet to Facebook Ads
Install Catchr Google Sheets Add-on

Option B: Directly within a Google Sheet:

  1. Open a new Google Sheet.
  2. In the top menu, click "Extensions", then hover over "Add-ons" and select "Get add-ons."
  3. Search for "Catchr" and choose "Catchr - data connector."
  4. Click "Install" and grant the required permissions.
  5. Close the installation pop-up when completed.
  6. Start using the Catchr add-on.
Install Catchr Add-on for Google Sheets
Install Catchr Add-on for Google Sheets

Once you have installed the add-on, you can start making requests.

Step 2: Create a New Query

After installing the Add-on, open a new Google Sheet and click on "New Query" to create a query. This is where you will choose the source of your data (in this case, WooCommerce). 

Open the Catchr add-on in Google Sheet.
Open the Catchr add-on in Google Sheet.

Step 3: Select Your WooCommerce Account

In the query tab, you'll see various options for selecting your data source. If your WooCommerce account is not already listed, click the "+" button to add it. You can then select your WooCommerce account in the "Select account(s)" tab.

Select Woocommerce from Google Sheets Catchr Add-on
Select Woocommerce from Google Sheets Catchr Add-on

Step 4: Choose Metrics and Dimensions

In the "metrics" tab, select the metrics you want to include in your Google Sheets report.

Then switch over to the "dimensions" tab to choose the dimensions you want to include in your report. Here are a few examples of useful Woocommerce dimensions:

  • Product Name: The name of the product.
  • Order Status: The current status of each order, such as "pending," "completed," or "refunded."
  • Billing Country: The geographical distribution of your customers, useful for targeting marketing campaigns.
Select Metrics from Google Sheets Add-On

Step 5: Set Your Date Range

In the date range tab, you can select the time period for which you want to import data. There are preset options like "Last month" and "This Year," or you can choose custom dates.

Select date range for data fetching
Select date range for data fetching

Step 7: Set filter

You can set any filter you want to our Add-on thanks to the "Filters" tabs. For example, if you want to filter by Product name, just follow the steps :

  • Clicks on "Add field"
  • Choose "Product name" from fields.
  • In the Filter type dropdown, choose "Equals". Some other operator are present like "Contains". 
  • And in the "Value" field, fill your product name. 
Add a filter for Google Sheets

Step 7: Schedule Automatic Refreshes and Activate Options

You can set up automatic refreshes in the options tab to make sure you are always working with the most up-to-date data. Additionally, you can activate options like "Appends rows," which appends new rows at the end of the query range, or "Combine rows," which updates all rows in the range.

Select options for data extracting from Woocommerce

Step 8: Import WooCommerce Data to Google Sheets

Once you've configured your query, click "Get Data" to start importing your WooCommerce data into Google Sheets. This process may take a few minutes, depending on the size of your data set. 

Why Use Catchr for WooCommerce and Google Sheets Integration offers several advantages for syncing WooCommerce with Google Sheets:

No coding is required: The Add-on is designed to be user-friendly, so you don't need any programming knowledge to set up the integration.

Real-time data: You can make sure that your Google Sheet always has the most up-to-date data from your WooCommerce store by setting up automatic refreshes. 

Save time and effort: Automating the data import process means you can focus on analyzing the data and making strategic decisions for your online store.

In conclusion, moving WooCommerce ecommerce data to Google Sheets using the Add-on is an efficient way to streamline your data analysis process and make data-driven decisions for your online store. With this easy-to-follow guide, you can now take control of your store's data and work towards achieving your business goals.

Start your free-trial now

Get all your marketing data in your favorite data activation, database or reporting tools.

Move your


 with Catchr