The Scenario
Your team tracks a competitor's pricing monthly. Until now, someone on the ops team was opening the competitor's main category page — 50 products listed — and manually copying each product name, price, and SKU into the pricing tracker. Last month they got through 30 products before switching to a different task. The remaining 20 rows have been blank for six weeks.
You're doing the monthly pricing review and the sheet is incomplete.
The bad version:
- Open the competitor's category page, scroll to where the data gaps start, read each product card, type the product name, price, and SKU into the next available row
- Discover that the page uses lazy loading — products 35 through 50 don't appear until you scroll, and the export button does nothing
- Finish the session with 18 of 20 rows filled in and two products you couldn't find because they'd been removed from the page since last month
The pricing review is in three days. The tracker is supposed to be the source of truth.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your data and through its built-in Firecrawl integration it can use LLM-powered structured extraction on a single category page — pulling every product listing at once — and write them as rows into your sheet. One URL, one prompt, one complete extract.
Use Firecrawl to extract all products listed on the page URL in cell A1. For each product, pull the product name, price, and SKU and write them as rows starting at row 2 in my "Pricing Tracker" sheet — product name in column A, price in column B, SKU in column C. If a product has no SKU listed, write "N/A" in column C.
What You Get
- One row per product, starting at row 2
- Column A with the product name as written on the page
- Column B with the listed price — formatted exactly as it appeared, whether that's "$49/mo", "From $49", or "Contact us"
- Column C with the SKU if present, or "N/A" if the listing had no SKU
- The complete list from the page in one pass — no lazy-loading issues, no rows dropped because you ran out of time
What If the Data Is Not Quite Ready
Some products show "Contact us" instead of a price — I want to flag those separately
Extract all products from the URL in cell A1 using Firecrawl. Write product name into column A, price into column B, SKU into column C. If the price is listed as "Contact us" or any variation of request-based pricing, write "POA" into column B and flag that row with "pricing inquiry needed" in column D.
The prices are in GBP but I need them in USD for the comparison
Extract all products from the URL in cell A1 with Firecrawl. Write product name into column A, the original GBP price into column B, and the USD equivalent (using the rate in cell F1) into column C. Write the SKU into column D.
The competitor has two category pages — one for annual plans and one for monthly — I need both
Extract all products from the annual pricing page URL in cell A1 and write them into columns A, B, C with a "annual" label in column D. Then extract all products from the monthly pricing page URL in cell A2 and append them below the last row, writing "monthly" in column D for those rows.
The full competitive pricing pipeline: extract, compare to last month, flag changes, and sort by impact
Extract all products from the URL in cell A1 with Firecrawl's structured extract. Write product name into column A, current price into column B, and SKU into column C. Then compare the current price in column B to the previous month's price in column E (matched by SKU in column C). Write the price change (+ or -) into column F. Flag any product where the price changed by more than 5% in column G. Sort the sheet by column F descending so the biggest price increases appear first.
One instruction: extract the full catalog, compare against last month, flag significant changes, and sort for the review meeting.
Try It
Get the 7-day free trial of SheetXAI and open your pricing tracker with the competitor URL in cell A1, then ask it to extract every product on the page and write them as rows with price and SKU. Link to the hub: How to Connect Firecrawl to Google Sheets. Also see: Bulk Scrape Competitor URLs Into Google Sheets With Firecrawl.