Brevo logo
Google BigQuery logo

Workflow template

Record Brevo list activity in BigQuery

Append one row per Brevo list addition. Choose a BigQuery table with added_at STRING and list_ids REPEATED INT64. The row contains all affected list IDs and the provider timestamp. Recipient addresses stay out of the warehouse.

How it works

Workflow steps

1 Trigger · 1 Action
Brevo1 · Trigger

Marketing List Addition

Receive Brevo marketing list_addition events.

Google BigQuery2 · Action

Insert notification row

Streams data into BigQuery one record at a time without needing to run a load job. # IAM Permissions Requires the following IAM permission(s) to use this method: - `bigquery.tables.updateData` on the table. - `bigquery.tables.get` on the table. - `bigquery.datasets.get` on the dataset.

Before activation

Set up your workflow

  1. Copy the template

    Open the template in FastHook to create an editable Workflow Draft.

  2. Connect your accounts

    Connect your accounts for Brevo, Google BigQuery.

  3. Review the Workflow

    Review the Steps, field mappings, routes, and provider settings.

  4. Activate

    Activate the Workflow when the Draft is ready, then verify a test run.

Questions about this template

Does the template copy someone else's credentials?

No. FastHook creates a disconnected Draft. Connect your own Brevo, Google BigQuery accounts before activation.

Can I change the Steps and mappings?

Yes. The copied Workflow is an editable Draft. Review every Step, input, mapping, and route before you activate it.

What is copied into my workspace?

FastHook recreates the Trigger configuration, Action Steps, routes, and mappings with new IDs. Provider accounts, credentials, and secrets are never copied.

When does the Workflow start running?

Only after you connect the required accounts, finish the configuration, and explicitly activate the Draft.

Explore connected apps