The Scenario
Your deduplication script finished running last night. It flagged 30 pairs of duplicate Simla customer records — source ID and target ID, one row per pair — and wrote them into a Google Sheet. Each pair needs to be merged in Simla: the source record gets absorbed into the target, the target record keeps the order history. It's your job to execute the merges before tomorrow's data quality review.
This is the kind of task where doing it by hand is just a waiting game. Thirty merges, each requiring you to navigate to a customer record in Simla, find the merge option, select the target, and confirm. It's not hard. It just takes an hour you don't have.
The bad version:
- Open Simla's customer record for the source ID in row 1, find the merge/combine option, search for the target ID, confirm the merge.
- Repeat for row 2. Then row 3. Then realize at row 15 that the merge UI requires you to search for the target customer by name — not by ID — and some target names are too generic to find quickly.
- Finish all 30 in an hour. Wonder if any of them silently failed.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside Google Sheets. It reads your duplicate pairs sheet and calls Simla's customer merge API for each row — writing a merge status into a result column so you have a complete audit log.
For each row in this sheet, merge the Simla customer in column A (duplicate) into the customer in column B (keep) — process all 30 pairs.
What You Get
- All 30 customer pairs merged in Simla — the source absorbed into the target
- A result written into column C for each row: "Merged" or the error message returned by the API
- A total of successful vs. failed merges in the sidebar summary
- A complete audit log to present at the data quality review
What If the Data Is Not Quite Ready
Some source IDs in the sheet are external IDs, not Simla internal customer IDs
For each row in this sheet, resolve the external customer ID in column A to Simla's internal customer ID, then merge it into the customer with external ID in column B — write the result in column C.
Some pairs appear duplicated in the deduplication script output — same pair listed twice with columns swapped
Remove rows where the pair (column A, column B) already appears in reverse order (column B, column A) elsewhere in the sheet, then process all unique merge pairs.
You want to validate that each source ID still exists before merging
For each row, verify that the customer ID in column A exists in Simla before attempting the merge — flag rows where the source is not found as "SOURCE NOT FOUND" in column C, and process all rows where it does exist.
Validate, deduplicate pairs, and merge in one ask
Remove reverse-duplicate pairs from the sheet, validate that each source customer ID exists in Simla, then merge all valid pairs and write the result — Merged, Source Not Found, or the error — into column C.
One prompt. The data quality review has a clean audit log to look at.
Try It
Get the 7-day free trial of SheetXAI and open your duplicate pairs spreadsheet the next time your deduplication script runs. See Bulk Set External IDs for mapping system identifiers, or the full Simla.com hub for all customer data management workflows.