The Scenario
A facilities procurement manager at a property services firm gets a spreadsheet every quarter with 25 home improvement product names — flooring materials, power tools, lighting fixtures — that need price quotes from at least two suppliers. Leroy Merlin is always one of them. The manager's job is to populate the sheet 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 as listed on the site, the price, and copy the URL
- Switch back to the sheet, 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 Google Sheet. 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 without you leaving the spreadsheet.
For each product name in column A (25 rows), search Leroy Merlin via Piloterr and write the top result's product name, price, and URL into columns B, C, and D
What You Get
- Column B: the product name as it appears on Leroy Merlin (useful for the procurement team to match against supplier invoices)
- Column C: the listed price at time of fetch
- Column D: a direct URL to the product listing
- Rows where no Leroy Merlin match is found get a note in column E so the manager knows which items need manual follow-up
What If the Data Is Not Quite Ready
The product names in column A are generic terms that may return irrelevant Leroy Merlin listings
For each product in column A, search Leroy Merlin via Piloterr — if the search term is fewer than 3 words, add "Leroy Merlin" at the end of the query to improve relevance; write the top result name, price, and URL into columns B, C, and D
You want the top 3 matches per product so the procurement team can compare options
For each product name in column A (25 rows), search Leroy Merlin via Piloterr and write the top 3 results — name, price, and URL for each — into columns B through J (3 results x 3 fields)
Column A has a mix of product names and some freeform descriptions that won't search cleanly
Read column A (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 column E; write the top result name, price, and URL into columns B, C, and D
You need the full top-3 table, a no-match flag, and a lowest-price highlight in one pass
Read column A (25 product names), search Leroy Merlin via Piloterr for each, write the top 3 results into columns B through J, flag rows with no matches in column K, and highlight the lowest price across the 3 results in column L
One prompt. The supplier comparison table arrives ready to share with the procurement team.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet 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 a Google Sheet or browse the full Piloterr integration hub.