/
/
Find customers who owe money and unsubscribed from email
For finance teams who want to know which Wave customers with balances opted out of Constant Contact, by asking their AI assistant.
On this page
Connector
Connect Wave, pick your AI tool and paste the prompt.
The problem
Customers who opted out never see your reminders
Reminders sent through Constant Contact skip anyone who unsubscribed, and nobody checks who owes money. Finding them means matching Wave balances to Constant Contact status email by email.
Without PopdockAI
- List Wave customers with outstanding balances
- Search each email in Constant Contact
- Open each unsubscribe record for the reason and date
- Notice too late that reminders never arrived
With PopdockAI
- Customers above your balance threshold are listed from Wave
- Each email is checked in Constant Contact
- Unsubscribe reason and date are shown
- Direct invoice reminders are recommended and nothing is sent
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For the Wave company `{company}`, list customers with an outstanding balance of at least `{min-outstanding}` (default 1) who are not subscribed in Constant Contact.
**Step 1: Customers with balances (wave-ai server)**
Call `wave-get-customer` with `company` = `{company}` and `outstanding-amount.min` = `{min-outstanding}`. Keep `name`, `email`, `outstanding-amount`, `overdue-amount`, `currency-code`.
**Step 2: Subscription state (constant-contact server)**
For each customer email call `constant-contact-get-contact` with `email-address` = that email and read `permission-to-send`. For contacts that are not subscribed also call `constant-contact-get-campaign-unsubscribe` with `email-address` = that email and keep `reason` and `created-date`.
**Step 3: Report**
Table: customer, email, balance and currency, Constant Contact status (subscribed, unsubscribed, not a contact), unsubscribe date and reason. Recommend a direct invoice reminder from Wave for the unsubscribed ones; do not suggest marketing email.
**Rules & Guidelines:**
* `wave-get-customer` is on wave-ai; `constant-contact-get-contact` and `constant-contact-get-campaign-unsubscribe` are on constant-contact.
* Read-only. Do NOT call `wave-add-customer`, `wave-update-customer`, `wave-delete-customer`, `wave-add-invoice`, `wave-update-invoice`, `wave-delete-invoice`, `wave-send-invoice`, `wave-add-invoice-payment` or any other Wave write tool, or `constant-contact-add-contact`, `constant-contact-update-contact`, `constant-contact-add-campaign`, `constant-contact-resend-campaign-to-non-openers` or any other Constant Contact write tool.
**Validation:**
* If no customer has a balance, say so and stop.
* If a customer has no email, list them as "no email on file".Who it's for
One answer, three teams that use it
Accounts receivable
Send reminders by a channel that works
Know who cannot receive marketing email so you send invoice reminders directly instead.
List Wave customers owing over 50 who are unsubscribed in Constant Contact, company Northwind Traders.
Finance managers
See how much is stuck behind opt outs
Size the balance held by customers who unsubscribed so you can plan collections.
How much do unsubscribed Constant Contact contacts owe us in Wave for Fabrikam Holdings?
Email marketers
Keep promotions away from people who owe
Know which customers opted out and owe money so campaigns and collections do not collide.
Which Wave customers with a balance are not subscribed in Constant Contact, and why did they unsubscribe?
How it works
What PopdockAI does when you ask
You give the Wave company and your AI assistant reads Wave, then Constant Contact. It only reads, and it never suggests marketing email to unsubscribed people.
Ask
You give the Wave company and optionally a minimum balance.
Collect
It lists Wave customers with an outstanding balance at or above that amount.
Check
It looks up each email in Constant Contact and reads the unsubscribe reason and date.
Report
It tables status per customer and recommends direct invoice reminders for the unsubscribed.
What PopdockAI provides
The tools behind the answer
Ready made tools for Wave and one secure connection to your AI tool. No code, no exports.
wave-get-customer
constant-contact-get-contact
constant-contact-get-campaign-unsubscribe
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
Reminders that reach the people who owe
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)
