The Scenario
You're a lead researcher and you've spent two days building a Google Sheet of 80 target executives — full name in column A, company domain in column B. No email addresses yet. The outreach campaign can't start until those are filled in, and the account exec is asking for an ETA.
This is the third time this month you've had to source emails manually. Last time you spent four hours toggling between LinkedIn, Hunter, and a separate verification tool, entering each result by hand, and still ended up with 11 addresses that bounced on send.
The bad version:
- Open Emelia's email finder interface, type in each name and domain one at a time, copy the result, switch back to the sheet, paste into column C, move to the next row.
- Hit the daily lookup limit halfway through, wait until tomorrow to continue, lose your place in the list.
- Hand over a sheet where 15 rows still say "not found" and no one is sure if that means Emelia couldn't find them or you just didn't get to them yet.
Eighty rows at two minutes each is two hours and forty minutes of mechanical, zero-judgment work you're doing instead of the actual research.
The Easy Way: One Prompt in SheetXAI
SheetXAI sits inside your Google Sheet and uses Emelia's email finder directly. You describe the columns, you describe where you want the result, and it runs through every row.
For each row in my Google Sheet where column A is the prospect's full name and column B is their company domain, use Emelia to find their email address and write the result to column C
What You Get
- Emelia's email finder runs for each row in the sheet.
- Column C receives the discovered email address where one is found.
- Rows where no email is found get "not found" written to column C so you can see the gap immediately.
- Any rows where the lookup returned a confidence score below Emelia's threshold are flagged in column C with a note.
What If the Data Is Not Quite Ready
Company domains are formatted inconsistently
Column B has a mix of "acme.com," "www.acme.com," and "https://acme.com" — the finder needs clean domains.
Strip any leading www. or https:// from column B domains, then run Emelia's email finder for each row using the full name in column A and the cleaned domain, and write the found email to column C
Some rows already have emails filled in
A previous researcher got partway through the sheet, so about 30 rows in column C are already populated. You only want to run the finder for the blanks.
For every row where column C is empty, use Emelia to find the email using full name from column A and company domain from column B, and write the result to column C
Names are split across two columns
Column A is first name, column B is last name, column C is the company domain, and you need the email in column D.
Combine the first name in column A and last name in column B for each row, use Emelia to find the email for that full name at the domain in column C, and write the result to column D
Verify the found emails immediately after finding them
You want to find and verify in one pass so you're not handing over addresses that haven't been confirmed.
For each row in my sheet, use Emelia to find the email for the person in column A at the domain in column B, then run Emelia's email verification on the result, and write the email to column C and the verification status to column D in a single pass
Running the find and verify together means you hand over a sheet where every populated cell in column C has already been checked.
Try It
Get the 7-day free trial of SheetXAI and open your prospect Google Sheet with a name column and a domain column, then ask it to fill in the email addresses using Emelia. For a related workflow, see Verify a Spreadsheet of Email Addresses in Bulk or the Emelia hub overview.