The Scenario
Your growth team is three days out from launching an outreach campaign. You have 150 prospects in your Excel workbook — column A is full name, column B is company domain — and the email column is blank. Every address has to be verified before it goes into the sequence. Without that, the campaign burns sender reputation on bounces before it's even started.
The bad version:
- Export the table to CSV, upload to Datagma's bulk finder, download the result, re-import into Excel, fix the column misalignment where the CSV headers didn't match the table — and then discover ten rows were skipped because the domain format didn't parse correctly
- Paste names and domains into the Datagma UI one at a time — 150 lookups, maybe four seconds each, which is still ten minutes if everything goes perfectly (it won't)
- Hire a freelancer to run the lookups over the weekend, which adds cost, compresses the timeline, and means your prospect list leaves the building
The campaign window doesn't flex. And you can't write a sequence around a blank column.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the prospect table, understands which columns hold the inputs, and through its built-in Datagma integration it calls the email finder endpoint and writes verified addresses back into the workbook. You don't touch the API.
For each person in my Excel sheet (full name in column A, company domain in column B), find their work email using Datagma and write it into column C
What You Get
- Column C: verified work email for each prospect where Datagma found a match
- Rows where Datagma returned no result or a low-confidence address are noted in column D — so you can triage them rather than send to a bad address
- The output format matches what your email platform expects — no reformatting before import
What If the Data Is Not Quite Ready
The domain column has formatting issues
Some domains have "https://" prepended, others are just the root domain. Datagma's email finder works from the root domain only.
Strip "https://" and any trailing slashes from the domains in column B, then call Datagma's email finder for each row using full name in column A and the cleaned domain, and write the result into column C
You need to flag low-confidence results before sending
Datagma returns a confidence score with each email. You want to color-code the output so your team can review borderline rows before the campaign goes out.
Find verified work emails for all 150 prospects in columns A and B, then flag any row in red where Datagma returned no email or a low-confidence result
Some prospects already have emails from a previous tool
You partially enriched this list with another tool two weeks ago. Column C has maybe 40 entries. You want Datagma to fill only the gaps.
Find verified work emails using Datagma for rows where column C is empty — use full name in column A and company domain in column B as inputs — and write results into column C
Full cleanup, dedup, and email fill in one pass
Domains have inconsistent formatting, 40 rows already have emails, and there are 12 duplicate company domains in the list. You want clean inputs, no duplicates enriched twice, and verified emails for everyone remaining.
Clean the domain format in column B, skip rows where column C already has an email, deduplicate by domain so each company is only looked up once, then use Datagma to find verified work emails for all remaining rows and write them into column C — flag any row where confidence was low in column D
Try It
If your outreach list is sitting in an Excel workbook with domains but no emails, get the 7-day free trial of SheetXAI and open that workbook. Ask it to run Datagma email lookup across the list and you'll have verified addresses in column C before the end of the hour. For related tasks, see bulk-enrich a lead list or append mobile phone numbers.