The Scenario
You are an e-commerce analyst at a retail brand. Last week's Zenserp Shopping search pull gave you 60 product IDs in column A of an Excel workbook. That was the easy part.
Now your category manager is asking for full product details — star ratings, price ranges, review counts, key specifications — for every one of those IDs. She needs them to build the competitive landscape deck by end of week.
You open the Zenserp docs and see there is a product details endpoint. It takes a product ID. It returns a structured JSON object with everything she needs.
Sixty product IDs. One endpoint each. All of it needs to land in columns B through F.
The bad version:
- Call the Zenserp product details endpoint for the first product ID, get a JSON blob, find the rating field buried two levels deep, paste it into column B.
- Find the price range field, paste it into column C.
- Find the review count, specifications. Paste. Paste. Paste.
- Repeat 59 more times.
Your category manager will have the deck on her desk by the time you finish row 60.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook with a Zenserp integration. It reads the product IDs in column A, calls the product details endpoint for each one, and writes the enriched fields back across the row.
Look up each Google Shopping product ID in column A using Zenserp and write the full product title, price, rating, and specifications into adjacent columns in this Excel sheet
What You Get
- Column B: full product title as it appears in Google Shopping
- Column C: price range (low to high)
- Column D: star rating (0–5 scale)
- Column E: review count
- Column F: top specifications as a comma-separated list
- Product IDs that return no results or errors get a note in column B
What If the Data Is Not Quite Ready
Some product IDs in column A are stale and no longer return results
IDs collected more than 30 days ago sometimes resolve to discontinued listings. You want to flag those rather than leave blanks.
For each product ID in column A, call the Zenserp product details endpoint. If the response returns no data or a not-found status, write "expired ID" in column B. Otherwise write product name, price range, and rating in columns B through D.
You need to join the enriched data back to a product catalog in another worksheet
The product IDs in column A also appear in your main catalog worksheet in column C. You want the rating and review count written into the Catalog worksheet, not into the current one.
For each product ID in column A of this worksheet, fetch rating and review count from Zenserp. Then find the matching product ID in column C of the Catalog worksheet and write the rating into column G and review count into column H of that row.
You only want to enrich products with fewer than 50 reviews
Products with under 50 reviews need attention in the deck. Products with more are performing well enough to skip.
For each product ID in column A, fetch the review count from Zenserp via the product details endpoint and write it into column B. Then, for any row where the review count is less than 50, also fetch the full product details and write product name, rating, and price range into columns C through E. Skip rows where review count is 50 or greater.
Full pipeline: enrich, filter, rank by rating, and flag the bottom quartile
For each product ID in column A, fetch product name, price range, rating, and review count from Zenserp. Write them into columns B through E. Sort the worksheet by column D descending. Calculate the 25th percentile of column D values and write "below benchmark" in column F for any product with a rating in the bottom quartile.
Pull the details, sort the results, and apply the flag in one instruction.
Try It
Get the 7-day free trial of SheetXAI and open your product ID workbook, then ask it to enrich each ID with full Zenserp product details. For collecting Shopping product IDs in the first place, see the Google Shopping competitive pricing spoke.