The Scenario
You picked up a Google Sheet from the SDR who left last month. It has 200 rows — name, email, and nothing else. The column headers for job title, company, and LinkedIn are there, empty, placeholder formatting and all. Your job this week is to get those enriched before the list goes into the CRM sequence. The data's been sitting there long enough.
The bad version:
- Copy 20 emails at a time into the PDL API console, run the lookup, manually paste job title, company name, and LinkedIn URL into the right sheet columns for each row
- Lose track at row 60 when you accidentally paste a row's company into the next row's title column and don't notice until you're at row 100
- Spend a separate pass just fixing the misaligned data before you can call the sheet clean
There is no version of doing this row by row that doesn't cost you most of a morning. And at the end of it, your work is indistinguishable from something a script could have done in 30 seconds.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the data already in front of it and uses its built-in People Data Labs integration to enrich your rows and write the results back — without you touching the API.
Enrich each row in this sheet using PDL: use the email in column A to look up the person and write their job title, company name, and LinkedIn URL into columns C, D, and E.
What You Get
- Column C populated with the person's current job title from PDL, one row at a time
- Column D populated with their current company name, canonicalized from PDL's record
- Column E populated with their LinkedIn profile URL
- Rows where PDL finds no match written with a "Not found" flag in column F so you can review or skip them before importing to the CRM
What If the Data Is Not Quite Ready
The email column has a mix of personal and work addresses
Enrich each row in column A with PDL using the email provided. If the match confidence is below 0.8, leave columns C through E blank and flag the row in column F as low confidence.
Some rows have name and company but no email
For rows where column A is empty, enrich using first name in column B and company in column C via PDL, and write job title, LinkedIn URL, and work email to columns D, E, and F.
The sheet has duplicates and you want to enrich only unique emails
Deduplicate the email list in column A first, then enrich each unique email via PDL and write job title, company, and LinkedIn back into the corresponding rows.
Clean, enrich, and flag seniority in one pass
Enrich each row using the email in column A via PDL. Write job title, company, and LinkedIn into columns C, D, and E. Then check if the seniority level from PDL is VP or above and flag those rows in column F as high-priority.
The pattern is to ask for the enrichment and the conditional logic together — you get back a sheet that is already segmented, not just enriched.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with a column of lead emails. Ask it to enrich the rows with job title and company from PDL — you'll have a qualified list in under a minute. Then see how to deduplicate contacts with PDL identity resolution or go back to the People Data Labs overview.