Back to Perigon in Google Sheets
SheetXAI logo
Perigon logo
Perigon · Google Sheets Guide

Build a One-Shot Research Brief in a Google Sheet Using Perigon and Wikipedia

2026-05-14
5 min read

The Scenario

A strategy consultant is preparing a client briefing on "quantum computing commercialization." The deliverable is a single structured sheet: the 10 most recent news articles on the topic from credible sources, plus the 3 most relevant Wikipedia pages for background context — all in one place, ready to send.

The consultant has done this kind of briefing before. The usual process is to search news sources separately, then do a Wikipedia search separately, then combine everything into a sheet with consistent column formatting.

This one is due before the afternoon call.

The bad version:

  • Run a Perigon search for "quantum computing commercialization." Copy article titles, sources, and URLs into the sheet manually — 10 rows.
  • Switch to Wikipedia. Search the same topic. Find 3 relevant pages. Copy page titles and URLs.
  • Merge the two data sources into one sheet with consistent columns — type (article vs. wiki), title, source/publication, and URL. Realize the column naming doesn't match between what you pasted from Perigon and what you typed for Wikipedia.

You have 90 minutes before the call. You've spent 40 of them on data formatting.

The Easy Way: One Prompt in SheetXAI

SheetXAI is an AI agent that lives inside your Google Sheet. It can run a Perigon article search and a Wikipedia search in the same prompt and write both result sets into your sheet with a shared column structure.

Search Perigon for the 10 most recent articles on "quantum computing commercialization" and also search Wikipedia for the top 3 relevant pages on the topic, then write all results to a Research Brief sheet with type (article/wiki), title, source, and URL.

What You Get

  • 13 rows in the Research Brief sheet: 10 articles and 3 Wikipedia pages.
  • Column A: type — "article" or "wiki". Column B: title. Column C: source or publication name. Column D: URL.
  • Both data sources formatted consistently in one pass.
  • Ready to drop into a client-facing document or send directly.

What If the Data Is Not Quite Ready

The research topic should be read from the sheet, not the prompt

Read the research topic from cell B1 of the Config sheet. Search Perigon for the 10 most recent articles on that topic and search Wikipedia for the top 3 relevant pages. Write type, title, source, and URL to the Research Brief sheet.

You want a date filter on the news articles

Search Perigon for the 10 most recent articles on "quantum computing commercialization" published in the last 90 days. Also search Wikipedia for the top 3 relevant pages. Write type, title, source, and URL to the Research Brief sheet.

The sheet has a previous briefing that needs to be replaced

Clear all rows in the Research Brief sheet below row 1. Search Perigon for the 10 most recent articles on "quantum computing commercialization" and Wikipedia for the top 3 relevant pages. Write type, title, source, and URL — articles first, then Wikipedia entries.

Pull news and Wikipedia results, add a one-line summary for each, and flag the highest-authority sources in one pass

Search Perigon for the 10 most recent articles on "quantum computing commercialization" and Wikipedia for the top 3 relevant pages. Write type, title, source, date, and URL to the Research Brief sheet. In column F, add a one-sentence summary for each entry. For Perigon articles from sources with high domain authority, mark column G with "authority source".

One prompt assembles the brief and adds editorial context without a second pass.

Try It

Get the 7-day free trial of SheetXAI and open any Google Sheet you use for client or internal research briefs, then ask it to pull Perigon articles and Wikipedia pages on your topic in one go. See the full Perigon integration overview or explore running a Perigon Wikipedia semantic search.

Stop memorizing formulas.
Tell your spreadsheet what to do.

Join 4,000+ professionals saving hours every week with SheetXAI.

Learn more