The Scenario
You are a marketing operations analyst. The campaign team just signed off on ten audience personas for the new product line — each one needs its own MailerLite segment so campaigns can target them from day one.
You have the segment names in a Google Sheet. Column A has the name. The team wants all ten created before the first campaign brief lands on 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 later you have to go back and 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 Sheet before you leave Thursday.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that creates MailerLite segments in bulk and writes the resulting IDs back so you have a record without doing any lookups.
Open the SheetXAI sidebar and type:
For each row in this sheet, 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 the results written back to the Sheet:
- 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 — so you know at a glance which ones need attention
- A permanent record in the Sheet that the developer can use directly for campaign targeting
The ID column is the part you cannot get from the MailerLite UI without clicking through each segment. With SheetXAI, it is in the Sheet the moment the segment is created.
What If the Data Is Not Quite Ready
Segment definitions from stakeholders are rarely final on first pass. SheetXAI handles variations in the same prompt.
When some segment names have trailing spaces from copy-paste
The names came from a Notion table 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 for each segment 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 to create the missing ones
You ran this last week for seven personas. The Sheet 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. You want the segments created and the right subscribers moved in.
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 — everything lands in the Sheet as a record.
Try It
Get the 7-day free trial of SheetXAI and open any Sheet 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 a Sheet or the MailerLite in Google Sheets overview.