Brevo campaigns and transactional emails

Load your Brevo campaigns and transactional emails into Excel or the web app, then act on them from the Actions pane. Each action writes one record, from your own click, and is confirmed before it runs.

Read what your campaigns achieved

1. Insert a LinkyFlow query, choose Brevo, then the query Email Campaigns.
2. Set Statistics to globalStats, and narrow with Status (draft, sent, queued…), Type, or a Start Date and an End Date. Set Sort to desc to read the latest first.
3. Add the statistics columns you want — Statistics Global Stats Sent, Delivered, Unique Views (unique opens), Unique Clicks, Unsubscriptions, Hard Bounces… — and run it. Each row is a campaign, with its status, its send date and Brevo's own numbers.

SMS Campaigns reads your SMS campaigns the same way, with their sent, delivered, answered, bounced and unsubscribed counts. Load your store orders or payouts in the same workbook to set the results beside your sales.

Prepare and send a campaign

1. In the Actions pane, choose Create Email Campaign. Give its Name, its Subject, its Sender Email and Sender Name, the Recipients List Ids it goes to, separated by commas, and its content: a Template ID, or Html Content. Leave Scheduled At empty: the campaign is created as a draft, and nothing is sent.
2. Select the campaign in Email Campaigns and choose Send Test Email: give the Email To addresses, each one of your account's test contacts, or none to send it to your whole test list.
3. The Actions pane offers Send Campaign Now while the campaign is a draft. LinkyFlow reads the campaign again just before the write and refuses anything but a draft. Once you confirm, Brevo sends it at once to every recipient of its lists. A send cannot be recalled.
4. Update Campaign Status suspends, cancels, archives or unarchives a campaign, duplicates it, or puts it back to draft — it never sends one.

A campaign created or updated with a Scheduled At date is sent by Brevo at that date, to every recipient of its lists: give one only when you mean it. Create SMS Campaign, Send Test SMS, Send SMS Campaign Now and Update SMS Campaign Status do the same for SMS, which spend your SMS credits.

Follow your transactional emails

1. Choose the query Transactional Email Reports and give Days (up to 30) or a Start Date and an End Date: each row is a day, with its requests, deliveries, opens, clicks, bounces, spam reports and unsubscriptions. Transactional Email Summary answers the same totals over a period, in one row.
2. Choose Transactional Email Events to read them event by event — a delivery, an open, a bounce — filtered by Email, Event or Template ID.
3. Choose Transactional Emails with an Email, a Template ID or a Message ID — Brevo needs one of them — to list the messages sent.
4. Blocked Transactional Contacts lists the contacts your transactional emails no longer reach: unsubscribed, bounced or blocked. On a row, Unblock Transactional Contact lifts the block, when the contact asks for it.

Templates and one-off messages

Create Email Template, Update Email Template and Delete Email Template manage your templates; Send Template Test sends one to your test addresses. Send Transactional Email and Send Transactional SMS send one message at once — for what the person expects, an order or their account, never a promotion: a transactional message goes out whatever their marketing consent.

In a cell

Each read is also an Excel function, among them =LF.brevo.emailCampaigns, =LF.brevo.emailReports and =LF.brevo.transactionalEmails. A function reads; the actions run from the Actions pane. The Brevo connection reference prints each function with its arguments.

The Brevo Campaigns & Transactional dashboard of the Excel add-in loads your latest 100 email campaigns with their results and your last 30 days of transactional emails, with ready-made counts: campaigns, drafts, delivered, unique opens and transactional emails delivered.

From ChatGPT or Claude, sending a campaign or a test, creating or changing a campaign and changing or testing a template are previewed and run only once you confirm; an assistant may change a campaign's status, never to send it. Every SMS write, the transactional sends and unblocking a contact stay in the Actions pane.