The Scenario
You manage dynamic product ads for a retail brand running three active DPA campaigns. Your media buyer flagged this morning that two of the campaigns are spending against out-of-stock products — impressions are running but the product pages are showing a sold-out message. The catalog needs to be audited before you burn another day of budget on unavailable inventory.
The bad version:
- Open the Snapchat Catalog Manager, search for products filtered by availability — discover there's no bulk-export button in the UI.
- Use the Snapchat Marketing API explorer to call the product search endpoint, figure out the pagination parameter, copy-paste the JSON response, parse out the fields you need, and manually format them into a sheet.
- Realize the price field is in microcents and you need to divide every value by 1,000,000 before the numbers make sense.
The catalog has 12,000 SKUs. You don't have a way to pull a filtered subset from the UI. Every minute of delay is more spend against unavailable products.
The Easy Way: One Prompt in SheetXAI
SheetXAI connects to the Snapchat Marketing API from inside your Google Sheet. You describe what you want from the catalog and it handles the API call, pagination, and formatting.
Search Snapchat catalog ID cat_123 for all products where availability is out_of_stock and write product name, product ID, price, and availability into columns A through D of the Catalog Audit tab
What You Get
- One row per out-of-stock product
- Column A: product name
- Column B: product ID (what Snapchat references internally)
- Column C: price in standard currency units (not microcents)
- Column D: availability value as returned by the API
- All pages fetched so no products are missed
What If the Data Is Not Quite Ready
You want to pull products by brand instead of by availability
Export all products from Snapchat catalog cat_456 where brand is Nike and write product ID, product name, price, and availability into columns A through D
You need to cross-reference against your internal SKU list in column A
For each product ID in column A of the SKU Check tab, look up the product in Snapchat catalog cat_123 and write the current availability status into column B — flag any product that returns out_of_stock or not found
You want products filtered by multiple conditions
Search Snapchat catalog cat_123 for all products where availability is out_of_stock AND price is greater than 50, and write product name, ID, price, and availability into columns A through D
Full feed fix: pull out-of-stock items, cross-reference your inventory sheet, and flag mismatches
Search Snapchat catalog cat_123 for all products — write product ID in column A, product name in B, availability in C, and price in D — then look up each product ID against the inventory sheet (column A in the Inventory tab), and write Mismatch in column E for any product where the catalog availability doesn't match the inventory sheet status in column B
One pass through both data sources, and you leave with a prioritized fix list rather than a raw export.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet where your catalog audit should live, then ask it to pull the filtered product list from your Snapchat catalog. Related: auditing audience segments, and the hub overview for all Snapchat workflows.