The Scenario
You are a sales development rep. Thursday at 3 PM. Your manager dropped an Excel workbook in Teams:300 LinkedIn-sourced prospects, first name, last name, and company domain in columns A, B, and C of the Prospects tab. Nothing else. She wants email addresses, phone numbers, and job titles filled in by Friday morning so the sequence can go live.
The workbook is clean. The problem is the columns to the right are empty.
The bad version of Thursday afternoon:
- You open Apollo's people search, paste in a name and domain, grab the contact record
- You copy email, phone, and title back to the workbook manually
- You do this for row two. Row three. Row four.
- After twenty rows you have spent forty minutes and you are looking at 280 more
- You try to export from Apollo, but the CSV does not map to your workbook structure without rearranging five columns first
- You send your manager a half-finished workbook at 11 PM and apologize.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads each row, calls Apollo, and writes enriched data back into the right columns without you looking up a single contact by hand.
Open the SheetXAI sidebar and type:
Enrich every row in the Prospects tab using Apollo — match by first name in column A, last name in column B, and company domain in column C — then fill email into column D, phone into column E, and job title into column F. Skip rows where any of the three input columns are blank. Flag rows Apollo could not match by writing "No match" into column G.
SheetXAI reads all 300 rows, sends the batch enrichment request to Apollo, and writes the results back to the right columns. Rows Apollo did not match get flagged. You go get dinner.
What You Get
A fully enriched workbook with:
- Column D — verified email addresses from Apollo's contact database
- Column E — direct phone numbers where available
- Column F — current job titles at the matched companies
- Column G — match status flag for any row Apollo could not resolve
Every write goes to the exact column you specified. SheetXAI does not create a new tab or dump results elsewhere.
Need LinkedIn URLs instead of phone numbers? Change the prompt. Need to add company size in column H at the same time? Add it to the same prompt.
What If the Data Is Not Quite Ready
Sourced lists in Excel rarely come clean. SheetXAI handles cleanup and enrichment in the same prompt.
When company domains are missing the TLD
Your workbook has "acme" in column C instead of "acme.com" — someone stripped domains when copying from LinkedIn.
Before enriching, fix every value in column C of the Prospects tab that is missing a dot by appending ".com" if no other TLD is present. Then enrich all rows using Apollo with first name in column A, last name in column B, and the corrected domain in column C. Write email, phone, and title to columns D, E, and F.
When some contacts have first-and-last merged in one column
The export from your sourcing tool put full names in column A and Apollo needs them split.
Split the full name in column A of the Prospects tab into first and last name. Put first name in column A and write last name into a new column B, shifting existing columns right. Then enrich every row using Apollo with first name in column A, last name in column B, and domain in column C. Write email, phone, and title into columns D, E, and F.
When you only want to enrich contacts at companies with more than 100 employees
You sourced broadly and want to filter before burning enrichment credits.
First enrich the domain in column C of the Prospects tab for each row using Apollo's organization lookup and write employee count into column H. Then enrich only the rows where column H is 100 or more, writing email, phone, and title into columns D, E, and F. Leave column H in the workbook.
When the list needs deduplication, cleanup, and enrichment in one shot
You merged three sourced lists and the result has duplicate emails, inconsistent domain formats, and mixed-case names.
Deduplicate rows in the Prospects tab by company domain and last name combined, keeping the first occurrence of each pair. Normalize domains in column C to lowercase with no "www." prefix. Standardize first and last names to title case. Then enrich all remaining rows using Apollo, writing email, phone, and title into columns D, E, and F. Flag unmatched rows in column G.
The pattern: cleaning and enriching are one operation. You do not fix the workbook first and then come back for enrichment.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with raw prospect names, then ask it to enrich rows from Apollo. The Apollo integration is included in every SheetXAI plan. For related workflows, see how to bulk-create contacts in Apollo from an Excel workbook or the Apollo in Excel overview.