Back to Templates

Inserting Brevo Contact Reports into NocoDB

Created by

Created by: Nima Salimi || salimi

Nima Salimi

Last update

Last update 21 days ago

Categories

Share


Overview

This n8n workflow automatically retrieves Brevo contact reports and inserts summarized engagement data into NocoDB.
It groups campaign activity by email, creating a clean, unified record that includes sent, delivered, opened, clicked, and blacklisted events.
This setup keeps your CRM or marketing database synchronized with the latest Brevo email performance data.


Tasks

  • ⏰ Runs automatically on schedule or manually
  • 🌐 Fetches contact activity data from Brevo API
  • 🧩 Groups all campaign activity per email
  • 💾 Inserts summarized data into NocoDB
  • ⚙️ Keeps engagement metrics synced between Brevo and NocoDB

🛠 How to Use

  • 🧱 Prepare your NocoDB table
    Create a table with fields for: email, messagesSent, delivered, opened, clicked, done, and blacklisted.

  • 🔑 Connect your Brevo credentials
    Add your Brevo API Key in the HTTP Request node to fetch contact data securely.

  • 🧮 Review the Code Nodes
    These nodes group contact activity by email and prepare a single dataset for insertion.

  • 🚀 Run or schedule the workflow
    Execute it manually or use a Schedule Trigger to automate the data sync process.


📌 Notes

  • 🗂 Make sure the field names in NocoDB match those used in the workflow.
  • 🔐 Keep your Brevo API Key secure and private.
  • ⚙️ The workflow can be expanded to include additional fields or filters.
  • 📊 Use the data for engagement analytics, segmentation, or campaign performance tracking.