/
/
Warn account owners when a Stripe payment fails mid-deal
For sales and account teams who want Salesforce accounts with open opportunities and failing Stripe payments listed by their AI assistant.
On this page
Connector
Connect Stripe, pick your AI tool and paste the prompt.
The problem
Account owners hear about failed payments too late
Account owners in Salesforce rarely hear that a customer's Stripe payment failed or an invoice is past due until finance escalates it. Spotting the overlap means matching failed charges to Salesforce contacts and checking each account for open opportunities.
Without PopdockAI
- Pull failed charges and past-due invoices from Stripe
- Match each email to a Salesforce contact
- Check the account for open opportunities
- Hear about it from finance weeks later
With PopdockAI
- Failed charges and past-due invoices are grouped by email
- Each is matched to a Salesforce contact and account
- Open opportunities are checked and sorted by amount
- Currencies are never added together, and nothing is changed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** List the Stripe customers with failed payments in the last `{lookback-days}` days (default 30) whose Salesforce account still has open opportunities, so the account owner can act before the deal moves. Only include opportunities of at least `{min-opportunity-amount}` (default: any amount).
**Step 1: Collect failed payments in Stripe**
Call `stripe-get-charge` with `status` set to failed and `created.from` set to today minus the lookback. Then call `stripe-get-invoice` with `status` set to open and `due-date.to` set to today to catch invoices already past due. Group the results by customer email, keeping customer-id, the failed amounts, the latest failure-message and the open amount-remaining.
**Step 2: Carry each email to Salesforce**
For each customer email, call `salesforce-get-contact` with `email` set to it. If nothing comes back, keep the customer in a separate list headed "In Stripe, not in Salesforce" and continue.
**Step 3: Find open opportunities on the account**
For each matched contact with an account-id, call `salesforce-get-opportunity` with `account-id` set to it and `closed` set to false (add `amount.min` set to `{min-opportunity-amount}` when given). Drop accounts with no open opportunity.
**Step 4: Report**
A table sorted by open opportunity amount, largest first: account name, account owner, contact email, Stripe customer-id, failed charge count and total, latest failure-message, open invoice amount-remaining, open opportunity names with stage, amount and close-date. Then the "In Stripe, not in Salesforce" list.
**Rules & Guidelines:**
* `stripe-get-charge` and `stripe-get-invoice` are on the stripe server. `salesforce-get-contact` and `salesforce-get-opportunity` are on the salesforce server.
* The join is the Stripe customer email against the Salesforce contact email, matched case-insensitively and trimmed.
* This is read-only. Do not call `salesforce-add-task`, `salesforce-add-case`, `salesforce-update-opportunity`, `salesforce-update-account`, `salesforce-update-contact` or any other salesforce add or update tool. Use the log-payment-follow-up prompt to record a follow-up.
**Validation:**
* If Stripe returns no failed charges and no past-due invoices, say so and stop.
* A charge with no customer email cannot be joined; list it by charge-id under "Unmatched".
* Never add amounts in different currencies together.Who it's for
One answer, three teams that use it
Account executives
Raise billing before you close
Know about a failed payment on your account before the next deal conversation.
Do any of my accounts with open opportunities have failed Stripe payments in the last 14 days?
Sales managers
Spot risk in the pipeline
Accounts sorted by open opportunity amount show where payment problems threaten the most revenue.
Which Salesforce accounts with open opportunities over 25,000 have past-due Stripe invoices?
Revenue operations
Find customers missing from Salesforce
Stripe customers with no Salesforce contact are listed, so data gaps can be closed.
List Stripe customers with failed payments this month who are not in Salesforce.
How it works
What PopdockAI does when you ask
You give a lookback period, and your AI assistant finds Salesforce accounts with open opportunities and Stripe payment problems. It only reads and lists Stripe customers not found in Salesforce.
01
Ask
You give a lookback period, and optionally a minimum deal size.
02
Collect
It gathers failed Stripe charges and past-due invoices by customer email.
03
Match
It finds each Salesforce contact and the open opportunities on the account.
04
Report
You get accounts sorted by open amount, with Stripe-only customers listed.
What PopdockAI provides
The tools behind the answer
Ready made tools for Stripe and one secure connection to your AI tool. No code, no exports.
stripe-get-charge
stripe-get-invoice
salesforce-get-contact
salesforce-get-opportunity
This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.
The outcome
Payment failures acted on before deals move
Related use cases
More ways to put this data to work
One prompt template with infinite possibilities.
Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.
Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.

.webp)
