The Scenario
You're an SDR at a B2B SaaS company. Last week, someone on the growth team scraped 500 email addresses from LinkedIn company pages and dropped them into a Google Sheet. Your job is to upload them to Salesloft by end of week — but Salesloft wants first name, last name, and a business-email flag for every contact, and right now you have nothing but raw email strings in column A.
Your options are: spend an hour Googling each address, or find a faster way.
The bad version:
- Open each email address in a browser tab, guess the name from the local part, and type a first and last name by hand into columns B and C — 500 times.
- Run the list through a LinkedIn search to find names, hit the rate limit after 40 searches, and realize this is going to take three days.
- Upload the raw emails to Salesloft with blank name fields and let the sales reps fill in the names manually during outreach.
This is the kind of work that sounds like "thirty minutes" and turns into three hours the moment you actually sit down to do it. The reps are waiting on the sequence to go live. There's a demo booked for Friday that needs the outreach running before it.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your data 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 flag back into the columns you need.
For each email in column A, call RiteKit's full email insights and write the inferred first name into column B, the inferred last name into column C, whether it is a business email into column D (TRUE/FALSE), and whether it is free-mail into column E (TRUE/FALSE). Leave cells blank where RiteKit cannot infer a value.
What You Get
- Column B: Inferred first name (e.g., "james" from james.harrison@acmecorp.com)
- Column C: Inferred last name ("harrison")
- Column D: TRUE if RiteKit identifies this as a business domain, FALSE otherwise
- Column E: TRUE for free-mail providers, FALSE for business addresses
- Rows where RiteKit returns no inference get blank name fields — no false data written
What If the Data Is Not Quite Ready
Some emails have numeric suffixes that break name inference — like john.smith2@company.com
For each email in column A, call RiteKit full email insights. Where the local part contains a trailing digit (like john.smith2), strip the digit before inferring the name, then write first name, last name, business-email, and free-mail flags to columns B, C, D, E.
The list has duplicate email addresses and I only want to enrich each unique address once
Deduplicate column A by email address, keeping the first occurrence of each. Then call RiteKit full email insights for each unique email and write first name, last name, business-email flag, and free-mail flag to columns B, C, D, E. For rows that were duplicates, copy the enrichment result from the first occurrence into the duplicate row.
I need to filter out free-mail addresses and only upload business emails to Salesloft
For each email in column A, call RiteKit full email insights. Write first name, last name, business-email flag, and free-mail flag to columns B, C, D, E. Then on a new tab called "Salesloft Upload" copy only the rows where column D is TRUE and column E is FALSE — those are confirmed business emails with inferred names ready to import.
I want to clean, enrich, and format the list for upload in one pass
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 missing an @ character — write "SKIP" in column B for those. Then on a new tab called "Ready for Salesloft" output only rows where column D is TRUE, with columns formatted as: Email | First Name | Last Name.
One prompt, clean output, ready to import.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet holding your scraped email list, then ask it to run RiteKit's full email insights across every row in column A. Once enriched, you might also want to validate those same addresses for disposable and typo signals, or go back to the RiteKit + Google Sheets overview.