The Scenario
Twelve new recruiting coordinators are joining next Monday. Their names, emails, and assigned access roles are all in a Google Sheet — someone from HR collected them during onboarding paperwork. The Lever admin needs their accounts created before the team's first Lever training on Tuesday. Twelve form fills. One admin. A weekend in between.
The bad version:
- Log into Lever as an admin, go to Users, click Invite User
- Type the name, paste the email, select the access role from a dropdown, click Invite
- Repeat 11 more times
- Come back Tuesday to find that two of the emails had typos and neither got the invite
You have better things to do with a Monday morning than create user accounts one at a time.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the onboarding sheet and creates Lever user accounts in bulk — writing back confirmation or error for each row.
Open your onboarding sheet and type:
Create a new Lever user for each row in this sheet using the name in Column A, email in Column B, and access role in Column C — write 'created' or the error into Column D. 12 rows total
What You Get
- A Lever user account created for every row where the API call succeeds
- 'created' written into Column D for each success
- The exact error (invalid email format, role name not recognized, account already exists) written into Column D for failures
- Rows that error do not block the remaining creations
What If the Data Is Not Quite Ready
All 12 should get the same default role
Add every row in this sheet as a new Lever user with the role 'interviewer' — write the returned user ID into Column E and any errors into Column D. 12 rows
Some emails have formatting issues from the paste
Before creating any Lever users, check Column B for emails that don't contain '@' and write 'invalid email' in Column D for those rows. Then create accounts for all remaining rows using name from Column A and role from Column C — write 'created' or the error into Column D
The HR system uses a different role name than Lever expects
For each row in this sheet, map the role in Column C as follows: 'Recruiter' stays 'recruiter', 'Coordinator' becomes 'limited', 'Manager' becomes 'admin'. Create the Lever user with the mapped role and write the result into Column D
Create users, log IDs, and send an onboarding note in one pass
Create a Lever user for each row in this sheet using name in Column A, email in Column B, and role in Column C. Write the returned user ID into Column D. Then for each successfully created user, add a Lever note to their profile saying 'Onboarded 2026-05-15 — Recruiting Coordinator cohort'
Starting onboarding documentation at account creation time means nothing falls through on Tuesday.
Try It
Get the 7-day free trial of SheetXAI and open your onboarding intake sheet, then ask it to create Lever accounts for your next cohort in one pass. See also the spoke on exporting Lever users for an access audit or return to the Lever integration overview.