blog post

How to move your website data from Matomo to Google Sheets

Florian Cabirol
May 16, 2023
How to move your website data from Matomo to Google Sheets

Are you struggling with moving your Matomo data to Google Sheets? In this blog post, we will guide you through the process of moving your Matomo data to Google Sheets using the Add-on. This will simplify your marketing analysis and make it easier for you to create custom reports. is a powerful SaaS solution designed to move data from various marketing sources, including Matomo, to Google Sheets.


How to start to move your data from Matomo to Google Sheets

Install the Google Sheets Add-on

To start exporting your matomo 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.

Create a New Query

To begin, open Google Sheets and click on "Catchr" in the menu. Then, click on "New Query" to create a new query that will help move your Matomo data.


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

Select Your Data Source

In the query tab, you can choose the source that you want to use – in this case, Matomo. If the account is not provided in the source list, you can easily add a new source by clicking on the "+" button.


Select Your Account(s).

Navigate to the "Select account(s)" tab and choose the Matomo account(s) that you want to import data from.

Select the account for Matomo on Google Sheets
Select the account for Matomo on Google Sheets

Choose Metrics and Dimensions

Next, go to the "Metrics" and "Dimensions" tabs to select the specific data points you want to include in your query. Here are some examples of metrics and dimensions you may find useful:

Metrics :

  • Pageviews: The number of times a page was viewed. 
  • Unique Pageviews: The number of unique visitors that have viewed a specific page. 
  • Bounce Rate: The percentage of single-page sessions where the user left without interacting further.
Select metrics from matomo
Select metrics from Matomo

Dimensions :

  • Country: The country from which the visitor accessed your website.
  • Device Type: The type of device used by the visitor (e.g., desktop, mobile, tablet). 
  • Browser: The web browser used by the visitor (e.g., Chrome, Safari, Firefox).

Remember to choose metrics and dimensions that are relevant to your analysis and reporting needs. 

Select dimensions from Matomo
Select dimensions from Matomo

Set Date Range

After selecting your metrics and dimensions, move to the "Date Range" tab. offers preset date ranges like "Last month" and "This year", but you can also select custom start and end dates for your data import.

Select date from Matomo
Select date from Matomo

Apply Filters

If you want to narrow down your data even further, you can apply filters in the "Filters" tab. To add a filter, fill in the following three fields:

  1. Field: The field name (e.g., country) 
  2. Operator: The operator (e.g., equals) 
  3. Value: The value (e.g., United States)

For example, if you want to see data only for visitors from the United States, you would set up a filter with Field = Country, Operator = Equals, and Value = United States.

Apply a filter on Matomo
Apply a filter on Matomo

Schedule & Customize Data Refreshness

Lastly, go to the "Options" tab to schedule automatic data refreshes for your query. You can also activate options like "Appends rows," which adds new rows at the end of the query range, or "Combine rows," which updates all rows in the range.

Options from Matomo on Google Sheets Add-on
Options from Matomo on Google Sheets Add-on

Examples of Data Reports You Can Build with Catchr and Google Sheets:

With and Google Sheets, you can build a wide variety of data reports to analyze and optimize your marketing efforts. Some examples include:

Traffic analysis: Evaluate your website's traffic by analyzing metrics like visits, unique visitors, and bounce rate, segmented by dimensions such as country, device type, and referral source.

Page performance: Assess the performance of individual pages on your site by analyzing metrics like page views, average time on page, and exit rate, organized by dimensions like page URL and page title.

Conversion tracking: Monitor your site's conversion rate by combining Matomo data with WooCommerce sales data to identify trends and opportunities for improvement.

Transferring your Matomo data to Google Sheets with can help you streamline your reporting process and gain valuable insights into your website's performance. By following the step-by-step guide outlined in this blog post, you'll be well on your way to creating robust, data-driven reports that drive informed decision-making for your business.


  1. Install the Google Sheet Add On for Catchr
  2. Connect your matomo account
  3. Build query

Start your free-trial now

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

Move your


 with Catchr