The Scenario
You're running competitive research for a SaaS company. The marketing manager asked for a pricing comparison table by end of Thursday — plan names, monthly prices, and primary CTAs from 50 competitor landing pages. You already have the URLs in column A of an Excel workbook. What you don't have is any of the actual data.
The bad version:
- Open each URL one by one, navigate to the pricing section, and manually read off the plan names and prices into the workbook
- Run an AgentQL query in the playground for the first ten, get back JSON objects, and spend 20 minutes copying field values into the right columns while not losing your place
- By URL 30, realize the JSON schema varied between sites and some of your column C values are plan descriptions instead of prices
You're supposed to be doing the analysis, not the data entry. The actual comparison — which plans are most aggressive on trial length, which competitors moved to usage-based pricing — that's the work. This isn't.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the data in your worksheets, and through its built-in AgentQL integration it can query web pages and write results back into your workbook. You don't configure selectors or build automations. You just ask.
Scrape the pricing table, plan names, and monthly prices from each URL in column A using AgentQL and write the results into columns B, C, and D
What You Get
- Column B: plan name for each competitor (e.g., "Starter", "Pro", "Enterprise")
- Column C: monthly price as scraped (e.g., "$29", "$99/mo", "Contact sales")
- Column D: primary CTA button text from the pricing section
- Rows where AgentQL couldn't extract a pricing table are flagged with a note in column E rather than left blank
What If the Data Is Not Quite Ready
The URLs in column A include tracking parameters and redirects
For each URL in column A, strip any query parameters before passing to AgentQL, scrape the pricing table, and write plan names and prices into columns B and C
Some competitor pages require scrolling to reveal the pricing section
Use AgentQL to extract the pricing table from each URL in column A even if the pricing content loads after scroll, and write plan names into column B and monthly prices into column C
I need to join pricing data with the company names already in column E
Match each scraped result to the company name in column E using the URL in column A as the key, then write plan names into column F and monthly prices into column G
The pricing data, the plan descriptions, and the company category are all in different worksheets — combine them and generate a competitive tier summary
Pull plan names and prices from AgentQL using URLs in column A of the 'Competitors' worksheet, join with company categories from column C of the 'Categories' worksheet, and write a tier summary by pricing bracket into the 'Summary' worksheet
The pattern here is to handle the data shape and the extraction in the same ask — one prompt covers both.
Try It
Get the 7-day free trial of SheetXAI and open an Excel workbook with a column of competitor URLs, then ask it to scrape pricing tables into the adjacent columns. For another AgentQL use case, see how to enrich a lead list with company metadata or the full AgentQL overview.