The Scenario
Three hundred webinar registrations came in over the last two weeks. The form only asked for email address. Sales wants follow-up calls starting tomorrow.
The RevOps analyst running this is staring at a column of email addresses and nothing else. No names. No companies. No titles. Sales needs enough context to open a conversation — who the person is, where they work, what they do.
The bad version:
- Export the email list, upload it to Clearout's person reverse lookup tool.
- Download the enriched results.
- Open the enrichment file and the original sheet side by side, VLOOKUP the fields back in, check which rows came back empty, figure out what to do with those.
- Manually note which addresses returned a company domain even if no person profile was found.
This is the third time this month the analyst has run this playbook. Each time, the reconciliation step is different enough that no clean process has ever stuck.
The email column is already in the sheet. The enrichment tool exists. The gap between them shouldn't require an afternoon.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the email column, calls Clearout's person reverse lookup for each address, and writes the returned profile fields — name, company, title, LinkedIn — directly into the columns you specify.
For each email in column A, use Clearout reverse lookup to find the person's full name, company, job title, and LinkedIn URL — write the results into columns B, C, D, and E.
What You Get
- Column B: full name (first + last) if a person profile was found
- Column C: company name associated with the email address
- Column D: job title or role at that company
- Column E: LinkedIn profile URL, when available
- Rows where Clearout found no person profile are left blank, not silently skipped
What If the Data Is Not Quite Ready
Some emails look like aliases or distribution addresses
For each email in column A, use Clearout person reverse lookup — if no person profile is returned, attempt Clearout company domain lookup on the email domain and write at minimum the company name into column C. Flag any row where neither lookup returned data as "no match" in column F.
I want to prioritize the enriched rows that came back with a job title
Enrich all emails in column A with Clearout person reverse lookup, writing name to column B, company to column C, job title to column D, and LinkedIn to column E. Then sort the sheet so rows with a job title in column D appear first.
Some emails are from the same company and I only want one contact per domain
After enriching all emails in column A with Clearout reverse lookup, deduplicate the sheet by the domain of the email address in column A — keep the row with the most complete profile — and mark duplicates as "removed" in column F before deletion.
Enrich, deduplicate, and flag sales-ready rows in a single pass
Use Clearout person reverse lookup to enrich all emails in column A — write full name to B, company to C, job title to D, LinkedIn to E. Then deduplicate by email domain, remove rows where no name and no company were returned, and flag any row where job title in column D contains "VP," "Director," or "Head of" with "priority" in column F.
Ask for the enrichment, the deduplication, and the prioritization in one prompt — the sheet that comes out is the one the sales team can open tomorrow.
Try It
Get the 7-day free trial of SheetXAI and open any sheet of webinar registrations, form submissions, or event sign-ups with a bare email column — and ask it to enrich each address with Clearout person data. For context on the next step, see how to remove non-business emails, or return to the Clearout hub for the full toolkit.