The Scenario
A category manager at a consumer goods company inherited a workbook from a colleague who left three weeks ago. The worksheet "AuchanCatalog" has 80 Auchan product page URLs in column A. The column headers for B, C, and D say "Product Name," "Price," and "Availability" but every cell is empty.
The audit report is due to the VP of merchandising next Tuesday. The manager has not worked with Auchan's data before and has no script to fall back on.
The bad version:
- Open URL 1 in a browser, read the product name, copy it into column B; find the price, copy it into column C; check the stock indicator, type the availability status into column D
- Close the tab, open URL 2, repeat
- Reach URL 34 and find that the page didn't load — mark it somehow, remember to come back, continue with URL 35
Eighty browser tabs. Eighty copy-paste operations per field. By the time you're done, the prices from the first twenty rows may already have changed.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your URL column, understands what fields you're trying to fill, and through its built-in Piloterr integration it can fetch each Auchan product page and write the product name, current price, and availability status back into the correct columns — across all 80 rows — without opening a single browser tab.
Read 60 Auchan product URLs from the Excel sheet 'AuchanCatalog', fetch product info for each via Piloterr, and populate name, price, and description into columns B, C, and D
What You Get
- Column B: product name as listed on Auchan
- Column C: current price at time of fetch
- Column D: product description or availability status as returned by Piloterr
- Rows where the URL returns a 404 or the page is unavailable get flagged with an error note in column E so you can review them separately
What If the Data Is Not Quite Ready
Some URLs in column A have trailing parameters or tracking codes that may affect the fetch
Read the 'AuchanCatalog' worksheet column A (80 Auchan product URLs) — strip any query parameters after the "?" before fetching via Piloterr, then write product name, price, and availability into columns B, C, and D
You want to flag products that are out of stock before writing the full table
For each Auchan URL in the 'AuchanCatalog' worksheet column A (80 rows), fetch product details via Piloterr — write name into column B, price into column C, and availability into column D; for any row where availability is "out of stock," also write "REVIEW" into column E
Column A has a mix of valid Auchan product URLs and some non-product pages that crept in
Read the 'AuchanCatalog' worksheet column A — before fetching, check whether each URL contains "/p/" (Auchan product URL pattern); skip rows that don't match and mark them "non-product URL" in column E; for the rest, fetch via Piloterr and write name, price, and availability into columns B, C, and D
You need clean names, current prices, availability flags, and a price-change comparison against column F in one pass
Read the 'AuchanCatalog' worksheet column A (80 Auchan product URLs), fetch product name, price, and availability via Piloterr for each — write into columns B, C, D; compare the fetched price against column F (previous price) and write "up," "down," or "same" into column G; flag out-of-stock rows with "REVIEW" in column H
One prompt. The full audit workbook arrives annotated and comparison-ready.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook where your Auchan URL list lives — then ask SheetXAI to fetch product details for each row via Piloterr and write the results back. Also see building an Auchan price table from category searches in Excel or visit the full Piloterr hub.