/
/
Get every Rillet customer onto your Constant Contact list
For marketers who want Rillet customer emails missing from Constant Contact added to a list, with consent set only as you confirm.
On this page
Connector
Connect Rillet, pick your AI tool and paste the prompt.
The problem
Paying customers who never make it onto your marketing list
Billing emails sit in Rillet while your Constant Contact lists grow separately, so many customers never hear your news. Closing the gap by hand means comparing two sets of addresses, removing duplicates and guessing at consent.
Without PopdockAI
- Export customer emails from Rillet
- Compare them by hand with the Constant Contact list
- Remove duplicates and invalid addresses
- Guess what consent each person gave
With PopdockAI
- Rillet emails read and checked against Constant Contact
- Existing contacts counted and left unchanged
- Consent set only to what you confirm
- Invalid addresses skipped and failures reported
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Make sure every Rillet customer email (optionally only customers whose name contains `{customer-name-contains}`) exists in Constant Contact, adding the missing ones to the list named `{list-name}` only after the user confirms.
**Step 1: Resolve the target list**
Call `constant-contact-get-contact-list` (constant-contact server) with `name` set to `{list-name}`. If nothing comes back, retry with `name.contains`. If several lists match, show them with `name`, `list-id` and `active-members` and ask which to use. If none match, say so and stop: this prompt does not create lists.
**Step 2: Read customer emails from Rillet**
Call `rillet-get-customer-emails` (rillet server). If `{customer-name-contains}` is given, keep rows whose `name` contains it, ignoring case. Remove duplicate emails.
**Step 3: Find the gap**
For each email, call `constant-contact-get-contact` (constant-contact server) with `email-address`. Sort each email into one of:
* **Missing:** no contact found. These are the candidates to add.
* **Present:** contact found. Do not change it.
**Step 4: Confirm**
Show a table of the Missing emails with the Rillet customer `name`, `customer-id` and `email-type`, and the count of Present emails. Ask the user to confirm adding the Missing contacts to the chosen list, and to confirm whether these people have given permission to receive marketing email. Do not continue without an explicit yes.
**Step 5: Add the contacts**
For each confirmed email, call `constant-contact-add-contact` (constant-contact server) once with `email`, `list-id` from Step 1, and `company-name` set to the Rillet customer name. Set `permission-to-send` only to the value the user confirmed in Step 4; if they did not confirm consent, leave it unset. Then call `constant-contact-get-contact` with `email-address` to confirm each one exists.
**Step 6: Report**
Counts of Present, Added and Failed, and a table of any failures with the error returned.
**Rules & Guidelines:**
* Tools starting rillet- are on the rillet server; tools starting constant-contact- are on the constant-contact server.
* `constant-contact-add-contact` is the only tool that may write, and only after the confirmation in Step 4. Call it once per email and never retry a call that returned an error without asking.
* Do not call `constant-contact-update-contact`, `constant-contact-add-contact-list`, `constant-contact-add-contact-tag` or any other constant-contact-add-* or constant-contact-update-* tool, and do not call any rillet-add-* or rillet-update-* tool. Rillet is read-only here.
**Validation:**
* If nothing is Missing, say every customer email is already in Constant Contact and stop.
* Skip rows whose email is blank or not a valid address, and list them as skipped.Who it's for
One answer, three teams that use it
Email marketers
Reach every paying customer with your news
Bring billing customers onto the list you send from, without exporting and matching two address files by hand.
Which Rillet customers are missing from our Product updates list in Constant Contact? Add them once I approve.
Customer marketing
Grow the customer list from real accounts
Every addition comes from a customer you bill, so the list reflects the accounts that pay you.
Add Rillet customers whose names include Contoso to our Customer news list in Constant Contact.
Marketing operations
Keep consent records honest
Permission is set only to what you confirm, and existing contacts are left exactly as they are.
Sync missing Rillet customer emails into Constant Contact, but ask me about consent before adding anyone.
How it works
What PopdockAI does when you ask
You name the Constant Contact list and your AI assistant finds the Rillet customers who are not on it. Nothing is added until you approve the list and state the consent they gave.
01
Ask
You name the Constant Contact list, and optionally part of a customer name.
02
Compare
It reads Rillet customer emails and checks each in Constant Contact.
03
Confirm
You approve the additions and say whether they gave consent.
04
Add
It adds the missing contacts and reports any failures.
What PopdockAI provides
The tools behind the answer
Ready made tools for Rillet and one secure connection to your AI tool. No code, no exports.
constant-contact-get-contact-list
rillet-get-customer-emails
constant-contact-get-contact
constant-contact-add-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
Billing customers on your list once, with consent recorded
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)
