The Scenario
Your content team holds a planning session every other Thursday. The format is always the same: someone presents trending topics, the group votes on what to pursue, and the calendar gets updated. Last cycle the trending topics were assembled by hand — someone spent an afternoon reading news sites and compiling story clusters into a deck.
You inherited that job this cycle. You have two days.
The bad version:
- Search Perigon manually for "open banking" — browse through story cluster results, screenshot the interesting ones, paste titles into an Excel worksheet.
- Repeat for "embedded finance." Realize the cluster counts from the first search and the second use different date ranges.
- Spend another hour trying to sort the combined list by article count so the most traction-heavy stories appear first.
There are 20 clusters to surface. The sorting alone takes longer than the content team will spend looking at the worksheet.
You are supposed to be a content strategist, not a data entry clerk.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It connects to Perigon's story cluster endpoint and writes results — cluster title, article count, top source, and date — directly into your workbook.
Pull Perigon story clusters related to "AI regulation" and "large language models" from the last 2 weeks and populate my Excel Content Ideas sheet with story name, article count, and publication date — one row per cluster.
What You Get
- One row per story cluster in the Content Ideas worksheet.
- Column A: story cluster name. Column B: article count. Column C: publication date of earliest article in the cluster.
- Combined results across both topic queries in a single worksheet.
- Ready to sort and hand off to the planning session.
What If the Data Is Not Quite Ready
You need clusters for two separate topics merged and sorted
Fetch Perigon story clusters for both "open banking" and "embedded finance" from the last 30 days. Combine all results, remove duplicates by cluster title, sort by article count descending, and write the top 20 to the Content Ideas worksheet with cluster title, article count, and date.
The date range should come from the workbook, not the prompt
Read the start date and end date from cells B1 and B2 in the Config worksheet. Fetch Perigon story clusters for "open banking" within that date range, sorted by article count descending, and write the top 20 to the Content Ideas worksheet with cluster title, article count, top source, and date.
You want to flag clusters your team already covered
Fetch the top 20 Perigon story clusters for "open banking" from the last 30 days. For each cluster title, check if it appears anywhere in column A of the Previously Covered worksheet. Write the results to the Content Ideas worksheet and mark column D with "covered" for any match.
Pull clusters, identify content gaps, and draft suggested angles in one pass
Fetch the top 20 Perigon story clusters for "open banking" from the last 30 days sorted by article count. For each cluster, check column A of the Previously Covered worksheet. In the Content Ideas worksheet, write cluster title, article count, and date. In column D, note "covered" or "gap". For the top 5 gaps, add a suggested content angle in column E based on the cluster title.
Ask for the data pull and the editorial judgment in the same prompt.
Try It
Get the 7-day free trial of SheetXAI and open any Excel content planning workbook with topic keywords in a column, then ask it to pull this month's Perigon story clusters. Explore the full Perigon integration overview or see how to pull raw news coverage into a workbook.