Connectors

/

Rillet

/

Summarize a customer's Rillet billing and Contivio calls
Report
Cross-Connector

A customer's Rillet billing and Contivio calls on one timeline

For support agents who want a Rillet customer's invoices, payments, credit memos and recent calls in a single view.

Try PopdockAI free
Get a live demo
Summarize a customer's Rillet billing and Contivio calls
Summarize customer CUST-1042 for the last 90 days: what they owe and who has spoken to them.
Northwind Traders (CUST-1042, net 30) has 5,200.00 due, 2 invoices overdue and 6 calls in 90 days. - Invoices: 4 billed, 18,600.00 total - Credit memos: 1, 800.00 - Calls: 6 (4 inbound, 2 outbound), most common result handled - Latest events: call on 2026-10-27, credit memo on 2026-10-12 Want the full merged timeline?
Rillet
Sample figures. Your results come from your own account.
rillet-get-customers
rillet-get-invoices
rillet-get-credit-memos
rillet-get-invoice-payments
contivio-get-call

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

Support sees billing or calls, rarely both

Agents flip between the finance system and the call system to see what a customer owes and who they have spoken to. One side is usually missed, so the full story never reaches one screen.

Without PopdockAI

  • Find the customer and their invoices in Rillet
  • Check credit memos and payments separately
  • Search the call system by customer
  • Merge it all by hand into a timeline

With PopdockAI

  • The customer is confirmed in Rillet first
  • Invoices, credit memos, payments and calls are gathered together
  • Calls are matched by customer id only, never guessed
  • A merged timeline and totals are reported

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 view of customer `{customer-id}` combining billing in Rillet and call activity in Contivio, looking back `{lookback-days}` days (default 90).

**Step 1: Establish the customer in Rillet**

Call `rillet-get-customers` and find the row whose `customer-id` equals `{customer-id}`. If none matches, report that and stop. Note `name` and `payment-terms`.

**Step 2: Pull billing**

Call `rillet-get-invoices` and keep rows whose `customer-id` matches, with `invoice-date` inside the window. Call `rillet-get-credit-memos` with `customer-id` set to `{customer-id}`. For invoices, read `invoice-id`, `invoice-number`, `status`, `total`, `amount-due`, `overdue`. Optionally call `rillet-get-invoice-payments` and keep payments whose `invoice-id` is one of those invoices.

**Step 3: Pull calls**

Take `customer-id` and call `contivio-get-call` with `customer-id` set to it and `start-time.from` set to the start of the window. Read `start-time`, `direction`, `queue`, `agent`, `result`, `disposition`, `talk-duration-seconds`, `ai-short-summary`.

**Step 4: Report**

Give: customer name and terms; invoice count, total billed, total amount due, number overdue; credit memo count and total; call count, inbound vs outbound, and the most common `result`. Then a short timeline merging invoice dates, credit memo dates and calls in date order.
**Rules & Guidelines:**

* `rillet-*` tools are on the rillet server; `contivio-*` tools are on the contivio server. Both servers must be connected.
* Read-only. Do not call any rillet add, update, apply, unapply, record or setup tool, and do not change anything in either system.
* Rillet customer-id is passed to `contivio-get-call` as its `customer-id` filter. Contivio calls carry no customer name, so match by customer-id only, never by guessing from names or phone numbers.
* Use ISO dates (YYYY-MM-DD) for date filters.

**Validation:**

* If either server returns nothing or an error, say which one and stop; do not fill in numbers.
* If no calls come back for a customer-id, report that customer as having no recorded calls and continue; do not assume the id format differs.
* Report only values present in the returned fields.

Who it's for

One answer, three teams that use it

Support agents

Handle a call knowing the account

See what the customer owes, what was credited and how often they have called, before you respond.

Summarize customer CUST-2210 for the last 60 days, billing and calls.

Finance operations

Review a customer's billing and contact

Check overdue counts, credit memos and calls in one view when preparing for a customer conversation.

For CUST-3307, how many invoices are overdue and how many calls did they make in 90 days?

Account managers

Prepare for a renewal conversation

Get a timeline of invoices, credits and calls for a customer, so you walk into the meeting knowing the history.

Build a billing and calls timeline for customer CUST-4120 over the last 90 days.

How it works

What PopdockAI does when you ask

You give a customer id and your AI assistant reads Rillet and Contivio. It calls no Rillet write action and stops if either system returns nothing.

Ask

You give a customer id and how many days to look back.

Your AI tool

Confirm

It confirms the customer in Rillet and stops if the id does not match.

rillet-get-customers
rillet-get-invoices
rillet-get-credit-memos
rillet-get-invoice-payments
contivio-get-call

Gather

It collects invoices, credit memos and payments, then the customer's Contivio calls.

No items found.

Report

You get totals for billing and calls and a merged timeline in date order.

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

Returns customer credit memos (number, customer, invoice, totals) from Rillet.
get-data

rillet-get-invoice-payments

Returns payments received against customer invoices from Rillet.
get-data

contivio-get-call

Returns Contivio call records with durations, results, direction, queue, agent and AI call summaries, filterable by date, agent, queue and customer.
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

The customer story in one timeline

Try PopdockAI free
Get a live demo

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.

Try PopdockAI Free
See Documentation