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 slide was assembled by hand — someone spent an afternoon reading through 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 the story cluster results, screenshot the interesting ones, paste the titles into a spreadsheet.
- Repeat for "embedded finance." Realize the cluster counts from the first search and the second search 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 you need to surface. The sorting alone takes longer than the content team will spend looking at the sheet.
You are supposed to be a content strategist, not a data entry clerk with a good eye for financial technology news.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It connects to Perigon's story cluster endpoint and writes the results — cluster title, article count, top source, and date — directly into your sheet.
Fetch Perigon story clusters for the query "open banking" from the last 30 days, sorted by article count descending, and write the top 20 to the Trending Stories sheet with cluster title, article count, top source, and date.
What You Get
- Rows 1-20 in the Trending Stories sheet, each representing one story cluster.
- Column A: cluster title. Column B: article count. Column C: top publishing source. Column D: first published date.
- Sorted by article count descending — highest traction at the top.
- Ready to hand off to the planning session without additional reformatting.
What If the Data Is Not Quite Ready
You need clusters for two separate topics merged into one sorted list
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 Trending Stories sheet with cluster title, article count, and date.
The date range should come from the sheet, not the prompt
Read the start date and end date from cells B1 and B2 in the Config sheet. Fetch Perigon story clusters for "open banking" within that date range, sorted by article count descending, and write the top 20 to the Trending Stories sheet with cluster title, article count, top source, and date.
You want to flag clusters your team already covered last quarter
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 sheet. Write the results to the Trending Stories sheet and mark column E with "covered" for any match.
Pull clusters, identify content gaps, and draft suggested angles in one shot
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 sheet. In the Trending Stories sheet, write cluster title, article count, and date. In column E, note "covered" or "gap". For the top 5 gaps, add a suggested content angle in column F based on the cluster title.
Ask for the data pull and the editorial judgment in the same prompt — SheetXAI handles the lookup logic inline.
Try It
Get the 7-day free trial of SheetXAI and open any content planning sheet 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 sheet.