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 a Google Sheet with headline, source, date, and URL in separate columns before the meeting.
The bad version:
- Export the Perigon results to CSV, import into the sheet, 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 actual 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 Google Sheet. It reads your sheet and, through its built-in Perigon integration, pulls news article data and writes it directly into your sheet — no export, no import, no column formatting.
Fetch all Perigon news articles from the last 7 days mentioning "Acme Corp" OR "BetaCo" OR "GammaTech" and write each one to the Coverage sheet with columns for headline, source, published date, and URL.
What You Get
- Each matching article lands as a new row in the Coverage sheet.
- Column A: headline. Column B: source name. Column C: published date in readable format. Column D: article URL.
- If Perigon returns no results for one of the terms, that term simply contributes zero rows — no errors, no blank columns.
- The sheet 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 A2:A5 in the Competitors sheet, then fetch all Perigon news articles from the last 7 days mentioning any of those terms and write the results to the Coverage sheet 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 sheet.
You need sentiment alongside the coverage data
Fetch Perigon news articles from the last 7 days for the terms in column A of the Competitors sheet. Write headline, source, published date, Perigon sentiment score, and URL to the Coverage sheet. 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 sheet 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 of the Competitors sheet. 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 run them separately and end up with a sheet that's half old and half new.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet 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.