The Scenario
Your outbound team just kicked off a new product launch and the SDR team lead needs a starting account list by tomorrow morning. The ICP is US e-commerce companies with 20 to 200 employees, founded after 2015. Nobody has built this list yet. The team currently prospects from a manually maintained spreadsheet of accounts that hasn't been touched in eight months. You have PDL access and a blank sheet.
The bad version:
- Spend an hour reading PDL's company search documentation and writing an Elasticsearch DSL query with the right filters for country, industry, employee range, and founding year
- Run the query, get back 300 company records as JSON, figure out how to parse and flatten the fields you need — name, website, employee count, LinkedIn URL — into a format you can paste into a sheet
- Discover that the JSON response nests the website under a "profiles" array and spend another 30 minutes writing a parsing script before you can even get the data into a column
You are supposed to be setting the outbound strategy, not learning JSON parsing at midnight.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your targeting criteria and uses its built-in PDL company search to pull matching accounts directly into the sheet.
Search People Data Labs for US e-commerce companies with 20 to 200 employees founded after 2015, return 300 results, and write each company's name, website, employee count, and LinkedIn URL into this sheet.
What You Get
- 300 rows written into the sheet with company name in column A, website in column B, employee count in column C, and LinkedIn URL in column D
- Results filtered to US-based companies PDL classifies as e-commerce, with founding year after 2015 and employee count within your range
- A note at the top of the sheet showing the search parameters used so you can adjust the ICP filters and re-run without re-typing the whole prompt
What If the Data Is Not Quite Ready
You want to split the list by employee band before handing off to SDRs
Search PDL for US e-commerce companies with 20 to 200 employees founded after 2015, return 300 results. Write company name, website, employee count, and LinkedIn to columns A through D. Add a column E tier: "Growth" for 100 to 200 employees, "Emerging" for 20 to 99.
The team wants to exclude any company already in the CRM — cross-reference a second tab
Search PDL for US e-commerce companies with 20 to 200 employees founded after 2015, return 400 results. Remove any row where the website matches a domain in the "CRM Accounts" tab column B. Write the remaining company name, website, employee count, and LinkedIn into this sheet.
You want to add headquarters city for regional outbound routing
Search PDL for US e-commerce companies with 20 to 200 employees founded after 2015, return 300 results. Write company name, website, employee count, LinkedIn URL, and HQ city to columns A through E. Flag any company headquartered in New York, LA, or Chicago in column F as "Priority metro."
Build the account list, add Shopify-signal enrichment, and score in one pass
Search PDL for US e-commerce companies with 20 to 200 employees founded after 2015, return 300 results. Write company name, website, employee count, and LinkedIn to columns A through D. Then check if PDL's tech stack data includes Shopify for each company and flag those rows in column E as "Shopify merchant."
One prompt pulls the ICP list and adds the platform signal your team uses for sequencing — no second research pass.
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet. Tell SheetXAI your ICP — industry, geography, company size — and ask it to pull matching accounts 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.