Connectors

/

Rillet

/

Find Rillet customers missing from Drip
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Find Rillet customers missing from Drip
Which of our Rillet customers are not in Drip?
Of 172 Rillet customer emails checked, 21 are not in Drip. - Missing: 21, including Northwind Traders, United Kingdom - Unsubscribed in Drip: 8 - Active: 143 Want the table of missing customers?
Rillet
Sample figures. Your results come from your own account.
rillet-get-customer-emails
drip-get-subscriber

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Rillet

Rillet
Run it on your own Rillet data.

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

Try PopdockAI free

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.

Prompt
**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.

Your AI tool

02

Read

It reads Rillet customer emails and removes blanks and duplicates.

rillet-get-customer-emails

03

Check

It looks up each address in Drip by email, never by name.

drip-get-subscriber

04

Report

You get missing customers, unsubscribed ones and the counts.

Your AI tool

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.

get-data

rillet-get-customer-emails

Returns customer email addresses with their type and the customer's location from Rillet.
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 Rillet 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

See every billing customer Drip cannot reach

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