/
/
Stop promoting to clients who owe you money
For finance teams who want to know which overdue FreshBooks clients are still in Drip campaigns, just by asking their AI assistant.
On this page
Connector
Connect FreshBooks, pick your AI tool and paste the prompt.
The problem
Clients get a collections reminder and a sales offer in one week
Collections and marketing run separately, so a client 60 days overdue keeps getting Drip promotions. FreshBooks knows who owes and Drip knows who is in a campaign, but nobody cross-checks.
Without PopdockAI
- Pull overdue invoices from FreshBooks
- Total balances per client
- Search Drip for each email
- Promotions keep going out meanwhile
With PopdockAI
- Overdue invoices are totaled per client
- Each email is checked for active Drip campaigns
- Clients are listed with overdue total and campaigns
- Truncated results flagged, 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 clients whose FreshBooks invoices are overdue by more than `{min-outstanding}` (default 0) and who are still receiving Drip campaigns, so marketing does not promote to someone who owes money. Check up to `{max-invoices}` invoices (default 50).
**Step 1: Find overdue invoices in FreshBooks**
Call `freshbooks-get-invoice` (FreshBooks server) with `due-date.to` set to today, `outstanding.min` set to `{min-outstanding}` (use 0.01 if that is 0) and `max-records` set to `{max-invoices}`. Group the results by `customer-id` and total the outstanding amount per client.
**Step 2: Get each client's email**
For each `customer-id`, call `freshbooks-get-client` with it as `id` to get the `email`. Skip clients with no email and list them in the report.
**Step 3: Check Drip**
For each email, call `drip-get-campaign-subscriber` (Drip server) with `email` set to it. Keep rows whose `campaign-status` and subscriber `status` are both active.
**Step 4: Report**
Table of clients to review: name, organization, email, overdue total, oldest due date, and the campaigns they are active in. End with counts of overdue clients, clients with no email, clients not in Drip, and clients active in campaigns.
**Rules & Guidelines:**
* `freshbooks-get-invoice` and `freshbooks-get-client` are on the FreshBooks server. `drip-get-campaign-subscriber` is on the Drip server.
* Read-only. Do not call `drip-pause-campaign`, `drip-remove-subscriber-from-campaign`, `drip-remove-subscriber-from-all-campaigns`, `drip-add-subscriber-tag`, `freshbooks-send-invoice-by-email` or any other write tool. Recommend the follow-up prompt that acts on a single client instead.
* Both servers take a `company` parameter; pass the company the user is authorized for on every call, and never mix companies.
**Validation:**
* If there are no overdue invoices, say so and stop.
* Match clients to subscribers on email only.
* If the invoice list hit the `{max-invoices}` limit, say the result may be incomplete.Who it's for
One answer, three teams that use it
Collections specialists
Avoid mixed messages
See which overdue clients are still getting marketing email while you chase payment.
Which FreshBooks clients over 500 overdue are in active Drip campaigns?
Email marketers
Pause promotions to clients in arrears
Get a short list of clients to review instead of cross-checking two systems.
List overdue FreshBooks clients still in our Drip Upgrade campaign.
Finance managers
Coordinate collections and marketing
See overdue totals, oldest due dates and campaigns in one report to share with marketing.
Check 100 overdue FreshBooks invoices and show which clients are active in Drip.
How it works
What PopdockAI does when you ask
You set a minimum amount and invoice limit, and your AI assistant finds overdue clients still in Drip campaigns. It reports only.
01
Ask
You set a minimum overdue amount and how many invoices to check.
02
Find
It lists overdue FreshBooks invoices and totals the balance per client.
03
Match
It looks up each client email in Drip and keeps those active in campaigns.
04
Report
You get a table of clients to review and counts of the rest.
What PopdockAI provides
The tools behind the answer
Ready made tools for FreshBooks and one secure connection to your AI tool. No code, no exports.
freshbooks-get-invoice
freshbooks-get-client
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
Stop promoting to clients who owe money
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)
