Blog post

WooCommerce & Catchr: How to connect your data

Catchr

WooCommerce

Johan Chemin
March 25, 2024
| Lastest update
July 1, 2025

Quick steps to create a WooCommerce report with Google Sheets:

You can easiliy create a WooCommerce report following this step :

  1. Get informations from the data integration from our WooCommerce connector.
  2. Create a source on catchr.io.
  3. Download our Google Sheets extensions.
  4. Configure and run your request
If you need more informations, you can follow the tutorial.

How to install Google Sheets Catchr Add-on.

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 Sheets to proceed.
Connect Google Sheet to Facebook Ads
Install Catchr Google Sheets Add-on

Option B: Directly within a Google Sheets:

  1. Open a new Google Sheets.
  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.

Quick steps to create a WooCommerce report with Looker Studio:

You can easiliy create a WooCommerce report following this step :

  1. Get informations from the data integration from our WooCommerce connector.
  2. Create a datasource and new report on Looker Studio.
  3. Choose your metrics and dimensions.
  4. Use charts with your metrics and dimensions.
If you need more informations, you can follow the tutorial. You can also find a template for WooCommerce at the end of the page.

Quick steps to create a WooCommerce report with PowerBI:

You can easiliy create a WooCommerce report following this step :

  1. Get informations from the data integration from our WooCommerce connector.
  2. Create a source on catchr.io.
  3. Configure your request on the PowerBI request manager.
  4. Copy the given URL in PowerBI
If you need more informations, you can follow the tutorial. You can also find a template for WooCommerce at the end of the page.

How to connect WooCommerce to Catchr?

Connecting WooCommerce to Catchr is the best way to make your E-commerce data accessible from any of our destinations.

Once linked, you can find your data on Looker Studio, Google Sheets, PowerBI, Tableau, and BigQuery or create a CSV or JSON feed.

To connect your account to Catchr, you must have:

  • You store URL.
  • You Consumer Key and Consumer Secret.

If you cannot create an API Key like the one explained in the first step of this tutorial, please ask an administrator to give you the highest level of access and create the Keys for you.

Find your store URL, consumer secret, and consumer key in Woocommerce.

WooCommerce Store URL

Open your Woocommerce Store. Your Store URL is everything before "/wp-admin" in the URL.

For Catchr, it looks like this: https://catchr-ecom.io/

You must create a new API Key for each store if you have multiple stores.

And the URL for each store will look like this: https://catchr-ecom.io/fr

Consumer Key and Consumer Secret

Go to the menu WooCommerce -> Settings -> Advanced -> RestAPI:

Create a new API Key in WooCommerce
  • Here, click Add Key
  • In Description, name your key. In User, indicate the owner of this key (it should be you if you are creating it).
  • In Permissions, choose Read.

Click Generate API Key.

Copy and paste your consumer key and secret. WooCommerce won't show it to you again, and you will have to create a new one if you lost them.

Create your Catchr Source

Login to Catchr and go to Source -> Add a new Source.

Select the WoocCommerce Integration under the Ecommerce menu:

Create a WooCommerce Source on Catchr.

Then name your Catchr Source and click Connect my account:

  • Paste your Store URL.
  • Paste your Consumer Secret
  • Paste your Consumer Key
Enter your store name, consumer key and consumer secret to add a new WooCommerce source on Cachr

Click next. If everything went fine, you can see your store name in your Catchr Source, like this:

WooCommerce account visible in your Catchr source.

Click save. You can now find your WooCommerce data in every destination Catchr can connect to.

Starting with Looker Studio:

Go to our WooCommerce connector for Looker Studio, go through the authorization steps and select you account in the dropdown. Then click connect.

The next page shows the available field in this WooCommerce data source. You can click Create Report to start creating a report.

Starting with Google Sheet:

Start by installing our Google Sheets add-on. Then, go to :

  • Extensions -> Catchr - Data connector -> Launch.
Launch Catchr add-on for Google Sheets.

From here, you can access all account linked to Catchr and generate a request that will import data for you (and schedule your request to be launched automatically).

You'll find here a complete tutorial to use Google Sheets with WooCommerce.

Starting with PowerBI, BigQuery, and CSV or JSON format:

Go to the API menu on Catchr. Here is your interface for creating a new request.

First, select your format. Then, build your request. This will generate a web URL.

Create a query in Catchr to get a web URL to request your data.

You can then copy and paste this URL wherever you need it.

Here's a complete tutorial on creating a request for PowerBI (it will work the same way for Tableau).

Bonus: Your free WooCommerce Template

In this WooCommerce template, you will find all the metrics and dimensions you would need to get a better view of your data.

If you need more templates, you could look at our looker studio template gallery.

No items found.

In this WooCommerce template, you will find all the metrics and dimensions you would need to get a better view of your data thank to our integrations.

If you need more templates, you could look at our PowerBI template gallery.

Looker studio

Start using Looker Studio with a ready-to-use template

Catchr provides free dashboard templates to help you start analyzing your WooCommerce data on Looker Studio!

Get the template

Start analyzing your data with a Looker Studio template

Catchr provides free dashboard templates to help you start analyzing your data on Looker Studio — 100+ available templates!

See all the Looker Studio templates

Start analyzing your data with a Power BI template

Catchr provides free dashboard templates to help you start analyzing your data on Power BI — 20+ available templates!

See all the Power BI templates

Start analyzing your data with a Power BI template

Catchr provides free dashboard templates to help you start analyzing your data on Power BI — 20+ available templates!

See all the Power BI templates
Google Sheets

Start analyzing your data with a Google Sheets template

Catchr provides free dashboard templates to help you start analyzing your data on Google Sheets — 20+ available templates!

See all the Google Sheets templates

Start analyzing your data with a Google Sheets template

Catchr provides free dashboard templates to help you start analyzing your data on Google Sheets — 20+ available templates!

See all the Google Sheets templates

Connect all your Marketing data to

Simplify your data extraction with 75+ marketing data connectors to easily move your data to . No-code integration!

Start your free trial

✔ 14 days free trial — No credit-card required

Easily connect your WooCommerce to

Move your data from WooCommerce to with Catchr's no-code integration. Easy to set up, always up-to-date. Automate your data extract now!

Connect your WooCommerce data to multiple destinations

Easily integrate your WooCommerce data thanks to Catchr's no-code connector. Move your data to dashboard tools, spreadsheets, database and more... 20+ destiantions available

Start your free trial

✔ 14 days free trial — No credit-card required

Move your Marketing data to your favorite tools

Simplify your data extraction and move all your Marketing data to dashboard tools, spreadsheets, database and more... No code required!
75+ connectors | 20+ destinations

Start your free trial

✔ 14 days free trial — No credit-card required

Unlock Insights with Style!

Transform your marketing data into stunning dashboards.

Integrate, visualize, and impress with Catchr's seamless dashboards. Elevate your data game now!
Build your first report
14 days free-trial - No credit card required 🎉

More blog post about WooCommerce