Connectors

/

Rillet

/

Check overdue Rillet customers' Drip email reach
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Check overdue Rillet customers' Drip email reach
Which overdue Rillet customers owing over 5,000 can we still reach in Drip?
11 customers owe over 5,000 overdue; 3 are unreachable in Drip. - Largest: Contoso, 18,400 USD, oldest due 14 August - Unreachable: Fabrikam, all emails unsubscribed - No email on file: 1 customer Want the full table?
Rillet
Sample figures. Your results come from your own account.
rillet-get-invoices
rillet-get-customer-emails
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

Rillet

Rillet
Run it on your own Rillet data.

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

Try PopdockAI free

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.

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

Your AI tool

02

Read

It totals overdue Rillet invoices per customer and gathers their emails.

rillet-get-invoices
rillet-get-customer-emails

03

Check

It looks up each email in Drip for status, score, tags and campaigns.

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

04

Report

You get a table by amount due, with unreachable customers flagged.

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-invoices

Returns customer invoices (number, customer, dates, status, totals, amount due) from Rillet.
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.
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 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

Know who email can reach before you chase payment

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