The Scenario
You're an SDR at an enterprise software company. Your revenue ops team scraped 500 email addresses from LinkedIn company pages and loaded them into an Excel workbook. The plan: enrich with names, filter to business emails only, and hand the final list to the AEs before the Monday morning pipeline review.
It's Thursday afternoon. The review is 9 AM Monday.
The bad version:
- Manually look up each email address, infer the first and last name from the local part, type them into columns B and C. Five hundred rows. Six hours minimum.
- Run the list through LinkedIn Sales Navigator's person lookup — hit the rate limit after 80 searches, realize the rest will have to wait until tomorrow, miss the Monday handoff window.
- Send the list to the AEs with blank name fields and a note that "names are TBD," watching the pipeline review slide happen without the enrichment data.
You have four other open tasks this week. This enrichment work shouldn't eat Thursday afternoon.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the email addresses and, through its built-in RiteKit integration, calls the full email insights API for each address and writes the inferred name fields and business-email signals to the columns you specify.
For each email in column A, call RiteKit's full email insights and write the inferred first name, last name, whether it is a business email, and whether it is free-mail into columns B, C, D, and E.
What You Get
- Column B: Inferred first name from the email local part
- Column C: Inferred last name
- Column D: TRUE for business email domains, FALSE for personal
- Column E: TRUE for recognized free-mail providers (gmail, yahoo, outlook), FALSE otherwise
- Rows where RiteKit cannot infer a name get blank cells in B and C — no fabricated data
What If the Data Is Not Quite Ready
Many addresses use initials instead of full names — like j.smith@company.com — and won't return useful name inferences
For each email in column A, call RiteKit full email insights. After writing results to columns B-E, check column B: if the inferred first name is a single character or blank, write "MANUAL REVIEW" in column F. For rows with a multi-character first name, leave column F blank. This flags the initial-only cases for manual cleanup.
The list has 80 duplicate email addresses and I only want to call RiteKit once per unique address
Deduplicate column A by email address, keeping the first row of each duplicate. Call RiteKit full email insights for each unique address and write first name, last name, business-email flag, and free-mail flag to columns B, C, D, E. For rows that were duplicates of a previously enriched row, copy the enrichment results from the first occurrence.
I need to separate the enriched list into two worksheets — one for business emails to send to AEs, one for free-mail to archive
For each email in column A, call RiteKit full email insights and write first name, last name, business-email flag, and free-mail flag to columns B, C, D, E. After all rows are enriched, create a worksheet called "AE Pipeline" with only rows where column D is TRUE and column E is FALSE. Create a second worksheet called "Archive" with the remaining rows.
I want to enrich, filter, and format the final list for the Monday review in one operation
For each email in column A, call RiteKit full email insights and write first name to column B, last name to column C, and business-email flag to column D. Skip rows where column A is blank or has no @ character. Then on a new worksheet called "Pipeline Review" output only rows where column D is TRUE, formatted as: First Name | Last Name | Email — with no header row, ready to paste into the AE's CRM import template.
Enrichment, filtering, and formatting in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open your Excel workbook holding the raw email list, then ask it to run RiteKit's full email insights across every address in column A. Once enriched, you might also want to validate those same addresses for disposable and typo signals, or return to the RiteKit + Excel overview.