The Scenario
You're an e-commerce manager and the summer campaign brief just landed on your desk. Before you brief the design team, you need to verify that every product you plan to feature has the right price and a working URL in Mailbluster — 200 products in the catalog, some of which were added over a year ago by a team member who has since left. You want the full list in a Google Sheet so you can cross-reference it against the live site.
The Mailbluster product UI shows you one product at a time. There's no "view all as table" mode, no export button, no CSV download.
The bad version:
- Open the Mailbluster products section and start scrolling through the list, clicking into each product to check the URL and price
- Try to spot which of the 200 products have stale prices or broken links without any way to compare at a glance
- Accept that you'll only be able to check 30 or 40 in the time you have before the design brief needs to go out
A catalog audit done 20% of the way through is not an audit. It's a guess with a spreadsheet attached.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It pulls the complete Mailbluster product catalog through the API and writes every record into a structured table — ready for side-by-side comparison.
List all Mailbluster products and write to sheet 'Product Audit' with columns: product_id, name, url, price, image_url, created_date
What You Get
- Every product in your Mailbluster catalog is written to the 'Product Audit' sheet
- product_id, name, url, price, image_url, and created_date land in the correct columns
- The table is ready to sort, filter, or compare against a live website export
- Any products missing a URL or price are immediately visible when you sort
What If the Data Is Not Quite Ready
You want to flag products that haven't been updated recently
List all Mailbluster products with product_id, name, url, price, image_url, created_date — add a column 'stale' with "yes" for any product where created_date is older than 2025-01-01
You want to compare the catalog against the prices in a separate sheet
Fetch all Mailbluster products, write to sheet 'Mailbluster Catalog' with product_id, name, price — then look up each product_id against the 'Live Site Prices' sheet and add a column showing whether the prices match
You want the products sorted by price for budget review
List all Mailbluster products with product_id, name, url, price, image_url — sort by price descending and write to sheet 'Product Audit'
Full audit in one shot
List all Mailbluster products with product_id, name, url, price, image_url, created_date — flag rows where url is blank in column G with "missing URL", flag rows where price is zero or blank with "missing price" in column H, sort by created_date ascending, write to 'Product Audit'
A complete audit table with issue flags, ready to share with the team.
Try It
Get the 7-day free trial of SheetXAI and open a Google Sheet, then ask it to pull your entire Mailbluster product catalog into a table you can actually audit. Once you've found what needs fixing, see how to bulk update product details or return to the Mailbluster overview.