/
/
One profile of a client's billing and giving
For leaders and relationship owners who want a client's FreshBooks billing and Bloomerang giving together, just by giving their email to their AI assistant.
On this page
Connector
Connect FreshBooks, pick your AI tool and paste the prompt.
The problem
Supporter conversations start without the full history
Before talking to a supporter who is also a customer, staff open two systems and piece together invoices, payments and gifts. A conversation can start without knowing about an unpaid invoice or a recent gift.
Without PopdockAI
- Look up the client's invoices and payments
- Search Bloomerang for the constituent
- Read gifts, interactions and tasks
- Miss an unpaid invoice or recent gift
With PopdockAI
- Billing is read from FreshBooks
- Giving, interactions and open tasks are read from Bloomerang
- One profile with a few plain observations
- Currencies shown apart, nothing sent or 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 combined billing and giving profile for the client with FreshBooks email `{client-email}`, covering the last `{lookback-days}` days (default 365).
**Step 1: Billing side (FreshBooks)**
Call `freshbooks-get-client` with `email` to get the client `id` and organization. Then call `freshbooks-get-invoice` with `customer-id` set to that `id` and `create-date.from` set to the start of the lookback. Call `freshbooks-get-payment` with `client-id` set to the `id` and `date.from` the same.
**Step 2: Giving side (Bloomerang)**
Call `bloomerang-get-constituent` with `primary-email` set to the email. Take its `id` and pass it as `account-id` to `bloomerang-get-transaction` (with `date.from`), `bloomerang-get-interaction` (with `date.from`) and `bloomerang-get-task`.
**Step 3: Report**
Sections: Identity (names, email, Bloomerang `status`), Billing (invoices raised, total `amount`, total `outstanding`, payments received), Giving (gift count, total, latest gift, fund names from `bloomerang-get-designation` only if asked), Relationship (recent interactions and open tasks). End with two or three plain observations, such as a large outstanding balance on a recent donor.
**Rules & Guidelines:**
* FreshBooks tools: `freshbooks-get-client`, `freshbooks-get-invoice`, `freshbooks-get-payment`. Bloomerang tools: `bloomerang-get-constituent`, `bloomerang-get-transaction`, `bloomerang-get-interaction`, `bloomerang-get-task`.
* Read only. Do not call any add, update or delete tool, and do not call `freshbooks-send-invoice-by-email`.
**Validation:**
* If the client is missing from FreshBooks, stop. If the donor is missing from Bloomerang, report the billing section and say there is no giving record.
* Currencies may differ between the two systems; show each amount with its own currency and do not add across them.Who it's for
One answer, three teams that use it
Executive directors
Walk into key meetings prepared
See what a supporter owes and what they have given in one profile.
Give me billing and giving for jo@contoso.org over the last two years.
Development officers
Avoid asking someone with an unpaid invoice
Know about outstanding balances before you make an ask.
Does our donor lee@fabrikam.com have unpaid FreshBooks invoices?
Finance managers
Understand the whole relationship
See invoices, payments, gifts and open tasks for a client who also gives.
Show FreshBooks invoices and Bloomerang gifts for ana@northwindtraders.com this year.
How it works
What PopdockAI does when you ask
You give a client email and your AI assistant builds one billing and giving profile. It reads only and reports billing alone if there is no donor record.
01
Ask
You give the client email and an optional look-back period.
02
Bill
It reads the client, invoices and payments in FreshBooks.
03
Give
It finds the Bloomerang constituent and reads gifts, interactions and tasks.
04
Report
You get one profile with a few plain 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
bloomerang-get-constituent
bloomerang-get-transaction
bloomerang-get-interaction
bloomerang-get-task
bloomerang-get-designation
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
Know billing and giving before you talk
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)
