Connectors

/

Drip

/

Drip and Shopify customer profile by email
Report
Cross-Connector

Answer consent and spend questions for any customer

For support and ecommerce teams who want a buyer's Shopify orders and Drip status compared, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Drip and Shopify customer profile by email
A customer at pat@fabrikam.com asks why they still get our emails. Check Shopify and Drip.
Shopify shows no marketing consent for Pat Morgan, but Drip is still emailing them. - Shopify: 6 orders, 742 USD spent, consent not given - Drip: active, in the Weekly Deals series - Spend: matches within 10 percent That consent conflict explains the emails.
Drip
Sample figures. Your results come from your own account.
shopify-get-customer
shopify-get-order
drip-get-subscriber
drip-get-campaign-subscriber

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Drip

Drip
Run it on your own Drip data.

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

Try PopdockAI free

The problem

Consent and spend answers are split across Shopify and Drip

When a customer asks why they still get email, the answer is split between Shopify consent and Drip status. Checking both and spotting the conflict by eye takes time on every ticket.

Without PopdockAI

  • Open the Shopify customer and their orders
  • Check their marketing consent
  • Look up the subscriber in Drip
  • Spot conflicts by eye

With PopdockAI

  • Shopify orders, spend and consent are read
  • Drip status, tags, score and campaigns are added
  • Only real mismatches are listed
  • Nothing is changed in either system

The prompt

Use this prompt

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

Prompt
**Objective:** Build a single profile for the person with email `{email}`, combining what they have bought in Shopify with how they are marketed to in Drip, looking at orders from the last `{lookback-days}` days (default 365).

**Step 1: Find the Shopify customer**

Call `shopify-get-customer` with `email` set to `{email}`. Note customer-id, name, orders-count, total-spent, accepts-marketing, state, tags and created-at. If nothing comes back, record the person as absent from Shopify and go to Step 3.

**Step 2: Read their Shopify orders**

Call `shopify-get-order` with `email` set to `{email}` and `created-at.from` set to the date `{lookback-days}` days before today (YYYY-MM-DD). List each order's name, created-at, total-price, financial-status and fulfillment-status. If the customer has orders-count above 0 but nothing comes back, say the orders fall outside the lookback window.

**Step 3: Find the Drip subscriber**

Call `drip-get-subscriber` with `email` set to `{email}`. Note person-id, status, tags, lead-score, lifetime-value and created-date. If nothing comes back, retry once with the email in lowercase. If still nothing, record the person as absent from Drip.

**Step 4: Read their Drip campaigns**

If a Drip subscriber was found, call `drip-get-campaign-subscriber` with `email` set to the email Drip returned. List each campaign-name with its campaign-status.

**Step 5: Report**

One section per system (Shopify, Drip), then a **Mismatches** section listing only real disagreements:

* accepts-marketing is false in Shopify but the Drip status is active
* the Drip status is unsubscribed but accepts-marketing is true in Shopify
* Shopify total-spent and Drip lifetime-value differ by more than 10 percent
* the name differs between the two systems

If there are no mismatches, say so in one line.

**Rules & Guidelines:**

* `shopify-get-customer` and `shopify-get-order` are on the shopify server; `drip-get-subscriber` and `drip-get-campaign-subscriber` are on the drip server.
* This prompt is read-only. Do NOT call `drip-update-subscriber`, `drip-add-subscriber`, `drip-unsubscribe-subscriber`, `drip-add-subscriber-tag`, `shopify-update-customer` or any other tool that adds, updates or removes records.

**Validation:**

* If the person is absent from both systems, say so and stop.
* Compare emails case-insensitively and ignore surrounding spaces. Treat currency values as numbers, ignoring symbols.

Who it's for

One answer, three teams that use it

Support agents

Answer why a customer still gets email

See Shopify consent next to Drip status, so you can explain exactly what happened.

Why is jamie@contoso.com still getting emails? Check Shopify consent and Drip.

Email marketers

Catch email sent without consent

Drip emailing someone without Shopify consent is flagged as a real mismatch to fix.

Does kim@fabrikam.com have Shopify marketing consent, and is Drip emailing them?

Ecommerce managers

Check a buyer's spend and engagement

See a customer's orders and spend beside their Drip lifetime value and tags.

Show Shopify orders over the last year and Drip engagement for chris@northwindtraders.com.

How it works

What PopdockAI does when you ask

You give an email address and a lookback, and your AI assistant reads both sides. It is read-only and lists only genuine conflicts.

01

Ask

You give an email address and how far back to look.

Your AI tool

02

Read

It reads the Shopify customer with orders, spend and marketing consent.

shopify-get-customer
shopify-get-order

03

Add

It reads the Drip subscriber with status, tags, score and campaigns.

drip-get-subscriber
drip-get-campaign-subscriber

04

Report

You see each side and only the real mismatches.

Your AI tool

What PopdockAI provides

The tools behind the answer

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

shopify-get-order

Returns Shopify orders with their financial status, fulfillment status and total. Filter by order number or name, customer, email, financial status, fulfillment status, created date and total price.
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.
get-data

drip-get-campaign-subscriber

Returns the people subscribed to each Drip email series campaign, with the campaign's status and the person's tags and lead score. Filter by campaign id or name, a person's email, subscriber status or minimum lead score.
Read only.Nothing in Drip 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

Answer consent and spend questions from one view

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