Connectors

/

Shopify

/

Reconcile Shopify marketing consent with Drip
Report
Cross-Connector

Find where Shopify consent and Drip subscriptions disagree

For email marketers who want Shopify marketing consent checked against Drip subscriber status, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Reconcile Shopify marketing consent with Drip
Audit marketing consent between Shopify and Drip for customers since 1 August.
412 customers checked, and 48 disagree. - Missing from Drip: 27 consented in Shopify - No Shopify consent: 12 are being marketed in Drip - Opted out in Drip only: 9 - In agreement: 364 Want the tables with tags and status?
Shopify
Sample figures. Your results come from your own account.
shopify-get-customer
drip-get-subscriber

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

Consent in Shopify and Drip can quietly disagree

Shopify records whether a customer accepts marketing and Drip records whether they are subscribed, and the two can disagree. That leaves you emailing people who never consented, or missing people who did.

Without PopdockAI

  • Export recent Shopify customers with their consent
  • Look up each one in Drip, minding email case
  • Sort them into buckets by hand
  • Decide what to do for each problem group

With PopdockAI

  • Recent Shopify customers with an email are looked up in Drip
  • A lowercase retry runs before anyone is called missing
  • Each customer lands in one consent bucket, with counts
  • Problem buckets get a table and a next step, and nothing is changed

The prompt

Use this prompt

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

Prompt
**Objective:** For Shopify customers created on or after `{since-date}` (default 30 days ago), find where Shopify marketing consent and Drip subscriber status disagree, checking at most `{max-customers}` customers (default 50).

**Step 1: List the Shopify customers**

Call `shopify-get-customer` with `created-at.from` set to `{since-date}` (or 30 days before today, YYYY-MM-DD, if blank) and `max-records` set to `{max-customers}` (default 50). Keep customers with an email; count and skip the ones without.

**Step 2: Look each one up in Drip**

For each customer, call `drip-get-subscriber` with `email` set to the Shopify email. Record the Drip status, or that no subscriber was found.

**Step 3: Classify**

Put every customer into exactly one bucket:

* **Missing from Drip:** accepts-marketing is true in Shopify, no Drip subscriber.
* **Marketed without consent:** accepts-marketing is false in Shopify, Drip status is active.
* **Opted out in Drip only:** Drip status is unsubscribed, accepts-marketing is true in Shopify.
* **In agreement:** everything else.

**Step 4: Report**

A count per bucket, then a table for each of the first three buckets with: email, Shopify name, accepts-marketing, Drip status, Drip tags. Do not list the customers who are in agreement. End with one line recommending the next action for each non-empty bucket, for example running `sync-new-customers-to-drip` for the missing ones.

**Rules & Guidelines:**

* `shopify-get-customer` is on the shopify server; `drip-get-subscriber` is on the drip server.
* This prompt is read-only. Do NOT call `drip-add-subscriber`, `drip-update-subscriber`, `drip-unsubscribe-subscriber` or `shopify-update-customer`, even to fix a mismatch.

**Validation:**

* If Shopify returns no customers in the window, say so and stop.
* If Shopify returned exactly `{max-customers}` records, say the list may be truncated.
* Compare emails case-insensitively; if an exact lookup in Drip finds nothing, retry once in lowercase before calling the customer missing.

Who it's for

One answer, three teams that use it

Privacy and compliance

Find marketing sent without consent

Customers marketed in Drip without Shopify consent get their own table, with tags and status.

Which Drip subscribers since 1 September have no marketing consent in Shopify?

Lifecycle marketers

Reach buyers who said yes

Customers who consented but are missing from Drip are listed, ready to add.

Audit Shopify and Drip consent for the last 500 customers and show who is missing from Drip.

Marketing operations

Spot opt-outs that never synced

People opted out in Drip only are flagged, so Shopify can be brought in line.

Who has opted out in Drip but still shows as accepting marketing in Shopify?

How it works

What PopdockAI does when you ask

You give a start date and a limit, and your AI assistant compares Shopify consent with Drip status for each customer. It is a read-only audit with a suggested next step for each problem.

01

Ask

You give a start date and a limit.

Your AI tool

02

Read

It reads recent Shopify customers with an email.

shopify-get-customer

03

Check

It looks each one up in Drip, retrying in lowercase before calling them missing.

drip-get-subscriber

04

Report

You get a count per bucket, a table per problem and a next step for each.

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

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

drip-get-subscriber

Returns Drip people (subscribers) with name, email, location, tags, status, GDPR consent, lead score and lifetime value. Filter by exact email, email domain, tag, status, country, minimum lead score, minimum lifetime value or date added.
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

Consent conflicts surfaced before they cause trouble

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