The Scenario
You just inherited an Excel workbook from a colleague who left the company. It has 200 rows — name, email, and empty columns for job title, company, and LinkedIn. The sequence tool needs all three fields populated before the list can go live. The handoff note just says "needs enrichment."
The bad version:
- Copy batches of emails into the PDL API console, run the lookup, manually paste the returned fields into the right Excel columns
- Paste a company name into the wrong row at row 55 and not catch it until row 120 because the scrolling made you lose your place
- Deliver a sheet where 30 rows are enriched with the wrong data and have to spend another hour correcting the misalignment before anyone can use it
There is a version of this that doesn't require you to babysit a copy-paste loop for three hours. You just haven't had access to it until now.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the data already in the workbook and uses its built-in People Data Labs integration to enrich your rows and write the results back.
For every row in my Excel Leads table, enrich the person using their email address in column B via People Data Labs and populate the Job Title, Company, and LinkedIn columns.
What You Get
- The Job Title column populated with each person's current title from PDL
- The Company column populated with the canonical company name from PDL's record
- The LinkedIn column populated with the person's LinkedIn profile URL
- Rows where PDL finds no confident match flagged with "Not found" so you know which contacts need manual review before CRM import
What If the Data Is Not Quite Ready
The email column has a mix of personal and business addresses
Enrich each row via PDL using the email in column B. If the match confidence is below 0.8, leave the enrichment columns blank and add a low-confidence flag in the Notes column so the team can follow up.
Some rows have name and company but no email
For rows where column B is empty, attempt PDL enrichment using first name in column C and company in column D. Write work email, title, and LinkedIn to the corresponding columns for any rows that resolve.
You want to deduplicate emails before enriching to avoid wasting credits
Identify duplicate email values in column B and mark them in a Duplicate column. Then enrich only the first occurrence of each unique email via PDL and copy the enriched values to all matching rows.
Enrich, flag seniority, and mark high-priority leads in one pass
Enrich each row using the email in column B via PDL. Populate Job Title, Company, and LinkedIn columns. Then add a Priority column: mark any row where PDL's seniority is VP or above as "High" and all others as "Standard."
One prompt handles the enrichment and the prioritization — the sequence tool gets a ready-to-import file without a separate scoring pass.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with a column of lead emails. Ask it to enrich each row with job title and company from PDL and write the results back. Then see how to deduplicate a merged contact list with PDL identity resolution or go back to the People Data Labs overview.