The Scenario
Your product team has a pricing committee meeting in three days and needs a full snapshot of every active product and its associated prices before the discussion. You're the one who knows where things live in Stripe.
You open Stripe's product catalogue. There are 23 active products, each with between 1 and 4 price variants — monthly, annual, legacy rates, grandfathered plans. Stripe shows you one product at a time. There is no "export all products and prices" button that produces a clean two-tab layout.
The bad version:
- Click through each of the 23 products, record its ID, name, and description into a Excel workbook manually.
- Go back into each product to find its associated prices, record each price's amount, currency, and billing interval into a second tab.
- Discover partway through that three products have archived prices mixed in with active ones, and re-check each to filter them out.
The pricing committee meets in three days. The Head of Product has already shared the calendar invite with six people. You don't have the bandwidth to spend four hours building a snapshot that should take ten minutes.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the workbook and connects to Stripe, and it can pull structured data across multiple related object types — products and their prices — in a single ask.
List all active Stripe products and write product ID, name, and description into Sheet1 — then for each product list its prices (amount, currency, billing interval) in Sheet2
What You Get
- Sheet1 fills with one row per active product: product ID, name, and description.
- Sheet2 fills with one row per price, with the parent product ID in column A, followed by amount, currency, and billing interval.
- Archived or inactive prices are excluded automatically.
- Both sheets populate in a single run — no second prompt needed.
What If the Data Is Not Quite Ready
You want prices shown as dollar amounts, not cents
List all active Stripe products in Sheet1 with product ID, name, and description — list all active prices in Sheet2 with product ID, display amount in dollars (not cents), currency, and billing interval
You want to see which products have no active prices
List all active Stripe products and their prices in Sheet1 and Sheet2 as before — also write a list on Sheet3 of any product that has no active price associated with it
You want the summary count for the committee deck
List all active Stripe products in Sheet1, list active prices in Sheet2, and write a summary on Sheet3: total active product count, total active price count, and a breakdown of price count by billing interval (monthly vs annual)
The full kill chain — products, prices, gaps, and summary in one shot
List all active Stripe products in Sheet1 with ID, name, and description; list all active prices in Sheet2 with product ID, amount in dollars, currency, and billing interval; flag any product with only one price variant in Sheet1 column E; and put summary counts on Sheet3 for the committee deck
The pattern: describe the multi-tab layout and the conditional logic together. SheetXAI builds the structure you described without requiring separate runs for each tab.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook your team uses for pricing or product planning — then ask it to pull the full Stripe product catalogue into a structured layout. For related reads, see how to export Stripe invoice line items for revenue attribution or audit active coupons before a pricing review.