blog post

How to connect Brevo to Catchr ?

Johan Chemin
April 15, 2024
How to connect Brevo to Catchr ?

Quick steps to create a Brevo (ex SendInBlue) report with Google Sheets:

You can easiliy create a Brevo (ex SendInBlue) report following this step :

  1. Get informations from the data integration from our Brevo (ex SendInBlue) 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 Brevo (ex SendInBlue) 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.

The tutorial

Quick steps to create a Brevo (ex SendInBlue) report with Looker Studio:

You can easiliy create a Brevo (ex SendInBlue) report following this step :

  1. Get informations from the data integration from our Brevo (ex SendInBlue) 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 Brevo (ex SendInBlue) at the end of the page.

The tutorial

Quick steps to create a Brevo (ex SendInBlue) report with PowerBI:

You can easiliy create a Brevo (ex SendInBlue) report following this step :

  1. Get informations from the data integration from our Brevo (ex SendInBlue) 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 Brevo (ex SendInBlue) at the end of the page.

The tutorial

How to connect Brevo to Catchr ?

In order to connect Brevo (ex sendInBlue) to Catchr and use it on all of our destinations (Looker Studio, Google Sheets, PowerBI, Tableau, etc.), you must create a new API Key in your Brevo account and use it to create a new Source on Catchr. Then, you can use your Brevo data where you want.

We will see here where you can generate your API Key in Brevo, how to create your Catchr Source, and how to start with our leading destination.

Finding your API Key in Brevo:

Open your Brevo account, locate the SMTP AND API menu and click on it:

SMTP and API menu in Brevo

Then go to the API Key menu and Generate a new API Key:

Create a new API Key in Brevo

Name your new API Key. I advise you to name it after the services you will use and use only one key for one service.

Copy the Key. (It will be given to you only once. If you want to use it again, store it in a secure place).

Create your Catchr Source

Connect to Catchr and go to Source -> Add a new Source (here's the direct link : https://app.catchr.io/data-connector/sources/new)

Select the Brevo Integration under the Emailing menu:

Create a new Brevo Source on Catchr

Then name the Catchr Source and click Connect my account:

Name your Catchr Source

Paste the API Key generated earlier:

Use the API key generated in the first paragraph.

Click next and let Catchr fetch your account.

Once you can see it on Catchr, you are good to go !

The Brevo account is added as a Source on Catchr.

Starting with Looker Studio:

For Looker Studio, you can follow this link to our Brevo connector, go through the authorization steps.

You should find your account in the dropdown selector :

Brevo account list on Looker Studio

Select your Brevo account and click Connect to create your Looker Studio data source. If you want to start with a blank canvas, uncheck the "Use report template for new report" checkbox.

In the next screen, click Create Report to create a new report.

New Brevo Looker Studio data source.

If you choose to start with a blank canvas, you can find the Brevo template here.

Starting with Google Sheet:

For Google Sheets, you now need to install our add-on. Once done, you can launch it in the extension menu :

Then click on Add New to start creating your request:

Here's a complete tutorial for Brevo and Google Sheets.

Here's a Brevo template for Looker Studio.

Starting with PowerBI and BigQuery:

In the API menu on your Catchr space, you can create a web URL to link to PowerBI or Tableau. You can then uses this web URL to fetch data automatically and keep your dashboards up to date.

To do so, select your format, then create a request (it is the same request builder as the Google Sheets Add-on).

Select your Format and start creating your request.

Once done, copy the URL and Paste it to your destination.

You'll find here a complete tutorial on how to create a Brevo request for PowerBI (it will work the same way for Tableau).

Here is a Brevo template for PowerBI.

Bonus : Your free Template Brevo Campaign Insight Template

In this Brevo (ex SendInBlue) 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.

Bonus : Your free Brevo Campaign InsightTemplate for PowerBI

In this Brevo (ex SendInBlue) 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.

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 Brevo (ex SendInBlue)

How to connect Brevo to Catchr ?

Learn how to generate your Brevo API Key and connect your account to Catchr and use it on Looker Studio, Google Sheets, PowerBI and our others destinations.

Johan Chemin

The Ultimate Guide to Best Brevo KPIs: Maximize Your Efficiency and Business Growth

Brevo lets businesses cultivate a delightful customer relationship with their users. Here are the best Brevo KPIs to track your marketing efforts on the platform.

Florian Cabirol

Import your Brevo emailing data to Google Sheets : How-to, metrics and more...

Master the art of integrating Brevo marketing data into Google Sheets with our detailed tutorial. Learn how to connect your Brevo account, select relevant metrics and dimensions, and set up automated data refreshes for real-time analysis. Ideal for marketers aiming to boost their email campaign strategies through enhanced reporting and insightful decision-making.

Florian Cabirol

Explore your Brevo (ex Sendinblue) emailing KPI with PowerBI : How-to, templates and more

Discover how to seamlessly integrate Brevo marketing data with PowerBI using Catchr for dynamic dashboard creation and data analysis. This guide covers the entire process, from data importation to visualization, helping marketers unlock powerful insights for strategic decision-making.

Florian Cabirol