The Scenario
You identified the problem last month: a re-engagement campaign mailed both a customer's real profile and a duplicate created when they used a slightly different email. Now you have the cleanup list — 80 duplicate pairs in an Excel workbook, canonical profile ID in column A, duplicate to merge in column B. Klaviyo needs to merge them before the next campaign, or you are doubling messages to the same people again.
The bad version:
- Log into Klaviyo and search for a bulk merge tool — there is none. Profile merges happen one at a time through the individual profile detail screen.
- Open pair one, initiate the merge, confirm the destination, submit. Open pair two. Repeat 79 more times.
- Get interrupted at pair 35, come back an hour later, and spend 10 minutes cross-referencing the workbook against Klaviyo to figure out where you left off.
Eighty individual merge actions. No way to pause and resume. The clicking is the entire job.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the duplicate pair list and calls Klaviyo's profile merge endpoint for each row — sequentially, with status logged back per row.
Merge all duplicate Klaviyo profiles listed in this workbook — column A is the destination profile ID and column B is the source profile ID to merge and delete
What You Get
- Each pair is submitted to Klaviyo's merge endpoint, column A as destination.
- Column C is populated with "MERGED" or "FAILED" plus the error reason for any pair that did not process.
- Event history and subscription data from the source profile are folded into the destination by Klaviyo.
What If the Data Is Not Quite Ready
You need explicit timestamps for the audit log
For each row in the "Duplicates" worksheet, merge the profile in column B into the profile in column A, mark column C as "MERGED" or "FAILED", and write the merge timestamp into column D
Some source profile IDs may already be deleted from a previous partial run
Merge each duplicate pair in this workbook — column A is destination, column B is source; if the source profile ID returns a 404, write "NOT FOUND" in column C and continue to the next row
Profile IDs are not available — you only have email addresses
For each row in this workbook, look up the Klaviyo profile ID for the email in column A and the email in column B, then merge the column B profile into the column A profile — write the resolved IDs into columns C and D and the merge status into column E
Full deduplication with summary
Process all 80 merge pairs (column A = destination, column B = source), write "MERGED", "NOT FOUND", or "FAILED" into column C, then output a summary at the bottom: total merged, total not found, total failed, and run timestamp
Eighty merges. One prompt. No clicking.
Try It
Get the 7-day free trial of SheetXAI and open your duplicate profile tracking workbook from the last data audit, then ask it to submit all merge requests to Klaviyo in sequence. Also see how to update profiles with RFM scores once the audience is clean.