The Scenario
Someone on the growth team sent a Slack message at 9 AM: "Hey, can you clean up the Userlist company records before the next campaign run? We've got test accounts and churned companies polluting the segments."
You open Userlist's dashboard and realize there's no bulk delete. You'd have to find each company by identifier, click into it, click delete, confirm. Thirty-five times.
You have a cleanup Excel workbook already. Column A has the company identifiers. It's been sitting there since Tuesday because nobody wanted to spend an hour clicking through a dashboard.
The bad version:
- Open Userlist, search for the first company identifier in column A, click into the record, click "Delete company," confirm.
- Do that 34 more times, occasionally losing your search result because you tabbed back to the workbook and the session timed out.
- Finish 20 records, get pulled into a standup, come back 40 minutes later and have no idea where you left off in the worksheet.
The campaign run is scheduled for tomorrow. You were supposed to clear this backlog two days ago. The cognitive overhead of keeping your place in two windows simultaneously is more exhausting than the actual work.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your cleanup list, calls the Userlist API to delete each company record, and writes the result back to the workbook — so you have a record of what was cleared and what failed.
Open the cleanup workbook and paste this into the SheetXAI sidebar:
Remove all companies listed in column A of my "Churn Cleanup" sheet from Userlist in one pass, recording the deletion status — "deleted" or "error" — in column B.
What You Get
- Column B fills with "deleted" for every company successfully removed from Userlist.
- Rows where the identifier wasn't found, or where the delete call failed, get "error" in column B — with the Userlist error message in column C if you ask for it.
- You end up with a timestamped record of what was purged, which is useful if anyone asks why a particular company stopped appearing in campaign segments.
- All 35 rows run in one pass. No dashboard tab-switching, no losing your place, no session timeouts.
What If the Data Is Not Quite Ready
Some identifiers might be duplicated in the workbook
The cleanup list was assembled from two different exports and might have the same company identifier listed twice.
Delete every Userlist company whose identifier appears in column A of the "Churn Cleanup" worksheet, deduplicating on column A so each identifier is only deleted once. Write "deleted", "duplicate-skipped", or "error" in column B.
You need to confirm a company is churned before deleting it
Column B in your workbook has the churn date, but some rows have blank churn dates — those should be skipped, not deleted.
For each row in the "Churn Cleanup" worksheet where column B contains a date, delete the corresponding Userlist company using the identifier in column A. Skip rows where column B is blank. Write "deleted", "skipped", or "error" in column C.
The identifiers are mixed with company names — you need to cross-reference
Your cleanup workbook has company names in column A and actual Userlist company identifiers in a separate "Identifiers" worksheet (company_name in column A, company_identifier in column B).
Look up each company name in column A of the "Churn Cleanup" worksheet against the "Identifiers" worksheet to find the corresponding company_identifier, then delete each matching company from Userlist. Write "deleted" or "error" in column B of the Churn Cleanup worksheet.
Full cleanup pass — dedup, filter, cross-reference, and delete
The workbook has duplicates, some blank churn dates that should be skipped, and identifiers that need to be looked up from a second worksheet.
In the "Churn Cleanup" worksheet: skip any row where column B (churn date) is blank. Deduplicate on company name so each is only processed once. Look up the company_identifier from the "Identifiers" worksheet using the company name in column A. Then delete each matching company from Userlist and write "deleted", "skipped", or "error" in column C.
One prompt handles the logic; the workbook records what happened.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook with your Userlist company identifiers marked for removal, then tell SheetXAI to run the purge and log the results. To see how SheetXAI handles relationship creation in the other direction, check the bulk push spoke or the Userlist overview.