The Scenario
The outbound campaign is launching Monday. It's Thursday afternoon and you're staring at an Excel workbook with 500 rows of LinkedIn-scraped prospects — first name, last name, company domain — and columns E and F are completely blank. Those are the email and phone columns. The campaign manager is already asking for the final list so they can load it into the sequencer.
You know what needs to happen. You also know what it's going to take to do it the normal way.
The bad version:
- Save the worksheet as a CSV, upload it into FullEnrich, spend 20 minutes matching your column headers to their input schema because yours says "Domain" and theirs expects "company_domain"
- Wait for the enrichment job to finish, download the result file, open it alongside your original workbook, and copy-paste 500 rows of email and phone data back in — praying the row order held
- Discover that 60 rows came back with null phone numbers, have no idea which ones they are, and spend another 30 minutes cross-referencing the downloaded CSV against your workbook to find them
The campaign manager is not waiting two days for you to sort this out. Neither is the sequencer. And none of this is the analysis work you were actually hired to do — it's just the plumbing that should be invisible.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your data, understands what you're working with, and through its built-in FullEnrich integration it can run bulk waterfall enrichments across every row in one shot — writing the results back into exactly the columns you name.
Here is the prompt for this task:
Enrich all rows in this workbook using the First Name, Last Name, and Domain columns — run a FullEnrich waterfall lookup and write the verified work email into column E and the direct-dial phone number into column F. Flag any row where enrichment returned no result by writing "Not found" in column G.
What You Get
- Column E populated with a verified work email for every successfully enriched contact
- Column F populated with a direct-dial phone number where FullEnrich's waterfall found one
- Column G showing "Not found" for any row where no result was returned — so the gaps are visible and filterable, not hidden
- A final count in the sidebar showing how many rows were enriched and how many came back empty
What If the Data Is Not Quite Ready
The domain column has inconsistent formatting — some rows say "acme.com," others say "https://www.acme.com"
Before enriching, normalize column C so every value is a bare domain with no protocol or www prefix — then run the FullEnrich waterfall lookup using the cleaned domain values and write email and phone into columns E and F
Some rows are already enriched from a previous run — you only want to enrich the gaps
Run FullEnrich enrichment only on rows where column E is blank — use First Name, Last Name, and Domain as inputs and write the returned email and phone into columns E and F, leaving already-populated rows untouched
The workbook has contacts from multiple companies and you only want to enrich a specific segment
Filter for rows where column D says "Series A" and run FullEnrich enrichment on those rows only — write verified email into column E and phone into column F, and add a timestamp in column H for each enriched row
The data is messy, some rows have the name split as full name in one column, and you need cleaning plus enrichment in one shot
For rows where column B contains a full name instead of separate first and last name: split the name into first and last, write them into columns C and D, then run FullEnrich enrichment using the split name and the domain in column E — write verified email into column F and phone into column G, and mark rows where enrichment failed in column H
The pattern in every case: describe the cleanup and the enrichment action in one prompt, and SheetXAI handles both in sequence.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook your next outbound campaign is built on — then ask it to bulk-enrich your prospect rows with verified emails and phone numbers before Monday's send. See also how to reverse-enrich inbound leads from email addresses or how to build a prospect list from scratch using people search.