Webhook and Brevo integration

This workflow automates the process of collecting contacts, storing them in Brevo, and sending a welcome email, while also supporting bulk import from Google Sheets and unsubscribe tracking. Key Advantages ✅ Full automation of lead management The workflow eliminates manual work by handling the entire lifecycle: Data collection → Contact creation → Email sending This ensures faster response times and no missed leads. ✅ Real-time and batch processing It supports both: Instant processing** (via form/webhook) Bulk operations** (via Google Sheets) This makes it flexible for different use cases (landing pages, imports, CRM sync). ✅ Data consistency with “upsert” Using the upsert operation, contacts are: Created if new Updated if already existing This prevents duplicates and keeps your database clean. 4.✅ Seamless Brevo integration The workflow directly interacts with Brevo APIs to: Manage contacts Assign them to lists Send transactional emails This centralizes marketing automation in one platform. ✅ Automated onboarding experience New users instantly receive a welcome email, improving: User engagement First impression Conversion rates ✅ Scalable bulk processing The loop system allows processing large datasets efficiently, making it suitable for: Campaign migrations CRM imports Lead enrichment ✅ Data tracking and feedback loop By updating Google Sheets: Processed contacts are marked (“Done”) Unsubscribed users are tracked This creates a simple but effective CRM feedback loop. ✅ Event-driven unsubscribe handling The workflow reacts automatically to unsubscribe events, ensuring: Compliance with email regulations (GDPR, etc.) Clean and updated contact lists How it works This workflow automates contact management and email communication using Brevo (formerly Sendinblue) and Google Sheets*. It handles three main scenarios: Form submission or webhook trigger – When a user submits a form or hits a webhook, their contact info (first name, last name, email) is upserted into Brevo, added to a specific list, and a welcome email is sent. Batch import from Google Sheets – When manually executed, the workflow reads rows from a Google Sheet, loops through each row, upserts the contact into Brevo, adds them to a list, sends a welcome email, and marks the row as done in the sheet. Unsubscribe tracking – When Brevo detects an unsubscribe event, the workflow updates the corresponding row in Google Sheets to mark the contact as unsubscribed. The workflow ensures no duplicate contacts are created in Brevo (using upsert), and all actions are logged back into the Google Sheet. Set up steps Brevo credentials Register and Create an API key in Brevo for FREE. In n8n, add a SendInBlue API credential (sendInBlueApi) and an HTTP Header Auth credential (httpHeaderAuth) using the same API key. Google Sheets credentials Set up a Google Sheets OAuth2 API credential (googleSheetsOAuth2Api) in n8n. Ensure the Google account has access to the target spreadsheet. Google Sheets configuration Use the provided spreadsheet ID. Columns expected: First Name, Last Name, Email, Done, Unsubscribe, row_number. The workflow uses row_number to update the correct row. Brevo template setup Create a welcome email template in Brevo. Set the template ID to 1 (or update the workflow nodes with the correct ID). Form and webhook configuration The form trigger is pre-configured with fields: first_name, last_mail, email. The webhook node is ready to receive POST requests at its path. Activate the workflow to expose the webhook URL. List ID configuration The workflow adds contacts to Brevo list ID 3. Replace this with your actual list ID if different. Activate workflow Toggle the workflow to active to start listening for form submissions, webhook calls, and Brevo unsubscribe events. Manual execution for batch processing Use the "When clicking ‘Execute workflow’" trigger to run the batch import from Google Sheets. 👉 Subscribe to my new YouTube channel. Here I’ll share videos and Shorts with practical tutorials and FREE templates for n8n. Need help customizing? Contact me for consulting and support or add me on Linkedin.

🎯 General principles This template automates the management of marketing campaign from a CRM based on Airtable, using Brevo for sending and tracking emails. 🧩 It is based on two main steps: Sending emails to targeted companies in Airtable, creating an interaction record for each sent email. Real-time tracking of events (email delivered / opened / clicked, unsubscribe request) via a n8n webhook, updating the corresponding interaction or company record. This workflow provides precise tracking of marketing actions and facilitates the history of interactions with prospects or clients. Prerequisites Airtable with at least 3 tables: Company: Contains information about your clients or prospects. Interaction: Log of exchanges and events. Campaign: Information about the ongoing campaign. Brevo: A predefined email template, which can include a link to a form. API access for sending and tracking emails. ⚙️ Step-by-step description 1️⃣ Sending Emails Selecting targeted companies The workflow queries the Company table in Airtable, filtering on a tag or a specific field related to the campaign (e.g., Campaign = "1"). Preparing data for Brevo For each company, retrieves the necessary information: email address. Sending the email via Brevo Uses a Brevo Send Template node with a predefined template. Brevo returns a unique identifier for each email sent. Creating an interaction in Airtable A record is added to the Interaction table containing: Company Date and time of interaction Media = email Brevo email identifier 2️⃣ Tracking Events Receiving Brevo events Brevo triggers a webhook to n8n for each event: Delivered Opened Clicked Unsubscribed Matching with the interaction Based on the Brevo identifier received, the workflow finds the corresponding Interaction in Airtable. Updating the interaction The interaction status is updated based on the event (e.g., "Opened" with date and time). Managing unsubscribes In case of an unsubscribe: The workflow finds the Company associated via the interaction. A specific field in the Company table (e.g., Opt-in) is updated to "No" in order to exclude this company from future campaigns. ✅ Benefits of this template Automated sending and real-time tracking. Interaction history stored in the CRM. RGPD (European regulations) compliance through automatic unsubscribe management. Clear view of campaign effectiveness (open rates, clicks, etc.). 📬 Contact Need help customizing this (e.g., expanding Data Tables, connecting multiple surveys, or automating follow-ups)? 📧 [email protected] 🔗 guy.salvatore 🌐 smarthome-smartelec.fr