The Scenario
A university career fair just wrapped. Your sourcing team collected 120 candidate profiles over two days. All the Recruitee IDs are already in column A of an Excel sheet — the profiles were created during the fair using a mobile form. What's missing is the tag: every one of these candidates should be labeled CampusHire-2026 so the team can filter them as a cohort for internship pipeline reviews later in the year.
The bad version:
- Open Recruitee, search for the first candidate ID, open the profile, click Edit, find the Tags field, type CampusHire-2026, save.
- Repeat 120 times across two days of fair traffic.
- Realize at row 60 that some profiles were already tagged from a previous event and you've now added a duplicate.
Tagging 120 candidates by hand is the kind of task that doesn't require a person — it requires a person willing to do something a person shouldn't have to do.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your spreadsheet and connects to Recruitee natively. It reads each candidate ID from column A, calls the Recruitee update candidate endpoint for each one, adds the specified tag, and writes the result back.
For each candidate ID in column A of my sheet, update the Recruitee candidate record to add the tag CampusHire-2026 and write Done into column B when the update succeeds
What You Get
- The tag CampusHire-2026 added to each Recruitee candidate profile whose ID is in column A.
- Column B updated with Done for every successful update.
- Column B updated with the error message for any ID that fails — not found, API timeout, or invalid format.
- All 120 profiles tagged without opening Recruitee once.
What If the Data Is Not Quite Ready
The tag to apply varies by row — some candidates get a different cohort label
For each row in my sheet, update the Recruitee candidate ID in column A to add the tag from column B — use whatever value is in column B as the tag string — and write Done into column C when the update succeeds
Some IDs in column A are blank or malformed — skip those rows
For each row in my sheet where column A contains a numeric Recruitee candidate ID, add the tag CampusHire-2026 to that candidate and write Done into column B. For rows where column A is blank or non-numeric, write Skipped - invalid ID into column B.
You need to add two tags at once — the cohort label and the source event
For each candidate ID in column A, update the Recruitee candidate to add both the tag CampusHire-2026 and the tag CareerFair-Spring — then write Done into column B on success
Full dedup check plus tagging in one shot
Check column A for duplicate candidate IDs and flag any duplicates in column C as Duplicate - skipped. For each unique ID in column A, add the tag CampusHire-2026 to the Recruitee candidate and write Done into column B. At the end, write a count of successful tags into cell D1.
Run the dedup check and the tagging in one prompt rather than cleaning the sheet first and then running a second pass.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook where your career fair candidate IDs live, then ask it to tag all of them in Recruitee at once. You can also look at how to bulk-import new candidates into Recruitee or export candidate notes for a compliance review.