How to connect Brevo to Catchr for data analysis?

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:

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

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:

Then name the Catchr Source and click Connect my account:

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 :

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.

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.

How to connect Brevo to Catchr ?