The Scenario
A facilities procurement manager at a property services firm gets a workbook every quarter with 25 home improvement product names that need price quotes from at least two suppliers. Leroy Merlin is always one of them. The manager's job is to populate the workbook with the current Leroy Merlin listing for each product: name, price, and a URL the procurement team can click through to verify.
Last quarter's version of this task took a full afternoon. This quarter the list has grown and the deadline moved up.
The bad version:
- Open Leroy Merlin, search for product 1, find the most relevant result, note the product name, the price, and copy the URL
- Switch back to the workbook, paste the three values into columns B, C, and D for row 1, go back to Leroy Merlin, clear the search, type the next product name
- By product 10, you've started abbreviating product names in ways the procurement team won't recognize, and you have to go back and spell them out properly
This is the kind of work that used to take half a day and still leaves room for transcription errors.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your product names, understands what you're building, and through its built-in Piloterr integration it can search Leroy Merlin for each row and write the top result's name, price, and URL into adjacent columns.
Read the Excel column 'DIYProducts' and search each via Piloterr Leroy Merlin — write the top match's name and price into adjacent columns
What You Get
- The product name column: Leroy Merlin's listing name for that product (useful for matching against supplier invoices)
- The price column: listed price at time of fetch
- The URL column: a direct link to the Leroy Merlin product listing
- Rows where no match is found get a note so the manager knows which items need manual follow-up
What If the Data Is Not Quite Ready
The product names in the 'DIYProducts' column are generic terms that may return irrelevant Leroy Merlin listings
For each product in the 'DIYProducts' worksheet column, search Leroy Merlin via Piloterr — if the search term is fewer than 3 words, add "bricolage" before searching to narrow results; note the modified query in the next column
You want the top 3 matches per product so the procurement team can compare options
For each product name in the 'DIYProducts' worksheet column (25 rows), search Leroy Merlin via Piloterr and write the top 3 results — name and price for each — into adjacent columns
The worksheet has a mix of product names and some freeform descriptions that won't search cleanly
Read the 'DIYProducts' worksheet column (25 rows) — for rows that look like freeform descriptions (more than 8 words), extract the most specific product noun before searching Leroy Merlin via Piloterr; note the extracted search term in a notes column; write the top result name and price into the output columns
You need the full top-3 table, a no-match flag, and a lowest-price highlight in one pass
Read the 'DIYProducts' worksheet column (25 product names), search Leroy Merlin via Piloterr for each, write the top 3 results into adjacent columns, flag rows with no matches in a notes column, and highlight the lowest price across the 3 results in a summary column
One prompt. The supplier comparison workbook arrives ready to share with the procurement team.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook where your procurement list lives — then ask SheetXAI to search Leroy Merlin for each product via Piloterr and populate the results. You can also look at how SheetXAI handles Auchan price searches from an Excel workbook or browse the full Piloterr integration hub.