/
/
Add missing Rillet customers to Mailchimp with opt-in
For marketers who want every Rillet customer email in a Mailchimp audience, without re-adding anyone who unsubscribed or was cleaned.
On this page
Connector
Connect Rillet, pick your AI tool and paste the prompt.
The problem
Closing the audience gap can re-add people who opted out
Rillet billing contacts and your Mailchimp audience drift apart as customers are added, and closing the gap means matching two exports by email. Re-add someone who unsubscribed or was cleaned and you override their consent and hurt your sender reputation.
Without PopdockAI
- Export Rillet customer emails and Mailchimp members
- Match the two files by email
- Miss the unsubscribed and cleaned members
- Import them as subscribed and hope for the best
With PopdockAI
- Every member checked in any status, including unsubscribed
- A table of emails to add, with rows you can remove
- New members added as pending by default
- Each address read back as added or failed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Add the Rillet customer emails that are not yet in the Mailchimp audience `{list-name}`, using member status `{member-status}` (default pending, which sends Mailchimp's opt-in confirmation).
**Step 1: Confirm the audience**
Call `mailchimp-get-list` with `name.contains` set to `{list-name}`. Continue only if exactly one audience matches; otherwise list the matches (or say there are none) and stop. Keep its `list-id`.
**Step 2: Find the gap**
* Call `rillet-get-customer-emails` (no filters).
* Call `mailchimp-get-list-member` with `list-name` set to the confirmed name and `max-records` covering the audience size.
* Match emails case-insensitively after trimming spaces. A Rillet customer can have several emails (`email-type`), and one email can appear on more than one Rillet customer: keep every pairing and say so in the report. Drop every email that already has a member row in ANY status, including unsubscribed and cleaned.
**Step 3: Show the plan and stop**
Present a table of the emails to add: email, Rillet customer name, `customer-id`, and the status they will get. State the total. Then ask the user to confirm. Do not write anything until they explicitly confirm; if they remove rows, use the edited list.
**Step 4: Add the members**
For each confirmed email, call `mailchimp-add-list-member` once with `list-id` from Step 1, `email-address` set to the email, and `status` set to the member status. Leave `first-name` and `last-name` empty, because Rillet stores the company name, not the person's name.
**Step 5: Confirm and report**
Call `mailchimp-get-list-member` with `list-name` and `email` for each added address and report: added, already present, and failed (with the error).
**Rules & Guidelines:**
* Tools named mailchimp- come from the mailchimp MCP server; tools named rillet- come from the rillet MCP server. If a tool from either server is missing, stop and say which server is not connected rather than working around it.
* The only key shared by the two systems is the email address. Mailchimp `customer-id` values (e-commerce store customers) are NOT Rillet customer ids; never pass one system's id into the other.
* The only write tool this prompt may call is `mailchimp-add-list-member` on the mailchimp server, and only after the user confirms the plan in Step 3.
* Never call `mailchimp-update-list-member`, and never add or re-subscribe anyone whose existing status is unsubscribed or cleaned. Doing so overrides their consent.
* Do not call any Rillet tool whose name starts with rillet-add-, rillet-update-, rillet-apply-, rillet-unapply-, rillet-record-, rillet-set- or rillet-setup-.
**Validation:**
* If `{member-status}` is empty, use pending. Accept only pending, subscribed or transactional; for anything else, ask the user to choose.
* Use subscribed only if the user states they already hold marketing consent for these contacts.
* If the gap is empty, report that every Rillet customer email is already in the audience and stop.
* If an add fails because the address is invalid or previously removed by Mailchimp, record it as failed and continue with the rest.Who it's for
One answer, three teams that use it
Email marketers
Cover every paying customer in Mailchimp
Find the customers your audience is missing and add them with an opt-in, without matching exports in a spreadsheet.
Which Rillet customers are not in our Newsletter audience in Mailchimp? Show me before adding them.
Marketing operations
Never override an unsubscribe
Anyone already in the audience in any status is left out, so a cleaned or unsubscribed address is never brought back.
Add new Rillet customers to the Customers audience as pending, and skip anyone who unsubscribed.
Customer success
Make sure new accounts get customer email
New billing customers land in the audience your onboarding and product emails go to, once you approve them.
Add the Rillet customers we signed this quarter, like Fabrikam, to our Mailchimp customer audience.
How it works
What PopdockAI does when you ask
You name the Mailchimp audience and your AI assistant compares it with every Rillet customer email. Nothing is written until you confirm, and new people go in as pending so Mailchimp asks for opt-in.
01
Ask
You name the Mailchimp audience.
02
Compare
It compares Rillet customer emails with every member in any status.
03
Confirm
You review the emails to add and remove any rows.
04
Add
New members go in as pending, and each is read back.
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.
mailchimp-get-list
rillet-get-customer-emails
mailchimp-get-list-member
mailchimp-add-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
Paying customers in your audience, opt-outs respected
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)
