/
/
Add vendors seen on site to Rillet without the typos
For finance teams who ask their AI assistant to find vendors in Procore site logs that are missing from Rillet and add the ones they confirm.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
The problem
Vendors on site reach the ledger late, and spelled wrong
The site logs show every vendor working on the job, but the ledger only knows the ones someone entered. Keying the rest by hand brings typos and duplicates of vendors that were already there.
Without PopdockAI
- Read the manpower, equipment and delivery logs
- List the distinct vendor names
- Search Rillet for each one
- Retype the missing ones and fix duplicates later
With PopdockAI
- Vendor names are gathered from all three site logs
- Exact and partial matches in Rillet are not treated as missing
- You confirm which vendors to create before anything is written
- Rillet is read again to confirm each new vendor appears
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For project `{project-name}`, find vendors in site logs from `{date-from}` (default: 30 days ago) that have no Rillet vendor record, and, only after confirmation, create them in Rillet with default payment terms `{payment-terms}` if the user gives one.
**Step 1: Vendors seen on site**
These tools are on the procore-project-management server. Call `procore-get-manpower-logs`, `procore-get-equipment-logs` and `procore-get-delivery-logs` filtered by `project-name` and `date.from`. Build one distinct list of `vendor-name` values.
**Step 2: Check Rillet**
These tools are on the rillet server. Call `rillet-get-vendors` and match each name (ignore case, punctuation, and suffixes like LLC or Inc). Anything with an exact normalized match or a partial match is not missing; show partial matches for the user to judge.
**Step 3: Confirm**
List the vendors with no match at all. Site logs hold only a name, so tell the user that address, email and tax details will be blank. Ask which to create. Do not write until they answer.
**Step 4: Create (confirmed only)**
For each confirmed vendor call `rillet-add-vendor` (rillet) with `name` set to the Procore `vendor-name` and `payment-terms` only if supplied. Leave every other field empty; never invent addresses, emails or tax ids. Then call `rillet-get-vendors` again and confirm each vendor now appears.
**Rules & Guidelines:**
* procore-get tools tools belong to procore-project-management; `rillet-get-vendors` and `rillet-add-vendor` belong to rillet.
* The only write allowed is `rillet-add-vendor`, once per confirmed vendor. Do not call `rillet-update-vendor`, any bill tool or any Procore write tool.
**Validation:**
* If nothing is missing, say so and make no writes.
* If a name is ambiguous or already partially matched, skip it unless the user explicitly confirms it.
* If `rillet-add-vendor` fails, report the error for that vendor and continue with the others.Who it's for
One answer, three teams that use it
Accounts payable
Be ready before invoices arrive
See which vendors working on site have no Rillet record, so they are set up before their first invoice.
Which vendors in the Fabrikam Depot site logs since 1 September are missing from Rillet?
Project accountants
Cover vendors the PO list missed
Pick up vendors that appear only in daily logs, like equipment hire and delivery suppliers.
Find vendors in Contoso Warehouse equipment and delivery logs from the last 30 days that Rillet lacks.
Controllers
Keep vendor setup tidy
Partial matches are shown for judgment and ambiguous names are skipped unless you say so.
Add the confirmed vendors from the Northwind Plaza site logs to Rillet, and skip anything that looks like an existing vendor.
How it works
What PopdockAI does when you ask
You name the project and date and your AI assistant checks the site logs against Rillet. It tells you what the logs cannot supply and writes only after you choose.
Ask
You name the project and the date to look from, and optionally default payment terms.
Check
It lists the vendors in the site logs and compares each with Rillet, showing partial matches.
Confirm
You see the vendors with no match and choose which to create.
Create
It creates each confirmed vendor by name and re-reads Rillet to confirm it appears.
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
rillet-get-vendors
rillet-add-vendor
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
Site vendors in the ledger, from confirmed names
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)
