The Scenario
RevOps handed you an Excel workbook with a Salesforce export: 500 companies, website column, nothing enriched. The account scoring model needs employee count, industry, and LinkedIn URL before it can run. You have PDL access and you know the bulk endpoint batches 100 records per call — five calls for 500 rows instead of 500. What you don't know is how to call it from a workbook without writing a script.
The bad version:
- Fall back to the individual enrichment endpoint because it's easier to understand — 500 separate API calls, each returning one company record
- Realize midway through that you've burned 5x the expected API credits and the response time for each call means the whole run takes 45 minutes
- Get to the end and find 28 rows silently failed because the individual endpoint doesn't distinguish between "no match" and "network error" in the same way the bulk endpoint does
You made the expensive choice because the efficient choice required more setup than the deadline allowed.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the company data in the workbook and uses PDL's bulk enrichment endpoint to process rows in batches of 100 and write results back.
Use People Data Labs bulk company enrichment on my Excel Target Accounts table — batch the rows by 100 using the domain column, and write enriched data back: employee count, industry, HQ city, and founded year.
What You Get
- Five bulk API calls instead of 500 individual requests — credits preserved
- Employee Count, Industry, HQ City, and Founded Year columns populated for each matched company
- Rows where PDL finds no match flagged in a Status column with "No match" so nothing fails silently
- A run summary added to the top of the sheet showing total processed, total matched, and total unmatched
What If the Data Is Not Quite Ready
The domain column has inconsistent formatting — some rows include protocol prefixes or trailing paths
Before enriching, normalize the domain column: strip https://, http://, www., and any path after the top-level domain. Then run PDL bulk company enrichment in batches of 100 and write employee count, industry, HQ city, and founded year back to the corresponding columns.
Some rows have a company name but no domain — use name as fallback
For rows where the domain column is empty, enrich by company name instead. For rows with a domain, use the domain. Run all rows through PDL bulk enrichment in batches of 100 and write employee count, industry, HQ city, and founded year to the corresponding columns.
You have duplicate domains in the table — deduplicate to avoid billing twice
Identify duplicate values in the domain column and mark duplicates in a Duplicate column. Run PDL bulk enrichment only on unique domains, batch by 100, write the enriched fields back to all rows that share the same domain, and note the shared match in the Duplicate column.
Enrich, score accounts, and flag priority targets for the SDR team in one pass
Run PDL bulk company enrichment on the Target Accounts table in batches of 100 using the domain column. Write employee count, industry, HQ city, and founded year to the corresponding columns. Then add a Priority Score column: 3 for SaaS or fintech companies over 200 employees, 2 for 50 to 200 employees, 1 for everything else.
One prompt handles the batch enrichment and the scoring logic — RevOps gets a decision-ready workbook, not raw data that still needs a second pass.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with a list of company domains or names. Ask it to enrich using PDL bulk batching and write firmographics back. Then see how to enrich individual contacts with PDL person enrichment or go back to the People Data Labs overview.