Automated Brevo Campaign Performance Report
N8N
Project's Category
Intro
This one turns raw email campaign data into an executive summary nobody has to write by hand. Every week it pulls sent campaign stats from Brevo, crunches the open, click, and bounce rates, and emails out a short AI written readout.
Problems
The client's marketing team was tracking campaign performance by hand, pulling numbers out of Brevo and building a report for leadership every week. It ate half a day, and the report still came out a little different depending on who wrote it.
Solutions
We built an n8n workflow that runs on a weekly schedule. It pulls sent campaign data straight from the Brevo API, cleans the raw JSON in a JavaScript step, and calculates open, click, and bounce rates. That data gets archived to Google Sheets so there's a running performance history, not just a one off snapshot. Then Gemini reads the last 7 days of trends and writes a 3 sentence executive summary, which goes out as a formatted HTML email through Gmail.
Final Thoughts
The bounce rate threshold is hardcoded at 2 percent right now, so that's the first thing to adjust for a client with a different tolerance. Dropping a Slack or Discord node on the end for instant alerts is an easy add if the client wants the numbers somewhere faster than their inbox.
Automated Brevo Campaign Performance Report
N8N
Project's Category
Intro
This one turns raw email campaign data into an executive summary nobody has to write by hand. Every week it pulls sent campaign stats from Brevo, crunches the open, click, and bounce rates, and emails out a short AI written readout.
Problems
The client's marketing team was tracking campaign performance by hand, pulling numbers out of Brevo and building a report for leadership every week. It ate half a day, and the report still came out a little different depending on who wrote it.
Solutions
We built an n8n workflow that runs on a weekly schedule. It pulls sent campaign data straight from the Brevo API, cleans the raw JSON in a JavaScript step, and calculates open, click, and bounce rates. That data gets archived to Google Sheets so there's a running performance history, not just a one off snapshot. Then Gemini reads the last 7 days of trends and writes a 3 sentence executive summary, which goes out as a formatted HTML email through Gmail.
Final Thoughts
The bounce rate threshold is hardcoded at 2 percent right now, so that's the first thing to adjust for a client with a different tolerance. Dropping a Slack or Discord node on the end for instant alerts is an easy add if the client wants the numbers somewhere faster than their inbox.
Building the automation systems that handles business processes.
Clear Communication
Reliable
Professional
Reliable Quality
Building the automation systems that handles business processes.
Clear Communication
Reliable
Professional
Reliable Quality
