The Scenario
You're a market analyst at a fintech consultancy. A client has asked for a briefing on "central bank digital currency adoption in emerging markets" — specifically, which publications are covering it, what angles are getting traction, and which articles are worth reading.
The problem is that keyword search on this topic returns a lot of noise. Articles that mention "central bank" and "digital" and "emerging markets" in the same piece but aren't really about CBDC adoption at all. What you actually need is semantic relevance — the 50 articles that are most conceptually on-topic, not the ones that happen to share three keywords.
The bad version:
- Run a Perigon keyword search with broad terms. Get 400 results. Open each one. Skim. Decide whether it's actually relevant.
- Build a shortlist of 50 manually. This takes most of the morning.
- Paste titles, sources, and URLs into a sheet. Format columns. Remove duplicates.
You have a client call in two hours. You need the briefing sheet ready before then.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. Through its Perigon integration, it can run a vector search against Perigon's news index and return results ranked by semantic relevance — then write them directly into your sheet.
Use Perigon vector search with the query "central bank digital currency adoption in emerging markets" and write the top 50 results to the Research sheet with title, source, date, summary, and URL.
What You Get
- 50 rows in the Research sheet, each representing one semantically relevant article.
- Column A: title. Column B: source name. Column C: published date. Column D: article summary. Column E: URL.
- Results ranked by semantic relevance to your query — not by keyword overlap.
- Ready for review and delivery without additional filtering.
What If the Data Is Not Quite Ready
The query should be read from a cell in the sheet
Read the research query from cell B1 of the Config sheet. Use Perigon vector search with that query and write the top 50 results to the Research sheet with title, source, date, summary, and URL.
You want to filter results to a specific date window
Use Perigon vector search for "central bank digital currency adoption in emerging markets". Filter results to articles published in the last 60 days. Write the top 30 matching results to the Research sheet with title, source, date, summary, and URL.
You need to deduplicate against articles already in the sheet
Use Perigon vector search for "central bank digital currency adoption in emerging markets" and retrieve the top 50 results. For each result, check if the URL already exists in column E of the Existing Research sheet. Write only new articles to the Research sheet — title, source, date, summary, and URL.
Pull semantic search results, cross-reference sources, and rank by coverage depth in one pass
Use Perigon vector search for "central bank digital currency adoption in emerging markets". Retrieve the top 100 results. Deduplicate by source domain — keep only the highest-ranked article per domain. Write the final set to the Research sheet with title, source, date, summary, and URL. In column F, note how many total results that source had in the original 100.
Ask for the search, deduplication, and source frequency analysis in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet where you're building a research brief or monitoring a complex topic, then ask it to run a Perigon semantic search and populate the results. See the full Perigon integration overview or explore importing Perigon story clusters for content planning.