Generate weekly Brevo campaign analytics reports with Groq and Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 12 nodes and runs on a schedule (every week at 08:00). Along the way it connects Google Sheets, Groq Chat Model and Gmail. It also calls api.brevo.com over HTTP.
How it runs
Trigger: On a schedule (every week at 08:00).
- HTTP Request: calls api.brevo.com
- Data Cleaning (Code): runs custom JavaScript code
- Append row in sheet (Google Sheets): append
- Aggregate: combines items into one
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- Filtered 7 days data (Code): runs custom JavaScript code
- Aggregate: combines items into one
- AI Agent: runs an AI agent, with model: Groq Chat Model
- Edit Fields (Edit Fields (Set)): sets 1 field: emailBoady
- Send a message (Gmail): uses Gmail
Services it uses
HTTP calls to: api.brevo.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (9)
- HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets - AI Agent
@n8n/n8n-nodes-langchain.agent - Groq Chat Model
@n8n/n8n-nodes-langchain.lmChatGroq - Edit Fields (Set)
n8n-nodes-base.set - Gmail
n8n-nodes-base.gmail - Aggregate
n8n-nodes-base.aggregate - Code
n8n-nodes-base.code - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
How it works: This workflow fetches sent campaign data from Brevo on a schedule, calculates key metrics (open rate, click rate, bounce rate), and stores results in Google Sheets. It then filters to a rolling 7-day window, runs an AI analysis to generate an…