The Scenario
Payment failures have been quietly accumulating. You know this because your MRR graph has been flat for three weeks despite new subscribers coming in, and when you dug into it on Friday afternoon you found 23 subscriptions with invoices in a failed or pending state.
You need those invoices — customer email, amount owed, billing date — in a Google Sheet so you can build a dunning outreach sequence. Your email tool can import from a sheet. But first you have to get the data out.
There's no "Export failed invoices" button in Lemon Squeezy. There's an invoices section that you can filter by status, and you can click into each one individually.
The bad version:
- Filter invoices to Failed status, click the first invoice, copy the email and amount
- Open your sheet, paste the row, go back to Lemon Squeezy, click the next invoice
- Repeat for every failed invoice, then repeat the whole process for Pending
- Find out at invoice 18 that the date format from the dashboard doesn't match your email tool's import format
Twenty-three invoices is maybe an hour of this. But the number goes up every week and this is not a task that should exist.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It connects to Lemon Squeezy through its built-in integration and pulls every failed or pending invoice in one pass.
List all Lemon Squeezy subscription invoices and write subscription ID, customer email, amount, status, and billing date into columns A through E
What You Get
- Column A: subscription ID
- Column B: customer email
- Column C: invoice amount (in dollars)
- Column D: invoice status (failed, pending, paid, void)
- Column E: billing date
- All statuses in one pull — you can filter to failed/pending in the sheet
What If the Data Is Not Quite Ready
You only want failed and pending, pre-filtered
Export every Lemon Squeezy subscription invoice with status failed or pending — write customer email, amount in dollars, billing date, and subscription ID into columns A through D — one row per invoice
You want to segment by amount for outreach priority
Pull all failed Lemon Squeezy invoices and write customer email, amount, and billing date into columns A through C — then add a column D that tags invoices over $50 as High Priority and the rest as Standard
You need the subscription plan name alongside the invoice
Fetch all failed or pending Lemon Squeezy invoices and include the subscription ID, customer email, associated plan name, amount owed, and billing date in columns A through E
Full dunning list build in one shot
Pull all Lemon Squeezy invoices with failed or pending status, write customer email, amount in dollars, billing date, and days since billing date into columns A through D, sort by days-overdue descending, and add a column E that flags anything over 14 days as Urgent
One prompt builds the list your email tool imports from tomorrow morning.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet you're using to stage dunning outreach, then ask it to pull all failed invoices sorted by amount owed. You can also pull subscription status or customer data into the same workbook.