The Scenario
You're a competitive intelligence analyst and you've spent the last hour building a clean list — 80 competitor product names in column A of an Excel workbook, one per row. The ask from the product team was simple: get the top search result for each one. Title, URL, snippet. Columns B through D.
You know the data exists. Tavily can find it in seconds per query. What you don't have is a way to run 80 queries and write 240 cells without doing it by hand.
The bad version:
- Open the Tavily playground, paste the first product name, copy the title into B2, the URL into C2, the snippet into D2.
- Move to the next row. Repeat. Watch the afternoon disappear.
- Lose your place around row 40, miss three rows, and spend 20 minutes reconciling which rows got filled and which didn't.
Seventy-nine more rows of that isn't analysis — it's data entry with extra steps. And you were supposed to have this in the product team's inbox before the 4 PM sync.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the data, talks to Tavily, and writes results directly into your columns — without you running a single query manually.
For each product name in column A (rows 2 through 81), run a Tavily search and write the top result's title into column B, the URL into column C, and the snippet into column D. Skip any row where column A is blank.
What You Get
- Columns B, C, and D populated across all 80 rows in one pass.
- Blank rows in column A skipped automatically — no #N/A errors to clean up.
- Each snippet is the raw text from the search result, not a generated summary.
- Any row where Tavily returns no result gets "NO RESULT" in column B so you can spot gaps immediately.
What If the Data Is Not Quite Ready
Product names have inconsistent formatting — trailing spaces, inconsistent capitalization, parenthetical notes
Clean the product names in column A first — trim whitespace, normalize capitalization, remove anything in parentheses — then run a Tavily search for each cleaned name and write the top result title, URL, and snippet into columns B, C, and D.
You only want results for products in a specific category listed in column E
For each row in column A where column E says "Category: SaaS", run a Tavily search and write the top result title to column B and URL to column C. Leave other rows blank.
Product names alone aren't precise enough — you need to add a qualifier to each query
For each product name in column A, search Tavily for "[product name] pricing" and write the top result title to column B and URL to column C. Use the exact text from column A combined with the word "pricing" as the search query.
Full cleanup and enrichment in one shot
Clean column A (trim, fix capitalization, remove anything in parentheses), then for each cleaned name search Tavily for "[name] product review", write the result title to column B, URL to column C, and snippet to column D. Flag rows where no result came back by writing "MISSING" in column E.
One prompt handles the normalization and the enrichment in sequence — you don't need to do a cleanup pass first.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with a product or competitor list in column A, then ask it to run Tavily searches and fill in results for every row. Or see how the same workflow handles URL content extraction and competitor site mapping.