Automate Email Marketing with NocoDB & Brevo

This n8n workflow powers a complete email marketing automation system by connecting to NocoDB as a Customer Data Platform (CDP), selecting email templates via flow_id, and delivering personalized messages through Brevo. It includes two modular sub-flows: 'Insert user_id' for data processing and 'Sending Email' for delivery. Key steps involve fetching user data, filtering duplicates by user_id to prevent over-sending, validating email addresses (flagging disposables), inserting records into a transaction database (n8n-transaction-ecrm), sending templated emails with dynamic parameters, and updating statuses with sent_result and sent_at timestamps.

The workflow is highly extensible, allowing additions like SMS, push notifications, or Telegram channels. It runs on a 30-minute schedule trigger, ensuring timely campaign execution without manual intervention. Benefits include reduced manual effort, higher deliverability through validation and deduplication, comprehensive tracking for analytics (integrates with BI tools like Metabase or Power BI), and scalability for high-volume sends.

Ideal for growth/CRM teams in health & fitness, ecommerce marketers handling time-sensitive journeys, and data teams building custom triggers from CDPs. Use the included example databases (cdp-ecrm, n8n-templates-ecrm, n8n-transaction-ecrm) to start quickly, or connect your own stack. Setup is straightforward: configure NocoDB/Brevo credentials, set flow_id in the Setup Flow node, and activate.