The Scenario
Your outbound team is launching into a new vertical next quarter. The team lead asked you to build a starting account list: 200 healthcare technology companies in Germany with more than 50 employees. You have PDL access, a blank Excel workbook, and no existing list to start from. The kickoff call is next Monday and you're supposed to walk in with something.
The bad version:
- Read through PDL's company search documentation, try to write the right filter combination for country, industry, and employee range in Elasticsearch DSL
- Run the query, realize the industry filter returned general healthcare companies rather than healthcare technology specifically, spend another hour refining the industry terms
- Get a working result, export the JSON, parse the company name, website, employee count, and HQ city fields into a format you can paste into Excel
You spent a morning doing technical query work to produce a list of companies. The list is the deliverable. The query work was just the tax.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your targeting description, builds the PDL company search query, runs it, and writes the results directly into the workbook.
Use PDL company search to find 200 healthcare technology companies in Germany with more than 50 employees and populate my Excel ICP Accounts sheet with company name, website, employee count, industry, and HQ city.
What You Get
- 200 rows written into the ICP Accounts sheet with company name, website, employee count, industry, and HQ city columns populated
- Results filtered to Germany-based companies PDL classifies as healthcare technology with more than 50 employees
- The query parameters noted at the top of the sheet so you can adjust the ICP and re-run without starting over
What If the Data Is Not Quite Ready
You want to split the list by city for regional SDR assignment
Search PDL for 200 healthcare technology companies in Germany with more than 50 employees. Write company name, website, employee count, industry, and HQ city to the ICP Accounts sheet. Add a Region column: "Berlin" for companies in Berlin, "Munich" for Munich, "Hamburg" for Hamburg, "Other" for everything else.
The team wants to prioritize companies with known tech stacks relevant to your product
Search PDL for 200 healthcare technology companies in Germany with more than 50 employees. Write company name, website, employee count, and HQ city to the ICP Accounts sheet. Check PDL tech stack data for each company and flag any that use relevant health data or API technologies in a Tech Signal column.
You need to exclude companies already in the CRM before presenting the list
Search PDL for 250 healthcare technology companies in Germany with more than 50 employees. Remove any row where the website domain matches a value in the Existing Accounts tab. Write the remaining company name, website, employee count, industry, and HQ city to the ICP Accounts sheet.
Build the account list, add tier labels, and assign to reps by region in one pass
Search PDL for 200 healthcare technology companies in Germany with more than 50 employees. Write company name, website, employee count, industry, and HQ city to the ICP Accounts sheet. Add a Tier column — "Tier 1" for over 200 employees, "Tier 2" for 50 to 200. Add a Rep Assignment column based on HQ city: "AE-Berlin" for Berlin, "AE-South" for Munich and Frankfurt, "AE-North" for Hamburg and other northern cities.
One prompt builds the list, applies the tier model, and assigns accounts to reps — you walk into Monday's kickoff with a distribution-ready spreadsheet.
Try It
Get the 7-day free trial of SheetXAI and open a blank Excel workbook. Describe your ICP — industry, geography, company size — and ask SheetXAI to pull matching companies from PDL and write them in. Then see how to enrich those accounts with additional firmographics or go back to the People Data Labs overview.