The Scenario
You pulled a list of 300 target company domains from a LinkedIn Sales Navigator export three days ago. It's been sitting in a Google Sheet — column A full of domains, columns B through D empty — while you figured out how to actually fill them.
The sales team wants the list enriched by end of week. You've been putting it off because you know what the manual version looks like:
The bad version:
- Open Tomba, paste a domain, copy the returned email addresses, switch to the sheet, find the right row, paste into B, C, and D — and check that you didn't accidentally overwrite something.
- Realize the second result sometimes returns two emails and sometimes three, so your columns end up ragged.
- Repeat 299 more times, losing track of your row somewhere around number 60.
The list has 300 rows. This work doesn't belong on your calendar.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the data in your sheet and talks to Tomba on your behalf — so you describe what you want, and it handles the lookup, the parsing, and the writeback.
Here's the prompt to use:
Look up the top 3 professional email addresses for every domain in column A and write the results into columns B, C, and D. Skip any rows where column A is blank.
What You Get
After running this prompt:
- Column B gets the first verified email address Tomba returns for each domain.
- Columns C and D get the second and third, if available — blank if Tomba returns fewer.
- Rows where column A is empty are skipped cleanly.
- Any domain Tomba can't resolve gets a note in column B so you know which ones to follow up on.
What If the Data Is Not Quite Ready
The domains have trailing slashes or "www." prefixes
Some scraped domain lists come back with inconsistent formatting — "www.acme.com", "acme.com/", "https://acme.com". Tomba expects clean root domains.
Normalize every domain in column A by stripping "www.", "https://", "http://", and trailing slashes, then look up the top 3 professional email addresses for each cleaned domain and write results into columns B, C, and D.
Some rows have company names instead of domains
If the export mixed company names with actual domains, Tomba won't know what to do with "Acme Inc" in column A.
For every row in column A, check whether the value looks like a domain (contains a dot, no spaces). If it does, look up professional email addresses and write them into columns B–D. If it doesn't, write "needs domain" into column B and leave C and D blank.
You only want emails for specific industries
You've got 300 domains but only want to enrich the SaaS companies — column E has an "Industry" label for each row.
For every row where column E contains "SaaS", look up the top 3 professional email addresses for the domain in column A and write them into columns B, C, and D. Skip all other rows.
Full pipeline: deduplicate, normalize, enrich, and flag gaps in one shot
Deduplicate the domains in column A (case-insensitive, strip www and trailing slashes). For each unique domain, look up the top 3 professional email addresses in Tomba and write them into columns B, C, and D. Where Tomba returns no results, write "no results" into column B. Remove any rows that are exact duplicates of a domain already processed.
The pattern: normalize and enrich in a single prompt — no intermediate cleanup step needed.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with a column of company domains, then ask it to enrich the list with Tomba email data. Or explore a related workflow: flagging webmail and disposable domains, or the full Tomba integration overview.