Connectors

/

FreshBooks

/

Review a FreshBooks client with Constant Contact engagement
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Review a FreshBooks client with Constant Contact engagement
Give me a profile of dana@contoso.com in the Northwind Traders FreshBooks company, including her Constant Contact activity over the last 90 days.
Dana Whitfield at Contoso Ltd has paid most of her billing but clicks campaigns while one invoice is overdue. - Billing: 12,400.00 invoiced, 9,900.00 paid, 2,500.00 outstanding, last payment 3 September - Consent: permission to send, on the Customers list - Tags: Wholesale, Newsletter - Last 90 days: 11 opens, 3 clicks Want me to list the invoices behind the outstanding amount?
FreshBooks
Sample figures. Your results come from your own account.
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

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

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.

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

Your AI tool

02

Find

It finds the client in FreshBooks and stops if there are none or several.

freshbooks-get-client

03

Combine

It totals billing and reads the Constant Contact consent, lists, tags and activity.

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

04

Report

You get a billing section, a marketing section and a line of observations.

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-client

Returns clients from FreshBooks with contact details, currency and outstanding balance. Filter by name or email.
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-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

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-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-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

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

Billing and marketing history side by side

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