The Scenario
It's been two weeks since the webinar and 300 attendees filled out the registration form. You have their emails. That's it. Before the demand-gen team can score this list and hand leads to sales, someone needs to append job title, company name, company size, and LinkedIn URL to every row. That someone is you, apparently, because you built the workbook.
You pull up the form responses export. Column A is email. Columns B through E are empty and waiting.
The bad version:
- Save the 300 emails as a CSV, upload it to FullEnrich's reverse lookup tool, wait for the job to complete, and download a result file that comes back with columns in a completely different order than your workbook expects
- Spend 40 minutes matching and pasting the four returned fields into the right columns, manually skipping the 30 rows that came back with partial results
- Realize FullEnrich appended "Company Size" as a range ("51-200") but your scoring model expects a number, so now you're reformatting a third column in a workbook you've already touched four times today
The scoring model is waiting. Sales is waiting. You are in Excel doing data cleanup that has nothing to do with demand generation.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the data, understands the context, and through its built-in FullEnrich integration it runs reverse email lookups across every row and writes the profile data back into the columns you specify — handling partial results and format normalization as part of the same request.
Here is the prompt for this task:
For every email in column A of the Inbound Leads worksheet, run a FullEnrich reverse email lookup and write the returned first name and last name into columns B and C, company name into column D, job title into column E, and LinkedIn URL into column F. Skip any row that already has a value in column D.
What You Get
- Columns B and C populated with first and last name for each matched contact
- Column D with company name, column E with job title, column F with LinkedIn URL
- Rows where FullEnrich found no match left blank so your downstream scoring query can filter them separately
- Rows where column D already had a value skipped entirely — no overwrites, no duplicate work
What If the Data Is Not Quite Ready
Some emails in column A are clearly malformed — missing the @ symbol or ending in ".con"
Before running the reverse lookup, check column A for malformed email addresses — flag invalid-format emails in column B with "Invalid email," then run FullEnrich reverse lookup on all remaining rows and write first name, last name, company, and title into columns C through F
You want to enrich only contacts who attended live, not on-demand registrants
Filter for rows where column G says "Live Attendee" and run FullEnrich reverse email lookup on those rows only — write returned first name, last name, company name, and job title into columns B through E
You need company size as a number, not a range, for scoring
Run FullEnrich reverse email lookup on every row in column A, write first name, last name, company, and title into columns B through E, and for company size write the midpoint of the returned range as a number into column F — for example, "51-200" should become 125
The list has duplicates and you only want to enrich unique emails, then roll the results back to all matching rows
Deduplicate column A by email address, run FullEnrich reverse lookup once per unique email, then write the returned first name, last name, company, and title back to every row that shares that email — write results into columns B through E and mark processed rows with a checkmark in column G
One prompt handles the deduplication, the enrichment, and the rollback — no intermediate steps, no manual merging.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook holding your next batch of inbound form submissions — then ask it to reverse-enrich the email column into full contact profiles before your scoring run. See also how to bulk-enrich a prospect list with email and phone or build a cold outreach list using people search.