The Scenario
The headcount plan was approved last Tuesday. Twenty-five new roles, each with a job title, team, hiring manager, and target headcount in an Excel workbook. The HRBP needs all 25 created as Lever requisitions before the recruiting kickoff call tomorrow afternoon. Nobody wants to create them one at a time through the Lever UI.
The bad version:
- Open Lever, go to requisitions, click New Requisition, fill in title, team, hiring manager, headcount, submit
- Go back to the workbook, find the next row, open Lever again, repeat
- Finish all 25 and realize you forgot to set the headcount on four of them because the dropdown was easy to miss
You have a kickoff call in 20 hours and a requisition list that still needs to exist in Lever.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your headcount plan row by row and creates the Lever requisitions in bulk — writing back the returned requisition ID for each one so your workbook becomes the source of truth.
Open your headcount plan workbook and type:
Create a Lever requisition for each row in this workbook using the job title in Column A, team in Column B, and headcount in Column C — write the returned requisition ID into Column D. Log any errors in Column E
What You Get
- A Lever requisition created for every row where the API call succeeds
- The returned requisition ID written into Column D for each successful creation
- Error messages written into Column E for any row that fails
- Failed rows do not interrupt the rest of the batch
What If the Data Is Not Quite Ready
Only create for approved rows
For every row marked 'Approved' in Column E, create a new Lever requisition with the title from Column A and target headcount from Column C — log the requisition ID in Column F and errors in Column G
The team name doesn't match Lever's team list
For each row in this workbook, before creating the requisition, check whether the team name in Column B exists in Lever. If it doesn't match exactly, write 'team not found' in Column E and skip that row. For matching rows, create the requisition and write the ID into Column D
You need to set a hiring manager per requisition
Create a Lever requisition for each row in this workbook using title from Column A, team from Column B, headcount from Column C, and set the hiring manager to the user email in Column D — write the requisition ID into Column E
Create, log IDs, and send a summary count in one shot
Create a Lever requisition for each row in this workbook using title in Column A, team in Column B, and headcount in Column C. Write the returned ID into Column D. Then count how many succeeded and how many failed and write those two numbers into cells F1 and F2
Knowing the success and failure counts immediately tells you whether the kickoff call list is complete.
Try It
Get the 7-day free trial of SheetXAI and open your headcount plan workbook, then ask it to create Lever requisitions for all your approved roles in one pass. See also the spoke on exporting open requisitions or return to the Lever integration overview.