Connectors

/

Salesforce

/

Salesforce contact and Stripe billing snapshot
Read
Cross-Connector

Check a contact's Stripe billing before you call them

For sales reps about to reach out who want the Salesforce contact and their Stripe billing side by side, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Salesforce contact and Stripe billing snapshot
Before I call jordan.lee@contoso.com, what does Salesforce say about them and are they in good standing in Stripe?
Jordan Lee is Operations Director at Contoso Ltd, and their Stripe account is past due. - Salesforce: 1 open deal, Contoso Expansion, 48,000 USD, Proposal - Subscription: past due, period ends 2026-10-15 - Open invoice: INV-1042, 2,400 USD, due 2026-09-30 - Charges: 1 failed in the last 90 days, no disputes Know before you call: raise the overdue invoice before the expansion.
Salesforce
Sample figures. Your results come from your own account.
salesforce-get-contact
salesforce-get-lead
salesforce-get-account
salesforce-get-opportunity
stripe-get-customer
stripe-get-subscription
stripe-get-invoice
stripe-get-charge

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Salesforce

Salesforce
Run it on your own Salesforce data.

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

Try PopdockAI free

The problem

Calling a customer without knowing they are past due

Before a call, a rep sees the Salesforce contact and deals but not whether the Stripe subscription is past due, an invoice is open or a charge was disputed. Getting that means asking finance or searching Stripe by email.

Without PopdockAI

  • Look up the contact and deals in Salesforce
  • Ask finance about the customer's billing
  • Or log into Stripe and search by email
  • Get blindsided by a payment problem on the call

With PopdockAI

  • The Salesforce contact or lead, account and deals are found
  • Stripe subscriptions, open invoices and charges are read
  • Failures, refunds and disputes are counted
  • Read only, with name mismatches flagged rather than decided

The prompt

Use this prompt

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

Prompt
**Objective:** For the email `{contact-email}`, show who the person is in Salesforce and how they are billed in Stripe, looking back `{lookback-days}` days for charges (default 90).

**Step 1: Find the contact in Salesforce**

Call `salesforce-get-contact` with `email` set to `{contact-email}`. If nothing comes back, also call `salesforce-get-lead` with `email` set to `{contact-email}` and report the lead instead. If more than one contact matches, list them all.

**Step 2: Read the account and its open deals**

If the contact has an account-id, call `salesforce-get-account` with `account-id` set to it, and `salesforce-get-opportunity` with `account-id` set to it and `closed` set to false.

**Step 3: Find the Stripe customer**

Call `stripe-get-customer` with `email` set to `{contact-email}`. If nothing comes back, report the person as present in Salesforce and absent from Stripe and go straight to the report.

**Step 4: Read billing**

With the Stripe customer-id, call `stripe-get-subscription` (customer-id), `stripe-get-invoice` (customer-id, status open) and `stripe-get-charge` (customer-id, created.from set to today minus the lookback). Count failed charges, refunded charges and disputed charges.

**Step 5: Report**

Two short sections side by side in a table or two lists: Salesforce (contact name, title, account, account owner, open opportunities with stage, amount and close-date) and Stripe (customer-id, delinquent, balance, each subscription with status and current-period-end, open invoices with amount-remaining and due-date, charges summary). End with one line of what a rep should know before contacting this person.

**Rules & Guidelines:**

* `salesforce-get-contact`, `salesforce-get-lead`, `salesforce-get-account` and `salesforce-get-opportunity` are on the salesforce server. `stripe-get-customer`, `stripe-get-subscription`, `stripe-get-invoice` and `stripe-get-charge` are on the stripe server.
* Match emails case-insensitively and trimmed.
* This is read-only. Do not call `salesforce-update-contact`, `salesforce-update-account`, `salesforce-update-opportunity`, `salesforce-add-task`, `salesforce-add-case` or any other salesforce add or update tool.

**Validation:**

* If neither system knows the email, say so and stop.
* If the Stripe customer name and the Salesforce contact or account name clearly disagree, show both and flag it; do not decide which is right.

Who it's for

One answer, three teams that use it

Account executives

Avoid surprises on customer calls

Know about past due subscriptions or disputed charges before you pitch an upsell.

Is priya@contoso.com in good standing in Stripe, and what deals do we have open with them?

Customer success managers

Check account health before outreach

See billing problems alongside the relationship so check ins address the real issues.

Give me a Salesforce and Stripe snapshot for lee@fabrikam.com over the last 90 days.

Collections specialists

See who owns the relationship

Find the account owner and open deals for a customer with billing trouble before you contact them.

Who owns billing@northwindtraders.com in Salesforce, and do they have open invoices or failed charges in Stripe?

How it works

What PopdockAI does when you ask

You give an email address, and your AI assistant shows the Salesforce record next to the customer's Stripe billing. Nothing is changed in either system.

01

Ask

You give an email address.

Your AI tool

02

Read

It finds the Salesforce contact or lead with the account and open deals.

salesforce-get-contact
salesforce-get-lead
salesforce-get-account
salesforce-get-opportunity

03

Check

It reads the Stripe customer's subscriptions, open invoices and charges.

stripe-get-customer
stripe-get-subscription
stripe-get-invoice
stripe-get-charge

04

Report

You see both sides and one line on what to know before reaching out.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Salesforce and one secure connection to your AI tool. No code, no exports.

get-data

salesforce-get-contact

Returns Salesforce contacts with their account, title, department, email, phone, mailing address, owner and lead source. Filter by name, email, account, title, owner, lead source and mailing city or state.
get-data

salesforce-get-lead

Returns Salesforce leads with their company, status, source, owner, contact details, location and whether they are converted. Filter by name, company, email, status, lead source, owner, state, converted flag and created date.
get-data

salesforce-get-account

Returns Salesforce accounts with their type, industry, owner, billing address, phone and annual revenue. Filter by name, account number, type, industry, owner, billing city or state, annual revenue and created date.
get-data

salesforce-get-opportunity

Returns Salesforce opportunities with their account, stage, amount, probability, close date, next step, owner and whether they are closed or won. Filter by name, account, stage, owner, amount, close date and closed and won flags.
get-data

stripe-get-customer

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

stripe-get-subscription

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

stripe-get-invoice

Returns invoices (number, customer, status, dates, totals, amount remaining) from Stripe.
get-data

stripe-get-charge

Returns charges (amount, status, refunds, customer, card used) from Stripe.
Read only.Nothing in Salesforce 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

Every call starts with the billing picture

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