The Scenario
You joined a luxury goods resale operation three weeks ago. The previous analyst left a WatchList sheet with 20 Rolex and Patek Philippe reference numbers in column A and a note that says "get the Retailed IDs and platform names for these." No further context. Your manager mentioned it in passing yesterday.
Columns B, C, and D are empty.
The bad version:
- Try to figure out what "Retailed IDs" means, look up the Retailed API docs, realize you need to call a search endpoint with the reference as a query parameter
- Make the first API call manually using a browser tool, get back a JSON blob, find the product_id field, paste it into column B, realize you have no idea which of the three platform names in the response is the right one to use
- Get through four rows before giving up and booking time with a developer
The institutional knowledge walked out the door when the previous analyst left. You're not there to reverse-engineer undocumented workflows — you're there to analyze the results.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the reference numbers in your sheet and, through its Retailed integration, searches the product database and returns the structured metadata you need.
For each product name in column A of the WatchList sheet, search Retailed for matching products and write the top result's product ID, brand, and name into columns B, C, and D
What You Get
- Column B: Retailed product ID for the matched item
- Column C: brand name as returned by the database
- Column D: matched product name
- Rows where no strong match is found get a note in column E — you know immediately which references need a manual review rather than finding out later when a downstream report breaks
What If the Data Is Not Quite Ready
Reference numbers are mixed with descriptive text — not clean queries
For each value in column A of the WatchList sheet, extract the reference number (the alphanumeric code), search Retailed for a match, and write the product ID, brand, and name into columns B, C, and D
You need platform names alongside the product ID
For each product name in column A of the WatchList sheet, search Retailed and write the top result's product ID into column B, brand into column C, and matched platform names into column D as a comma-separated list
Some references appear twice with slightly different formatting
Deduplicate column A of the WatchList sheet by normalizing spacing and case, then search Retailed for each unique reference and write product ID, brand, and name into columns B, C, and D, noting any duplicates that were merged in column E
Full catalog enrichment: search, add SKUs, flag items with no platform match
Search Retailed for each reference in column A of the WatchList sheet, write product ID into column B, brand into column C, and name into column D, then flag in column E any row where no platform names were returned — those likely need manual verification before being added to the catalog
Clean reference list, enriched metadata, and a clear flag on what needs human eyes before it goes further.
Try It
Get the 7-day free trial of SheetXAI and open any sheet with a column of brand references, product names, or model codes, then ask SheetXAI to search the Retailed database and populate IDs and metadata inline. Related: Enrich inventory with full StockX variant data and the Retailed integration hub.