The Scenario
You're a journalist at a media outlet and your editor has handed you a fact-check assignment with a four-hour window. Column A of a Google Sheet has 60 factual claims pulled from a source document — statistics, attribution statements, historical dates, organizational claims. Your job is to find the top supporting or contradicting source for each one and record the headline and URL.
You've done this before by hand. It took two days and you still missed four.
The bad version:
- Copy claim from A2. Paste into a search engine. Read the first three results. Decide which is most relevant. Copy its headline into B2 and its URL into C2.
- Move to A3. Repeat. For 60 rows.
- The last 20 claims got sloppy sources because you were running out of time and started accepting whatever ranked first.
Sixty claims, done carefully, is a full day of work. Done at deadline pace, it's the kind of thing that ends up in a correction.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads each claim in column A, runs a Tavily web search to find the most relevant source, and writes the result title and URL directly into columns B and C.
For each claim in column A (rows 2 through 61), search Tavily for evidence and write the top result's title to column B and its URL to column C. If no relevant source is found, write "NO SOURCE FOUND" in column B.
What You Get
- Column B: the title of the most relevant source Tavily finds for each claim.
- Column C: the URL of that source.
- Claims with no relevant result flagged as "NO SOURCE FOUND" in column B.
- All 60 claims processed in a single pass — search quality stays consistent through row 60.
What If the Data Is Not Quite Ready
Some claims are too vague to search effectively — they need a clarifying keyword appended
For each claim in column A, also read column B which has a subject keyword (e.g., "climate", "GDP", "elections"). Combine the claim text and the subject keyword as the Tavily search query. Write the top result title to column C and its URL to column D.
You want to flag whether the source supports or contradicts the claim
For each claim in column A, search Tavily and write the top result title to column B and URL to column C. In column D, write "SUPPORTS" if the source appears to confirm the claim, "CONTRADICTS" if it challenges it, or "UNCLEAR" if the relevance is ambiguous.
You need multiple sources per claim, not just the top one
For each claim in column A, search Tavily and write the top 3 result titles to columns B, C, and D, and their corresponding URLs to columns E, F, and G. Write "NO SOURCE" if fewer than 3 results are returned.
Full verification pass: multi-source, stance labeling, and gap flagging in one shot
For each claim in column A, search Tavily. Write the top result's title to column B and URL to column C. Write a second source's title to column D and URL to column E. In column F, write "SUPPORTS", "CONTRADICTS", or "UNCLEAR" based on the retrieved sources. Write "NEEDS MANUAL REVIEW" in column F for any claim where no relevant source was found.
One prompt builds the full verification layer — consistent quality, no deadline drift.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with a column of claims, statements, or data points, then ask it to find supporting sources for each row via Tavily. See also bulk enrichment with search results and the hub overview.