Skip to content
AirtableBrevo

Connect Airtable and Brevo

Start a client’s workflow in Airtable and act in Brevo, or the other way round, on the client’s own accounts.

Step by step, with the other ways to do it: How to add new Brevo list subscribers to Airtable

Each app by itself: Airtable integration and Brevo integration, with how to connect it, its scopes and its limits.

What Airtable and Brevo do together

Brevo holds a client’s mailing lists and sends their transactional email, and Airtable is often the table where the same client tracks customers, orders or event places. Workflows between them copy people across or send a message when the base changes.

Brevo has three triggers here. A contact joining a chosen list and a contact’s details changing are both heard within seconds, and a newly created contact is checked for every 15 minutes. Each has a starter that adds an Airtable row. From Airtable, a record that is added or changed can send a plain-text email through Brevo from a sender verified there, and Brevo’s “Add or update a contact” step is there for workflows you build.

What the pair is used for

  • New Brevo contacts can be copied into Airtable with their email, creation time and whether they have unsubscribed from email, so the client sees in the base who can still be mailed.
  • From the base, Brevo’s “Add or update a contact” creates the person or updates the one with that email, so a row for a new customer puts them in Brevo once.

Every way Airtable and Brevo join

A workflow starts from a trigger in one app and runs a step in the other, on the client’s accounts. Where the library has a starter for it, it installs that pairing into a client switched off; any other pairing is two steps on the canvas.

From Airtable to Brevo

Triggers in Airtable with steps in Brevo
When this happens in AirtableThis runs in BrevoHow fastStarter
A record is addedAdd or update a contactWithin 15 minutesTwo steps on the canvas
A record is addedSend an emailWithin 15 minutesInstall the starter
A record is changedAdd or update a contactWithin 15 minutesTwo steps on the canvas
A record is changedSend an emailWithin 15 minutesInstall the starter

From Brevo to Airtable

Triggers in Brevo with steps in Airtable
When this happens in BrevoThis runs in AirtableHow fastStarter
A new contact is addedCreate a recordWithin 15 minutesInstall the starter
A new contact is addedFind recordsWithin 15 minutesTwo steps on the canvas
A new contact is addedUpdate a recordWithin 15 minutesTwo steps on the canvas
A contact joins a listCreate a recordWithin secondsInstall the starter
A contact joins a listFind recordsWithin secondsTwo steps on the canvas
A contact joins a listUpdate a recordWithin secondsTwo steps on the canvas
A contact’s details changeCreate a recordWithin secondsInstall the starter
A contact’s details changeFind recordsWithin secondsTwo steps on the canvas
A contact’s details changeUpdate a recordWithin secondsTwo steps on the canvas

Set up the starter

Create a record in Airtable when a contact joins a list in Brevo

The starter judged most useful for this pair is Brevo’s “A contact joins a list” to Airtable’s “Create a record”. You give it the Brevo list ID (the number beside the list’s name under Contacts → Lists), the base ID from the base’s address and the table name. Brevo tells the workflow within seconds when someone joins that list, from a signup form or an import.

Each join adds one row holding three values, the contact’s email in “Their email”, the list’s ID in “Lists it joined” and the time of the event in “When”. Airtable wants columns with those exact names, so rename them in the step to match the client’s table, or add the columns in Airtable, before switching it on.

  1. 1Install the starter into the client from Templates → Library. It lands switched off.
  2. 2Connect the client’s Brevo, for “A contact joins a list”
  3. 3Connect the client’s Airtable, for “Create a record”
  4. 4Fill in Brevo: List ID (Contacts → Lists: the number beside the list’s name)
  5. 5Fill in Airtable: Base ID (From the base’s URL: airtable.com/appXXXX/…)
  6. 6Fill in Airtable: Table (For example Leads)
  7. 7Match Airtable’s fields to the client’s own: Their email, Lists it joined, When
  8. 8Switch it on. Within seconds: Brevo tells us as it happens.
The install dialog for an example client, with the Brevo and Airtable details filled in.
The installed workflow on the canvas: Brevo’s “A contact joins a list” trigger leading to Airtable’s “Create a record” step.

What it produces

The Airtable step as it runs for an example client, Lakeview Consulting, when Emma Collins asks for a consultation: each value the starter fills in.

Base ID
appXXXXXXXXXXXXXX
Fields
{"Lists it joined":"{{ trigger.payload.list_id }}","Their email":"{{ trigger.payload.email }}","When":"{{ trigger.payload.date }}"}
Table
Leads

Setup notes for this pair

  • The Brevo starters write different columns. A new contact fills “Created at”, “Their email” and “Unsubscribed from email”; a change fills “Their email” and “When”. A table shared by all three needs every name, “Lists it joined” included.
  • A contact who joins a list and later edits their details ends up on two rows, since these starters only ever create records.

Field mapping, starter by starter

Each value a starter’s step is given, and where it comes from. Words in brackets are filled in when it runs; change any of it after installing.

Send an email for new records

Send an email in Brevo when a record is added in Airtable

The values Send an email in Brevo when a record is added in Airtable sends
Brevo valueFilled from
From[Brevo: From address]
SubjectA record is added
TextA record is added in Airtable. Added at: [the created time, from Airtable]
To[Who it goes to (Brevo)]

Send an email for changed records

Send an email in Brevo when a record is changed in Airtable

The values Send an email in Brevo when a record is changed in Airtable sends
Brevo valueFilled from
From[Brevo: From address]
SubjectA record is changed
TextA record is changed in Airtable. Added at: [the created time, from Airtable]
To[Who it goes to (Brevo)]

Create a record for list signups

Create a record in Airtable when a contact joins a list in Brevo

The values Create a record in Airtable when a contact joins a list in Brevo sends
Airtable valueFilled from
Base ID[Airtable: Base ID]
Fields{"Lists it joined":"[the contact’s list id, from Brevo]","Their email":"[the contact’s email, from Brevo]","When":"[the contact’s date, from Brevo]"}
Table[Airtable: Table]

Create a record for new contacts

Create a record in Airtable when a new contact is added in Brevo

The values Create a record in Airtable when a new contact is added in Brevo sends
Airtable valueFilled from
Base ID[Airtable: Base ID]
Fields{"Created at":"[the contact’s created at, from Brevo]","Their email":"[the contact’s email, from Brevo]","Unsubscribed from email":"[the contact’s email blacklisted, from Brevo]"}
Table[Airtable: Table]

Create a record for contact changes

Create a record in Airtable when a contact’s details change in Brevo

The values Create a record in Airtable when a contact’s details change in Brevo sends
Airtable valueFilled from
Base ID[Airtable: Base ID]
Fields{"Their email":"[the contact’s email, from Brevo]","When":"[the contact’s date, from Brevo]"}
Table[Airtable: Table]

Airtable and Brevo and their logos are trademarks of their owners, used here only to say what Thrum works with; no endorsement is implied.

Thrum is cooking.

Get early access and you’ll be among the first in. Early members get a launch perk.