Automate Marketing Campaigns: Airtable CRM & Brevo Tracking

This n8n workflow streamlines marketing campaign management by integrating Airtable as a CRM with Brevo for email automation. It handles two core processes: batch-sending personalized emails to selected companies and capturing event data to maintain accurate interaction histories.

In the sending phase, the workflow queries the Airtable 'Company' table for targets based on campaign tags or fields. For each company, it retrieves contact details, sends emails via Brevo's template API (capturing unique email IDs), and logs a new 'Interaction' record in Airtable with timestamps, media type, and Brevo ID. This ensures a complete audit trail from the start.

The tracking phase uses an n8n webhook to receive real-time Brevo events such as delivered, opened, clicked, or unsubscribe requests. It then matches events to existing interactions or companies via the Brevo ID and updates Airtable records accordingly, providing precise visibility into campaign performance.

Benefits include time savings on manual tracking, enhanced prospect engagement insights, and scalable automation for sales teams. Ideal for B2B marketing, lead nurturing, or client outreach, reducing no-shows on email metrics and enabling data-driven follow-ups.