The Scenario
The SDR team lead walked into your desk at 11 AM and asked for a list of 200 VP-level contacts at US fintech companies with 50 to 500 employees by 3 PM. They need name, title, company, work email, and LinkedIn for each person — something they can drop straight into the sequence tool. You have PDL access. You do not have time to write an Elasticsearch DSL query from scratch, run it against the API, parse the response, and format it into a sheet in four hours.
The bad version:
- Open PDL's API reference docs and spend 45 minutes figuring out the query syntax for filtering by seniority level, industry, and employee count simultaneously
- Get the query wrong on the first two runs — the first returns companies with 50 to 500 employees globally rather than US-only, the second includes Manager-level contacts alongside VPs because the seniority filter wasn't exclusive enough
- Finally get a working query at 2:30 PM, paste the JSON response into a text editor, manually extract the fields you need, and format them into the sheet with 20 minutes to spare
You did four hours of technical work to produce something that should have taken five minutes to describe.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your ask, builds the PDL person search query for you, runs it, and writes the results directly into the sheet.
Search People Data Labs for VP-level people at US fintech companies with 50 to 500 employees, return 200 results, and write each person's name, title, company, work email, and LinkedIn URL into this sheet.
What You Get
- 200 rows written into the sheet, each with name in column A, title in column B, company in column C, work email in column D, and LinkedIn URL in column E
- Results filtered to US-based contacts only, VP or above seniority, at companies PDL classifies as fintech with 50 to 500 employees
- A note in cell A1 showing the query parameters used, so you can tweak them if the count or filters need adjusting
What If the Data Is Not Quite Ready
You want to narrow by sub-industry — payments specifically, not all fintech
Search PDL for VP-level people at US payments companies with 50 to 500 employees, return 200 results, and write name, title, company, work email, and LinkedIn to columns A through E. Note the sub-industry filter used in cell A1.
The initial results include a few companies you're already working — exclude them
Search PDL for VP-level people at US fintech companies with 50 to 500 employees, return 250 results. Then remove any rows where the company name matches a value in the "Existing Accounts" tab column A. Write the remaining results — name, title, company, work email, LinkedIn — into this sheet.
You want seniority ranked so the highest-level contacts are at the top
Search PDL for VP or C-level people at US fintech companies with 50 to 500 employees, return 200 results. Sort results so C-level contacts appear first, then VPs. Write name, title, seniority, company, work email, and LinkedIn to columns A through F.
Pull the list, score by company size, and segment into two routing groups
Search PDL for VP-level people at US fintech companies with 50 to 500 employees, return 200 results. Write name, title, company, work email, and LinkedIn to columns A through E. Add a column F routing label: "AE-1" for contacts at companies with 200 or more employees, "AE-2" for smaller.
One prompt builds the prospect list and the routing split — no second pass required.
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet or any existing prospect sheet. Describe your ICP to SheetXAI and ask it to pull matching contacts from PDL directly into the sheet. Then see how to enrich an existing lead list with PDL person enrichment or go back to the People Data Labs overview.