LinkyFlow for Brevo
The Brevo connection brings one Brevo account into Excel and the LinkyFlow web app: its contacts with their lists and blocklists, its lists, folders and segments, its email, SMS and WhatsApp campaigns with their statistics, its transactional emails day by day, and its CRM — deals, companies, tasks and notes. You connect with an API key of the account. Load them as structured tables, next to your store and payment data in the same workbook, and analyse them with your formulas. It writes only what you ask, from the Actions pane, each change confirmed before it runs.
Key capabilities
Contacts and lists
Contacts reads the people the account knows: their email, their attributes, the lists they belong to, the lists they unsubscribed from, and whether they blocklisted email, SMS or WhatsApp. Filter by creation or modification date, by list or by segment. Contact Lists reads the lists with their subscribers and blocklisted contacts, Contacts of a List the members of one list, Contact Folders and Lists of a Folder how lists are filed, Segments the segments. Contact Attributes reads the attributes a contact may hold, Consent Groups what a contact agreed to receive where Brevo enables them, and Events the custom events tracked on contacts, one a row.
Campaigns
Email Campaigns reads the campaigns with their subject, sender, recipients, schedule, status and statistics — sent, delivered, opens, unique opens, clicks, unique clicks, bounces, unsubscriptions; SMS Campaigns the SMS campaigns with theirs — sent, delivered, answered, bounces, unsubscriptions. WhatsApp Campaigns, WhatsApp Templates and WhatsApp Configuration are read where the account has WhatsApp.
Transactional
Transactional Email Reports reads your transactional emails day by day — requests, deliveries, opens, clicks, bounces, spam reports, unsubscriptions — and Transactional Email Summary the same totals over a period. Transactional Email Events reads them event by event, Transactional Emails the emails sent to an address, from a template or by message id, and Blocked Transactional Contacts the contacts transactional emails no longer reach: unsubscribed, bounced or blocked. Email Templates reads the templates with their settings — their HTML stays in Brevo and is never read into a row. SMS Templates, Transactional SMS Events, Transactional SMS Reports, WhatsApp Events and Webhooks complete it.
CRM
Deals reads the deals with their name, stage, pipeline, amount, owner and close date, and the contacts and companies linked to them; Companies the companies with their domain, industry and contacts; Pipelines the pipelines and their stages; Tasks and Task Types the tasks with their due date and whether they are done; Notes the notes; CRM Files the files attached to contacts, companies and deals — listed, not downloaded. Company Attributes and Deal Attributes read the attributes a company or a deal may hold.
The account
Account reads the account's company, plans and credits; Senders and Sender Domains what it sends from; Background Processes its imports and exports.
Edits published back to Brevo
From the Actions pane of Excel or the web app, one record at a time, each change confirmed before it runs:
- Contacts: create, update or delete a contact; Create Contact by Double Opt-In has Brevo email a person first and adds them once they confirm; Import Contacts, Export Contacts; Track Event records an event on a contact.
- Lists: create, rename or delete a list or a folder; Add Contacts to List and Remove Contacts from List by their emails or ids.
- Campaigns: create, update or delete an email or SMS campaign; Send Test Email or Send Test SMS; Send Campaign Now and Send SMS Campaign Now send a draft — LinkyFlow reads the campaign first and refuses anything but a draft; Update Campaign Status suspends, cancels, archives, unarchives, duplicates it or puts it back to draft; Export Campaign Recipients.
- Transactional: create, update or delete an email template and Send Template Test; Unblock Transactional Contact; Send Transactional Email and Send Transactional SMS send one message; create, update or delete a webhook.
- CRM: create, update or delete a company, a deal, a task or a note; Link Company and Link Deal link or unlink contacts, companies and deals.
A campaign created or updated with a Scheduled At date is sent by Brevo at that date: leave it empty to keep a draft. WhatsApp is read only.
What you can do:
- Clean up your lists from a sheet: read their members, add or remove contacts in one action
- Load campaign and transactional results next to your Shopify orders or Stripe payouts
- Prepare a draft campaign in the sheet and send it only once you decide
- Keep the CRM's deals and tasks up to date from a sheet
- Read a table in a cell with the
=LF.brevofunctions - Read the same account from ChatGPT or Claude through MCP
How lists are read
Brevo pages through a list by offset, each list under its own ceiling, from 50 to 10,000 rows; LinkyFlow reads 50 rows when you say nothing. All results walks at most 1,000 pages and says so when the answer is incomplete. Contacts of a List and Lists of a Folder read one list or one folder: give its id. Transactional Emails needs an email, a template or a message id, and Transactional SMS Events and Transactional SMS Reports a start date or a number of days: Brevo answers nothing without them.
Limits
Brevo limits calls by kind and by plan, per second or per hour — on a free plan, campaigns and the CRM take 100 calls an hour. A read Brevo refuses for that is tried again after a short wait, twice at most; a write is never sent twice. A feature your plan lacks — consent groups, WhatsApp — is refused in Brevo's words. If Brevo answers that Deals are not set up, open CRM → Deals once in Brevo.
Agents
The Inventory Stock Sync, Price Sync and Omnichannel Sales agents work on stores: Brevo holds no stock and no sales channel of its own, so it is not one of their connections.
ChatGPT and Claude
Through MCP, an assistant reads every table with the same connection. Sending a campaign or a test, creating or changing a campaign, changing or testing a template, a deletion, creating or changing a contact and putting contacts on a list are previewed first and run only once you confirm. Organising the account — lists and folders created or renamed, contacts taken off a list, a campaign's status (never a send), a template created, the CRM's records and links — runs at once. Every SMS write, Create Contact by Double Opt-In, the transactional sends, Unblock Transactional Contact, imports, exports, webhooks and Track Event are never offered to an assistant: a person does them in the Actions pane.
What is not done
No campaign is sent by LinkyFlow unless it is a draft and you confirm it. A campaign's or a template's HTML is never read into a row. No WhatsApp message is sent. Brevo's copy of a shop — its products, orders and coupons — is not read: LinkyFlow reads the shop itself.
Next steps: