/
/
Know if email will reach customers with overdue Wave invoices
For finance teams who chase overdue invoices by email and want their AI assistant to check each customer in Mailchimp first.
On this page
Connector
Connect Wave, pick your AI tool and paste the prompt.
The problem
Overdue reminders may never be read
Before chasing overdue invoices by email you would have to find each customer's address and check it in Mailchimp. Without that, a bounce or an unsubscribe means the reminder goes nowhere.
Without PopdockAI
- List overdue invoices in Wave
- Look up each customer's email
- Search each address in Mailchimp
- Count opens, bounces and unsubscribes by hand
With PopdockAI
- Overdue invoices and customer emails are read together
- Customers it cannot resolve are marked, not guessed
- Each address is checked for status and recent activity
- Verdicts and amounts per group come back, with nothing written
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For overdue Wave invoices over {min-amount-due} (default 0), show whether the customer's email address is reachable and responsive in Mailchimp, over the last {lookback-days} days (default 60).
**Step 1: Overdue invoices in Wave**
Call `wave-get-invoice` (wave-ai server) with `status` = OVERDUE, `amount-due.min` = {min-amount-due} and `max-records` = 25. Keep `invoice-number`, `customer-name`, `amount-due` and `due-date`.
**Step 2: Get each customer's email**
For each distinct `customer-name`, call `wave-get-customer` (wave-ai server) with `name` = that name. If it returns more than one, or none, mark the invoice "customer unresolved" and move on. Keep `email`.
**Step 3: Mailchimp activity**
Call `mailchimp-get-campaign-email-activity` (mailchimp server) with `email-address` = that email and `activity-date.from` set {lookback-days} days back. Count opens, clicks, bounces and unsubscribes by `action`. Call `mailchimp-get-list-member` (mailchimp server) with `email` to get `status`.
**Step 4: Report**
Per invoice: invoice number, customer, amount due, days overdue, Mailchimp status, activity counts, and a verdict of reachable, silent, bouncing or unsubscribed. Finish with the totals of amount due in each verdict.
**Rules & Guidelines:**
* `wave-get-invoice` and `wave-get-customer` are on the wave-ai server; the Mailchimp tools are on the mailchimp server.
* Do not call any write tool on either server, including `wave-add-customer`, `wave-update-customer`, `wave-send-invoice`, `mailchimp-add-list-member`, `mailchimp-update-list-member`, `mailchimp-add-segment-member`, `mailchimp-start-automation` or `mailchimp-pause-automation`.
**Validation:**
* If the customer has no email or no Mailchimp record, verdict "not in Mailchimp" and say the reminder must go another way.
* If Wave returns no overdue invoices, say so and stop.Who it's for
One answer, three teams that use it
Accounts receivable
Decide who to email and who to call
Split overdue customers into those email can reach and those who need a call or letter before you send reminders.
Check Mailchimp reachability for Wave invoices overdue by more than 500, looking at the last 90 days.
Finance managers
See how much sits behind unreachable addresses
Total the overdue amount held by bouncing or unsubscribed customers to size the collections risk.
How much overdue Wave money belongs to customers who bounced or unsubscribed in Mailchimp?
Credit controllers
Prepare a collections plan
Use a reachable, silent, bouncing or unsubscribed verdict to choose the first step for each overdue account.
For overdue Wave invoices, which customers are silent in Mailchimp so I should phone them first?
How it works
What PopdockAI does when you ask
You set the thresholds and your AI assistant reads Wave, then Mailchimp. It only reads, and it says when a reminder must go by another route.
Ask
You set a minimum amount due and how many days of email activity to review.
Collect
It reads overdue Wave invoices and finds each customer's email, marking unclear ones unresolved.
Check
It looks up each address in Mailchimp and counts opens, clicks, bounces and unsubscribes.
Report
It gives a verdict per invoice and totals the amount due in each verdict.
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-invoice
wave-get-customer
mailchimp-get-campaign-email-activity
mailchimp-get-list-member
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
Chase the right customers the right way
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)
