The Scenario
You are a CRM analyst. Three months ago, the company ran a re-engagement campaign that mailed both the canonical customer profile and a duplicate that was created when the same customer used a slightly different email variation. You now have a Google Sheet identifying 80 of these duplicate pairs: the correct profile ID in column A, the duplicate profile ID to be merged and deleted in column B. Getting Klaviyo to merge them is the last step before the audience data can be trusted for the next campaign.
The bad version:
- Log into Klaviyo and search for a bulk merge option — discover there is none. Merges happen one at a time through the profile detail screen.
- Open the first pair, initiate the merge, confirm the destination profile, submit. Repeat 79 more times.
- Lose track of which pairs you have already processed at row 35 when you get pulled into a meeting, come back, and have to cross-reference the sheet against Klaviyo manually to find where you left off.
Eighty merges at three minutes each is four hours of clicking. Your job is analysis, not data entry.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the duplicate pair list and calls Klaviyo's profile merge endpoint for each row — sequentially, with status written back per row.
Merge all duplicate Klaviyo profiles listed in this sheet — 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, with the column A profile as the destination.
- Column C is populated with "MERGED" or "FAILED" plus the error reason for any pair that did not process.
- Event history and subscription status from the source profile are combined into the destination profile by Klaviyo.
What If the Data Is Not Quite Ready
You need explicit confirmation logged for audit purposes
For each row in the "Duplicates" sheet, call Klaviyo to merge the profile in column B into the profile in column A, then mark column C as "MERGED" or "FAILED" — include the timestamp of each merge in column D
Some source profile IDs might already have been deleted from a previous partial run
Merge each duplicate pair in this sheet — column A is destination, column B is source; if the source profile ID in column B returns a 404 (already deleted or invalid), write "NOT FOUND" in column C and continue to the next row
The profile IDs are not in the sheet — you only have emails, and need to look up IDs first
For each row in this sheet, 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 profile IDs into columns C and D and the merge status into column E
Full deduplication workflow with summary
Process all 80 merge pairs in the "Duplicates" sheet (column A = destination ID, column B = source ID), write "MERGED", "NOT FOUND", or "FAILED" plus any error into column C, then output a summary at the bottom: total merged, total not found, total failed, and timestamp of the run
The duplicate backlog clears in one session instead of an afternoon of clicking.
Try It
Get the 7-day free trial of SheetXAI and open the duplicate profile tracking sheet from your last data audit, then ask it to submit all 80 merge requests to Klaviyo in sequence. Also see how to bulk update profiles with RFM scores once your audience data is clean.