Connectors

/

Rillet

/

Note overdue Rillet invoices on Procore bid board projects
Write
Cross-Connector

Warn estimators about overdue customers on the bid board

For project and finance teams who want a customer's overdue Rillet invoices noted on their Procore bid board projects by asking their AI assistant.

Try PopdockAI free
Get a live demo
Note overdue Rillet invoices on Procore bid board projects
Northwind Traders is behind on payments. Add a note about their overdue Rillet invoices to their open bid board projects.
Northwind Traders has 3 overdue invoices totalling 42,000 and 2 open bid board projects. - Projects: Riverside Tower Phase 2, Harbour Depot Extension - Note: Northwind Traders has 3 overdue invoices, 42,000 due, as of today - Project status will not be changed Shall I add this note to both projects?
Rillet
Sample figures. Your results come from your own account.
rillet-get-customers
rillet-get-invoices
procore-get-estimating-bid-board-projects
procore-create-estimating-bid-board-projects-notes

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

Estimators bid blind to overdue balances

The overdue balance for a customer sits in the ledger while estimators work on the bid board. Without a warning on the project, bids go out for customers who are already behind on payment.

Without PopdockAI

  • Check the customer's invoices in Rillet
  • Add up what is overdue
  • Open each bid board project for that customer
  • Type a note on every one and hope nobody repeats it

With PopdockAI

  • Overdue invoices and the total come from Rillet
  • You see the exact note before anything is written
  • Only a bid board note is added, never a status change
  • Projects with the same note from today are skipped

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** For the customer `{customer-name}`, find overdue invoices in Rillet and, after confirmation, add a note about them to each of the customer's bid board projects with status `{status}` (default: every status) so the estimator sees it before bidding.

**Step 1: Find the overdue balance (Rillet server)**

Call `rillet-get-customers` and match `name` or `invoicing-name` to `{customer-name}`. If no match, say so and stop. Call `rillet-get-invoices`, which has no filters, keep rows with that `customer-id` where `overdue` is true, and total `amount-due`. If nothing is overdue, report that and stop.

**Step 2: Find the projects (Procore Preconstruction server)**

Call `procore-get-estimating-bid-board-projects` with `customer-company-name.contains` set to `{customer-name}`, and `status` set to `{status}` when it is not empty. Keep `id` and `name`. If none, report the overdue balance and stop.

**Step 3: Confirm**

Show the user the overdue invoices, the total, the projects, and the exact note text: the customer, overdue invoice count, total amount due and today's date. Do not call a write tool until the user explicitly confirms.

**Step 4: Write the notes (Procore Preconstruction server)**

For each project call `procore-create-estimating-bid-board-projects-notes` with `bid-board-project-id` set to the project `id` and `value` set to the confirmed note text. Report each result.

**Rules & Guidelines:**

* `rillet-get-customers` and `rillet-get-invoices` are on the Rillet server; `procore-get-estimating-bid-board-projects` and `procore-create-estimating-bid-board-projects-notes` are on the Procore Preconstruction server.
* `procore-create-estimating-bid-board-projects-notes` is the only tool that may write, and only after Step 3 confirmation. Never change project status, and never call any Rillet add or update tool.
* Tell the user the Procore write tools may be Inactive; if the call is refused, report that and stop.

**Validation:**

* If a project already has a note with the same text from today, tell the user and skip it.
* If the matches cover more than one customer name, list them and stop.

Who it's for

One answer, three teams that use it

Estimators

See credit risk before you bid

Find overdue balances noted on the project, so you know before you price work for the customer.

Add a note about Contoso Holdings' overdue Rillet invoices to their bid board projects.

Finance controllers

Pass on credit warnings

Get overdue invoice warnings onto the bid board without messaging every estimator.

Note Fabrikam Developments' overdue invoices on their bid board projects with status Bidding.

Business development managers

Prepare for a customer conversation

Make sure a customer's overdue position is on record before a new proposal goes out.

Northwind Traders owes us overdue invoices in Rillet. Put the total on their open bid board projects.

How it works

What PopdockAI does when you ask

You name the customer and your AI assistant finds the overdue balance and the bid board projects. Nothing is written until you have seen the note and said yes.

Ask

You name the customer and, optionally, a bid board status.

Your AI tool

Check

It totals the customer's overdue invoices in Rillet and finds their bid board projects in Procore.

rillet-get-customers
rillet-get-invoices
procore-get-estimating-bid-board-projects

Confirm

You see the invoices, the projects and the exact note, then say yes.

No items found.

Note

It adds the note to each project, skips any with the same note today and reports each result.

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

procore-get-estimating-bid-board-projects

Returns Procore Preconstruction bid board projects, with status and the assigned estimator.
run-action

procore-create-estimating-bid-board-projects-notes

Adds a note to a Procore bid board project. Action tool: built Inactive and not yet run end to end through MCP, so test it against a sandbox Procore company before switching it on.
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

Overdue balances visible before the next bid

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