The Scenario
A new SDR joined the team on Monday. Her manager told her to build a prospecting list: VP-level and above at SaaS companies with 200 to 1000 employees in North America, 100 contacts, ready for import into Salesloft by Wednesday. She has ZoomInfo access. She has never built a list from a spreadsheet before. The usual path is to filter in the ZoomInfo UI, export a CSV, open it, delete the columns she doesn't need, rename the headers to match the Salesloft import template, and then discover that the export had 140 results but 40 of them are duplicates or international.
The bad version:
- Build the ZoomInfo search filter, realize the UI has 12 filter options that interact with each other in non-obvious ways, and spend 45 minutes getting the criteria right
- Export 140 results, open the CSV, delete 8 columns, rename 5 headers, remove 40 rows that don't meet the criteria, and get to 100
- Import into Salesloft and have 12 rows bounce on validation because the phone field format doesn't match what the importer expects
The list was supposed to take an afternoon. It took two days and is still not clean.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. You describe the criteria in plain language, it queries ZoomInfo, and writes the results directly into the sheet in whatever column structure you specify.
Search ZoomInfo for contacts with job titles containing VP or Vice President at SaaS companies with 200 to 1000 employees in North America and write the top 100 results — first name, last name, title, company, direct email, and phone — into this Sheet starting at row 2
What You Get
- Row 2 onward: 100 contacts matching the specified criteria
- Columns: FirstName, LastName, Title, Company, DirectEmail, Phone (or whatever headers you name in the prompt)
- Results are deduplicated before writing — no duplicate contacts from the same company
What If the Data Is Not Quite Ready
I need the column headers to match a specific Salesloft import template exactly
Search ZoomInfo for VP-level and above contacts at SaaS companies with 200–1000 employees in North America — write results into this Sheet with these exact column headers: First Name, Last Name, Job Title, Company Name, Email Address, Mobile Phone — limit to 100 results and deduplicate by email
I want to exclude contacts from companies that are already in our CRM
Pull a ZoomInfo search for VP and above contacts at SaaS companies with 200–1000 employees in North America — write 100 results into this Sheet — then check column H for a list of company names already in our CRM and remove any row where the company matches one in column H before finalizing the list
I want to split the results into tiers based on company size
Search ZoomInfo for VP-level contacts at SaaS companies with 200–1000 employees in North America — write 100 results into this Sheet — then add a Tier column: Enterprise for companies with 500–1000 employees, Mid-Market for 200–499 employees
Full list build plus a draft email opener for each contact in one shot
Search ZoomInfo for VP and above contacts at SaaS companies with 200–1000 employees in North America — write 100 results into this Sheet with columns for name, title, company, email, phone — then write a one-sentence personalized opening line in the final column referencing the contact's title and company
The list is ready to import and the first email is already written.
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet — ask it to pull a fresh ZoomInfo contact search matching your ICP criteria and write the results directly into the sheet. Check the hub overview for the full ZoomInfo + Google Sheets workflow guide.