The Scenario
You are the data manager at a Square merchant with a mid-size customer database. Three weeks ago, a junior team member ran a test import of customer profiles to check the field mapping. That import created 150 duplicate records — test accounts scattered through your customer directory, polluting your customer segments, your loyalty group counts, and your email lists.
You have identified the duplicate customer IDs. They are in column A of a Google Sheet, 150 rows, nothing else. You need them gone.
The manual version:
- Log into Square's Customer Directory
- Search for the first customer ID
- Click into the profile, confirm it is the test duplicate
- Click Delete, confirm
- Go back, search for the next ID
- At 90 seconds per record, that is 225 minutes. You do not have 225 minutes.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet that reads the IDs in column A and deletes each corresponding Square customer profile, writing a result back per row so you have a complete audit log.
Open the SheetXAI sidebar and type:
Delete every Square customer whose ID is listed in column A of this sheet. Write "Deleted" into column B for each successful deletion, or the error message if it failed.
SheetXAI calls Square's bulk delete endpoint, processes all 150 IDs, and writes the result into column B. Rows that deleted successfully show "Deleted." Rows that returned an error show the error message — typically "Customer not found" if an ID was already removed, or a conflict error if the customer has associated orders.
What You Get
A sheet with 150 rows resolved:
- Column B: "Deleted" for every profile that was removed
- Column B: error message for any ID that Square could not delete — customer not found, active order conflict, etc.
- Complete audit trail — you know exactly which records were removed and which were not, and why
The errors are immediately useful. If 6 IDs failed because those customer profiles have pending orders you cannot delete, you have a specific list to review in the Square dashboard rather than guessing.
What If the Data Is Not Quite Ready
Duplicate removal lists have common complications. SheetXAI handles them in the same prompt.
When some IDs in the list are already deleted
A previous partial cleanup removed some of them. You do not know which.
Delete every Square customer whose ID is in column A. Write "Deleted" into column B for successful deletions. If the customer is not found (already deleted), write "Already removed" into column B. If any other error, write the error message.
When you want to preview before deleting
You are not 100% confident the list is correct and want to verify each ID is a test record before deleting it.
For each customer ID in column A, retrieve the Square customer profile and write the customer's name, email, and creation date into columns B, C, and D. Do not delete anything yet.
Then you review, mark confirmed test records with "DELETE" in column E, and run a second prompt:
Delete every Square customer whose ID is in column A where column E says "DELETE." Write the result into column F.
When you need to batch only the IDs that do not have associated orders
You want to skip customers who have transaction history to avoid accidentally removing real customers who were added to the test import list by mistake.
For each customer ID in column A, check whether the customer has any associated Square orders. If they have no orders, delete them and write "Deleted" into column B. If they have orders, skip them and write "Skipped — has orders" into column B.
When you need to delete, verify, and report the final count in one shot
Your manager wants a clean summary of how many were deleted, how many already did not exist, and how many could not be removed.
Delete all Square customers in column A. Write the result per row into column B. Then, below the data, add a summary section showing: total deleted, total already missing, total errors with error types. Use this to confirm the cleanup is complete.
The pattern: the audit log in column B is not just a nicety — it is the proof that the cleanup ran correctly, which your data manager will ask for.
Try It
Get the 7-day free trial of SheetXAI and clean up your Square customer directory from the sheet you already have. The Square integration is included in every SheetXAI plan. For related workflows, see how to bulk-import customers into Square or the Square in Google Sheets overview.