Connectors

/

Procore

/

Check Procore trades against Rillet vendors
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Check Procore trades against Rillet vendors
Which Procore trades have a vendor in Rillet that looks like they supply it, and are any of those vendors overdue? Look back 90 days.
12 Procore trades were checked, and every vendor match is a proposal by name. - Covered: Electrical, proposed Northwind Electric, 4 bills, 1 overdue - Possible: Concrete, proposed Fabrikam Concrete Pumping, 2 bills - No vendor: Glazing, Fire Protection, Elevators - Overdue unpaid bills: 2, both with Northwind Electric Want the table of all 12 trades?
Procore
Sample figures. Your results come from your own account.
procore-get-trades
rillet-get-vendors
rillet-get-bills

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Procore

Procore
Run it on your own Procore data.

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

Try PopdockAI free

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.

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

Your AI tool

Read

It reads the Procore trades and the Rillet vendors.

procore-get-trades
rillet-get-vendors
rillet-get-bills

Match

It proposes vendors by name for each trade and reads their bills in the window.

No items found.

Report

You get each trade with status, proposed vendors, bills and overdue items, then trades with no vendor.

Your AI tool

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.

get-data

procore-get-trades

Returns trades records from Procore, with an optional name filter. Read-only.
get-data

rillet-get-vendors

Returns vendors (name, contact, address, payment terms, 1099 status) from Rillet.
get-data

rillet-get-bills

Returns vendor bills (expense number, vendor, dates, status) from Rillet.
Read only.Nothing in Procore 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

Trade coverage reviewed without the spreadsheet guesswork

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