The Scenario
Your growth team returned from a conference with a badge scanner export: 300 contacts, first name, last name, company — no emails, no titles, no LinkedIn. The follow-up email campaign goes out in a week. Someone on the team remembered that PDL has a bulk person endpoint and forwarded the workbook to you with a note saying "can you run this through PDL?" You've opened PDL's documentation. The bulk endpoint takes an array of objects with specific field names. You have never done this before.
The bad version:
- Write a Python script to read the Excel file, structure each row as a PDL bulk request object, call the endpoint, parse the response, and write the results back — four hours in and the response parsing is still throwing key errors because some rows return empty arrays
- Give up on the script and fall back to the individual person endpoint, spending the next two days running 300 separate lookups and pasting results by hand
- Deliver the workbook on Thursday with 80 contacts still missing emails because the manual process ran out of runway
You told the team it would take a day. It took three.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the name and company columns and uses PDL's bulk person enrichment endpoint to resolve each contact in batches of 100, writing work emails and LinkedIn URLs back into the workbook.
For my Excel Tradeshow Leads table, use People Data Labs bulk person enrichment (batches of 100) with first name, last name, and company name columns to populate Work Email, Title, and LinkedIn URL.
What You Get
- Work Email, Title, and LinkedIn URL columns populated for each contact PDL can resolve
- Five bulk API calls instead of 300 individual requests
- Contacts where PDL finds no match flagged in a Status column so the team can decide whether to skip or follow up manually
- A summary row at the top of the table showing total contacts enriched and total unresolved
What If the Data Is Not Quite Ready
Company names have inconsistent formatting — some rows list a subsidiary, some the parent brand
Before enriching, normalize company names in the Company column: strip legal suffixes and standardize common abbreviations. Then run PDL bulk person enrichment in batches of 100 using first name, last name, and normalized company name.
Some rows have a LinkedIn URL but no company — use LinkedIn as the enrichment signal
For rows where the Company column is empty but a LinkedIn URL is present, use that LinkedIn URL as the primary signal for PDL enrichment. For rows with a company name, use first name, last name, and company. Run all contacts through bulk person enrichment in batches of 100.
You want to filter by seniority before sending to the sequence tool
Enrich all contacts in the Tradeshow Leads table via PDL bulk person enrichment in batches of 100. Populate Work Email, Title, and LinkedIn URL columns. Add a Sequence column: "Director Sequence" for Director or above seniority, "IC Sequence" for individual contributors, "Hold" for any row where seniority is unclear.
Enrich, filter out competitors, and segment by industry in one pass
Run PDL bulk person enrichment on the Tradeshow Leads table in batches of 100. Populate Work Email, Title, and LinkedIn URL. Then remove any row where PDL's company industry matches "staffing" or "recruiting." Add an Industry column using PDL's classification for the remaining rows.
One prompt handles the enrichment, the competitor filter, and the industry segmentation — the sequence tool gets a clean, segmented list without three separate operations.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with a column of names and companies from a badge scan or event list. Ask it to enrich using PDL bulk person batching and write work emails back. Then see how to run a person search and import fresh prospects or go back to the People Data Labs overview.