The Scenario
Your SDR team's weekly cadence kicks off Monday and they need a conversation opener for each of the 60 accounts on the call list. Nobody wants to cold-open with product features. The playbook says to lead with something timely — a recent funding round, an executive hire, a market expansion. You know ZoomInfo has news data for each company. The problem is that pulling it row by row from the UI for 60 accounts is three hours of work that nobody put on any calendar.
The bad version:
- Open ZoomInfo, search each company, navigate to the news section, find the most recent headline, copy the headline and date, switch back to the sheet, paste into the correct row
- Repeat 60 times — or until you lose your place and have to cross-reference the list to figure out which company you were on
- Finish and realize two of the news items are from 14 months ago and are no longer useful as conversation openers
Three hours of enrichment work for a conversation opener is not a sustainable unit economics for an SDR team.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads the company list, queries ZoomInfo for the most recent news for each account, and writes the headline, publication date, and summary back into adjacent columns.
For each company in column A, fetch the most recent ZoomInfo news article and write the headline, publication date, and summary into columns B, C, and D
What You Get
- Column B: news headline text
- Column C: publication date
- Column D: short summary of the article
- Rows where no news is found within the last 90 days receive a NO RECENT NEWS flag in column E
What If the Data Is Not Quite Ready
I only want news from the last 60 days — anything older is not useful for outreach
For each company in column A, fetch the most recent ZoomInfo news article published within the last 60 days and write the headline into B, publication date into C, and summary into D — if the most recent article is older than 60 days, write STALE in column E instead
I want a ready-to-use opener sentence, not just the headline
For each company in column A, pull the most recent ZoomInfo news headline and date into B and C — then write a one-sentence conversation opener in column D that references the headline in first person as if an SDR is opening an email: for example, Saw that [Company] recently [news item] — wanted to reach out because...
Some companies in my list go by different names than what ZoomInfo indexes
Try to match each company name in column A to a verified ZoomInfo company record — write the matched name in column B — then fetch the most recent news headline into C and publication date into D; flag MATCH UNCLEAR in column E for any rows where the company could not be confidently identified
Full news enrichment plus seniority-matched contacts in one shot
For each company in column A, pull the most recent ZoomInfo news headline and date into columns B and C — then search ZoomInfo for one Director-or-above contact at each company and write their name, title, and email into columns D, E, and F — so each row has both the opener and the person to send it to
That final prompt is a complete outreach-ready row for every account on the list.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with a list of target accounts — ask it to fetch the most recent ZoomInfo news for each company so your team has a timely hook before the first call goes out. See the hub overview for other ZoomInfo + Google Sheets workflows.