The Scenario
A procurement analyst at a European retailer is building a price benchmarking spreadsheet. Their company carries 20 product categories — cleaning supplies, small appliances, pantry staples — and leadership wants to know where Auchan sits on price relative to their own catalog. The ask came in Tuesday. The analyst has a Google Sheet 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 spreadsheet, 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 by position, copy each product name, price, and URL
- Switch back to the sheet, paste into the correct columns — remembering which of the twelve columns is supposed to hold which piece of data 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 now two different things
You're supposed to be doing analysis. Filling in a table cell by cell is not analysis.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. 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 without you touching the browser.
For each product category in column A (20 rows), search Auchan via Piloterr and write the top 5 results — product name, price, and URL — into adjacent columns starting at B
What You Get
- Columns B, C, D for result 1 (name, price, URL); columns E, F, G for result 2; and so on through result 5
- Where Auchan returns fewer than 5 results for a category, the remaining columns for that row stay blank
- Prices land as returned by Piloterr — you can apply a currency format to the price columns after the fact if needed
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 column A, search Auchan via Piloterr — where the category name is a single generic word like "cleaning" or "appliances", append the word "product" before searching to narrow results, and note the modified query in a new column G
You only want the cheapest result per category, not the top-positioned one
For each category in column A (20 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 sheet already has some categories filled in from a previous run and you only want to refresh the blanks
Read column A (20 product categories) — skip any rows where column B already contains data, and 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 column A, 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 Google Sheet 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 if you already have product links and need to pull details, or the full Piloterr overview.