Connectors

/

FreshBooks

/

Check overdue FreshBooks clients before a Constant Contact mailing
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Check overdue FreshBooks clients before a Constant Contact mailing
Which Northwind Traders clients have overdue FreshBooks invoices, and can I still email them through Constant Contact? Only include balances of 100 or more.
3 clients are overdue by 100 or more, and 1 of them has unsubscribed from Constant Contact. - Contoso Ltd: 2 invoices, 4,250.00 outstanding, permission to send, opened a campaign last week - Fabrikam Inc: 1 invoice, 1,800.00 outstanding, unsubscribed, do not send marketing - Adventure Works: 1 invoice, 640.00 outstanding, not in Constant Contact Want the full table with last activity dates?
FreshBooks
Sample figures. Your results come from your own account.
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

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

FreshBooks

FreshBooks
Run it on your own FreshBooks data.

Connect FreshBooks, pick your AI tool and paste the prompt.

Try PopdockAI free

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.

Prompt
**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.

Your AI tool

02

Find

It lists overdue FreshBooks invoices and totals what each client owes.

freshbooks-get-invoice
freshbooks-get-client

03

Match

It looks up each client email in Constant Contact for permission to send and recent activity.

constant-contact-get-contact
constant-contact-get-contact-activity
constant-contact-get-contact-list-member
constant-contact-get-contact-list

04

Report

You get one table, largest balance first, with notes on unsubscribed clients.

Your AI tool

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.

get-data

freshbooks-get-invoice

Returns invoices from FreshBooks, including client, amounts, status and due date. Filter by client, status or date range.
get-data

freshbooks-get-client

Returns clients from FreshBooks with contact details, currency and outstanding balance. Filter by name or email.
get-data

constant-contact-get-contact

Returns Constant Contact contacts with their name, email, company, job title, phone, location, tags and email permission. Filter by email address or domain, last name, company, state, permission and created date.
get-data

constant-contact-get-contact-activity

Returns a Constant Contact contact's email activity timeline, such as opens, clicks and bounces. Filter by contact, email address, campaign activity, activity type and date.
get-data

freshbooks-get-payment

Returns payments recorded against FreshBooks invoices, with amount, date and method. Filter by invoice, client or date range.
get-data

constant-contact-get-contact-list-member

Returns the members of Constant Contact contact lists with their email permission. Filter by list name or ID, contact, email address and permission.
get-data

constant-contact-get-contact-list

Returns Constant Contact contact lists with their description, active member count and favorite flag. Filter by name, member count and favorite.
Read only.Nothing in FreshBooks Changes

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.

How Popdock AI secures your data

The outcome

No overdue or unsubscribed client gets a promotion

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

All Ramp use cases

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.

Try PopdockAI Free
See Documentation