The Scenario
Annual headcount planning wrapped up last month. Finance approved 12 positions. HR has an Excel workbook with job title in column A, department in column B, location in column C, and a full job description in column D. None of them exist in Recruitee yet.
The request came in this morning: get them created as draft job offers so the recruiting team can start writing JDs and getting approvals before the roles go live.
The bad version:
- Open Recruitee, click New Job Offer, type the title, select the department from a dropdown, set the location, paste the description, save. Repeat 12 times.
- Realize halfway through that Recruitee's department list doesn't exactly match the names in the workbook, so you're guessing which one Finance means.
- Finish creating the 12 offers and realize you now need to go log the offer IDs back into the workbook for the HR system of record.
Twelve is manageable. Next quarter it's 28. And whoever is doing this would rather be doing literally anything else that requires their judgment.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads each row, creates a Recruitee draft job offer using the title, department, and description from the workbook, and writes the returned offer ID back into column E — all in one pass.
For each row in my workbook, create a Recruitee draft job offer using the job title from column A, department from column B, and job description from column D — then write the returned offer ID into column E
What You Get
- One draft job offer created in Recruitee per row in the workbook.
- The offer ID written into column E for each row as a confirmation and reference.
- Rows that fail — department name not matching a Recruitee department, missing title — flagged in column E with the error message.
- All 12 offers ready in Recruitee for recruiters to add pipeline stages, scorecards, and team assignments.
What If the Data Is Not Quite Ready
Department names in the workbook don't match Recruitee's department list exactly
Before creating each Recruitee draft job offer, check the department in column B and map People Ops to HR, GTM to Sales, and Eng to Engineering — then create the offer using the mapped department name and write the offer ID into column E
Some descriptions are too short to be useful — flag them before creating
For each row in my workbook, check if the job description in column D is shorter than 200 characters. If it is, write Description too short into column E and skip that row. For all other rows, create a Recruitee draft job offer with the title from column A and description from column D and write the offer ID into column E.
You need to create offers and then immediately assign them to a recruiter
For each row in my workbook, create a Recruitee draft job offer using title from column A, department from column B, and description from column D — then assign the offer to the recruiter whose email is in column C and write the offer ID into column E
Full headcount workbook creation with error logging and summary
Create Recruitee draft job offers for all rows in my workbook using title from column A, department from column B, and job description from column D. Write the offer ID into column E for successes and the error message for failures. Then in cell G1 write a summary: X offers created, Y failed.
One prompt handles the bulk creation and the summary — no need to run them as separate steps.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook where your approved headcount lives, then ask it to create all the draft offers in Recruitee at once. You can also explore how to pull a pipeline snapshot of all open roles or bulk-tag candidates once they start applying.