/
/
Check overdue clients before you send a campaign
For finance teams who want to know which FreshBooks clients owe money and can be emailed through Constant Contact, just by asking their AI assistant.
On this page
Connector
Connect FreshBooks, pick your AI tool and paste the prompt.
The problem
Promotions go to clients who owe you money
Before a campaign goes out, nobody checks which recipients owe money or have unsubscribed. Invoices sit in FreshBooks and the list in Constant Contact, so overdue or opted out clients get promotions.
Without PopdockAI
- Pull overdue invoices from FreshBooks
- Total what each client owes
- Search Constant Contact for each email
- Mail an overdue or opted out client anyway
With PopdockAI
- Overdue clients and balances are found
- Each email is checked for permission and recent activity
- Unsubscribed clients are flagged not to market to
- Nothing is changed in either system
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** List the clients of `{company}` with overdue invoices and show, for each, whether Constant Contact can email them and whether they have engaged with recent campaigns. Look only at overdue invoices with at least `{min-outstanding}` outstanding (default 0).
**Step 1: Find overdue invoices (FreshBooks)**
Call `freshbooks-get-invoice` with `company` set to `{company}`, `status-name` or `payment-status` set to the overdue or unpaid value the tool returns, and `outstanding.min` set to `{min-outstanding}`. Group the invoices by `customer-id` and total `outstanding` per client. If the status values are unclear, call it once without a status filter and read the values that appear.
**Step 2: Get each client email (FreshBooks)**
Call `freshbooks-get-client` with `id` set to the `customer-id`. Keep `email`, `first-name`, `last-name` and `organization`. If the client has no email, report them as not reachable by email and skip step 3.
**Step 3: Check Constant Contact**
Call `constant-contact-get-contact` with `email-address` set to the client email. Take `contact-id` and `permission-to-send`. If nothing comes back, report the client as not in Constant Contact. Then call `constant-contact-get-contact-activity` with `contact-id` and note the most recent activity type and date.
**Step 4: Report**
One table sorted by total outstanding, largest first: client, invoices overdue, total outstanding, email, permission to send, last Constant Contact activity. Add a note on any client who is unsubscribed (do not send marketing to them) and any who are active in campaigns but owe money.
**Rules & Guidelines:**
* FreshBooks tools (server `freshbooks`): `freshbooks-get-client`, `freshbooks-get-invoice`, `freshbooks-get-payment`. Constant Contact tools (server `constant-contact`): `constant-contact-get-contact`, `constant-contact-get-contact-list-member`, `constant-contact-get-contact-list`, `constant-contact-get-contact-activity`.
* This prompt is read-only. Never call any add, update, delete, send or mark tool on either server, including `freshbooks-add-client`, `freshbooks-update-client`, `freshbooks-send-invoice-by-email`, `constant-contact-add-contact` and `constant-contact-update-contact`.
* Match clients to contacts on email address, compared case-insensitively after trimming spaces. Never match on name alone.
* Query only the FreshBooks company named in `{company}`; if it is empty and the account has more than one, ask which one before calling anything.
**Validation:**
* If there are no overdue invoices, say so and stop.
* If a client email maps to more than one contact, list them and do not pick one.Who it's for
One answer, three teams that use it
Email marketers
Clean the list before you send
See overdue clients and their permission status so you can hold them back from a promotion.
Which overdue FreshBooks clients are on our Constant Contact lists right now?
Collections specialists
Avoid mixed messages while chasing
Know which clients you are chasing who may also be about to get a sales email.
Show FreshBooks clients owing more than 1,000 and their latest Constant Contact activity.
Finance managers
Align finance and marketing
Give marketing a read-only list of clients with overdue balances before each campaign.
List Contoso FreshBooks clients with overdue invoices and whether Constant Contact can email them.
How it works
What PopdockAI does when you ask
You name the company and a minimum amount, and your AI assistant checks overdue clients against Constant Contact. It reports only, before the campaign goes out.
01
Ask
You name the FreshBooks company and an optional minimum outstanding amount.
02
Find
It lists overdue FreshBooks invoices and totals what each client owes.
03
Match
It looks up each client email in Constant Contact for permission to send and recent activity.
04
Report
You get one table, largest balance first, with notes on unsubscribed clients.
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
constant-contact-get-contact
constant-contact-get-contact-activity
freshbooks-get-payment
constant-contact-get-contact-list-member
constant-contact-get-contact-list
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
No overdue or unsubscribed client gets a promotion
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)
