Connectors

/

Rillet

/

Add missing Rillet customers to a Mailchimp audience
Write
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Add missing Rillet customers to a Mailchimp audience
Add Rillet customers who are not in our Customers audience in Mailchimp.
31 Rillet customer emails are not in the Customers audience. - Add as pending: 31, each gets an opt-in email - Left out: unsubscribed and cleaned members already present - Example: ap@contoso.com, Contoso Ltd Shall I add the 31 as pending?
Rillet
Sample figures. Your results come from your own account.
mailchimp-get-list
rillet-get-customer-emails
mailchimp-get-list-member
mailchimp-add-list-member

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Rillet

Rillet
Run it on your own Rillet data.

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

Try PopdockAI free

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.

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

Your AI tool

02

Compare

It compares Rillet customer emails with every member in any status.

mailchimp-get-list
rillet-get-customer-emails
mailchimp-get-list-member

03

Confirm

You review the emails to add and remove any rows.

No items found.

04

Add

New members go in as pending, and each is read back.

Your AI tool

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.

get-data

mailchimp-get-list

Returns Mailchimp lists (audiences) with member counts, open and click rates, and recent campaign activity.
get-data

rillet-get-customer-emails

Returns customer email addresses with their type and the customer's location from Rillet.
get-data

mailchimp-get-list-member

Returns the members (subscribers) of Mailchimp audiences, with subscription status, tags and engagement rating. Filter by email address or status to look someone up.
run-action

mailchimp-add-list-member

Adds a contact to a Mailchimp audience with an email address, name and subscription status.
Read only.Nothing in Rillet 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

Paying customers in your audience, opt-outs respected

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

All Ramp use cases

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