The Scenario
Your cold outreach push goes out Friday. It is Wednesday morning and the workbook has 80 rows: company names in column A, LinkedIn URLs in column B, and nothing in columns C and D where the work emails and direct dials should be.
The list came from your marketing team. They did the targeting work. The LeadIQ lookup is yours.
The bad version:
- Open LeadIQ in a browser tab, paste the LinkedIn URL from B2, find the contact, click through to the profile, copy the email into C2, copy the phone into D2.
- Move to B3. Repeat. Hit a URL that's stale halfway through and spend four minutes figuring out why no record matches.
- Reach row 40 and realize you've been skipping the phone lookup on ambiguous matches to save time, which means column D is already half empty.
You've got seventy-two hours and a workbook filling in slower than expected. Every minute spent in LeadIQ's UI is a minute not spent on the actual outreach.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent built into your Excel workbook. It reads the worksheet, understands the columns, and through its LeadIQ integration it can run the lookups and write the results in one pass — without you touching a browser tab for each row.
Search LeadIQ for the person matching each name and company in columns A and B of my Excel sheet and fill in their work email and job title in columns C and D
What You Get
- Column C fills with verified work emails, one per row, matched to the contact in that row.
- Column D fills with direct dials where LeadIQ has them; cells that come back empty are left blank rather than filled with guesses.
- Any rows where LeadIQ returns no match are flagged in column E so you know which ones need a manual follow-up.
- The rest of the workbook stays untouched.
What If the Data Is Not Quite Ready
The LinkedIn URLs have inconsistent formats — some are full URLs, some are just the handle
Normalize all values in column B to full LinkedIn profile URLs (https://linkedin.com/in/handle format), then search LeadIQ for each one and write the work email and direct phone into columns C and D
Some rows have names and companies instead of LinkedIn URLs
For rows in column B that contain a LinkedIn URL, use that for the LeadIQ search. For rows where column B is empty, use the name in column A and company in column E to find the contact and write email and phone into columns C and D
The worksheet has duplicate LinkedIn URLs across rows
Before running LeadIQ lookups, identify any duplicate values in column B and mark them in column F with "duplicate." Then for unique rows only, search LeadIQ and fill in columns C and D. Skip the duplicates to avoid redundant API calls.
Clean up formatting inconsistencies, deduplicate, and enrich in one shot
Remove any trailing slashes from LinkedIn URLs in column B, flag duplicates in column F, then for each unique row search LeadIQ for the work email and direct phone number and write results into columns C and D — note any rows where LeadIQ returns no match in column G
One prompt handles the cleanup and the enrichment together, so the workbook you hand off is complete rather than something someone else needs to scrub.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with a prospect list and a column of LinkedIn URLs — then ask it to enrich the list with emails and direct dials from LeadIQ. When you're done, see how the same workflow works for enriching accounts with firmographic data or check the LeadIQ overview for the full list of things you can do.