The Scenario
The demand gen manager on your team built a target account list two weeks ago. Fifty companies. Good firmographic fit. The problem is that "firmographic fit" doesn't tell you which of those 50 accounts is actually researching your category right now. You want intent scores from ZoomInfo — specifically for the topics "CRM software" and "sales automation" — so you can stop spreading budget evenly and start concentrating it where the signal is.
The bad version:
- Open ZoomInfo, navigate to the intent data view, search each company name one at a time, note the intent score for each topic, and copy it into the sheet by hand
- Realize halfway through that ZoomInfo's intent view shows aggregate scores, not the per-topic breakdown you need, and spend time figuring out how to get the data you actually want
- Finish the exercise with a sheet full of numbers that nobody on the demand gen team has time to interpret before the campaign goes live tomorrow
Intent data that arrives after the budget decision is decorative.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads your account list, queries ZoomInfo for intent signals on the topics you specify, and writes the scores back into the sheet — ready for sorting.
For each company name in column A, enrich with ZoomInfo intent data for topics CRM software and sales automation, and write the intent score and signal count for each topic into columns B, C, D, and E
What You Get
- Column B: intent score for "CRM software"
- Column C: signal count for "CRM software"
- Column D: intent score for "sales automation"
- Column E: signal count for "sales automation"
- Rows with no detectable intent data receive a blank cell rather than a zero, so you can filter accurately
What If the Data Is Not Quite Ready
I want a combined score and a priority label, not raw numbers
For each company in column A, pull ZoomInfo intent signals for CRM software and sales automation — write individual scores into B and C — then calculate a combined intent score (sum of both) in column D and label rows HIGH PRIORITY in column E if the combined score is above 70, MEDIUM if 40–70, and LOW if below 40
The company names in my sheet are inconsistent with how ZoomInfo identifies them
Before enriching intent data, attempt to match each company name in column A to a verified ZoomInfo company record and write the normalized company name into column B — then pull intent scores for CRM software and sales automation into columns C through F for the matched records
I want to sort the sheet after enrichment so the highest-signal accounts are on top
Enrich all 50 accounts in column A with ZoomInfo intent data for CRM software and sales automation — write intent scores into columns B and C — then sort the sheet by the combined score descending and mark the top 15 rows HIGH PRIORITY in column D
Full enrichment plus a campaign-ready brief in one prompt
For each company in column A, pull ZoomInfo intent scores for CRM software and sales automation into B and C, compute the combined score in D, assign a priority tier in E, and for each HIGH PRIORITY account pull the most recent news headline from ZoomInfo and write it into column F — so the team has both signal and a conversation opener in one sheet
That final prompt is the one you send to leadership when they ask why this account is getting the budget.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet with your target account list — ask it to enrich each row with ZoomInfo intent signals for the topics your category competes on. Link to the hub overview for the full ZoomInfo + Google Sheets integration guide.