The Scenario
A pet supply distributor tracks competitive pricing in a Google Sheet. Column A has 40 Chewy product identifiers — a mix of product IDs and product title strings pulled from their internal catalog. The goal: get the current Chewy product name, category, and URL for each so the pricing team can compare against their own catalog and spot where they're priced above or below the market.
Someone at the company built a manual version of this workflow six months ago — it involved opening Chewy's search, looking up each identifier, confirming it was the right product, and copying the details into the sheet. The analyst who built it no longer works there. No one has run it since. The pricing manager needs this table updated by end of week for a review with the sales director.
The bad version:
- Search Chewy for product ID or title 1, identify the correct listing from the results (some IDs return multiple matches), note the product name, category link, and URL
- Switch back to the sheet, enter the values into columns B, C, and D, return to Chewy, clear the search
- Hit product 18 and find that a title match returns a different product variant than the one in the internal catalog, requiring a judgment call about which listing is the right one
Forty lookups with ambiguous matches in the middle is a recipe for a table with a few quiet errors that nobody catches until the pricing review goes wrong.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your product identifiers, understands what you're populating, and through its built-in Piloterr integration it can fetch Chewy product listings for each row and write the name, category, and URL into adjacent columns — handling ambiguous matches by choosing the most exact result.
For each product ID or title in column A (40 rows), fetch the Chewy product listing via Piloterr and write the product name, category, and URL into columns B, C, and D
What You Get
- Column B: product name as listed on Chewy
- Column C: the product's primary category (e.g., "Dog Food," "Cat Toys") for grouping and filtering
- Column D: direct URL to the Chewy listing so the pricing team can verify the match
- Column E: flagged rows where the lookup returned multiple close matches, so you know which ones to review rather than assuming they're all clean
What If the Data Is Not Quite Ready
Column A mixes product IDs (numeric) and product titles (strings) and they need different lookup approaches
Read column A (40 rows) — for numeric values, treat them as Chewy product IDs and fetch directly via Piloterr; for string values, treat them as search titles and take the closest match; write product name, category, and URL into columns B, C, and D; note the lookup type used in column E
You want to flag products where the Chewy price is more than 15% above your internal price in column E
For each product in column A, fetch the Chewy listing via Piloterr — write name into column B, category into column C, URL into column D, and Chewy price into column E; compare to column F (internal price) and write "above" or "below" in column G, flagging any row more than 15% above with "REVIEW" in column H
Some product titles in column A include size variants (e.g., "5lb bag," "12-pack") that may or may not match the Chewy listing
Read column A (40 rows) — strip size and quantity descriptors before searching Chewy via Piloterr; note the cleaned search term in column E; write the best-match product name, category, and URL into columns B, C, and D
You need cleaned identifiers, matched listings, price comparisons, and variant flags in one shot
Read column A (40 product identifiers), clean any size/variant descriptors, fetch Chewy listings via Piloterr, write name into B, category into C, URL into D, Chewy price into E — compare to internal price in column F, write percentage difference in column G, flag rows more than 15% above as "REVIEW" in column H
The pricing comparison table arrives annotated and ready for the sales director review.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet where your Chewy product identifiers live — then ask SheetXAI to fetch current listings via Piloterr and populate the comparison columns. Also see how SheetXAI handles Leroy Merlin product lookups from a sheet or browse the full Piloterr integration hub.