Connectors

/

Shopify

/

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

Add opted-in Shopify customers to Mailchimp without breaking consent

For marketers who want Shopify buyers who accepted marketing added to a Mailchimp audience, with past unsubscribes respected, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Add missing Shopify customers to a Mailchimp audience
Add the Shopify customers from the last 30 days who accept marketing to our Northwind Customers audience in Mailchimp.
24 Shopify customers can be added to Northwind Customers. - Status: pending, for double opt-in - Left alone: 9 already members in some status - Left alone: 2 found in the unsubscribe history Shall I add the 24 members?
Shopify
Sample figures. Your results come from your own account.
mailchimp-get-list
shopify-get-customer
mailchimp-get-list-member
mailchimp-get-campaign-unsubscribe
mailchimp-add-list-member

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Shopify

Shopify
Run it on your own Shopify data.

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

Try PopdockAI free

The problem

Shopify subscribers slip through before they reach Mailchimp

Customers who agree to marketing at Shopify checkout do not always reach your Mailchimp audience. Fixing it by hand means comparing them one by one, and adding back someone who unsubscribed or was cleaned breaks their consent.

Without PopdockAI

  • Export recent Shopify customers who accept marketing
  • Search the Mailchimp audience for each email
  • Dig through unsubscribe history to avoid re-adding anyone
  • Risk a consent complaint when one slips back in

With PopdockAI

  • Opted-in Shopify customers with an email are read for you
  • Existing members in any status and past unsubscribes are left alone
  • You see who will be added and their status before anything is written
  • Each new member is read back to confirm it landed

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** Find Shopify customers created on or after `{customer-created-from}` (default: 30 days before today) who accept marketing but are not on the Mailchimp audience named `{list-name}`, and after confirmation add them with status `{subscribe-status}` (default pending, which sends a double opt-in email).

**Step 1: Resolve the audience in Mailchimp**

Call `mailchimp-get-list` with `name` = `{list-name}`. If it does not match exactly one audience, list the matches and stop. Note `list-id`.

**Step 2: Candidate customers from Shopify**

Call `shopify-get-customer` with `created-at.from` = `{customer-created-from}` and `max-records` = 250. Keep only customers whose `accepts-marketing` is true and who have an `email`. Note `first-name` and `last-name`.

**Step 3: Check each against Mailchimp**

For each candidate, call `mailchimp-get-list-member` with `email` and `list-name` = `{list-name}`.

* No member: a candidate to add.
* Member with any status (subscribed, pending, unsubscribed, cleaned, archived): leave alone. Never re-add someone who unsubscribed or was cleaned; list them separately as "consent withdrawn in Mailchimp".

Also call `mailchimp-get-campaign-unsubscribe` with `email` for each candidate; anyone who appears there is not a candidate, even if they are absent from this audience.

**Step 4: Confirm**

Show a table of the people to add (name, email, Shopify customer since) and the status they will be given. Ask the user to confirm. Do not continue without an explicit yes. If the user removes people, drop them.

**Step 5: Add**

For each confirmed person, call `mailchimp-add-list-member` once with `list-id` from Step 1, `email-address`, `status` = `{subscribe-status}` (pending if empty), `first-name` and `last-name`. If a call fails, record the error and continue with the next.

**Step 6: Verify and report**

Call `mailchimp-get-list-member` with each added email and `list-name` = `{list-name}` to confirm the member exists. Report added, failed (with the error), skipped as already present, and skipped for withdrawn consent.

**Rules & Guidelines:**

* `shopify-*` tools are on the shopify server and are read only here; `mailchimp-*` tools are on the mailchimp server.
* The only write tool this prompt may call is `mailchimp-add-list-member`, only in Step 5, only after confirmation. Do NOT call `mailchimp-update-list-member`, `mailchimp-add-customer`, `shopify-update-customer` or any other add or update tool.
* Match on email only, case-insensitive and trimmed.
* Accept only subscribed or pending for `{subscribe-status}`; refuse anything else and stop.

**Validation:**

* If there are no candidates, say the audience is already in step with Shopify and stop.
* If Step 2 returns 250 customers, say the run was capped and suggest a later `{customer-created-from}`.

Who it's for

One answer, three teams that use it

Email marketers

Keep the audience growing with real buyers

Add shoppers who agreed to marketing without a spreadsheet comparison, so every campaign reaches your newest customers.

Add Shopify customers since 15 September who accept marketing to our Contoso Shoppers audience in Mailchimp.

Marketing operations

Respect every unsubscribe automatically

Past unsubscribes and cleaned contacts are checked first, so a catch-up sync never puts someone back on the list.

Which opted-in Shopify customers are missing from the Fabrikam Newsletter audience? Leave out anyone who ever unsubscribed.

Privacy and compliance

Show consent was honoured on every add

Members are added as pending by default, so double opt-in stays in place and you can see why each person was skipped.

Before we add new Shopify buyers to Mailchimp, show me who would be added as pending and who is skipped for past unsubscribes.

How it works

What PopdockAI does when you ask

You name the audience, and your AI assistant checks each opted-in Shopify customer against Mailchimp and its unsubscribe history. Members are added only after you confirm, pending by default for double opt-in.

01

Ask

You name the Mailchimp audience and optionally a start date.

Your AI tool

02

Check

It reads opted-in Shopify customers and skips existing members and past unsubscribes.

shopify-get-customer
mailchimp-get-list-member
mailchimp-get-campaign-unsubscribe

03

Confirm

You see who will be added and their status, pending by default, and say yes.

No items found.

04

Add

It adds each member and reads them back.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Shopify 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

shopify-get-customer

Returns Shopify customers with their account state, total spent and default address. Filter by name, email, tags, customer id, city, province, created date and total spent.
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.
get-data

mailchimp-get-campaign-unsubscribe

Returns the members who unsubscribed from each Mailchimp campaign, with the date and the reason they gave.
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 Shopify 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

Consenting customers in, withdrawn consent kept out

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