The Scenario
You're a recruiter who inherited a spreadsheet from a colleague who left last month. Column A has 200 candidate email addresses. That's it — no names, no titles, no LinkedIn profiles, nothing else. You need job title, LinkedIn URL, and current location for each person before you can prioritize outreach. Your ATS won't let you import candidates without at least a name and title, and your hiring manager wants a shortlist by Friday.
It's Wednesday.
The bad version:
- Google the first email address, try to find the person on LinkedIn, copy their job title and location, paste into the sheet.
- For the ones who don't appear in a Google search, try Hunter's people enrichment one by one.
- Get through maybe 30 rows before realizing you've been doing this for 45 minutes and you still have 170 left.
You're supposed to be screening candidates, not building the spreadsheet that lets you screen candidates.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your email addresses and through its Hunter integration it can enrich each one with person-level data — name, title, employer, LinkedIn profile, location — and write it all back to the sheet in one run.
For each email address in column A, run Hunter's people enrichment and write the person's full name, job title, company, LinkedIn URL, and location to columns B–F.
What You Get
- Column B: full name as Hunter has it.
- Column C: current job title.
- Column D: current employer or company name.
- Column E: LinkedIn profile URL.
- Column F: location (city, country) where available.
- Rows where Hunter returned no enrichment data left blank, so you can filter them separately.
What If the Data Is Not Quite Ready
Some email addresses are no longer valid and you want to filter them before enriching
Your colleague's list is old enough that some addresses might have bounced or changed. Running enrichment on dead addresses wastes API calls.
Before enriching, verify every email in column A using Hunter's email verifier. Write the verification status to column B. Then run people enrichment only for addresses where column B is "VALID". Write name, title, company, LinkedIn, and location to columns C–G for those rows only.
You want to prioritize candidates at specific companies
You're recruiting for a niche role and you know the profile you want — someone currently at a Series B SaaS company, ideally in a product or engineering function. Hunter's enrichment returns employer and title, which lets you filter.
Enrich all emails in column A with Hunter's people enrichment. Write name to column B, job title to column C, current company to column D, LinkedIn to column E. Add a column F that marks each row "PRIORITY" if the title contains "engineer", "product", or "designer", and "REVIEW" for everything else.
You also have email addresses in a second tab and want to combine results
Your ATS export is on the "ATS Candidates" tab and the inbound applications are on the "Inbound" tab. You want to enrich both but write all results to a single "Enriched" tab.
Enrich all email addresses in column A of the "ATS Candidates" tab and all email addresses in column A of the "Inbound" tab using Hunter's people enrichment. Write all results — source tab, email, name, title, company, LinkedIn, location — to a new tab called "Enriched".
You want enrichment + verification + an import-ready ATS export in one pass
Your ATS import template needs: email, first name, last name, title, current company, LinkedIn, location, and a verification status column. You want the full enrichment pipeline done and formatted for import.
Enrich all emails in column A using Hunter's combined enrichment. Write first name to column B, last name to column C, job title to column D, current company to column E, LinkedIn to column F, and location to column G. Then verify each email and write the verification status to column H. Format the output so it matches the column order: email, first name, last name, title, company, LinkedIn, location, status.
Running the enrichment and verification in a single prompt means the output is import-ready, not a raw data dump you still have to clean and reformat before uploading.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet where column A holds a list of email addresses that need person-level context. Ask SheetXAI to run Hunter's people enrichment across all of them. See also bulk email verification or return to the Hunter overview.