/
/
See a client's balance and email engagement together
For support teams who want one profile from FreshBooks and Drip before answering a client, just by asking their AI assistant.
On this page
Connector
Connect FreshBooks, pick your AI tool and paste the prompt.
The problem
Client queries mean switching between two screens
Answering a client means opening FreshBooks for the balance and Drip for email history. The views are never side by side, so you miss that an overdue client is still in a promotional campaign.
Without PopdockAI
- Look up the balance in FreshBooks
- Total payments by hand
- Search Drip for the same email
- Keep the client waiting
With PopdockAI
- Open invoices and recent payments are totaled
- Drip status, tags, score and campaigns are added
- It stops if several clients match the email
- No currency conversion, 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:** Build a single profile for the client with email `{client-email}`, combining what they owe and have paid in FreshBooks with how they are engaged in Drip. Look back `{lookback-days}` days for payments (default 365).
**Step 1: Find the client in FreshBooks**
Call `freshbooks-get-client` (FreshBooks server) with `email` set to `{client-email}`. If it returns more than one client, list them and stop. If none, say the client is not in FreshBooks and continue with Step 3 only.
**Step 2: Read the billing position**
Take the client `id` and call `freshbooks-get-invoice` with it as `customer-id` for open invoices (use `outstanding.min` of 0.01), and `freshbooks-get-payment` with it as `client-id` and `date.from` set to the lookback start. Total the outstanding amount and the payments received.
**Step 3: Find the subscriber in Drip**
Call `drip-get-subscriber` (Drip server) with `email` set to `{client-email}`. Then call `drip-get-campaign-subscriber` with the same `email` to list the campaigns they are in.
**Step 4: Report**
Show: client name and organization, outstanding balance and oldest due date, payments in the period, Drip status, tags, lead score, lifetime value, and each campaign with its status. Finish with a short note on anything that stands out, for example an unsubscribed contact who has paid recently, or an active campaign running against an overdue balance.
**Rules & Guidelines:**
* FreshBooks tools are `freshbooks-get-client`, `freshbooks-get-invoice` and `freshbooks-get-payment`. Drip tools are `drip-get-subscriber` and `drip-get-campaign-subscriber`.
* Read-only. Do not call `freshbooks-update-client`, `freshbooks-add-payment`, `drip-update-subscriber`, `drip-add-subscriber-tag`, `drip-unsubscribe-subscriber` or any other write tool.
* Both servers take a `company` parameter; pass the company the user is authorized for on every call, and never mix companies.
**Validation:**
* If the client is in one system and not the other, report that plainly rather than leaving the section blank.
* Currencies may differ between systems. Show amounts in the currency the system returned and do not convert.Who it's for
One answer, three teams that use it
Support agents
Answer client questions faster
See balance, payments and campaigns in one place while the client waits.
What does kim@fabrikam.com owe in FreshBooks, and which Drip campaigns are they in?
Account managers
Spot overdue clients in promotions
Notice a client with an overdue balance who is still getting promotional email.
Is chris@contoso.com overdue in FreshBooks and still in a Drip promotion?
Bookkeepers
Check payments and contact status together
Confirm recent payments and whether the client is still reachable by email.
Show payments from lee@northwindtraders.com in the last 6 months and their Drip status.
How it works
What PopdockAI does when you ask
You give a client email and lookback, and your AI assistant shows billing and email engagement together. It reads only.
01
Ask
You give the client email and how far back to look.
02
Billing
It finds the client in FreshBooks and totals open invoices and recent payments.
03
Engagement
It looks the email up in Drip for status, tags, lead score and campaigns.
04
Report
You get both views together, with a note on anything that stands out.
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-client
freshbooks-get-invoice
freshbooks-get-payment
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
Balance and engagement in one view
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)
