Connectors

/

Rillet

/

Log Rillet billing status as a Constant Contact note
Write
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Log Rillet billing status as a Constant Contact note
Add Northwind Traders' billing status from Rillet as a note in Constant Contact.
Northwind Traders matches 2 Constant Contact contacts. - Note: 3 open invoices, 1 overdue, 4,200 USD due - Also: ARR 96,000 USD, contract ends 31 March 2027 - Contacts: dana@northwindtraders.com and ap@northwindtraders.com Shall I add the note to both contacts?
Rillet
Sample figures. Your results come from your own account.
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

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Rillet

Rillet
Run it on your own Rillet data.

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

Try PopdockAI free

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.

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

Your AI tool

02

Summarize

It builds a note on open and overdue invoices, ARR and contract end.

rillet-get-customers
rillet-get-invoices
rillet-get-arr-waterfall
rillet-get-contracts

03

Confirm

You see the note and which contacts it will go on.

No items found.

04

Write

It adds the note once per contact and reads it back.

Your AI tool

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.

get-data

rillet-get-customers

Returns customers (name, address, payment terms, invoicing settings) from Rillet.
get-data

rillet-get-invoices

Returns customer invoices (number, customer, dates, status, totals, amount due) from Rillet.
get-data

rillet-get-arr-waterfall

Returns annual recurring revenue by customer and month from Rillet.
get-data

rillet-get-contracts

Returns customer contracts (term, status, total value, invoicing) from Rillet.
get-data

rillet-get-customer-emails

Returns customer email addresses with their type and the customer's location from Rillet.
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.
run-action

constant-contact-add-contact-note

Adds a note to a Constant Contact contact.
get-data

constant-contact-get-contact-note

Returns the notes logged against Constant Contact contacts. Filter by contact, email address, company name and created date.
Read only.Nothing in Rillet 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 context in front of marketing before they reach out

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