The Scenario
You run e-commerce for a fashion brand that's been running dynamic product ads on Snapchat for three months. Your media buyer noticed this morning that two campaigns are spending against products that are showing as sold out on the website. You need to pull every out-of-stock product from the Snapchat catalog — name, ID, price, availability — into an Excel workbook so you can cross-reference it against your inventory system and fix the feed before more budget goes out the door.
You open Snapchat Catalog Manager. There is no bulk export option for filtered product data.
The bad version:
- Navigate to the Snapchat Marketing API docs, find the product catalog search endpoint.
- Call the endpoint manually using API explorer or a tool like Postman, filtering by availability. Note that the price field is returned in microcents.
- Copy the JSON response, paste into a text editor, extract the fields you need, format into rows, paste into Excel.
- Repeat for every page of results — the catalog has 12,000 SKUs and the endpoint paginates.
Every minute this takes is more spend against unavailable products. The catalog audit is urgent, not exploratory.
The Easy Way: One Prompt in SheetXAI
SheetXAI connects to the Snapchat Marketing API from inside your Excel workbook. You describe the filter and it handles the catalog query, pagination, and field 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 sheet
What You Get
- One row per out-of-stock product, all catalog pages fetched
- Column A: product name
- Column B: product ID (Snapchat's internal reference)
- Column C: price in standard currency units (not microcents)
- Column D: availability value from the API
What If the Data Is Not Quite Ready
You want to filter by brand instead of availability
Export all products from Snapchat catalog cat_456 where brand is Nike and write product ID, 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 sheet, look up the product in Snapchat catalog cat_123 and write the current availability status into column B — flag anything that returns out_of_stock or not found
You want multiple filter conditions applied at once
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 repair: pull out-of-stock items, compare against inventory workbook, flag mismatches
Search Snapchat catalog cat_123 for all products — product ID in A, name in B, availability in C, price in D — then look up each product ID in the Inventory sheet (column A = product ID, column B = stock status) and write Mismatch in column E for any product where catalog availability doesn't match the inventory sheet
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook where your catalog audit should live, then ask it to pull filtered product data from your Snapchat catalog. Related: auditing audience segments, and the hub overview for all Snapchat workflows.