The Scenario
You are a marketing operations analyst. The campaign team signed off on ten audience personas for the new product line. Each needs its own MailerLite segment so campaigns can target them from day one.
You have the segment names in an Excel workbook. Column A has the name. Everything needs to be ready before the first campaign brief lands Friday morning.
The bad version:
- You log into MailerLite and navigate to Subscribers → Segments
- You click "Create segment," type the first name, configure the filter, save
- You do this ten times
- On segment six you mistype a name — you do not catch it until a campaign goes out to the wrong audience
- You have no record of which segment IDs were created, so when a developer asks for them you have to look up each one manually
- The campaign brief lands at 9 AM Friday and two segment IDs are still missing from the targeting doc.
The fast version creates all ten and writes the IDs back to the workbook before you leave Thursday.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that creates MailerLite segments in bulk and writes the resulting IDs back as a record.
Open the SheetXAI sidebar and type:
For each row in this workbook, create a new MailerLite segment using the segment name in column A — write the created segment ID into column B and CREATED or FAILED into column C.
SheetXAI reads every row in column A, calls the MailerLite segments API to create each one, and writes the segment ID and outcome back. If a segment with that name already exists, the status in column C tells you.
What You Get
Ten new MailerLite segments, with results written back to the workbook:
- Segment names taken directly from column A — no retyping
- Segment IDs written into column B for every successfully created segment
- CREATED or FAILED in column C
- A permanent record the developer can use for campaign targeting
The ID column is the part you cannot get from the MailerLite UI without clicking through each segment.
What If the Data Is Not Quite Ready
Segment definitions from stakeholders are never quite final. SheetXAI handles variations in the same prompt.
When some segment names have trailing spaces from copy-paste
The names came from a Teams document and a few have invisible whitespace.
Trim whitespace from column A for each row, then create a MailerLite segment for each. Write the segment ID into column B and CREATED or FAILED into column C.
When you want subscriber counts immediately after creation
The campaign team wants to know if the audiences are big enough before briefing starts.
Create a MailerLite segment for each row in column A. Write the segment ID into column B and CREATED or FAILED into column C. Then fetch the subscriber count for each newly created segment and write it into column D.
When some segments already exist and you only want the missing ones
You ran this last week for seven personas. The workbook now has ten and you only need the three new ones.
Check each segment name in column A against existing MailerLite segments. For segments that already exist, write ALREADY_EXISTS and the existing ID into columns C and B. For segments that do not exist, create them and write the new ID into column B and CREATED into column C.
When you want to create segments and immediately populate them from another tab
The Personas tab has the segment definitions. The Subscribers tab has emails tagged by persona in column B.
Create a MailerLite segment for each row in column A of the Personas tab and write the ID into column B. Then go to the Subscribers tab and for each email in column A, add that subscriber to the MailerLite segment whose name matches column B. Write the outcome into column C.
The pattern: one prompt creates the segments, captures the IDs, and optionally populates them — all in the workbook as a record.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with audience or persona definitions, then ask it to create the MailerLite segments and write the IDs back. The MailerLite integration is included in every SheetXAI plan. For related workflows, see how to sync group membership from an Excel workbook or the MailerLite in Excel overview.