The Scenario
You are a marketing coordinator. It is Tuesday morning and the trade-show wrapped Friday. You have 2,000 leads in an Excel workbook — email in column A of the Leads tab, first name in column B, company in column C — and you need them in a new Brevo list called "Event 2025" before your 10 AM follow-up kickoff.
The bad version of this morning:
- You export the Leads tab as CSV
- You go into Brevo and click "Create a list"
- You open the contact import wizard, upload the file
- You spend fifteen minutes mapping your column headers to Brevo's expected fields because "Company Name" did not match "company"
- Half the rows fail because two hundred of them have trailing spaces in the email column
- You fix the CSV in Excel, re-export, re-upload, re-map
- You walk into the 10 AM meeting with 1,800 of 2,000 contacts imported and no idea which 200 failed.
The fast version is one prompt and the count is in the workbook.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads your contact data and calls Brevo directly, so you never have to export a CSV or click through a column mapping wizard.
Open the SheetXAI sidebar and type:
Create a new Brevo contact list called "Event 2025" and add every contact from the Leads tab of this workbook. Use column A for email, column B for first name, and column C for company. After importing, write the total number of contacts successfully added into cell E1.
SheetXAI reads every row in the Leads tab, calls Brevo's API to create the list, imports the contacts in batches, handles rate limiting on its own, and writes the final success count back to E1.
What You Get
- A new Brevo list called "Event 2025" — created and populated in one pass
- 2,000 contacts added — email, first name, and company mapped automatically from the Leads tab columns
- A count written to E1 — so you know what went in without logging into Brevo
- No CSV export, no column mapping wizard, no re-uploads
If a row has a malformed email, SheetXAI skips it and reports the count. You know exactly how many went in. That number is in the workbook, not buried in a Brevo import log.
Want to add contacts to an existing list instead of creating a new one? Tell SheetXAI to use list ID 42 or give it the list name. It looks up the right one.
What If the Data Is Not Quite Ready
Real trade-show exports are rarely as clean as the scenario above. SheetXAI handles cleanup and the import in the same prompt.
When there are duplicate email addresses
Your registration platform let people sign up twice and both rows are in the workbook.
Deduplicate the Leads tab by email address in column A, keeping the first occurrence of each. Then create a new Brevo list called "Event 2025" and import all contacts using columns A, B, and C.
When some rows are missing a first name
A few hundred people only gave their email and company at registration.
Import all contacts from the Leads tab into a new Brevo list called "Event 2025." If a row is missing a first name in column B, import it without a first name — do not skip the row. Write the count of rows imported without a first name into cell E2.
When the email column has formatting issues
Trailing spaces, uppercase domains, or a handful of obviously malformed entries that will bounce.
Normalize the email addresses in column A of the Leads tab — trim whitespace and convert to lowercase. Flag any that are clearly malformed (missing @ or domain) by writing "INVALID" in column D. Then import all non-flagged rows into a new Brevo list called "Event 2025."
When you want to segment the list on import
Some contacts are from the morning session, some from the afternoon, based on a column D value. You want two separate Brevo lists, not one.
Read the Leads tab. For rows where column D says "AM," import the contact into a Brevo list called "Event 2025 AM." For rows where column D says "PM," import into a list called "Event 2025 PM." Write the counts for each list into cells E1 and E2 respectively.
The pattern: instead of cleaning the workbook yourself and then managing the import, you describe both operations in one prompt and SheetXAI runs them in sequence.
Try It
Get the 7-day free trial of SheetXAI and open any workbook with a contact list, then ask it to import the contacts into Brevo. The Brevo integration is included in every SheetXAI plan. For related workflows, see how to export Brevo contacts for a data audit in Excel or the Brevo in Excel overview.