The Scenario
You are a digital marketer at a mid-size e-commerce brand. The quarterly stakeholder review is Thursday. Your CMO wants a slide showing email channel performance for the past year, and the data is all in Brevo.
You have sent 30 email campaigns in the past twelve months. You need campaign name, send date, recipient count, open rate, and click rate in a Google Sheet so you can build the chart and write the commentary.
The bad version of this week:
- You go to Brevo's Reports tab and export campaign statistics as CSV
- Brevo exports a flat file with column names that do not match what you want in the chart
- You paste it into the sheet and spend thirty minutes reformatting headers
- You realize the export only goes back six months by default
- You repeat the export for the first six months of the year with a different date filter
- You combine the two exports, deduplicate the overlapping rows
- You realize the open rate column is a decimal and your chart expects a percentage
- You are still fixing the sheet at 11 PM on Wednesday.
The fast version is one prompt and the chart data is ready before lunch.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that pulls Brevo campaign data directly, so you get the columns you need in the format you need them.
Open the SheetXAI sidebar and type:
Pull all sent Brevo email campaigns from the past 12 months into this sheet. Include campaign name, send date, total recipients, open rate as a percentage, and click rate as a percentage. Sort by send date ascending. Write results starting from row 2 with headers in row 1.
SheetXAI calls Brevo's campaign API, pulls all 30 campaigns, converts the open and click rates to percentages, and writes them into the sheet in the order you asked for. Done before your second coffee.
What You Get
A clean Google Sheet with one row per campaign:
- Campaign name — exactly as it appears in Brevo
- Send date — formatted as a date, not a Unix timestamp
- Total recipients — the count Brevo delivered to
- Open rate — expressed as a percentage (e.g. 24.3, not 0.243)
- Click rate — same
The rows are sorted by send date, so you can drop the data directly into a chart without reordering anything. No reformatting. No CSV merge. No unit conversion by hand.
Want to add subject line and sender name for the slide's footnotes? Add them to the prompt. SheetXAI pulls whatever columns Brevo exposes.
What If the Data Is Not Quite Ready
Campaign data gets messy when you are filtering, comparing, or calculating derived metrics.
When you want to filter by campaign type
You ran a mix of newsletters and promotional campaigns and the stakeholder slide should show them separately.
Pull all sent Brevo email campaigns from 2025 into this sheet. Include campaign name, type, send date, recipient count, open rate as a percentage, and click rate as a percentage. After pulling, add a column called "Type" and label each row "Newsletter" or "Promo" based on whether the word "newsletter" appears in the campaign name. Sort by type, then by send date.
When you need quarter-over-quarter comparison
The CMO wants to see Q1 vs Q2 vs Q3 vs Q4 performance in the same view.
Pull all Brevo email campaigns sent in 2025 into this sheet. Add a "Quarter" column derived from the send date. Then create a summary row at the bottom of each quarter group showing average open rate and average click rate for that quarter.
When some campaigns were tests and should be excluded
You have a handful of A/B test sends with small recipient counts that would skew the averages.
Pull all sent Brevo email campaigns from the past 12 months. Exclude any campaign with fewer than 500 recipients. Include campaign name, send date, recipient count, open rate as a percentage, and click rate as a percentage.
When you need the full analysis in one shot for the board slide
The CMO also wants to know the best-performing campaign by open rate, the worst by click rate, and whether there is a seasonal trend — all in the same sheet.
Pull all 30 Brevo email campaigns from the past year into this sheet with campaign name, send date, recipient count, open rate as a percentage, and click rate as a percentage. Identify the top 3 campaigns by open rate and the bottom 3 by click rate, and write those findings into a "Highlights" section starting in column H. Also check whether open rates are higher in Q4 than the rest of the year and write a one-sentence finding.
The pattern: instead of pulling the data and then doing the analysis separately, ask for both in one prompt. The CMO gets a sheet that is already half a presentation.
Try It
Get the 7-day free trial of SheetXAI and open a blank sheet, then ask it to pull your Brevo campaign stats. The Brevo integration is included in every SheetXAI plan. For related workflows, see how to export Brevo contacts for a data audit or the Brevo in Google Sheets overview.