The Scenario
Your paid acquisition team needs a Facebook custom audience seeded from Klaviyo's "High LTV Customers" segment — around 3,000 profiles. The lookalike campaign launches next week. You need those profiles in an Excel workbook with email, first name, and phone number in the right format for Facebook Ads Manager's custom audience upload.
The bad version:
- Log into Klaviyo, navigate to the segment, and look for an export button — find that there is no direct segment export in the UI that gives you the specific columns you need in a single step.
- Write or find a script to call Klaviyo's segment profiles endpoint, handle pagination across 30 pages of 100 profiles each, and stitch the pages into a single workbook.
- Discover the phone column is not in E.164 format — reformat 3,000 cells before uploading to Facebook.
The lookalike campaign has a launch date. Three thousand pagination calls and a phone reformatting step are not in the plan.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It handles the full pagination loop and writes the profiles directly into the workbook — no scripting needed.
Export all profiles from Klaviyo segment ID seg123 and write each profile's email, first name, and phone number into this workbook
What You Get
- All 3,000 segment members are pulled across paginated API calls and written as one row per profile.
- Columns contain email, first name, and phone number in the format Klaviyo returns.
- The workbook is ready for Facebook Ads Manager upload, with an optional reformatting prompt if the phone format needs adjustment.
What If the Data Is Not Quite Ready
You need city and country for geographic targeting
Fetch all members of the Klaviyo segment named "High LTV Customers" and populate columns A through D with email, external_id, city, and country
Phone numbers need E.164 formatting for Facebook
Export all profiles from Klaviyo segment ID seg123, write email (A), first name (B), and phone (C), then normalize column C to E.164 format before writing
The segment ID is not known — you only have the name
Export all profiles from the Klaviyo segment named "High LTV Customers" and write email, first name, and phone into columns A through C — look up the segment ID from the segment name first
Full Facebook custom audience prep in one pass
Export all profiles from the Klaviyo segment named "High LTV Customers"; write email (A), first name (B), phone normalized to E.164 (C), and country (D); remove any rows where email is blank; write the total profile count at the bottom of column A
The seed audience is ready. The lookalike launches on time.
Try It
Get the 7-day free trial of SheetXAI and open a blank Excel workbook when you need your next Klaviyo segment for an ad campaign, then ask it to pull and format the profiles in one pass. Also see how to bulk suppress opt-out contacts to keep that seed audience clean.