/
/
Give marketing a customer's billing status before they reach out
For finance and marketing teams who want a factual Rillet billing summary saved as a note on the customer's Constant Contact contact.
On this page
Connector
Connect Rillet, pick your AI tool and paste the prompt.
The problem
Upgrade offers land on customers who are behind on invoices
A marketing email offering an upgrade lands badly when the customer is two invoices overdue in Rillet. Marketing rarely sees that context, and pasting billing summaries into Constant Contact by hand is not something anyone keeps up.
Without PopdockAI
- Look up open and overdue invoices in Rillet
- Check ARR and the contract end date
- Find the customer's contacts in Constant Contact
- Type a note on each one, if anyone remembers
With PopdockAI
- A short factual note on balances, ARR and contract end
- Rillet emails matched to existing contacts, none created
- The note and its contacts shown before anything is written
- One note per contact, read back after your yes
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Summarise the Rillet billing status of the customer whose name contains `{customer-name}` and, after the user confirms, save it as a note on their Constant Contact contact (optionally only the contact with email `{email-address}`), so marketing can see billing context before contacting them.
**Step 1: Identify the customer in Rillet**
Call `rillet-get-customers` (rillet server) and keep rows whose `name` contains `{customer-name}`, ignoring case. If several match, list them with `name` and `customer-id` and ask which one. If none match, say so and stop.
**Step 2: Build the billing summary**
Call `rillet-get-invoices` (rillet server) and keep invoices for the `customer-id`. Count open invoices (`amount-due` above 0), count overdue ones (`overdue` true), and total `amount-due` by `currency`. Call `rillet-get-arr-waterfall` (rillet server) with `customer-id` and take the latest `year-month`, `arr` and `currency`. Call `rillet-get-contracts` (rillet server) with `customer-id` and note any active contract's `end-date`.
Write the note as plain text, at most five lines, for example:
Billing status (Rillet) as of <today>: 2 open invoices, 1 overdue since <date>. Amount due: <amount> <currency>. ARR: <amount> <currency>. Contract ends <date>.
**Step 3: Find the Constant Contact contact**
Call `rillet-get-customer-emails` (rillet server) and keep the emails for the `customer-id`. If `{email-address}` is given, keep only that one. For each email, call `constant-contact-get-contact` (constant-contact server) with `email-address`. If no email resolves to a contact, report the summary and stop: this prompt does not create contacts.
**Step 4: Confirm**
Show the note text and the contact(s) it will be added to (name, email, `contact-id`). Ask the user to confirm. Do not continue without an explicit yes.
**Step 5: Write and verify**
For each confirmed contact, call `constant-contact-add-contact-note` (constant-contact server) once with `contact-id` and `content` set to the note. Then call `constant-contact-get-contact-note` with `contact-id` and confirm the note is there.
**Rules & Guidelines:**
* Tools starting rillet- are on the rillet server; tools starting constant-contact- are on the constant-contact server.
* `constant-contact-add-contact-note` is the only tool that may write, once per contact, after the confirmation in Step 4.
* Do not call `constant-contact-update-contact`, `constant-contact-add-contact` or any other constant-contact-add-* or constant-contact-update-* tool, and do not call `rillet-update-customer`, `rillet-set-invoice-sent-status` or any other rillet-add-* or rillet-update-* tool.
* Keep the note factual: no judgement words such as "bad payer".
**Validation:**
* If the customer has no open invoices and no ARR, still offer the note, stating "No open balance".
* Never add amounts in different currencies.Who it's for
One answer, three teams that use it
Email marketers
Check billing before you send an offer
See a customer's billing status on their contact, so upgrade offers do not land on accounts in trouble.
Note Contoso's current Rillet billing status on their Constant Contact contacts.
Account managers
Share account context with marketing
Put open balances and contract end dates where marketing will see them, without writing it up yourself.
Add a billing note from Rillet to the Constant Contact contact for jane@fabrikam.com.
Collections
Keep marketing in the loop on overdue accounts
A factual note on what is overdue stops the wrong message going to a customer you are chasing.
Log the overdue balance for Northwind Traders from Rillet on their contacts in Constant Contact.
How it works
What PopdockAI does when you ask
You name the Rillet customer and your AI assistant drafts a factual billing note for their Constant Contact contacts. Nothing is written until you have seen the note and the contacts it will go on.
01
Ask
You name the Rillet customer, and optionally one contact email.
02
Summarize
It builds a note on open and overdue invoices, ARR and contract end.
03
Confirm
You see the note and which contacts it will go on.
04
Write
It adds the note once per contact and reads it back.
What PopdockAI provides
The tools behind the answer
Ready made tools for Rillet and one secure connection to your AI tool. No code, no exports.
rillet-get-customers
rillet-get-invoices
rillet-get-arr-waterfall
rillet-get-contracts
rillet-get-customer-emails
constant-contact-get-contact
constant-contact-add-contact-note
constant-contact-get-contact-note
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 context in front of marketing before they reach out
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)
