/
/
Find the Rillet customers Drip cannot reach
For marketers who want to know which Rillet customer emails are not Drip subscribers, and which are there but unsubscribed.
On this page
Connector
Connect Rillet, pick your AI tool and paste the prompt.
The problem
Customers you invoice but never email
Billing customers live in Rillet and your email audience lives in Drip, and nothing tells you when they drift apart. Finding the gap means exporting every customer email and looking each one up in Drip by hand.
Without PopdockAI
- Export every customer email from Rillet
- Remove blanks and duplicates
- Look up each address in Drip
- Treat a capital letter as a different person
With PopdockAI
- Rillet emails cleaned of blanks and duplicates
- Each address checked in Drip by email, never by name
- Missing and unsubscribed customers in separate tables
- Counts for checked, active, unsubscribed and missing, nothing changed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Find the Rillet customers that Drip cannot reach because their email address is not a Drip subscriber, checking emails of type `{email-type}` (default: every type).
**Step 1: Read Rillet customer emails**
Call `rillet-get-customer-emails` (Rillet) once. If `{email-type}` is set, keep only rows with that email-type. Drop blank emails and de-duplicate by lower-cased email.
**Step 2: Check each address in Drip**
For each email, call `drip-get-subscriber` (Drip) with email set to that address. Record one of: missing (no row), active, or unsubscribed (any other status, reported as given).
If there are more than 50 emails, instead call `drip-get-subscriber` (Drip) once with max-records set high enough to cover the list, and match in memory.
**Step 3: Report**
A table of the missing addresses: email, Rillet customer name, customer-id, email-type, country. Below it, a second short table of addresses that exist in Drip but are unsubscribed. End with counts: checked, active in Drip, unsubscribed, missing.
**Rules & Guidelines:**
* The only key shared by the two systems is the email address. Rillet emails come from `rillet-get-customer-emails` (one row per address, with its customer-id and email-type); Drip emails come from the email field of `drip-get-subscriber`. Compare them trimmed and lower-cased. Never match on name alone.
* This prompt is read-only. Do not call `drip-add-subscriber`, `drip-update-subscriber`, `drip-add-subscriber-tag`, `drip-remove-subscriber-tag`, `drip-add-subscriber-to-campaign`, `drip-remove-subscriber-from-campaign`, `drip-remove-subscriber-from-all-campaigns`, `drip-unsubscribe-subscriber`, `drip-start-subscriber-workflow`, `drip-remove-subscriber-from-workflow`, `drip-activate-campaign`, `drip-pause-campaign`, `drip-activate-workflow`, `drip-pause-workflow` on Drip, and 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.
* This prompt only reports. To add the missing customers, use the sync-customers-to-drip prompt.
**Validation:**
* If Rillet returns no emails (or none of the requested type), say so and stop.
* A Drip email that differs only by case or surrounding spaces is a match, not a gap.Who it's for
One answer, three teams that use it
Email marketers
Find customers missing from your list
Get the customers Drip does not have, with name, email type and country, ready to act on.
Which Rillet customers are missing from Drip? Include their country.
Lifecycle marketers
Check who is unsubscribed
Customers who exist in Drip but unsubscribed are listed apart from those never added.
How many of our Rillet customers are unsubscribed in Drip, and who are they?
Marketing operations
Audit the billing to email gap
Counts for checked, active, unsubscribed and missing give a quick health check of your list.
Compare Rillet billing emails with Drip subscribers and give me the counts.
How it works
What PopdockAI does when you ask
You can name an email type and your AI assistant checks every Rillet customer email against your Drip subscribers. It only reads and reports.
01
Ask
You optionally name an email type.
02
Read
It reads Rillet customer emails and removes blanks and duplicates.
03
Check
It looks up each address in Drip by email, never by name.
04
Report
You get missing customers, unsubscribed ones and the counts.
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.
rillet-get-customer-emails
drip-get-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
See every billing customer Drip cannot reach
Related use cases
More ways to put this data to work
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.

.webp)
