/
/
Match Wave customers to your Constant Contact contacts
For marketing teams who want to see which customers are not on the email list, just by asking their AI assistant.
On this page
Connector
Connect Wave, pick your AI tool and paste the prompt.
The problem
Two customer lists that never quite agree
Matching the accounting customer list to the email list by hand means two exports. People are missed, and gaps such as paying customers who are not on the list go unseen.
Without PopdockAI
- Export the customers from Wave
- Export the contacts from Constant Contact
- Compare email addresses by eye
- Miss differences in letter case and duplicates
With PopdockAI
- Active customers are read from Wave
- Each email is looked up in Constant Contact, ignoring case
- Duplicates are listed rather than picked
- Matched, missing and no email are reported with counts
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Compare Wave customers with Constant Contact contacts, matching on email, for the Wave company `{company}` (limit to the first {max-records} customers, default 100).
**Step 1: Read Wave customers (wave-ai server)**
Call `wave-get-customer` with `company` = `{company}`, `is-active` = true and `max-records` = `{max-records}`. Keep `name`, `email`, `outstanding-amount` and `overdue-amount`. Set aside customers with no email as "no email on file".
**Step 2: Look each email up in Constant Contact (constant-contact server)**
For each customer email call `constant-contact-get-contact` with `email-address` set to that email. Record `contact-id`, `permission-to-send` and `tags` when a contact is returned. Compare emails case-insensitively. If nothing is returned, mark the customer "not in Constant Contact".
**Step 3: Report**
Give three tables: matched (customer, email, permission-to-send), Wave customers missing from Constant Contact (with outstanding amount), and customers with no email. End with counts for each.
**Rules & Guidelines:**
* `wave-get-customer` is on the wave-ai server; `constant-contact-get-contact` is on the constant-contact server.
* 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 `wave-get-customer` returns nothing, say so and stop.
* If one email returns more than one contact, list them all and do not pick one.
* If results hit `{max-records}`, say the list may be truncated.Who it's for
One answer, three teams that use it
Email marketers
Find customers not on the list
See which paying customers are missing from Constant Contact, so campaigns reach the people who should get them.
Which active Wave customers are not in Constant Contact?
Account managers
Check permission to send
See which of your customers have permission to receive emails before you plan outreach.
Match the first 50 Wave customers to Constant Contact and show their permission to send.
Bookkeepers
Find customers with no email on file
Get the list of Wave customers with no email, so the records can be completed.
For Fabrikam Studio in Wave, list active customers with no email address and who owes the most.
How it works
What PopdockAI does when you ask
You name the Wave company, and your AI assistant checks each customer's email in Constant Contact. It only reads, and flags results that may be truncated.
Ask
You name the Wave company and how many customers to check.
Match
It reads active Wave customers and looks each email up in Constant Contact, ignoring case.
Report
You get matched customers, those missing from Constant Contact and those with no email, with counts.
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
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
See exactly who is missing from the email list
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)
