The Scenario
You're a media monitoring analyst at a news intelligence firm. You've been asked to build a topic taxonomy for a new client dashboard — a structured list of every topic in the Perigon system, with ID, name, category, and subcategory, so the client's team can configure which topics to track.
Your manager said the list should be comprehensive. That means all of it.
The bad version:
- Navigate to the Perigon developer docs. Find the topics endpoint. Make a manual API call. Copy the JSON response. Open Excel. Paste the raw JSON. Get a blob in one cell because Excel doesn't parse JSON on paste.
- Write a Power Query formula to flatten the nested JSON into columns. Spend an hour getting the category and subcategory fields to split correctly.
- Handle pagination if the endpoint returns results in batches.
This is setup work. It should not take most of a day.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It connects to the Perigon topics endpoint and writes the complete topic list — ID, name, category, subcategory — into your workbook without you writing a line of API code.
Pull the complete list of Perigon topics and populate my Excel Topic Taxonomy sheet with topic ID, topic name, and both category and subcategory label columns.
What You Get
- One row per Perigon topic in the Topic Taxonomy worksheet.
- Column A: topic ID. Column B: topic name. Column C: category label. Column D: subcategory label.
- The complete list with no pagination to manage.
- Ready to use as a filter reference for a dashboard or reporting template.
What If the Data Is Not Quite Ready
You only want topics in a specific category
Pull all available Perigon topics and filter to those where the category label is "Business". Write topic ID, name, and subcategory label to the Business Topics worksheet.
You want to cross-reference against topics already configured in a client worksheet
Pull all available Perigon topics and write topic ID, name, category, and subcategory to the Full Taxonomy worksheet. For each topic, check if the topic ID exists in column A of the Client Config worksheet. Mark column E with "active" if it does, "available" if it doesn't.
The worksheet already has a partial topic list that needs replacing
Clear all rows in the Topic Taxonomy worksheet below row 1. Pull all available Perigon topics and write topic ID, name, category label, and subcategory label — one row per topic.
Pull the full taxonomy, flag priority categories, and generate a coverage gap summary in one pass
Pull all available Perigon topics. Write topic ID, name, category, and subcategory to the Full Taxonomy worksheet. Flag rows where the category matches any value in column A of the Priority Categories worksheet by marking column E with "priority". Count how many priority-category topics are not in column A of the Client Config worksheet and write that number to cell B1 of the Summary worksheet.
One prompt handles the full pull, cross-reference, and gap count.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook where you're setting up a news monitoring configuration or building a topic filter system, then ask it to import the full Perigon topic taxonomy. See the full Perigon integration overview or explore validating company entities against Perigon.