The Scenario
A category manager at a consumer goods company inherited a spreadsheet from a colleague who left three weeks ago. Column A has 80 Auchan product page URLs — collected as part of a catalog audit that was never finished. 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 from the page, 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 Google Sheet. 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.
For each Auchan product URL in column A (80 rows), fetch the product details via Piloterr and write the product name, current price, and availability 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: availability status (in stock, out of stock, or limited — 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 rather than scanning the whole sheet for blanks
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 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 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 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 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 table arrives annotated and comparison-ready.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet 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 if you're working from queries instead of URLs, or visit the full Piloterr hub.