Connectors

/

Wave

/

Match Wave customers to Constant Contact contacts
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Match Wave customers to Constant Contact contacts
Compare our active Wave customers for Contoso Retail with Constant Contact and tell me who is not on the email list.
Of 100 Wave customers, 78 are in Constant Contact, 14 are missing and 8 have no email. - Matched: 78 customers, 71 with permission to send - Missing: Fabrikam Studio, 1,310.00 outstanding - Missing: Adventure Works, 640.00 outstanding - Note: the limit of 100 was reached, so the list may be truncated Want the full table of the 14 missing customers?
Wave
Sample figures. Your results come from your own account.
wave-get-customer
constant-contact-get-contact

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Wave

Wave
Run it on your own Wave data.

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

Try PopdockAI free

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.

Prompt
**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.

Your AI tool

Match

It reads active Wave customers and looks each email up in Constant Contact, ignoring case.

wave-get-customer
constant-contact-get-contact

Report

You get matched customers, those missing from Constant Contact and those with no email, with counts.

No items found.

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.

get-data

wave-get-customer

Returns customers from Wave. Wave connector tool; filter by the parameters it offers.
get-data

constant-contact-get-contact

Returns Constant Contact contacts with their name, email, company, job title, phone, location, tags and email permission. Filter by email address or domain, last name, company, state, permission and created date.
Read only.Nothing in Wave 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

See exactly who is missing from the email list

Try PopdockAI free
Get a live demo

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.

Try PopdockAI Free
See Documentation