How to integrate Brevo with Google Sheets to automatically add contact information to Google Sheets when it is registered in Brevo.

For those managing customer and lead information with Brevo and Google Sheets, entering the same data into each app can be a hassle.
If you've ever thought it would be easier if data entry could be done just once, Yoom is recommended.
With Yoom, there is no need for complex code input, making app integration and automation simple.
This article will set up automation to "add contact information registered in Brevo to Google Sheets."

Benefits of Integrating Brevo and Google Sheets

The benefits of integrating Brevo and Google Sheets include obtaining the latest information and saving time.
Below is a summary of the benefits of app integration, so please take a look.

Benefit 1: Obtain the Latest Information

Integrating Brevo and Google Sheets offers the benefit of obtaining the latest information.
For example, it is possible to add contact information registered in Brevo to Google Sheets.
Since customer information is automatically shared, there is no need to enter information into Google Sheets.
This allows marketing teams and others to always obtain the latest customer information, making analysis easier.

Benefit 2: Save Time

Integrating Brevo and Google Sheets offers the benefit of saving time.
If the apps are not integrated, contact information must be manually transferred to Google Sheets.
By automating, manual input tasks are eliminated, which is a significant benefit for those with many tasks.
This automation leads to time savings, allowing you to start other tasks.
Manual input can sometimes result in incorrect contact data entry, but automation ensures accurate data entry.

Benefits of Integrating Apps with Yoom

API integration requires a certain level of knowledge and is not something everyone can do like an engineer.
However, Yoom provides an environment where even those with zero programming knowledge can easily integrate apps.
The appeal of Yoom is that everyone can utilize automation, regardless of their knowledge.
There is no need to hire engineers, leading to cost savings.
There are no complex settings, so you won't waste time unnecessarily.
First, try the free trial and experience the efficiency for yourself.

How to Create an Integration Flow for Brevo and Google Sheets

This time, we will introduce the settings for the following template: "Add contact information registered in Brevo to Google Sheets."

There are only two steps, so the setup will be completed in 10-15 minutes.

Setting up a flow bot that triggers when a contact is newly created
Setting up the action to add a record

If you are not using Yoom, please register for free from here.
If you are already using Yoom, please log in.

How to Connect Brevo and Google Sheets with Yoom

Register your My Apps to link Brevo and Google Sheets with Yoom.
By registering My Apps first, the automation setup becomes easier.

Let's start with registering Brevo in My Apps.
Click "My Apps" → "New Connection" on the left side of the screen.
Search for Google Sheets from "Search by App Name" or find it from the app list.

You will transition to the following screen, so check the settings.

"Account Name" → Set any account name, e.g., Administrator Account
"Access Token" → Set the API key obtained from Brevo
※You can obtain the API key by going to "SMTP&API>API Key" in Brevo.

Next, register Google Sheets in My Apps, and select Google Sheets as before.
Once you transition to the following screen, log in to Google Sheets.

Once Brevo and Google Sheets are displayed in your My Apps section, the My Apps registration is complete.

How to Add Contact Information Registered in Brevo to Google Sheets

To set up automation, click "Try it" on the banner below.

You will be redirected to the following screen, so please check the "Title" and "Description".
If you want to make changes, you can do so from the page below.
First, start with the Brevo settings, and click on "When a contact is newly created".

Once you move to the following screen, please check the settings.

"App Trigger Title" → Can be changed if necessary
"Account Information to Link with Brevo" → Check if it's the account you are using
"Trigger Action" → When a contact is newly created

You will be redirected to the following screen, so set the "Trigger Activation Interval" as desired.
Click "Test" → "Test Successful" → "Save".

Next, set up Google Sheets by clicking "Add Record".
Once you move to the following screen, please check the settings.

"Title" → Can be changed if necessary
"Account Information to Link with Google Sheets" → Check if it's the account you are using
"Execution Action" → Add Record

Before scrolling, set up Google Sheets.
As an example, I entered the contact information item names in Google Sheets as follows.
Enter the necessary items as shown below.

Scroll down and set up "Database Integration".

"Spreadsheet ID" → The part "●●●●●" in the URL "/spreadsheets/d/●●●●●/edit" is the Spreadsheet ID
"Spreadsheet Tab Name" → Specify the tab name like "Sheet1"
"Table Range" → Specify the table range in the format "A1:G30"

Once you move to the following screen, the items you set will be displayed, so select the output that matches the item from the red frame.
Click "Test" → "Test Successful" → "Save".

Finally, by turning the app trigger "ON", the automation setup is complete.

‍

Summary

In this article, we set up automation to "add contact information registered in Brevo to Google Sheets."
By integrating Brevo with Google Sheets, you can save time by eliminating the need to manually enter contact information.
This is especially recommended for those who manage contact information with both Brevo and Google Sheets.
App integration with Yoom is very simple, so you won't waste time unnecessarily.
Why not incorporate Yoom into your busy schedule to ease your workload a bit? Register for free and streamline your tasks.