The Scenario
A colleague who handled win-back campaigns left the company three weeks ago. Her handoff document says the re-engagement list lives "somewhere in Stripe" and gets refreshed quarterly. You've inherited the campaign, the refresh is overdue, and the list that feeds into the email tool is stale.
You open Stripe. There is no "customers with no active subscription" filter in the UI. You can browse the customer list, but subscription status is not a column — you'd need to click into each customer record to check. With 4,000+ customers in the account, that's not a path.
The bad version:
- Export the full customer list from Stripe (which includes customers both with and without active subscriptions), paste it into a sheet.
- Try to cross-reference against the subscription export to find customers with a canceled or absent subscription record — using VLOOKUP across two messy exports with mismatched ID formats.
- Spend two hours on the join and still not be confident it's complete because some customers appear in both lists for different reasons.
Your re-engagement campaign was supposed to go out this week. The list needs to be clean enough to hand to the email tool, not a VLOOKUP project.
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 query across multiple object types in a single ask — customers and their subscription status — without you building the join yourself.
List all Stripe customers and for each write email, name, created date, and current subscription status into this workbook — flag customers with no active subscription in column E
What You Get
- The sheet fills with one row per Stripe customer: email, name, created date, subscription status, and a flag in column E for any customer with no active subscription.
- Customers with canceled, unpaid, or absent subscriptions are all flagged distinctly.
- The count of flagged customers appears in the SheetXAI response so you know the size of the audience before you open the email tool.
What If the Data Is Not Quite Ready
You only want customers who had a subscription at some point — not free signups who never subscribed
Search Stripe for customers who have a canceled or expired subscription (not customers who never had one), export them into Sheet2 with email, name, and original plan name
You want to include the date their last subscription ended
List all Stripe customers with a canceled subscription and write email, name, plan name, and cancellation date into Sheet2 — sort by cancellation date descending so the most recently churned appear first
You want to exclude customers who already have an open quote or pending invoice
List all Stripe customers with no active subscription, exclude any who have an open quote or unpaid invoice in Stripe, and write the remaining list into Sheet2 with email, name, and last subscription end date
The full kill chain — pull lapsed customers, filter, and produce a ready-to-import list in one shot
List all Stripe customers who had a subscription that is now cancelled, exclude anyone cancelled more than 2 years ago, write their email and name into Sheet2, count the total in cell Sheet2!A1, and add a column C with the label 'win-back candidate'
The pattern: the filtering, exclusion logic, and labelling happen in a single ask rather than across three separate sheet operations.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook you use for customer outreach — then ask it to pull your lapsed Stripe customers directly into the list. For related reads, see how to build a churn analysis from cancelled subscriptions or export invoice history for revenue reporting.