The Scenario
A market research firm is putting together a landscape report on US technology media. One deliverable is a structured sheet listing every significant tech news source in the country — domain, name, traffic tier, and country — so the client can filter and cross-reference against their ad spend data.
The analyst assigned to this task has been searching the Perigon dashboard by hand, scrolling through source listings, copying rows into a spreadsheet.
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 "tech" category, United States. Browse page by page. Copy visible rows into the sheet. Scroll to the next page. Repeat.
- Realize the copy-paste loses the column structure halfway through — traffic tier ended up merged with the domain column.
- Reconcile the pasted data, remove duplicates from overlapping page views, and verify the country field didn't get dropped on some rows.
The client is expecting a comprehensive list, not a hand-curated sample.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. Through its Perigon integration, it can call the source directory endpoint with your filters and write the full result set directly into your sheet.
Fetch all Perigon media sources in category "tech" from the US and write each one to the Sources sheet with columns for domain, source name, country, and traffic rank.
What You Get
- Every matching Perigon source as a separate row in the Sources sheet.
- Column A: domain. Column B: source name. Column C: country. Column D: traffic rank.
- The full result set — not a hand-curated sample — written in one pass.
- Ready for client delivery without reformatting.
What If the Data Is Not Quite Ready
You need sources across multiple categories
Fetch all Perigon media sources in categories "tech" and "science" from the US. Combine the results, remove any duplicate domains, and write domain, source name, category, and traffic rank to the Sources sheet.
The category should be read from the sheet, not typed in the prompt
Read the category filter from cell B1 and the country filter from cell B2 in the Config sheet. Fetch all matching Perigon media sources and write domain, source name, country, and traffic rank to the Sources sheet.
You want to cross-reference against an existing source list
Fetch all Perigon media sources in category "tech" from the US. For each source, check if the domain appears in column A of the Existing Sources sheet. Write domain, source name, country, and traffic rank to the New Sources sheet. In column E, mark "existing" if the domain was already in the list, or "new" if it wasn't.
Pull sources, filter by traffic tier, and summarize coverage gaps in one pass
Fetch all Perigon media sources in category "tech" from the US. Write domain, source name, country, and traffic rank to the Sources sheet. Filter to sources where traffic rank indicates top-500 reach. In column E, flag any source whose domain does not appear in column A of the Client Ad Spend sheet. Count flagged sources and write the total to cell A1 of the Summary sheet.
One prompt handles the data pull, the cross-reference, and the count — no intermediate steps needed.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet where you're compiling a media source directory or landscape analysis, then ask it to pull the matching Perigon sources. See the full Perigon integration overview or explore running a Perigon semantic news search.