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 spreadsheet 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 sheet 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 sheet.
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 Google Sheet. It reads your cleanup list, calls the Userlist API to delete each company record, and writes the result back to the sheet — so you have a record of what was cleared and what failed.
Open the cleanup spreadsheet and paste this into the SheetXAI sidebar:
Delete every Userlist company whose identifier appears in column A of my "Churn Cleanup" sheet, and mark column B "deleted" or "error" for each row.
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 sheet
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" sheet, 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 sheet has the churn date, but some rows have blank churn dates — those should be skipped, not deleted.
For each row in the "Churn Cleanup" sheet 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 sheet has company names in column A and actual Userlist company identifiers in a separate "Identifiers" tab (company_name in column A, company_identifier in column B).
Look up each company name in column A of the "Churn Cleanup" sheet against the "Identifiers" tab to find the corresponding company_identifier, then delete each matching company from Userlist. Write "deleted" or "error" in column B of the Churn Cleanup sheet.
Full cleanup pass — dedup, filter, cross-reference, and delete
The sheet has duplicates, some blank churn dates that should be skipped, and identifiers that need to be looked up from a second tab.
In the "Churn Cleanup" sheet: 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" tab 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 sheet records what happened.
Try It
Get the 7-day free trial of SheetXAI and open the spreadsheet 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.