The Scenario
You are a sales development rep. Thursday at 3 PM. Your manager just dropped a Google Sheet in Slack:300 LinkedIn-sourced prospects, first name, last name, and company domain in columns A, B, and C. Nothing else. She wants email addresses, phone numbers, and job titles filled in by Friday morning so the sequence can go live.
The sheet 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 sheet manually
- You do this for row two. Row three. Row four.
- After twenty rows you have spent forty minutes and are looking at 280 more
- You try to export from Apollo, but the CSV does not map back to your sheet structure without a column rearrangement
- You send your manager a half-finished sheet 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 spreadsheet that reads each row, calls Apollo, and writes enriched data back into the right columns, so you do not have to look up a single contact by hand.
Open the SheetXAI sidebar and type:
Enrich every row in this sheet 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 so you can handle them separately. You go get dinner.
What You Get
A fully enriched sheet 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 somewhere unexpected.
Need LinkedIn URLs instead of phone numbers? Change the prompt. Need to add company size in column H while you are at it? Add it to the same prompt. SheetXAI adjusts without you reconfiguring anything.
What If the Data Is Not Quite Ready
Most sourced lists are not as clean as a flat first-name, last-name, domain export. SheetXAI handles cleanup and enrichment in the same prompt.
When company domains are missing the TLD
Your sheet has "acme" in column C instead of "acme.com" — someone stripped the domains when copying from LinkedIn.
Before enriching, fix every value in column C 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. Apollo needs them split.
Split the full name in column A into first name and last name. Put first name in column A and write last name into a new column B, shifting the 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 now want to filter before burning enrichment credits.
First enrich the company domain in column C 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 sheet.
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 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 the list and enriching it are one operation. You do not need to fix the sheet first, then come back and run enrichment.
Try It
Get the 7-day free trial of SheetXAI and open any sheet of raw prospect names, then ask it to enrich the rows from Apollo. The Apollo integration is included in every SheetXAI plan. For related workflows, see how to bulk-create contacts in Apollo from a sheet or the Apollo in Google Sheets overview.