The Scenario
You are a marketing analyst. The channel performance review is Monday. Your VP of Marketing wants a comparison of email versus SMS for the past six months — delivery rates, click rates, cost per click. The SMS data is all in Brevo.
You have sent 24 SMS campaigns in the last six months. You need campaign name, send date, recipient count, delivered count, and click count in a Google Sheet by Friday afternoon so you can spend the weekend building the comparison deck.
The bad version of this Friday:
- You go into Brevo's SMS Reports section
- You find the export button, download a CSV
- You open it in Google Sheets and realize the columns are named differently from what you expected
- The delivered count and the recipient count are in the same column as a fraction (1243/1500)
- You spend an hour parsing the fraction into two separate columns
- You go back and realize the export was capped at the last 10 campaigns
- You repeat the export with an earlier date range, get another 10, combine the files
- You are fixing it Saturday morning instead of building the deck.
The fast version is one prompt on Friday at noon.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that pulls Brevo SMS campaign data directly, so you get the columns split the way you need them.
Open the SheetXAI sidebar and type:
Pull all sent Brevo SMS campaigns from the past 6 months into this sheet. Include campaign name, send date, recipient count, delivered count, and click count as separate columns. Sort by send date ascending. Write results starting from row 2 with headers in row 1.
SheetXAI fetches all 24 campaigns from Brevo's SMS API, splits the delivered and recipient counts into separate columns, and writes them sorted by date. Done before lunch.
What You Get
A Google Sheet with one row per SMS campaign:
- Campaign name — as it appears in Brevo
- Send date — formatted as a readable date
- Recipient count — the number Brevo attempted to reach
- Delivered count — how many actually received it
- Click count — tracked clicks from the message
The delivered and recipient counts are in separate columns. You do not have to parse a fraction. You can go straight to building the delivery rate formula in the next column.
Want to add sender name and message content for the deck footnotes? Add those fields to the prompt. SheetXAI pulls whatever Brevo exposes.
What If the Data Is Not Quite Ready
SMS reporting data has quirks that make analysis harder than it should be.
When you want delivery rate and click rate calculated automatically
You do not want to write the formulas yourself after the pull.
Pull all sent Brevo SMS campaigns from the past 6 months into this sheet with campaign name, send date, recipient count, delivered count, and click count. Add a "Delivery Rate %" column (delivered/recipient × 100, rounded to 1 decimal) and a "Click Rate %" column (clicks/delivered × 100, rounded to 1 decimal).
When you need to group by month for the comparison chart
The VP wants a month-by-month view, not one row per campaign.
Pull all Brevo SMS campaigns from the past 6 months. Aggregate by calendar month — total recipients, total delivered, total clicks, and average delivery rate for each month. Write the aggregated rows into this sheet, one row per month.
When some campaigns are tests and should be excluded
You ran a handful of small test sends to internal lists that would skew the delivery rate.
Pull all sent Brevo SMS campaigns from the past 6 months. Exclude any campaign with fewer than 200 recipients. Include campaign name, send date, recipient count, delivered count, and click count.
When you want the full channel comparison report assembled in one shot
The VP wants the SMS data, the top 3 campaigns by click rate, and a one-sentence observation about delivery trends — all in the same sheet, ready for the deck.
Pull all 24 Brevo SMS campaigns from the past 6 months with campaign name, send date, recipient count, delivered count, and click count. Add delivery rate and click rate columns. Identify the top 3 campaigns by click rate and write them into a "Highlights" section starting in column H. Write a one-sentence observation about whether delivery rates improved or declined over the period in cell H1.
The pattern: ask for the pull and the analysis in one prompt. The deck starts from a finished sheet, not a raw export.
Try It
Get the 7-day free trial of SheetXAI and open a blank sheet, then ask it to pull your Brevo SMS campaign stats. The Brevo integration is included in every SheetXAI plan. For related workflows, see how to pull email campaign stats into a sheet or the Brevo in Google Sheets overview.