/
/
Check whether overdue Rillet customers are reachable in Drip
For collections and marketing teams who want to know if customers with overdue Rillet invoices still have active Drip email addresses.
On this page
Connector
Connect Rillet, pick your AI tool and paste the prompt.
The problem
You cannot tell which overdue customers email will still reach
Collections and marketing both need to know whether overdue Rillet customers can still be reached by email. Finding out means totalling overdue invoices per customer, pulling their addresses and checking each one in Drip.
Without PopdockAI
- Filter Rillet invoices for overdue ones
- Total what each customer owes
- Look up every customer email address
- Check each one in Drip for status and campaigns
With PopdockAI
- Overdue invoices totalled per customer and currency
- Every customer email checked in Drip for status, score and tags
- Unreachable customers flagged, and no-email customers listed
- Nothing changed in Rillet or Drip
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For every customer with overdue invoices in Rillet owing at least `{min-amount-due}` in total (default 0), show whether their email address is reachable in Drip, so collections and marketing can see who has gone quiet.
**Step 1: Find overdue invoices**
Call `rillet-get-invoices` (Rillet) once. Keep invoices marked overdue with an amount-due above zero. Group by customer-id and sum amount-due per currency. Drop customers below `{min-amount-due}`.
**Step 2: Get their emails**
Call `rillet-get-customer-emails` (Rillet) once and attach every email for each remaining customer-id, along with the customer name.
**Step 3: Check Drip**
For each email, call `drip-get-subscriber` (Drip) with email set to it. Record status, lead-score and tags. For subscribers that exist, call `drip-get-campaign-subscriber` (Drip) with the email and note any campaigns they are active in.
**Step 4: Report**
A table sorted by total amount-due, largest first: customer name, customer-id, overdue invoice count, amount-due and currency, oldest due-date, email, Drip status, active campaigns. Flag rows where every email is unsubscribed or missing in Drip as "unreachable by email".
**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.
* `rillet-get-customer-emails` and `rillet-get-invoices` take no filters. Call each once, keep the result, and match in memory rather than calling them per customer.
* 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.
* Do not suggest pausing or unsubscribing anyone. Report only.
**Validation:**
* If no invoices are overdue, say so and stop.
* If an overdue customer has no email in Rillet, list them under "no email on file" instead of dropping them.
* Never add amounts across different currencies.Who it's for
One answer, three teams that use it
Collections
Pick the right channel for each overdue account
See which customers email can still reach and which need a call, before you send another reminder.
Which overdue Rillet customers are unsubscribed or missing in Drip? Sort them by amount due.
Credit managers
Prioritise the largest unreachable balances
A table sorted by amount due, with the oldest due date, shows where the risk sits first.
List overdue Rillet customers owing over 10,000 and whether their emails are active in Drip.
Lifecycle marketers
See which overdue customers are in campaigns
Know whether overdue customers are still getting your campaigns before finance follows up.
Are any overdue Rillet customers like Contoso still active in Drip campaigns? Show their tags too.
How it works
What PopdockAI does when you ask
You set a minimum amount due and your AI assistant checks every overdue customer's emails in Drip. It only reports, and it does not pause or unsubscribe anyone.
01
Ask
You set a minimum amount due.
02
Read
It totals overdue Rillet invoices per customer and gathers their emails.
03
Check
It looks up each email in Drip for status, score, tags and campaigns.
04
Report
You get a table by amount due, with unreachable customers flagged.
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-invoices
rillet-get-customer-emails
drip-get-subscriber
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
Know who email can reach before you chase payment
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)
