The Scenario
You took over the outbound motion three weeks ago. The previous SDR left an Excel workbook with 150 rows: first name, last name, company domain. No email addresses — those were apparently "looked up manually" before each send cycle. The next send is Thursday. It's Tuesday afternoon.
The bad version:
- Open Hunter's email finder, type in the first name, last name, and domain for row 2, copy the result email and confidence score, paste into columns D and E.
- Repeat for row 3. And row 4. And the 146 after that.
- Realize at row 30 that some domains return no result and you need to decide what to write in that cell, which breaks your paste rhythm.
There's no version of this that ends before 6 PM. And the send is Thursday, not Friday — you still have the copy to write.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the data in your worksheets, understands the column structure, and through its Hunter integration it can look up email addresses for every row in one shot.
Use Hunter's email finder on every row in this Excel workbook — look up the email for the name in column A at the domain in column B and write the result, confidence score, and status (valid/risky/unknown) to columns C–E.
What You Get
- Column C filled with the best-match email address Hunter found for each person, or blank if no match exists.
- Column D filled with Hunter's confidence score (0–100) for each found address.
- Column E with the preliminary deliverability status Hunter returns alongside the finder result.
- Rows where Hunter returned no match left blank in column C so you can filter them out.
What If the Data Is Not Quite Ready
Company names instead of domains in column B
Some prospect lists come with "Acme Corp" in the domain column instead of "acme.com." Hunter's email finder needs a domain, not a company name.
For each row in my workbook, the value in column B is a company name, not a domain. Attempt to infer the most likely domain (e.g., remove spaces, lowercase, add .com) and use that for the Hunter email lookup. Write the inferred domain to column F, the found email to column C, and the confidence score to column D.
Some rows are missing a last name
About 20 rows in your workbook only have a first name — no last name field.
For rows where column B is empty, run the Hunter email finder using only the first name in column A and the domain in column C. Write the result to columns D and E. Note in column F that the last name was missing for these rows.
You want to cross-reference a second worksheet of existing contacts
You already have a worksheet called "Existing Contacts" with emails you've already verified. Before looking up new ones, you want to skip rows where you already have a match.
Before running Hunter lookups on the "Prospects" worksheet, check if each domain-plus-first-name combination already exists in the "Existing Contacts" worksheet. Skip any rows that match and write "already known" to column D for those rows. Only call Hunter for the rows that don't appear in existing contacts.
You want the email lookup and a deliverability check in one shot
You don't want to run the email finder and then run the verifier as a separate step. You want both done at once.
For each row in my workbook, use Hunter to find the email address for the person with first name in column A, last name in column B, and domain in column C. Then immediately verify the found email and write the email to column D, the confidence score to column E, and the verification status (VALID / RISKY / INVALID / UNKNOWN) to column F — all in one pass.
Asking for the lookup and validation in a single prompt saves you a full second run through the workbook.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook where you have names and company domains but still need the emails. Ask SheetXAI to run the Hunter finder on every row. See also the bulk email verification spoke or return to the Hunter overview.