/
/
Find refunded Shopify customers still getting Drip promotions
For email marketers who want to know which recently refunded Shopify customers are still in active Drip campaigns, by asking their AI assistant.
On this page
Connector
Connect Shopify, pick your AI tool and paste the prompt.
The problem
Refunded customers still get your cheerful promotions
A customer just refunded in Shopify may still be getting promotional email from Drip, which can make a bad experience worse. Spotting them means checking each customer's Drip campaigns by hand, and nobody has time to do it every week.
Without PopdockAI
- Export recent Shopify refunds
- Group them by customer email
- Check each customer's active Drip campaigns
- Let promotions keep going to unhappy customers
With PopdockAI
- Shopify refunds since your date are grouped by email
- Each customer is checked for active Drip campaigns
- Refunded customers still emailed are listed with campaign names
- It only reports, and removal stays your decision
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Find customers who received a Shopify refund on or after `{since-date}` (default 14 days ago) and are still subscribed to active Drip campaigns.
**Step 1: List recent refunds**
Call `shopify-get-refund` with `created-at.from` set to `{since-date}` (or 14 days before today, YYYY-MM-DD). Keep customer-email, order-name, total-adjustments, created-at and note. Group refunds by customer-email; skip refunds with no customer-email and count them.
**Step 2: Check their Drip campaigns**
For each distinct customer-email, call `drip-get-campaign-subscriber` with `email` set to it. Keep the rows where campaign-status is active and the subscriber status is active.
**Step 3: Report**
A table of customers who have at least one active campaign: email, order name(s) refunded, refund date, refund note, and the active campaign-name values. Then a one-line count of refunded customers with no active campaigns.
**Rules & Guidelines:**
* `shopify-get-refund` is on the shopify server; `drip-get-campaign-subscriber` is on the drip server.
* This prompt is read-only. Do NOT call `drip-remove-subscriber-from-campaign`, `drip-remove-subscriber-from-all-campaigns`, `drip-unsubscribe-subscriber` or `drip-add-subscriber-tag`. Leave removal to the user.
**Validation:**
* If there are no refunds in the window, say so and stop.
* If a refunded customer is not found in Drip at all, list them under a separate "Not in Drip" line rather than dropping them.
* Compare emails case-insensitively.Who it's for
One answer, three teams that use it
Support team leads
Protect customers after a bad experience
See who is still getting promotions after a refund, so you can pause them before the next send.
Which customers refunded in Shopify this week are still in active Drip campaigns?
Lifecycle marketers
Keep promotions away from refunded buyers
A weekly check shows which campaigns still include refunded customers, with the refund details to decide.
List refunded Shopify customers since 1 November who are still subscribed to the Holiday Promo campaign in Drip.
Customer experience managers
Spot where refunds and marketing collide
Counts of refunded customers in and out of Drip campaigns show how often promotions reach unhappy buyers.
How many customers refunded in Shopify last month are still receiving Drip campaigns, and which ones?
How it works
What PopdockAI does when you ask
You give a start date, and your AI assistant checks every recently refunded Shopify customer in Drip. It changes no campaign or subscriber and leaves the next step to you.
01
Ask
You give a start date.
02
Read
It reads Shopify refunds since then and groups them by customer email.
03
Check
It checks each customer for active Drip campaigns they still receive.
04
Report
You get a table of refunded customers still emailed, with nothing changed.
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.
shopify-get-refund
drip-get-campaign-subscriber
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
Promotions paused before they add to frustration
Related use cases
More ways to put this data to work
Add missing Shopify customers to Drip
Ask your AI to add missing Shopify customers to Drip and it finds opted-in buyers Drip does not have, adds them with your tag after you confirm and checks each one.
Learn More
Enroll a Shopify customer in a Drip campaign
Ask your AI to enroll a Shopify customer in a Drip campaign and it checks consent in both systems and current enrollment, then adds them after you confirm.
Learn More
Tag top Shopify customers in Drip
Ask your AI to tag top Shopify customers in Drip and it matches high spenders to active subscribers, skips the rest and tags them after you confirm.
Learn More
Reconcile Shopify marketing consent with Drip
Ask your AI to audit consent between Shopify and Drip and it sorts recent customers into missing, marketed without consent, opted out or in agreement.
Learn More
Add missing Shopify customers to a Constant Contact list
Ask your AI to add missing Shopify customers to Constant Contact and it finds opted-in buyers not already there, skips anyone who unsubscribed and adds them after you confirm.
Learn More
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.