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 select which topics to track.
Your manager said the list should be comprehensive. That means all of it, not a sample.
The bad version:
- Navigate to the Perigon developer docs. Find the topics endpoint. Make a manual API call in Postman. Copy the JSON response. Open your sheet. Paste the raw JSON. Realize Excel and Sheets don't parse JSON on paste — you get a blob in one cell.
- Write a formula or script to parse and flatten the JSON across columns. Spend an hour getting the nested category fields to split correctly.
- Make additional API calls for subsequent pages if the endpoint is paginated.
This is setup work. It shouldn't take the better part of a day.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It connects to the Perigon topics endpoint and writes the complete topic list into your sheet — ID, name, category, subcategory — without you writing a line of API code.
Fetch all available Perigon news topics and write each one to the Topics sheet with columns for topic ID, name, category label, and subcategory label.
What You Get
- One row per Perigon topic in the Topics sheet.
- Column A: topic ID. Column B: topic name. Column C: category label. Column D: subcategory label.
- The complete list — no pagination to manage, no truncated results.
- 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
Fetch all available Perigon news topics and filter to those where the category label is "Technology". Write topic ID, name, and subcategory label to the Tech Topics sheet.
You want to cross-reference against topics already configured in a client sheet
Fetch all available Perigon news topics and write topic ID, name, category, and subcategory to the Full Taxonomy sheet. For each topic, check if the topic ID exists in column A of the Client Config sheet. Mark column E with "active" if it does, "available" if it doesn't.
The sheet already has a partial topic list that needs to be updated
Clear all rows in the Topics sheet below row 1. Fetch all available Perigon news topics and write topic ID, name, category label, and subcategory label to the Topics sheet — one row per topic.
Pull the full taxonomy, flag high-priority categories, and generate a coverage gap summary in one pass
Fetch all available Perigon news topics. Write topic ID, name, category, and subcategory to the Full Taxonomy sheet. Flag rows where the category matches any value in column A of the Priority Categories sheet by marking column E with "priority". Count how many priority-category topics are not in column A of the Client Config sheet and write that number to cell B1 of the Summary sheet.
One prompt handles the full pull, the cross-reference, and the gap count.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet 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.