The Scenario
A BDR on your team put together a Google Sheet with 50 target company names — Fortune 1000 firms they want to penetrate this quarter. The goal is CISOs and VPs of Security. No contacts, no emails, just company names and the titles they want to reach.
Your manager just asked who's building the list. Nobody volunteered. Now it's yours.
The bad version:
- Open RocketReach people search, type the first company name, filter by "CISO" or "VP Security," read through the results, copy the top three contacts' names, titles, and emails into the sheet one by one, move to the next company.
- Company 8: RocketReach returns 12 results. You're not sure which three are most relevant. You copy the first three and keep going.
- Company 22: the search returns no results for the exact company name. You try a variation. You get results for a different company. You skip it.
Building a prospecting list from scratch is legitimate work. But it's the kind of work that collapses into a grind the moment you have to repeat the same lookup pattern 50 times by hand.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your list of target companies and uses RocketReach people search to populate contacts directly into your sheet. Open the SheetXAI sidebar:
Here is the prompt for this task:
For each company name in column A of my 'Search Targets' sheet, search RocketReach for people with 'CISO' or 'VP Security' in their title and write the top 3 results' names, titles, and emails into rows below
What You Get
- For each company, up to 3 matching contacts written into rows below the company header row (or into a separate results tab, depending on your preference).
- Name, title, and verified email for each result.
- Companies that returned no matches are noted so you know which ones need alternate targeting.
What If the Data Is Not Quite Ready
The company names have inconsistent formatting
For each company name in column A of my 'Search Targets' sheet, clean any trailing punctuation or legal suffixes like Inc., LLC, or Corp. before searching RocketReach — then write the top 3 CISO or VP Security contacts' names, titles, and emails into the rows below each company name
You want results written to a separate output sheet instead of inline
Search RocketReach for people with 'CISO' or 'VP Security' at each company in column A of my 'Search Targets' sheet — write each result as a new row in my 'Prospect Output' sheet with company name in column A, contact name in column B, title in column C, and email in column D
You want to expand the title search to catch variant naming
For each company in column A of my 'Search Targets' sheet, search RocketReach for people whose title contains any of these terms: CISO, Chief Information Security, VP Security, VP of Security, Head of Security — write the top 3 results per company to rows below, with name, title, and email
Build the list, deduplicate, and flag existing pipeline contacts in one shot
For each company in column A of my 'Search Targets' sheet, search RocketReach for CISO or VP Security contacts and write the top 3 results per company into my 'Prospect Output' sheet — then check each email against my 'Active Pipeline' sheet and flag any matches as "Already In Pipeline" in column E
One prompt builds the list, writes it to the output sheet, and cross-references your existing pipeline before you ever open the results.
Try It
Open a Google Sheet with target company names and job titles you want to reach, then Get the 7-day free trial of SheetXAI and ask it to build your prospect list using RocketReach people search. Also see the spoke on resolving company names to verified domains, or the hub overview for all the ways to connect RocketReach to Google Sheets.