The Scenario
Last Tuesday's webinar pulled 400 registrations. Your marketing ops specialist downloaded the registration export and it has one usable column: email addresses. The CRM upload form requires first name, last name, job title, and company name, or it rejects the record. The upload is blocked and the leads are sitting cold while someone figures out how to fix it.
That someone is now you.
The bad version:
- Copy an email address, paste it into CompanyEnrich's person lookup, wait for the result, copy each field individually, paste first name into column B, last name into column C, title into column D, company into column E.
- Move to the next row.
- Do this 400 times, with occasional lookups returning no result that you have to handle manually.
Marketing wants this list uploaded before the follow-up sequence goes out tomorrow morning. Spending the evening on manual lookups is not a strategy, it's a penalty for a data problem that shouldn't be yours to solve.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your data, understands the structure, and through its CompanyEnrich integration it can look up every email address in the sheet and write the enriched contact fields back — in one prompt.
For each email address in column A, use CompanyEnrich to look up the person and write their full name, job title, and company name into columns B, C, and D.
What You Get
- Column B gets the person's full name as returned by CompanyEnrich.
- Column C gets job title.
- Column D gets company name.
- Rows where CompanyEnrich finds no match are left blank in columns B through D, making it easy to see which addresses need a fallback approach.
- No formatting applied — the values come back exactly as CompanyEnrich returns them.
What If the Data Is Not Quite Ready
You want first name and last name in separate columns
For each email in column A, use CompanyEnrich person lookup to get the person's first name, last name, job title, and company name, then write first name into column B, last name into column C, job title into column D, and company name into column E.
You want to flag high-priority contacts by title
For each email address in column A, use CompanyEnrich to look up the person and write their full name, job title, and company name into columns B, C, and D. Then in column E, write "High Priority" for any row where the job title contains "Director", "VP", "Chief", or "Head of", and leave column E blank for all others.
The email column has duplicates you want to deduplicate first
In column A, remove any duplicate email addresses before running lookups. Then for each unique email, use CompanyEnrich person lookup to get full name, job title, and company name, and write results into columns B, C, and D.
Full enrichment + tier + upload-ready output in one shot
For each email in column A of my Webinar Registrants sheet, use CompanyEnrich person lookup to get first name, last name, job title, and company name. Write first name into B, last name into C, job title into D, company name into E. Then in column F, write "Tier 1" if title contains "Director", "VP", or "C-suite", "Tier 2" if title contains "Manager", and "Tier 3" for all others. Copy rows where column F is "Tier 1" or "Tier 2" into a new sheet called "Priority Upload".
One prompt enriches, scores, and stages the upload-ready segment.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet with your raw webinar email list, then ask it to enrich each address using CompanyEnrich person lookup and populate the name, title, and company columns. You might also want to build a prospect list by company criteria using the companies that appear in your results.