The Scenario
You are a sales development rep. It is 7:45 AM on a Monday and your team is uploading a new batch to Salesforce at 9 AM sharp. Your manager has already slacked you twice.
You have 500 prospect rows in a Google Sheet, first name, last name, and company domain, collected from a trade show over the weekend. Every row needs a verified work email before the upload. Without a valid email, the lead goes into Salesforce incomplete and sits in a queue nobody works.
The bad version of this morning:
- You export the sheet and upload it to Icypeas's web app
- Icypeas returns results, you download the CSV
- You open a second tab and paste the emails back into the original sheet, column by column
- A dozen rows come back with no match, so you manually flag them
- You realize the confidence scores are in a separate column in the export and do not align with your original row order
- You spend forty minutes on reconciliation
- You miss the 9 AM Salesforce window.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet that talks to Icypeas directly, so you never have to leave the sheet or touch a CSV export.
Open the SheetXAI sidebar and type:
Take every row in this sheet (columns: First Name, Last Name, Domain), run an Icypeas bulk email search, then write the found email and confidence score into columns D and E. If no email is found for a row, write "Not found" in column D and leave column E blank.
SheetXAI reads all 500 rows, calls Icypeas's bulk email search, maps each result back to the correct row, and writes the emails and confidence scores in place. No download, no reconciliation, no re-upload. When it finishes, your sheet is Salesforce-ready.
What You Get
A fully enriched sheet with 500 rows updated in one pass:
- Column D (Email) — the found professional work email, or "Not found" where Icypeas had no match
- Column E (Confidence Score) — Icypeas's confidence rating per result, so you can decide which rows to act on immediately and which to skip
- Row alignment — every result written back to the exact row it came from, no manual reconciliation
The confidence score is actionable, not decorative. A score below a threshold you set means you hold that lead out of the Salesforce upload. A score above it goes straight in.
You can also tell SheetXAI to filter the output before writing. Ask it to skip rows below a confidence threshold and flag them in column F, and it will.
What If the Data Is Not Quite Ready
Most real prospect lists are not clean by the time they land in a sheet. SheetXAI handles cleanup and the Icypeas enrichment in the same prompt.
When the domain column has inconsistent formatting
Some rows have acme.com, some have www.acme.com, some have https://acme.com. Icypeas expects a clean bare domain.
Normalize column C so every domain is a bare domain with no protocol or www prefix. Then run Icypeas bulk email search on every row using First Name, Last Name, and the cleaned domain. Write found emails into column D and confidence scores into column E.
When some rows are missing a domain
You collected contacts from multiple sources and a portion of the rows have a company name in column C but no domain. You do not want those rows to silently return nothing.
For rows where column C contains a company name instead of a domain, write "Missing domain" into column D and skip Icypeas lookup. For all other rows, run Icypeas bulk email search using First Name, Last Name, and Domain and fill in columns D and E.
When you only want high-confidence results uploaded
Your team has a standing rule: only load emails with a confidence score above 70 into Salesforce. You want the filtering to happen in the sheet, not in Salesforce.
Run Icypeas bulk email search on every row using columns A, B, and C. Write the found email into column D and the confidence score into column E. Then add a column F called "Upload Ready" and mark it TRUE if the confidence score is 70 or above, FALSE if lower or if no email was found.
When you have a raw prospect CSV with no prior cleanup and need it Salesforce-ready in one shot
The list came from a vendor. Names are mixed case, some domains have trailing slashes, the company column has both domains and company names mixed together, and a handful of rows are outright duplicates. You have twenty minutes.
Deduplicate this sheet by first name, last name, and domain, keeping the first occurrence of each. Normalize all names to title case. Strip any protocol, www prefix, or trailing slash from column C values that look like domains. For rows where column C looks like a company name rather than a domain, write "Missing domain" into column D. For all remaining rows, run Icypeas bulk email search using First Name, Last Name, and the cleaned domain, and write the email and confidence score into columns D and E. Finally, add a column F called "Upload Ready" with TRUE where confidence is 70 or above and FALSE everywhere else.
The pattern: instead of cleaning the list first, exporting it, enriching it, and reconciling the results, you ask for all of it in one prompt. SheetXAI handles the conditional logic inline, which is what makes the messy-data case faster than the clean-data case used to be.
Try It
Get the 7-day free trial of SheetXAI and open any sheet with prospect names and domains, then ask it to run Icypeas bulk email search and write the results back in place. The Icypeas integration is included in every SheetXAI plan. For related workflows, see how to verify an existing email list with Icypeas or the Icypeas in Google Sheets overview.