Brevo
Brevo (formerly Sendinblue) is a cloud-based email marketing solution for businesses that want to automate email marketing campaigns with a limited budget. The solution includes email marketing, transactional email, marketing automation, customer relationship management, SMS marketing, and more.
Data integration: Skyvia supports importing data to and from Brevo, exporting Brevo data to CSV files, replicating Brevo data to relational databases, and synchronizing Brevo data with other cloud apps and relational databases.
Backup: Skyvia Backup does not support Brevo.
Query: Skyvia Query supports Brevo.
Establishing Connection
You need the API Key to create a connection with Brevo.
Getting Credentials
To get your API Key, perform the following steps:
- Sign in with Brevo.
-
Click your user icon in the top right corner.
-
In the drop-down list, click SMTP & API and switch to the API Keys tab.
- Click Generate a new API key.
- Enter the API key name and click Generate.
- Copy your API Key and store in a safe place. Note that this is the only time you can see it, and you will need to generate a new one if you lose it.
Creating Connection
Enter the obtained API Key to the corresponding box in the Connection Editor.
Connector Specifics
Object Peculiarities
Read-only objects
The following Brevo objects are read-only: TransactionalEmailActivity_AggregatedPerDay, SMSActivity_AggregatedPerDay, SMSActivity_UnaggregatedEvents, and TransactionalEmailActivity_UnaggregatedEvents.
BlockedDomain
The BlockedDomains object has a single Domain field. It contains the list of all the blocked domains in JSON array format: ["example1.com", "example2.com"]
.
To extend the list of blocked domains, use the INSERT operation. To remove the domain from the list, use the DELETE operation.
For example, your list of blocked domains looks like ["example1.com", "example2.com"]
. Suppose you want to block one more domain with the example3.com value. Use the INSERT operation in the integration and map the Domain field to the example3.com value. As a result, your list looks like ["example1.com", "example2.com", "example3.com"]
.
BlockedContacts
The BlockedContacts object does not have an Id field. The primary key is the Email field.
Contacts_Attributes
The Contacts_Attributes object does not have an Id field. The primary keys are the Name and Category fields.
Contacts
To insert data to this object, map either the Email field or the SMS nested attribute in the Attributes field. For example, {"SMS":"012345678910"}
.
The ListIds field stores the identifiers of all the lists the contact belongs to in the JSON array format: [1,2,3]
.
To extend the array of IDs, use the UPDATE operation in the integration and map the ListIds field to the value you want to add.
For example, the ListIds field contains the value [1,2]
. Suppose you want to add 3 to the array. To add an item to the list, use the UPDATE operation and map the ListIds field to the [3]
value. As a result, the ListIds value becomes [1,2,3]
.
To delete the specific IDs from the array, map the UnlinkListIds field to the value you want to remove.
For example, if you want to remove [5]
from the [3,4,5]
ListIds array, map the UnlinkListIds to [5]
. As a result, the ListIds value becomes [3,4]
.
Activity Objects
The TransactionalEmailActivity_AggregatedPerDay, SMSActivity_AggregatedPerDay, SMSActivity_UnaggregatedEvents, and TransactionalEmailActivity_UnaggregatedEvents objects are read-only.
When you query the TransactionalEmailActivity_AggregatedPerDay and SMSActivity_AggregatedPerDay objects, the result contains data for the last ten days by default. To get data for another period, set the filters by the startDate and endDate fields. The period specified in the filters must be at most 30 days.
When you query the SMSActivity_UnaggregatedEvents and TransactionalEmailActivity_UnaggregatedEvents objects, the result contains data for the last 30 days by default. To get data for another period, set the filters by the startDate and endDate fields.
DML Operations Support
Skyvia supports the following DML operations for Brevo.
Operation | Object |
---|---|
INSERT, UPDATE, DELETE | Companies, ChildrenAccounts, Contacts, ContactsAttributes, Contacts_Folders, Contacts_Lists, Deals, Email_Campaigns, Senders, SMS_Campaigns, Tasks, Templates, WebhooksMarketing, WebhooksTransactional, WhatsAppCampaigns |
INSERT, DELETE | Domains, BlockedDomains |
INSERT, UPDATE | CouponCollections |
INSERT | SenderDomains_ChildrenAccounts |
DELETE | BlockedContacts |
Incremental Replication and Synchronization
Skyvia supports Incremental Replication for the following Brevo objects: Companies, Contacts, Contacts_Lists, ContactSegments, Email_Campaigns, SMS_Campaigns, Template, WebhooksMarketing, WebhooksTransactional, WhatsAppCampaigns.
Incremental Replication tracks the new records only for the Deals, Tasks, Categories, and CouponCollections objects.
Skyvia supports Synchronization for the following Brevo objects: Companies, Email_Campaigns, SMS_Campaigns, Template, WebhooksMarketing, WebhooksTransactional, WhatsAppCampaigns.
Supported Actions
Skyvia supports all the common actions for Brevo.