The Scenario
It's Monday morning. Your director of communications has asked for the weekly share-of-voice report by 10 AM. You open your browser and start a Perigon search for your brand and your three main competitors — filters set to the past 7 days, sorted by date. The results come back. Now you need 150-odd articles in an Excel workbook with headline, source, date, and URL in separate columns before the meeting.
The bad version:
- Export the Perigon results to CSV, import into Excel using the data import wizard, realize the date column is formatted as a Unix timestamp, spend 15 minutes converting it.
- Do the same for competitor 2. Competitor 3. Align the column headers across three separate paste operations because Perigon's export includes fields you don't need.
- Write formulas to calculate share-of-voice percentages across the raw row count.
Three sources, 150 rows, two hours of your morning gone before you've written a single line of commentary.
This report goes to your VP every Monday. You cannot keep spending a third of the day on the data plumbing.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your workbook and, through its built-in Perigon integration, pulls news article data and writes it directly into your workbook — no export, no import, no column formatting.
Pull news articles from Perigon for the keywords in cells A1:A5 of my Excel sheet, filtered to the last 14 days, and populate a News Feed sheet with title, source name, published date, sentiment, and article URL.
What You Get
- Each matching article lands as a new row in the News Feed worksheet.
- Column A: title. Column B: source name. Column C: published date in readable format. Column D: Perigon sentiment score. Column E: article URL.
- If Perigon returns no results for one of the keywords, that keyword simply contributes zero rows.
- The worksheet is ready for pivot tables or share-of-voice formulas immediately.
What If the Data Is Not Quite Ready
The competitor names are in cells, not typed out in the prompt
Read the competitor names from cells A1:A5 of my Excel sheet, then fetch all Perigon news articles from the last 7 days mentioning any of those terms and write the results to the Coverage worksheet with columns for headline, source name, published date, and URL.
The results include articles that mention the brand only in passing
Fetch Perigon articles from the last 7 days mentioning "Acme Corp" OR "BetaCo" in the headline specifically, not just the body, and write headline, source, published date, and URL to the Coverage worksheet.
You need sentiment alongside the coverage data
Fetch Perigon news articles from the last 7 days for the terms in column A of my Excel sheet. Write headline, source, published date, Perigon sentiment score, and URL to the Coverage worksheet. Flag rows where sentiment is negative by marking column F with "negative".
Clean up stale rows, pull fresh data, and summarize in one pass
Delete all rows in the Coverage worksheet where the published date is older than 14 days. Then fetch new Perigon articles from the last 7 days for the keywords in column A. Write headline, source, date, and URL for each result. Finally, add a summary row at the top counting articles per competitor.
The underlying pattern: cleanup and fresh pull in one instruction, so you never end up with a workbook that's half old and half new.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook where you're tracking brand or competitor keywords, then ask it to pull this week's Perigon coverage. See the full Perigon integration overview or explore enriching journalist contacts from a press list.