The Scenario
You sourced 120 engineering profiles on LinkedIn last week. Names, emails, and the posting ID they're matched to — all sitting in a Google Sheet. The hiring manager wants them in Lever by tomorrow morning so the team can start reviewing. Creating them one by one through the Lever UI means 120 separate form fills.
The bad version:
- Open Lever, click New Opportunity, paste the candidate name, paste the email, select the posting from a dropdown, set the source, click save
- Repeat 119 more times
- Come back the next morning to find that 14 emails already existed in Lever and created duplicates instead of deduplicating
You sourced these candidates. You are not supposed to be a data entry operator.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your sourcing sheet row by row and creates Lever opportunities in bulk — handling deduplication where Lever supports it and writing back the returned opportunity ID so you have a permanent record.
Open your sourcing sheet and type:
Create a Lever opportunity for each row in this sheet — Column A is candidate name, Column B is email, Column C is the posting ID — and write the returned opportunity ID into Column D. Log any errors in Column E
What You Get
- A Lever opportunity created for every row where the API call succeeds
- The returned opportunity ID written into Column D for each successful creation
- Any error message (duplicate detected, invalid posting ID, etc.) written into Column E
- Rows that error do not block the rest of the batch
What If the Data Is Not Quite Ready
The posting ID is in a single cell, not per-row
Create a Lever opportunity for each row in columns A and B — Column A is name, Column B is email — and link all of them to the posting ID in cell E1. Set source to 'LinkedIn Outbound' and write the opportunity ID into Column C
You only want to create for a subset of rows
For rows in this sheet where Column D says 'Approved', create a Lever opportunity using name from Column A and email from Column B — write the returned opportunity ID into Column E and log errors in Column F
Some emails are formatted incorrectly
Before creating any Lever opportunities, check Column B for emails that don't contain '@' and write 'invalid email' into Column E for those rows. Then create opportunities for all remaining rows and write the returned IDs into Column D
You want to create, tag, and log in one shot
Create a Lever opportunity for each row in this sheet using name in Column A and email in Column B linked to posting ID in Column C. Set source to 'LinkedIn Outbound' for all. Then add the tag 'Spring-2026-Eng' to each newly created opportunity. Write the opportunity ID into Column D and the tag result into Column E
Running creation and tagging in one prompt means no second pass through the sheet.
Try It
Get the 7-day free trial of SheetXAI and open your sourcing sheet, then ask it to create Lever opportunities for however many candidates you have — with whatever source tag and posting ID your team uses. See also the spoke on bulk-tagging Lever opportunities or go back to the Lever integration overview.