/
/
Reconcile FreshBooks clients with your Constant Contact list
For marketing teams who want to find clients missing from the mailing list or mailed after unsubscribing, just by asking their AI assistant.
On this page
Connector
Connect FreshBooks, pick your AI tool and paste the prompt.
The problem
Client and mailing lists never line up
Someone exports FreshBooks clients and Constant Contact contacts and compares emails by hand. Clients get missed from the mailing list, and unsubscribed clients can still be mailed.
Without PopdockAI
- Export clients from FreshBooks
- Export contacts from Constant Contact
- Compare emails in a spreadsheet
- Miss unsubscribes and gaps
With PopdockAI
- Clients are read, no-email ones set aside
- Each email is matched in Constant Contact, never by name
- Missing, unsubscribed and unmatched groups are listed
- Truncation warned, 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:** Reconcile the FreshBooks clients of `{company}` against Constant Contact contacts, matching on email address, and report the mismatches. Check at most `{max-clients}` clients (default 100).
**Step 1: Read the clients (FreshBooks)**
Call `freshbooks-get-client` with `company` set to `{company}` and `max-records` set to `{max-clients}`. Keep `id`, `first-name`, `last-name`, `organization` and `email`. Set aside clients with no email and count them.
**Step 2: Look each client up in Constant Contact**
For each client with an email, call `constant-contact-get-contact` with `email-address` set to that email. Take `contact-id`, `permission-to-send` and `tags` from the result. If nothing comes back, mark the client as not in Constant Contact. If more than one contact comes back, list them and do not guess.
**Step 3: Find contacts with no client**
Call `constant-contact-get-contact` with `max-records` 200. Any contact whose email matches no FreshBooks client is a contact with no client. If 200 rows come back, say the list may be truncated.
**Step 4: Report**
Give four short tables: (a) clients not in Constant Contact, (b) clients whose contact has `permission-to-send` of unsubscribed, (c) clients with no email, (d) contacts with no matching client. Finish with the counts of matched, missing and unsubscribed.
**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 FreshBooks returns no clients, or Constant Contact returns no contacts, say which side is empty and stop.
* If an email differs only by case or spacing, treat it as a match and mention it.Who it's for
One answer, three teams that use it
Email marketers
Find clients missing from your list
See which clients are not in Constant Contact so they get your updates.
Which FreshBooks clients are not in Constant Contact?
Compliance leads
Make sure unsubscribed clients stay unmailed
Clients who unsubscribed are listed so nobody adds them back by mistake.
Which FreshBooks clients have unsubscribed in Constant Contact?
Marketing operations
Find contacts with no client record
Constant Contact contacts with no matching client show where the lists drift.
Reconcile 200 Contoso FreshBooks clients with Constant Contact and list contacts with no client.
How it works
What PopdockAI does when you ask
You name the company and how many clients to check, and your AI assistant reconciles them with Constant Contact. It reports only.
01
Ask
You name the FreshBooks company and how many clients to check.
02
Read
It reads the clients and sets aside any with no email.
03
Match
It looks each email up in Constant Contact and checks for contacts with no client.
04
Report
You get four short tables and the counts of matched, missing and unsubscribed.
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
constant-contact-get-contact
freshbooks-get-invoice
freshbooks-get-payment
constant-contact-get-contact-list-member
constant-contact-get-contact-list
constant-contact-get-contact-activity
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
A clear list of missing and unsubscribed clients
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)
