/
/
Find site vendors with no Rillet vendor record
For finance and project teams who want Procore site log vendors checked against Rillet by asking their AI assistant.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
The problem
Vendors reach site before they reach the ledger
A vendor shows up in manpower or delivery logs in Procore, but nobody checks it has a record in Rillet. The first bill then has nowhere to land and payment is delayed.
Without PopdockAI
- Read four types of site log in Procore
- Build a list of the vendor names by hand
- Search the Rillet vendor list for each one
- Argue over names that only partly match
With PopdockAI
- Vendors are gathered from all four log types
- Each is compared with the Rillet vendor list
- Partial matches are shown, never confirmed
- Missing vendors come first 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:** Find every vendor that appears in the site logs of project `{project-name}` between `{date-from}` and `{date-to}` (default: the last 30 days) and report which of them have no vendor record in Rillet.
**Step 1: Collect vendors from Procore**
These tools are on the procore-project-management server. Call `procore-get-manpower-logs`, `procore-get-equipment-logs`, `procore-get-delivery-logs` and `procore-get-dumpster-logs`, each filtered by `project-name` and `date.from` / `date.to`. Take `vendor-name` from every row and build one distinct list, noting which log types each vendor appeared in and how many log rows. If `project-name` matches more than one project, list the matching projects and stop.
**Step 2: Read the Rillet vendors**
These tools are on the rillet server. Call `rillet-get-vendors` once. It has no filters, so match client-side. Compare names ignoring case, punctuation and suffixes such as LLC, Inc, Ltd and Co. Treat an exact normalized match as matched, a partial match as possible (show both names), and no match as missing.
**Step 3: Report**
A table with: Procore vendor name, log types seen, log row count, Rillet match status (matched, possible, missing), Rillet `vendor-id` and `payment-terms` where matched. List missing vendors first.
**Rules & Guidelines:**
* procore-get tools tools belong to procore-project-management; rillet-get tools tools belong to rillet.
* Read only. Do not call `rillet-add-vendor`, `rillet-update-vendor` or any `procore-create-*`, `procore-update-*` or `procore-delete-*` tool.
**Validation:**
* If no log rows have a `vendor-name`, say so and stop.
* If `rillet-get-vendors` returns nothing, say Rillet has no vendors or the tool is unavailable and stop.
* Never treat a partial name match as a confirmed match.Who it's for
One answer, three teams that use it
Accounts payable
Set up vendors before bills arrive
See which vendors on site have no Rillet record so they can be created ahead of invoicing.
List vendors in the last 30 days of Northwind Plaza site logs that are missing from Rillet.
Project managers
Check subcontractors are onboarded
Confirm the vendors working on your project are set up for payment.
Are all the vendors in the Contoso Warehouse site logs set up in Rillet?
Procurement managers
Find unvetted suppliers on site
Spot suppliers delivering or working on site who never went through vendor set up.
Which vendors with delivery logs on Riverside Tower are not in Rillet?
How it works
What PopdockAI does when you ask
You name the project and your AI assistant reads the site logs and the Rillet vendor list. It stops if the project name is ambiguous and never confirms a partial match.
Ask
You name the project and, optionally, the date range.
Collect
It lists every vendor in the manpower, equipment, delivery and dumpster logs and stops if the project is ambiguous.
Match
It reads the Rillet vendors and classes each as matched, possible or missing.
Report
You get the table with Rillet ids and payment terms, missing vendors first.
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-manpower-logs
procore-get-equipment-logs
procore-get-delivery-logs
procore-get-dumpster-logs
rillet-get-vendors
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
Every site vendor checked against the ledger
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)
