The Scenario
Your growth team scanned 300 badges at a tradeshow last week. The sheet that came back has first name, last name, and company — no emails, no titles, no LinkedIn. The campaign sequence goes out next Thursday and it needs work emails at minimum. Someone flagged the sheet in Slack asking if you can "just run this through PDL." You've used PDL before but never the bulk person endpoint, and the individual endpoint on 300 rows is going to be expensive.
The bad version:
- Look up each person one at a time in the PDL API console using first name, last name, and company — copy the work email and LinkedIn URL back into the sheet by hand
- Find at row 30 that "John Smith at Acme" matches 8 profiles in PDL and you have no way to disambiguate from the sidebar
- Give up on the hard-to-match rows, deliver a half-enriched sheet, and spend the following week explaining why 80 contacts are still missing emails
The enrichment itself is not the hard part. The hard part is doing it in a way that doesn't cost you a full day per campaign cycle.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the contact data already in the sheet and uses PDL's bulk person endpoint to resolve names and companies to full profiles — batched at 100 per call so you're not burning credits on individual lookups.
Enrich all contacts in this sheet using PDL bulk person enrichment in batches of 100: use first name in column A, last name in column B, and company in column C — write the work email and LinkedIn URL to columns D and E.
What You Get
- PDL's bulk endpoint called in batches of 100, not 300 individual requests
- Column D populated with work email for each matched person
- Column E populated with their LinkedIn profile URL
- Rows where PDL finds no confident match flagged in column F so your team can decide whether to skip or enrich manually
What If the Data Is Not Quite Ready
Some rows have company website instead of company name
For rows where column C has a website domain instead of a company name, use that domain as the company signal in the PDL lookup. For rows with a company name, use the name. Run all contacts through PDL bulk person enrichment in batches of 100 and write work email, title, and LinkedIn to columns D, E, and F.
Names are inconsistently formatted — some all-caps, some with middle names
Before enriching, normalize the names: trim whitespace from columns A and B, strip middle initials, and convert all-caps names to title case. Then run PDL bulk person enrichment in batches of 100 using normalized first name, last name, and company.
You want to prioritize rows where PDL confidence is high enough to email
Enrich all contacts via PDL bulk person enrichment in batches of 100. Write work email to column D and confidence score to column E. Flag rows with confidence above 0.85 in column F as "Ready for sequence" and the rest as "Hold for review."
Enrich, filter by seniority, and segment by company size in one shot
Enrich all contacts via PDL bulk person enrichment in batches of 100 — write work email, title, and LinkedIn to columns D, E, and F. Then flag contacts whose PDL seniority is Director or above in column G as "High priority." Cross-reference company employee count from PDL and flag companies over 200 employees in column H as "Mid-market or above."
One prompt replaces three separate data passes — enrichment, seniority filter, and company-size segmentation all land at once.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with a column of names and companies from an event or badge scan. 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.