Back to Blog

How to Connect WooCommerce to Looker Studio (Google Data Studio)

WooCommerce is an ecommerce platform and Google Looker Studio (former Data Studio) is a data visualization platform. Those who need to connect these two platforms most likely want to build a custom dashboard or report to monitor and analyze their business performance. So, basically, they’d like to automate data flow from WooCommerce to Looker Studio to make a self-updating dashboard. Are you one of these users? I bet you are, so keep reading because I’m going to demonstrate how you can connect WooCommerce to Looker Studio to do some magic with your data.  

How can you pull data from WooCommerce to Looker Studio?

When you create a new report in Looker Studio, you’re prompted to connect to data. The most common option is File Upload but it’s not efficient since it includes two steps:

  • Download WooCommerce data as CSV to your computer
  • Upload this CSV file to Looker Studio

The main drawback of this way is that every time you need to refresh data in your custom dashboard, you’ll have to perform the same operation by hand. This is not what I need, so let’s check out any direct WooCommerce to Looker Studio connectors. Unfortunately, there are no native ones. 

1 no native woocommerce looker studio connectors

However, you can go with one of the partner connectors. is one of these and it allows you to benefit from a custom dashboard with all your WooCommerce data in it. Let’s see how it works!

Connect WooCommerce to Looker Studio to automate data exports is an all-in-one data automation and analytics platform. It allows you to gather, transform, and analyze data from WooCommerce. supports 4 destinations, including Looker Studio. So, let’s see how it works to synchronize Looker Studio and WooCommerce.

Start with creating a free account. After that, you can click Add new importer and choose WooCommerce as a source app and Looker Studio as a destination app. Click Proceed.

  • In the Source section, you’ll need to connect your WooCommerce account, then select the data entity to export, for example, Orders.
3.1 source account data entity

Optionally, you can filter out the data by after/before date, status, and even a search string. Then you’ll get to the preview stage. offers you a preview of the data before importing it into Looker Studio. At this stage, you can also implement additional transformations: hide/add columns, filter records by multiple criteria, and sort the data.

3.2 woocommerce preview data
  • Once you’re done with the data transformation, click Continue in the top-right corner to proceed to the destination settings. Follow the instructions to connect WooCommerce to Looker Studio.
  • Generate an access API token and copy it. Then click the Looker Studio link to create a new data source in Looker Studio.
7 destination settings coupler
  • A new tab will open where you’ll need to click Authorize and then enter the access token that you copied in the previous step and click Submit.
8 enter coupler authorization key
  • On the next screen, the Importer Id field will be pre-filled. Click Connect in the top right corner.
9 connect mysql to lookerstudio via coupler
  • Wait till the connector pulls the data from WooCommerce to Looker Studio. Once it’s done, click Create Report.
3.4 create report woocommerce looker studio

You can now use the data exported from WooCommerce to build a report in Looker Studio. 

Automate data sync between WooCommerce and Looker Studio

When configuring the WooCommerce Looker Studio importer at, we forgot to enable the automatic data refresh. This feature automates data synchronization between WooCommerce and your newly created data source in Looker Studio. So, toggle it on and configure the schedule you’d like to refresh your data. 

7. Google Ads to Looker Studio step3

What data can you load from WooCommerce to Looker Studio?

In the example above, we mentioned Orders as a data entity to export from WooCommerce to Looker Studio. At the same time, you can count on other entities, raw data and reports, that you can load if you use to connect WooCommerce to Looker Studio.

Raw dataReports
  • Continents
  • Countries
  • Coupons
  • Currencies
  • Customers
  • Orders
  • Orders with line items
  • Product attributes
  • Product categories
  • Product reviews
  • Product shipping classes
  • Product tags
  • Products
  • Shipping zone
  • Tax classes
  • Tax rates
  • Report: Coupon totals
  • Report: Customer totals
  • Report: Order totals
  • Report: Product totals
  • Report: Review totals
  • Report: Sales totals
  • Report: Top sellers report
  • Streamline data analytics & reporting

    Streamline your data analytics & reporting with! is an all-in-one data analytics and automation platform designed to close the gap between getting data and using its full potential. Gather, transform, understand, and act on data to make better decisions and drive your business forward!

    • Save hours of your time on data analytics by integrating business applications with data warehouses, data visualization tools, or spreadsheets. Enjoy 200+ available integrations!
    • Preview, transform, and filter your data before sending it to the destination. Get excited about how easy data analytics can be.
    • Access data that is always up to date by enabling refreshing data on a schedule as often as every 15 minutes.
    • Visualize your data by loading it to BI tools or exporting it directly to Looker Studio. Making data-driven decisions has never been easier.
    • Easily track and improve your business metrics by creating live dashboards on your own or with the help of our experts.

    Try today at no cost with a 14-day free trial (no credit card required), and join 700,000+ happy users to accelerate growth with data-driven decisions.

    Start 14-day free trial

    Are there other options to connect WooCommerce to Looker Studio?

    Well, is not the only partner connector to synchronize WooCommerce to Looker Studio. There are other options presented by Catchr, Funnel, Octoboard, and others.

    3.5 other woocommerce looker studio connectors

    We can’t say how good or bad they are due to our marketing prejudice. However, if you’re up for experimenting, then you can always try them out. On the other hand, do you really need to do this if you can start with right away and get your job done? Besides WooCommerce, supports plenty of other sources including CRM apps, marketing tools, project management apps, and more. Try it free for 14 days!

    • Zakhar Yung

      A content manager at whose key responsibility is to ensure that the readers love our content on the blog. With 5 years of experience as a wordsmith in SaaS, I know how to make texts resonate with readers' queries✍🏼

    Back to Blog

    Comments are closed.

    Focus on your business
    goals while we take care of your data!