The Scenario
You inherited the competitive intelligence sheet from a colleague who left last quarter. It has 30 SaaS pricing-page URLs in column A, a note that says "update monthly," and nothing in any other column. Your first quarterly review is in eight days.
The bad version:
- Open each URL, read the pricing page, decide which plan tiers to record, find a consistent way to represent "custom pricing" and "contact sales" across different page layouts, and type three or four fields per company into adjacent columns
- Get to a page that has six tiers and realize your column structure only accommodates three — go back and restructure the sheet, then redo the earlier rows to match
- Spend the last hour trying to reconcile two pages where the pricing has changed since the last person visited and the columns no longer make sense
Your first task at this company should not be manually reading 30 pricing pages and making judgment calls about how to structure a comparison table. That work belongs to the tool.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your URLs, calls Scrapfly's AI extraction model for each one, and writes structured pricing data back into your sheet — without you deciding what counts as a "plan name" or how to handle custom pricing tiers.
For each URL in column A, use Scrapfly AI extraction to pull pricing tier names, monthly prices, and up to three key features from the page, then write results into columns B, C, and D
What You Get
- Column B contains the plan or tier name for each pricing page (e.g., "Starter," "Pro," "Enterprise")
- Column C contains the monthly price as a number where available, and descriptive text like "Contact sales" where pricing is not published
- Column D contains up to three standout features listed for that tier, joined into a single cell
- Pages with multiple tiers produce multiple rows — one per tier — with the source URL repeated in column A for each
What If the Data Is Not Quite Ready
The page uses a toggle between monthly and annual pricing
Some SaaS pricing pages default to annual pricing and hide the monthly rate behind a toggle. If column C is returning annual prices when you need monthly, make the intent explicit:
For each URL in column A, use Scrapfly AI extraction to pull the monthly pricing tier names and prices — if the page defaults to annual, extract the per-month equivalent — and write plan name and price into columns B and C
Some companies only show "Contact us" and you need to note that clearly
If certain rows are coming back blank because the page has no published price, add an explicit fallback:
For each URL in column A, extract plan names and monthly prices using Scrapfly — if pricing is not published, write "Unpublished" in column C and continue to the next URL
You want to join the scraped data against your own product's pricing for comparison
Your product's tiers and prices are already in a reference tab called "Our Plans." Ask SheetXAI to cross-reference while extracting:
For each URL in column A, use Scrapfly AI extraction to pull plan name and monthly price into columns B and C, then in column D write whether each competitor tier is priced above or below the matching tier in the Our Plans tab
You need the full comparison table built, cleaned, and summarized in one go
For each URL in column A, use Scrapfly AI extraction to pull all pricing tiers, monthly prices, and key features — write one row per tier into a new sheet called Pricing Comparison, deduplicate any duplicate tier names from the same domain, and in column E flag any tier priced more than 20% below our equivalent plan in the Our Plans tab
One pass, structured output, ready for your quarterly review.
Try It
Get the 7-day free trial of SheetXAI and open your competitive intelligence sheet with SaaS pricing URLs in column A, then ask it to extract all tiers and prices using Scrapfly. You can also use the same approach to bulk-scrape product pages or extract article metadata from a content list.