The Scenario
The inside sales team at a B2B services company just finished a round of email verification — 60 prospects in a Google Sheet, all with confirmed email addresses in column A. Before the team's calling blitz on Thursday, the manager asked for phone numbers. Nobody has them. The ask landed on you yesterday.
It's Tuesday afternoon.
The bad version:
- Open Emelia's phone-find interface for the first email address, submit the job, wait, come back, copy the result, switch to the sheet, paste it into column B, move to the next row.
- Discover that 14 of the 60 jobs returned nothing, 8 returned "pending" — which means you need to come back and poll them again — and there's no way to tell at a glance which rows still need attention without checking each one.
- Come back Wednesday morning, run the pending 8 again, get 3 more numbers, update 3 cells, manually track the other 5 as "no result."
Sixty contacts. Spread across two sessions. A spreadsheet that still needs interpretation before the team can use it.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It submits Emelia phone-find jobs for your email column, waits for the results, and writes each phone number back to the column you specify.
For each email address in column A of my Google Sheet, initiate an Emelia phone-find job and write the discovered phone number to column B once the job completes
What You Get
- An Emelia phone-find job runs for each email address in column A.
- Column B receives the phone number for every row where Emelia returns one.
- Rows where no phone number is found get "not found" written to column B.
- Rows where the job errors get a note in column B explaining the failure.
- The sales team gets a single sheet they can sort by column B — numbers on top, "not found" rows below.
What If the Data Is Not Quite Ready
Only run phone-find for rows that have been verified
The sheet has both verified and unverified emails. Column C has the verification status and you only want to run phone-find for the "valid" rows.
For every row in my Google Sheet where column C is 'valid', run an Emelia phone-find job using the email in column A and write the discovered phone number to column B
The email column has inconsistent formatting
Some addresses in column A have trailing spaces or odd capitalization that may affect the lookup.
Trim and normalize every email in column A, then run Emelia phone-find for each and write the discovered phone number to column B
You want to flag rows where no phone was found so the team can try a manual LinkedIn lookup
The sales team needs to know which contacts still need attention, not just which ones have numbers.
Run Emelia phone-find for each email in column A, write any discovered phone number to column B, and write 'manual lookup needed' in column C for any row that came back with no result
Verify emails, find phones, and prep the full calling list in one pass
The original list hasn't been verified yet. You want to skip any invalid addresses and only run phone-find for the ones that pass.
Run Emelia email verification on column A, skip any rows that come back invalid, then run phone-find for the valid emails — write the verified status to column B and the phone number (or 'not found') to column C
One prompt produces a calling list where column C tells the team exactly what they have for each contact.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with a column of verified email addresses, then ask it to run Emelia phone-find jobs and populate a phone number column. For related workflows, see Find Emails for a Prospect List or the Emelia hub overview.