/
/
Prepare for a client call with billing and email history
For sales teams who want one profile of a client from FreshBooks and Constant Contact, just by asking their AI assistant.
On this page
Connector
Connect FreshBooks, pick your AI tool and paste the prompt.
The problem
Walking into a call without knowing they owe or opted out
Preparing for a client call means checking FreshBooks for invoices and Constant Contact for consent and clicks. It is easy to miss that the client owes money or has opted out of email.
Without PopdockAI
- Look up invoices and payments in FreshBooks
- Search Constant Contact for consent
- Check lists and campaign clicks
- Stitch it together before the call
With PopdockAI
- The client is found, or it stops if missing or ambiguous
- Invoiced, paid and outstanding are totaled
- Consent, lists, tags, opens and clicks are added
- Name conflicts reported, 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}` in the FreshBooks company `{company}`, combining billing history with Constant Contact activity over the last `{lookback-days}` days (default 90).
**Step 1: Find the client (FreshBooks)**
Call `freshbooks-get-client` with `company` set to `{company}` and `email` set to `{client-email}`. If several clients match, list them and stop. If none match, say so and stop. Keep `id`, name and `organization`.
**Step 2: Read billing (FreshBooks)**
Call `freshbooks-get-invoice` with `customer-id` set to the client `id`, and `freshbooks-get-payment` with `client-id` set to the same value. Total invoiced, paid and outstanding, and note the date of the last payment.
**Step 3: Read Constant Contact**
Call `constant-contact-get-contact` with `email-address` set to `{client-email}`; keep `contact-id`, `permission-to-send` and `tags`. If nothing comes back, report that the client is not in Constant Contact and skip the rest of this step. Call `constant-contact-get-contact-list-member` with `contact-id` for list membership, and `constant-contact-get-contact-activity` with `contact-id` and `created-date.from` set to the start of the lookback window.
**Step 4: Report**
Three short sections: billing (invoiced, paid, outstanding, last payment), marketing (consent, lists, tags, counts of opens and clicks in the window) and one line of observations, for example a client who clicks campaigns but has overdue invoices.
**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:**
* Match on `{client-email}` exactly as a case-insensitive string; do not search by name.
* If the two systems show different names for the same email, report both.Who it's for
One answer, three teams that use it
Account executives
Prep a client call in one request
Know what the client owes and how they engage with your email before you talk.
Profile jamie@fabrikam.com from FreshBooks and Constant Contact over 60 days.
Account managers
Check consent before sending an update
See permission to send and lists for a client before you add them to a campaign.
Can we email lee@contoso.com through Constant Contact, and what is their FreshBooks balance?
Finance staff
See if a debtor is reading your email
Check opens and clicks for a client with an outstanding balance.
Has ana@northwindtraders.com opened any Constant Contact emails this quarter, and what do they owe?
How it works
What PopdockAI does when you ask
You give a client email and lookback, and your AI assistant combines billing and marketing history. It reads only.
01
Ask
You give the client email, the FreshBooks company and a look-back period.
02
Find
It finds the client in FreshBooks and stops if there are none or several.
03
Combine
It totals billing and reads the Constant Contact consent, lists, tags and activity.
04
Report
You get a billing section, a marketing section and a line of observations.
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
constant-contact-get-contact
constant-contact-get-contact-list-member
constant-contact-get-contact-activity
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
Billing and marketing history side by side
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)
