The Scenario
Your growth team is three days out from launching an outreach campaign. You have 150 prospects in your sheet — column A is full name, column B is company domain — and the email column is blank. Every email has to be verified before it goes into the sequence. Without that, the campaign burns sender reputation on bounces before it's even gotten started.
The bad version:
- Paste names and domains into Datagma one at a time, copy the returned email, paste it into the sheet, move to the next row — 150 times
- Export the sheet to CSV, upload it to Datagma's bulk enrichment tool, download the result, re-import it, fix the formatting where the columns didn't land cleanly
- Ask a freelancer to run the lookups over the weekend, which adds cost, delays the timeline, and means someone outside your org now has your prospect list
The campaign window doesn't flex. And you can't write a campaign sequence around a blank column.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. 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 sheet. You don't touch the API.
For each person in my 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 step 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 work emails for all 150 prospects using name in column A and domain in column B, write the email into column C, and highlight any row in red where Datagma returned no email or flagged the result as low confidence
Some prospects already have emails from a previous tool
You partially enriched this list with a different tool two weeks ago. Column C has maybe 40 entries. You want Datagma to fill the gaps only.
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 Google Sheets with domains but no emails, get the 7-day free trial of SheetXAI and open that sheet. 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.