The Scenario
A pet supply distributor tracks competitive pricing in an Excel workbook. The 'PriceWatch' worksheet has 40 Chewy product titles in column A pulled from their internal catalog. The goal: get the current Chewy product URL and matching category for each so the pricing team can compare against their own catalog.
Someone at the company built a manual version of this workflow six months ago. The analyst who built it no longer works there. The pricing manager needs this workbook updated by end of week for a review with the sales director.
The bad version:
- Search Chewy for product title 1, identify the correct listing from the results (some titles return multiple matches), note the URL and category
- Switch back to the workbook, enter the values into columns B and C, 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 workbook with a few quiet errors that nobody catches until the pricing review goes sideways.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. 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 URL and category into adjacent columns.
Read 30 Chewy product titles from the Excel sheet 'PriceWatch', fetch each via Piloterr, and write product URL and matching category into columns B and C
What You Get
- Column B: direct URL to the Chewy listing so the pricing team can verify the match
- Column C: the product's primary Chewy category for grouping and filtering
- Column D: product name as listed on Chewy, for cross-referencing with the internal catalog
- Column E: flagged rows where the lookup returned multiple close matches, so you know which ones to review
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 the 'PriceWatch' worksheet 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 URL and category into columns B and C; note the lookup type used in column D
You want to flag products where the Chewy price is more than 15% above your internal price in column E
For each product in the 'PriceWatch' worksheet column A, fetch the Chewy listing via Piloterr — write URL into column B, category into column C, and Chewy price into column D; compare to column E (internal price) and write "above" or "below" in column F, flagging any row more than 15% above with "REVIEW" in column G
Some product titles in column A include size variants that may not match the Chewy listing cleanly
Read the 'PriceWatch' worksheet column A (40 rows) — strip size and quantity descriptors (e.g., "5lb", "12-pack") before searching Chewy via Piloterr; note the cleaned search term in column D; write the best-match URL and category into columns B and C
You need cleaned identifiers, matched listings, price comparisons, and variant flags in one shot
Read the 'PriceWatch' worksheet column A (40 product titles), clean size/variant descriptors, fetch Chewy listings via Piloterr, write URL into B, category into C, Chewy price into D — compare to internal price in column E, write percentage difference in column F, flag rows more than 15% above as "REVIEW" in column G
The pricing comparison workbook arrives annotated and ready for the sales director review.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook 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 an Excel workbook or browse the full Piloterr integration hub.