The Scenario
You exported a list of 150 LinkedIn profiles from Sales Navigator into an Excel workbook last Tuesday. Profile URLs, one per row. Your recruiting coordinator asked you to have verified emails and direct phone numbers ready before the InMail sequence starts — and that starts Monday.
It is Thursday afternoon.
The bad version:
- Open each LinkedIn URL in a new tab, find the profile, go to RocketReach and paste the URL in the search bar, wait for the result, copy the email and phone separately, switch back to Excel, find the row again, paste each into the right column.
- Row 25: the profile page has changed since the export. The URL now redirects. You skip it and plan to come back.
- Row 50: RocketReach finds a verified email but no phone. You leave the phone column blank and keep moving, knowing someone will eventually ask why 30 rows have missing phone data.
Sourcing candidates is the work. Manually bridging a LinkedIn export into a contact enrichment tool row by row is the kind of task that makes experienced recruiters start updating their own resumes.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your LinkedIn URLs and talks to RocketReach directly — no tab-switching, no manual copy-paste. Open the SheetXAI sidebar and try it:
Here is the prompt for this task:
Take the 150 LinkedIn URLs in my 'Recruiting Pipeline' sheet (column A) and enrich each row with the RocketReach verified email (column B) and phone (column C)
What You Get
- Column B fills with the verified primary work email for each profile RocketReach matched.
- Column C fills with the direct phone number where available.
- Rows where no phone was found are left blank — not silently skipped, just clearly empty.
- Rows where the LinkedIn URL returned no RocketReach match are flagged so you can route them to manual follow-up.
What If the Data Is Not Quite Ready
Some LinkedIn URLs are malformed or shortened
For each URL in column A, check if it follows standard LinkedIn profile URL format — if it is malformed or uses a short link, flag it in column D as "Bad URL" before attempting the RocketReach lookup; for valid URLs, write email to column B and phone to column C
You want to filter before enriching to save API calls
Only enrich rows where column B is currently blank — for those rows, use the LinkedIn URL in column A to look up the profile in RocketReach and write the verified email to column B and phone to column C
The sheet mixes LinkedIn company and personal profile URLs
Check each URL in column A — skip any that are company page URLs rather than personal profile URLs, flag those in column D as "Company Page", and only look up personal profiles in RocketReach — write email to column B, phone to column C
Enrich, check domain match, and score outreach readiness in one pass
For each LinkedIn URL in column A, look up the profile in RocketReach — write the verified email to column B and phone to column C — then check if the email domain matches any company domain in column E, and write "Ready" to column D if both email and phone were found, "Partial" if only one was found, and "Missing" if neither was
One prompt handles the enrichment, the validation, and the readiness score together.
Try It
Open your Excel workbook with LinkedIn profile URLs and Get the 7-day free trial of SheetXAI — ask it to look up each profile in RocketReach and populate emails and phone numbers across all 150 rows. You can also see the related spoke on bulk email enrichment from name and company or the hub overview for all RocketReach connection methods.