/
/
See which Procore trades have a payable vendor in Rillet
For procurement and operations teams who ask their AI assistant to propose Rillet vendors for each Procore trade and summarise their bills.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
The problem
Trades and ledger vendors have no link between them
Procore holds trades and Rillet holds vendors, and there is no shared id, so seeing whether each trade has a payable vendor means reading both lists. Overdue bills for those vendors are checked separately, if at all.
Without PopdockAI
- Export the Procore trades
- Export the Rillet vendors
- Guess which vendor belongs to which trade by name
- Check bills for each guessed vendor
With PopdockAI
- Each trade is marked Covered, Possible or No vendor
- Vendors are proposed by name, with obvious stems allowed
- Recent bills and overdue unpaid ones are counted for each
- Every match is labelled a proposal and nothing is changed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For Procore trades whose name contains `{trade-name}` (default: all trades), find vendors in Rillet that look like they supply the trade and report the status of their bills over the last `{lookback-days}` days (default 90).
**Step 1: Read the trades**
Call `procore-get-trades` (Procore) with `name.contains` set to `{trade-name}` when given. Record each trade `name`. If nothing comes back, say so and stop.
**Step 2: Read the vendors**
Call `rillet-get-vendors` (Rillet) once. For each trade, propose vendors whose `name` contains the trade name or an obvious stem of it (for example Electric for Electrical). Mark each trade Covered, Possible or No vendor. Trade names are Procore classifications and vendor names are company names, so every match is a guess; say so.
**Step 3: Check recent bills**
For each proposed vendor, call `rillet-get-bills` (Rillet) with `vendor-id` set to the vendor's `vendor-id` and `bill-date.from` set to the start of the lookback window. Count bills by `status`, and note any with a `due-date` in the past that are not paid.
**Step 4: Report**
A table of trade, status, proposed vendors, bills in window and overdue bills. Then the trades with No vendor, as a short list for procurement to review.
**Rules & Guidelines:**
* Tools whose names start with procore run on the procore-company-admin server; tools whose names start with rillet run on the rillet server. Both must be connected.
* Read-only. Do not call any write tool on either server, including `procore-create-office`, `procore-update-office`, `procore-delete-office`, `procore-update-role`, `procore-delete-role` on Procore and `rillet-add-vendor`, `rillet-update-vendor`, `rillet-add-customer`, `rillet-update-customer`, `rillet-add-bank-account`, `rillet-add-account` on Rillet.
* Procore is the construction system of record and Rillet is the accounting ledger. There is no shared id between them, so every match is made on names or codes and must be shown as a proposed match, never as a certainty.
* Do not use em dashes.
**Validation:**
* Do not state that a vendor performs a trade; say it is a proposed match by name.
* If `rillet-get-vendors` returns nothing, report that Rillet has no vendors and stop after Step 1.
* If a vendor has no bills in the window, report zero rather than an error.Who it's for
One answer, three teams that use it
Procurement managers
Find trades with no vendor
See which trades have no obvious vendor in Rillet, as a short list to review.
List the Procore trades that have no Rillet vendor by name.
Operations managers
Check vendor payment health
See recent and overdue bills for the vendors that look like they supply each trade.
For trades containing Electric, show proposed Rillet vendors and their overdue bills.
Finance systems owners
Spot mismatched naming
See where trade names and vendor names do not line up, so setup can be tidied.
Check all Procore trades against Rillet vendors for the last 180 days and show the Possible matches.
How it works
What PopdockAI does when you ask
You name a trade or leave it open, and your AI assistant compares both lists. It reads only, and it never states that a vendor performs a trade.
Ask
You name a trade, or leave it open for all, and choose how far back to look.
Read
It reads the Procore trades and the Rillet vendors.
Match
It proposes vendors by name for each trade and reads their bills in the window.
Report
You get each trade with status, proposed vendors, bills and overdue items, then trades with no vendor.
What PopdockAI provides
The tools behind the answer
Ready made tools for Procore and one secure connection to your AI tool. No code, no exports.
procore-get-trades
rillet-get-vendors
rillet-get-bills
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
Trade coverage reviewed without the spreadsheet guesswork
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)
