The Scenario
You've been asked to put together a competitive intelligence brief before the product strategy offsite next week. Your manager wants a single document that covers what each of your 50 competitor product pages is actually claiming — their key value props, their positioning, their target audience signals.
You have 50 URLs in column A. You need a 2-sentence summary of each page's main claims in column B so you can scan the brief in 15 minutes instead of clicking through 50 pages.
The bad version:
- Open the first URL. Read the page. Attempt to distill the key claims into 2 sentences. Copy your summary into column B. Open the next URL.
- Halfway through, you realize your summaries for the first 10 pages are inconsistent — some are about the product, some are about the company, some accidentally summarize the nav bar. You go back and redo 10 of them.
- It's been 3 hours and you're on URL 22. The brief is due tomorrow and you still have the analysis section to write.
The page reading isn't the job. The analysis is the job. You've spent three hours on the wrong one.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the URLs in column A, fetches the text content of each page through Composio Search's web fetch tool, and writes a 2-sentence summary of the main product or service claims into column B.
Fetch the text content of each URL in column A and write a 2-sentence summary of the main product or service claims into column B, focusing on the value proposition and target customer described on the page.
Fifty URLs. Fifty summaries. One pass.
What You Get
- Column B: A 2-sentence summary of the page's primary product or service claims
- Pages that return an error (404, blocked) are flagged 'Could not fetch' in column B
- Summaries focus on value propositions, not company history or boilerplate footer text
What If the Data Is Not Quite Ready
You also want the headline and meta description extracted
Your SEO team needs these for a separate analysis.
Extract the main headline and meta description from each URL in column A and write both to columns B and C.
Some URLs redirect or have changed since the list was built
Fetch the content of each URL in column A. If the URL redirects, note the final destination URL in column C. Write the 2-sentence summary of the final page's content into column B.
You want to classify each competitor by primary use case
After summarizing, you need to tag each page as 'Sales Tool', 'Marketing Tool', 'Analytics', 'Operations', or 'Other' so you can group them in the brief.
Fetch the text content of each URL in column A, write a 2-sentence summary into column B, and classify the primary product category as one of: Sales Tool, Marketing Tool, Analytics, Operations, or Other in column C.
Kill chain: fetch, summarize, classify, and flag pages that seem outdated
Fetch the content of each URL in column A. Write a 2-sentence summary into column B, classify the product category into column C, extract the main headline into column D, and flag any page where the content appears to be a placeholder, error page, or last updated more than 2 years ago with 'Stale' in column E.
One prompt reads every page, summarizes it, categorizes it, and surfaces the ones that may not reflect current positioning.
Try It
Get the 7-day free trial of SheetXAI and open your competitive intelligence workbook. Ask it to fetch and summarize every URL in column A so you can spend your time on analysis instead of page reading. See also: Enrich a Business List in an Excel workbook With Google Maps Data via Composio Search or the Composio Search hub.