Connectors

/

Stripe

/

Stripe churn risk review with HubSpot context
Report
Cross-Connector

Rank Stripe churn risk with the HubSpot context to act

For customer success and revenue teams who want at-risk Stripe subscriptions ranked with their HubSpot owner and activity by their AI assistant.

Try PopdockAI free
Get a live demo
Stripe churn risk review with HubSpot context
Which Stripe customers are most likely to churn in the next 30 days? Show the top 10 with their HubSpot owner.
10 Stripe customers are at risk in the next 30 days, with 18,400.00 USD monthly revenue at risk. - Contoso: set to cancel and past due, 4,200.00 MRR, owner Jordan Lee - Fabrikam: unpaid, 2,900.00 MRR, no activity for 41 days, 1 open ticket - Northwind Traders: past due, 1,800.00 MRR, open renewal deal - Not in HubSpot: 2 customers Want the full ranked list?
Stripe
Sample figures. Your results come from your own account.
stripe-get-subscription
stripe-get-customer
stripe-get-subscription-item
hubspot-get-contacts
hubspot-get-companies
hubspot-get-tickets
hubspot-get-deals

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Stripe

Stripe
Run it on your own Stripe data.

Connect Stripe, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

Churn risk in Stripe with no owner in sight

Stripe shows which subscriptions are cancelling, past due or unpaid, but not who owns the customer in HubSpot, when they were last contacted or whether a ticket or deal is open. Pulling that together means matching each at-risk customer by hand.

Without PopdockAI

  • List cancelling, past due and unpaid subscriptions
  • Work out recurring revenue for each
  • Find the owner and last activity in HubSpot
  • Check for open tickets and deals one by one

With PopdockAI

  • At-risk subscriptions and delinquent customers are scored once each
  • Monthly recurring revenue at risk is worked out per currency
  • Each customer is matched to a HubSpot contact or company
  • Owner, last activity, tickets and deals are added, read-only

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** Rank the Stripe subscriptions most likely to churn in the next `{renewal-window-days}` days (default 30) and show each one's HubSpot owner, recent activity and open tickets, limited to the top `{max-accounts}` accounts (default 20).

**Step 1: Collect at-risk subscriptions in Stripe**

Call `stripe-get-subscription` three times, `max-records` 200 each:

* `cancel-at-period-end` = true
* `status` = past_due
* `status` = unpaid

Also call `stripe-get-customer` with `delinquent` = true.

Merge by `customer-id`. Give each customer a risk score: cancel at period end ending within `{renewal-window-days}` days (default 30) = 3, unpaid = 3, past_due = 2, delinquent = 1. For each at-risk subscription call `stripe-get-subscription-item` with `subscription-id` and compute its MRR (`price-unit-amount` x `quantity`, year / 12, week x 52 / 12, day x 365 / 12).

If nothing is at risk, say so and stop.

**Step 2: Carry each customer across to HubSpot**

Using the subscription's `customer-email`, call `hubspot-get-contacts` with `email`. If none, call `hubspot-get-companies` with `company-domain-name` = the email's domain (skip free mail domains). Record the company, `company-owner` or `contact-owner`, and `last-activity-date`. If nothing matches, mark the account "not in HubSpot" and continue.

**Step 3: Add HubSpot context**

For each matched company, call `hubspot-get-tickets` with `company-id` and keep tickets that are not closed. Call `hubspot-get-deals` with `company-id` and keep open deals (renewal or expansion deals are worth calling out).

**Step 4: Report**

Sort by risk score, then MRR, and show the top `{max-accounts}` (default 20): company, customer email, Stripe reason (cancel at period end / past_due / unpaid / delinquent), period end, MRR and currency, HubSpot owner, days since last activity, open tickets, open deals.

Finish with total MRR at risk per currency, and the accounts not found in HubSpot.

**Rules & Guidelines:**

* `stripe-get-subscription`, `stripe-get-customer` and `stripe-get-subscription-item` are on the stripe server. `hubspot-get-contacts`, `hubspot-get-companies`, `hubspot-get-tickets` and `hubspot-get-deals` are on the hubspot server.
* Read-only. Do not call `hubspot-add-ticket`, `hubspot-update-company`, `hubspot-add-company-note` or any other HubSpot add or update tool.

**Validation:**

* Do not double count a customer that appears in several Step 1 calls; take the highest single score plus 1 for each extra signal.
* Never add MRR across currencies.
* If a parameter is empty or not a number, use its default.

Who it's for

One answer, three teams that use it

Revenue leaders

See revenue at risk

Total recurring revenue at risk per currency gives you the size of the problem.

How much recurring revenue is at risk from Stripe subscriptions in the next 60 days?

Customer success managers

Know which accounts to call

A ranked list with owners and last activity tells you who needs attention first.

Show the top 15 Stripe churn risks with their HubSpot owner and last activity.

Sales managers

Protect open deals

At-risk customers with open deals are visible, so the deal team can act.

Which at-risk Stripe customers have open deals or tickets in HubSpot?

How it works

What PopdockAI does when you ask

You give a renewal window, and your AI assistant ranks at-risk Stripe customers with HubSpot context. It only reads and lists customers not found in HubSpot.

01

Ask

You give a renewal window and how many accounts to show.

Your AI tool

02

Score

It collects at-risk Stripe subscriptions and scores each customer once.

stripe-get-subscription
stripe-get-customer
stripe-get-subscription-item

03

Match

It finds the HubSpot contact or company and adds owner, activity, tickets and deals.

hubspot-get-contacts
hubspot-get-companies
hubspot-get-tickets
hubspot-get-deals

04

Report

You get a ranked list and revenue at risk per currency.

Your AI tool

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.

get-data

stripe-get-subscription

Returns subscriptions (customer, status, billing period, cancellation, trial) from Stripe.
get-data

stripe-get-customer

Returns customer records (name, email, balance, delinquency, address) from Stripe.
get-data

stripe-get-subscription-item

Returns subscription line items (product, price, quantity, billing period) from Stripe.
get-data

hubspot-get-contacts

Returns contact records from HubSpot CRM, with email, phone, company, lifecycle stage, lead status, owner and location from the HubSpot connector. Filter by company id, state region, contact owner, email, last name, create date, company name, record id, lifecycle stage, lead status.
get-data

hubspot-get-companies

Returns company records from HubSpot CRM, with domain, industry, lifecycle stage, owner, location and revenue from the HubSpot connector. Filter by record id, company domain name, industry, lifecycle stage, annual revenue, state region, company owner, company name, create date, country region.
get-data

hubspot-get-tickets

Returns support tickets from HubSpot, with name, status, priority, category, owner, dates and associated contact and company from the HubSpot connector. Filter by category, record id, priority, ticket name, create date, ticket status, company id, contact id, ticket owner.
get-data

hubspot-get-deals

Returns deals from HubSpot CRM, with amount, stage, pipeline, close date, owner and associated company and contact from the HubSpot connector. Filter by pipeline name, close date, deal stage name, deal type, record id, company id, deal name, amount, deal owner.
Read only.Nothing in Stripe Changes

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.

How Popdock AI secures your data

The outcome

The accounts most likely to churn, worked first

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

All Ramp use cases

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.

Try PopdockAI Free
See Documentation