The Scenario
Your SDR manager stopped by your desk at 2 PM with a request: 150 Director or above contacts at B2B SaaS companies in the UK with more than 100 employees, by end of day, for a new outbound sequence. You have PDL access. You do not have a ready-made query, and you have never written PDL's Elasticsearch DSL syntax before. The PDL documentation is comprehensive. It is also 40 pages long.
The bad version:
- Spend 90 minutes reading the query builder reference and trying to construct the right filter combination for country, seniority, industry, and employee count
- Run the query and get back 600 results because the seniority filter let in Manager-level contacts — spend another 30 minutes fixing the exclusion logic
- Get a working query, export the JSON, parse the fields you need manually, and paste them into an Excel table with 10 minutes to spare before your manager asks for an update
You said you could do it. You did it. But "by end of day" means your afternoon is gone.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your plain-English targeting description, builds the PDL query for you, runs the search, and writes the results directly into the workbook.
Use PDL person search to find 150 Director or above contacts at B2B SaaS companies in the UK with more than 100 employees, and populate my Excel Prospects sheet with name, title, company, email, and location.
What You Get
- 150 rows written into the Prospects sheet with name, title, company, email, and location columns populated
- Results filtered to Director, VP, and C-level contacts at UK-based B2B SaaS companies with more than 100 employees per PDL's data
- The generated query parameters written into a header cell so you can adjust the filters and re-run without re-describing the whole criteria
What If the Data Is Not Quite Ready
You want to restrict to contacts with a verified work email, not just any email
Search PDL for Director or above contacts at UK B2B SaaS companies with more than 100 employees. Return only contacts where PDL has a work email on record. Write name, title, company, work email, and location to the Prospects sheet, up to 150 results.
The manager wants to exclude competitors from the list
Search PDL for 150 Director or above contacts at UK B2B SaaS companies with more than 100 employees. Remove any row where the company name matches a value in the Competitors tab column A. Write name, title, company, email, and location to the Prospects sheet.
You need company size as a column to support tiered outreach
Search PDL for 150 Director or above contacts at UK B2B SaaS companies with more than 100 employees. Write name, title, company, email, location, and company employee count to the Prospects sheet. Add a Tier column: "Enterprise" for over 500 employees, "Mid-Market" for 100 to 500.
Build the list, remove existing contacts, and add a sequence assignment in one pass
Search PDL for 200 Director or above contacts at UK B2B SaaS companies with more than 100 employees. Remove any row where the email matches a value in the Existing Contacts tab. Write name, title, company, email, and location to the Prospects sheet. Add a Sequence column: "UK-Enterprise" for companies over 500 employees, "UK-Growth" for the rest.
One prompt pulls the list, cleans against your existing contacts, and routes by segment — your manager gets a ready-to-launch sequence, not a raw export to process.
Try It
Get the 7-day free trial of SheetXAI and open a blank Excel workbook or any existing prospect table. Describe your ICP to SheetXAI and ask it to pull matching contacts from PDL into the workbook. Then see how to enrich an existing contact list with job title and company data or go back to the People Data Labs overview.