The Scenario
A procurement analyst at a European retailer is building a price benchmarking workbook. Their company carries 20 product categories and leadership wants to know where Auchan sits on price relative to their own catalog. The ask came in Tuesday. The analyst has an Excel workbook with those 20 categories in column A and nothing in columns B through F.
They tried pulling this manually once before, six months ago. They searched each category on Auchan, scrolled through the results, copied the top 5 product names and prices into a separate sheet, then formatted the table. It took most of an afternoon and the data was already stale by the time anyone looked at it.
The bad version:
- Open Auchan, search for category 1, identify the top 5 products, copy each product name, price, and URL
- Switch back to the workbook, paste into the correct columns — keeping track of which column maps to which field for which result position
- Reach category 7 and find that Auchan returned a sponsored listing first, which means "top 5 by position" and "top 5 organic results" are two different things
You're supposed to be doing analysis. Filling in cells by hand is not analysis.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your categories, understands what columns you're building, and through its built-in Piloterr integration it can search Auchan for each category and write the top results back — name, price, and URL — into adjacent columns.
Read the Excel column 'SearchQuery' (15 rows), run each query against Auchan via Piloterr, and write the top result's name and price into columns B and C
What You Get
- Column B: product name of the top Auchan result for each category query
- Column C: listed price for that result at time of fetch
- Column D: URL to the product listing for the procurement team to verify
- Where Auchan returns no results for a category, that row gets flagged so the manager knows which items need manual attention
What If the Data Is Not Quite Ready
Some category names in column A are too broad and return irrelevant Auchan results
For each category in the 'SearchQuery' column, search Auchan via Piloterr — if the search term is a single generic word, append "produit" before searching to narrow results, and note the modified query in column E
You only want the cheapest result per category, not the top-positioned one
For each category in the 'SearchQuery' worksheet column (15 rows), search Auchan via Piloterr, retrieve the top 10 results, then write only the product with the lowest price into columns B (name), C (price), and D (URL)
The workbook already has some categories filled in from a previous run and you only want to refresh the blanks
Read the 'SearchQuery' worksheet column (15 product categories) — skip any rows where column B already contains data; for the remaining rows, search Auchan via Piloterr and write the top result's name, price, and URL into columns B, C, and D
You need the full top-5 table, flagged for price outliers, and filtered to exclude sponsored listings in one pass
For each category in the 'SearchQuery' column, search Auchan via Piloterr, skip any sponsored or promoted results, write the top 5 organic results (name, price, URL) into columns B through P, then flag any product where the price is more than 30% above the average for that row in an adjacent notes column
The output lands ready to hand to whoever is building the comparison slide.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook where your Auchan category list lives — then ask SheetXAI to run the searches and populate the price table. Also see how SheetXAI handles enriching individual Auchan product URLs in Excel or the full Piloterr overview.