The Scenario
You sourced 150 engineering candidates on LinkedIn last month. The Lever opportunity records exist — they were created during the initial outreach batch. What's missing is the LinkedIn URL on each profile. You have the opportunity IDs in Column A and the profile URLs in Column B. Without the URLs in Lever, anyone opening those records has no way to find the candidate's actual profile.
The bad version:
- Open the first Lever opportunity, find the links section, click Add Link, paste the LinkedIn URL, set the type to LinkedIn, save
- Go back to the sheet, find row 2, open Lever, search for the opportunity ID
- By row 40 you have the sheet open in one tab and Lever in another and you are losing your place every third entry
150 profiles. One URL each. This should not take three hours.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the opportunity IDs and LinkedIn URLs from your columns and attaches each link to the correct Lever contact record in bulk — logging success or error per row.
Open your sourcing sheet with opportunity IDs in Column A and LinkedIn URLs in Column B and type:
For each Lever opportunity ID in Column A, add the LinkedIn URL from Column B as a contact link — write 'added' or the error into Column C. 150 rows
What You Get
- The LinkedIn URL from Column B attached to the Lever contact for each corresponding opportunity ID in Column A
- 'added' written into Column C for each successful attachment
- The exact error (opportunity not found, invalid URL format, link already exists) written into Column C for failures
- Failed rows do not block the rest of the batch
What If the Data Is Not Quite Ready
Some LinkedIn URLs are missing the protocol prefix
Before attaching any links, check Column B for URLs that don't start with 'https://' — prepend it if missing, then add the link to Lever and write 'added' or the error into Column C
Some opportunity IDs already have a LinkedIn link and should be skipped
For each opportunity ID in Column A, check whether a LinkedIn link already exists in Lever before adding the one in Column B. Write 'already present' if it was there, 'added' if it was just attached, or the error if the call failed — into Column C
You want to add the LinkedIn URL and set source attribution in the same pass
For each opportunity ID in Column A, add the LinkedIn URL from Column B as a contact link in Lever and also set the source attribution to 'LinkedIn Outbound'. Write 'done' into Column C if both succeed, or the error if either fails
Attach URLs, log results, and flag rows that need manual follow-up
For each opportunity ID in Column A, attach the LinkedIn URL from Column B in Lever — write 'added' or the error into Column C. Then, starting in column E, list all rows where Column C is not 'added' with the opportunity ID and error so a recruiter can follow up manually
One prompt adds the links and delivers a clean exception report.
Try It
Get the 7-day free trial of SheetXAI and open your sourcing sheet with Lever opportunity IDs and LinkedIn profile URLs, then ask it to attach all 150 links in one pass. See also the spoke on bulk-creating Lever opportunities or return to the Lever integration overview.