The Scenario
A market research firm is putting together a landscape report on UK business media. One deliverable is a structured worksheet listing every significant business news source in the country — domain, name, traffic estimate, and category — so the client can cross-reference against their media buying data.
The analyst assigned to this has been searching the Perigon source directory by hand, scrolling page by page, copying rows into an Excel worksheet.
It's taken two days. The list is still incomplete. The client is asking for a preview.
The bad version:
- Filter Perigon source directory to "Business" category, United Kingdom. Browse page by page. Copy visible rows into the worksheet. Scroll. Repeat.
- Realize the copy-paste loses the column structure halfway through — the traffic estimate ended up merged with the domain column.
- Reconcile the pasted data, remove duplicates from overlapping page views, verify the country field didn't get dropped on some rows.
The client wants comprehensive coverage, not a hand-curated sample.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. Through its Perigon integration, it calls the source directory endpoint with your filters and writes the full result set into your workbook.
List Perigon news sources filtered to "Business" category in the United Kingdom and populate my Excel UK Business Media sheet with source name, domain, category, and monthly traffic estimate.
What You Get
- Every matching Perigon source as a separate row in the UK Business Media worksheet.
- Column A: source name. Column B: domain. Column C: category. Column D: monthly traffic estimate.
- The full result set written in one pass — not a hand-curated sample.
- Ready for client delivery without additional reformatting.
What If the Data Is Not Quite Ready
You need sources across multiple categories
Fetch all Perigon media sources in categories "Business" and "Finance" from the United Kingdom. Combine the results, remove any duplicate domains, and write source name, domain, category, and traffic estimate to the UK Media worksheet.
The category and country should be read from the workbook
Read the category filter from cell B1 and the country filter from cell B2 in the Config worksheet. Fetch all matching Perigon media sources and write source name, domain, category, and traffic estimate to the Sources worksheet.
You want to cross-reference against an existing source list
Fetch all Perigon media sources in category "Business" from the United Kingdom. For each source, check if the domain appears in column B of the Existing Sources worksheet. Write source name, domain, category, and traffic estimate to the New Sources worksheet. In column E, mark "existing" if the domain was already present, or "new" if it wasn't.
Pull sources, filter by traffic tier, and summarize gaps against a media buy list in one pass
Fetch all Perigon media sources in category "Business" from the United Kingdom. Write source name, domain, category, and traffic estimate to the Sources worksheet. Flag sources where the domain does not appear in column B of the Media Buy worksheet in column E. Count flagged sources and write the total to cell B1 of the Summary worksheet.
One prompt handles the data pull, the cross-reference, and the count.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook where you're building a media landscape or source directory analysis, then ask it to pull the matching Perigon sources. See the full Perigon integration overview or explore running a Perigon semantic news search into an Excel workbook.