The Scenario
A RevOps analyst pulled a CRM export last Tuesday: 300 contacts with name, company, and job title — but missing direct email or phone for 189 of them. The data went in years ago when the rep only needed the company name to log the call. Now the team is trying to reactivate the list and half the records are useless for outreach. ZoomInfo can fill in the gaps. The question is how to do it for 189 rows without spending two days in the ZoomInfo UI.
The bad version:
- Search each of the 189 contacts by name and company in ZoomInfo, find the matching profile, copy the direct email and phone, switch back to the sheet, find the correct row, paste
- Discover on contact 45 that the CRM stored the company under an old name and ZoomInfo doesn't return a confident match, and spend time guessing the current legal entity name
- Finish at row 120, call it close enough, and submit a list that's still 35 percent incomplete
A reactivation list that's 35 percent incomplete is not a reactivation campaign.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads the contacts where the email column is blank, searches ZoomInfo for each one, and writes in the missing fields — without touching rows that are already complete.
For each row in this Sheet where column D (DirectEmail) is blank, search ZoomInfo using the first name, last name, and company columns and write the found email into column D and phone into column E
What You Get
- Column D: direct email filled in for rows where it was previously blank
- Column E: direct phone or mobile filled in for the same rows
- Rows where ZoomInfo returns no match receive a NOT FOUND flag in column F so they can be reviewed separately
- Already-complete rows are untouched
What If the Data Is Not Quite Ready
Some company names in the CRM export are outdated or informal
For each row where column D is blank, attempt to match the company name in the company column to a verified ZoomInfo company record — write the normalized company name into column G — then search for the contact and write direct email into D and phone into E; flag COMPANY UNCLEAR in column F if the company cannot be confidently matched
I also want to update job titles that may have changed since the record was created
For each row where column D (DirectEmail) is blank OR column C (JobTitle) was last updated more than 18 months ago, search ZoomInfo using first name, last name, and company — write the current job title into C, direct email into D, and phone into E; flag NOT FOUND in column F for no-match rows
I want to run the enrichment for all 300 rows, not just the ones missing email
For all 300 contacts in this Sheet, search ZoomInfo and write current job title into C, direct email into D, and mobile phone into E — mark ENRICHED in column F if data was found, NOT FOUND if no match
Full enrichment plus a priority flag based on title seniority in one shot
Enrich all 300 contacts in this Sheet with ZoomInfo — write job title into C, direct email into D, phone into E, enrichment status into F — then add a Priority column in G: High if the title contains VP, Director, or C-level; Low otherwise — and sort so High rows appear first
That final output is a reactivation list sorted by the contacts most likely to respond.
Try It
Get the 7-day free trial of SheetXAI and open the CRM export sheet with missing contact data — ask it to use ZoomInfo to fill in direct email and phone for every row where those fields are blank. The hub overview covers all ZoomInfo + Google Sheets workflows.