The Scenario
A data privacy officer finished the biennial data retention audit on Wednesday. The result: 90 candidate profiles in Recruitee that are past the two-year retention window and need to be permanently deleted. All 90 IDs are in column A of a Google Sheet. Legal wants confirmation that each deletion happened, with a status next to each ID.
The bad version:
- Open Recruitee, search for the first candidate ID, open the profile, click the delete option, confirm the deletion dialog, go back to the sheet, write Deleted in column B.
- Repeat 90 times.
- Stop at row 47 because the session timed out, log back in, lose track of where you stopped, and accidentally re-check a few you already deleted.
Ninety deletions is not a large number. It's a small number that takes a long time to do by hand and carries real compliance consequences if you miss any or double-log any.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet and connects to Recruitee through its built-in integration. It reads each candidate ID from column A, calls the Recruitee delete endpoint for each one, and writes the outcome — Deleted or the error message — into column B.
Delete all Recruitee candidates whose IDs are listed in column A of my sheet and write Deleted or the error message into column B for each
What You Get
- Each candidate profile in Recruitee permanently removed using the ID from column A.
- Column B updated with Deleted for each successful deletion.
- Column B updated with the specific error message for any ID that fails — not found, already deleted, or API error.
- All 90 deletions attempted in one run with a full audit trail in the sheet.
What If the Data Is Not Quite Ready
Some IDs in column A may already have been deleted in a previous pass — handle gracefully
For each candidate ID in column A, attempt to delete the Recruitee candidate. If the API returns a not found error, write Already deleted into column B. If the deletion succeeds, write Deleted. If any other error occurs, write the error message.
You need to log a deletion timestamp next to each ID
For each candidate ID in column A, delete the Recruitee candidate and write Deleted into column B and the current UTC timestamp into column C — or write the error message into column B and leave column C blank if the deletion fails
The sheet has candidate names in column B and you want to preserve them in the log
For each row in my sheet, use the candidate ID in column A to delete the Recruitee candidate. Move the candidate name from column B into column C as a record, then write Deleted or the error into column D.
Full compliance export before deletion: pull notes first, then delete
For each candidate ID in column A, first fetch all Recruitee notes for that candidate and write them into a log table in Sheet2 with candidate ID, note text, author, and date. Then delete each candidate from Recruitee and write Deleted or the error message into column B of Sheet1.
Pull the notes and delete the profiles in one prompt — no need to run the export and the deletion as separate sessions.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet with your flagged candidate IDs, then ask it to delete all of them from Recruitee and write a status next to each one. For related tasks, see how to export all candidate notes before deletion or bulk-tag candidates for data hygiene review.