Connectors

/

Procore

/

Match Procore site log vendors to Rillet vendors
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Match Procore site log vendors to Rillet vendors
Which vendors in the last 30 days of site logs on Riverside Tower do not have a vendor record in Rillet?
11 vendors appear in the Riverside Tower logs, and 2 have no Rillet record. - Fabrikam Plant Hire: equipment and delivery logs, 9 rows, missing from Rillet - Contoso Skips: dumpster logs, 4 rows, possible match to Contoso Skip Hire - Northwind Steel: matched, payment terms Net 30 Want the full table of all 11 vendors?
Procore
Sample figures. Your results come from your own account.
procore-get-manpower-logs
procore-get-equipment-logs
procore-get-delivery-logs
procore-get-dumpster-logs
rillet-get-vendors

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

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.

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

Your AI tool

Collect

It lists every vendor in the manpower, equipment, delivery and dumpster logs and stops if the project is ambiguous.

procore-get-manpower-logs
procore-get-equipment-logs
procore-get-delivery-logs
procore-get-dumpster-logs
rillet-get-vendors

Match

It reads the Rillet vendors and classes each as matched, possible or missing.

No items found.

Report

You get the table with Rillet ids and payment terms, missing vendors first.

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-manpower-logs

Returns Procore manpower log entries from daily logs, including the vendor and workers on site. Filter by project and date.
get-data

procore-get-equipment-logs

Returns equipment log records from Procore: the equipment, vendor and days logged on a project. Filter by project and date range.
get-data

procore-get-delivery-logs

Returns delivery log records from Procore daily logs: the supplier, contents and time of each delivery on a project. Filter by project and date range.
get-data

procore-get-dumpster-logs

Returns dumpster log records from Procore daily logs: the vendor, dumpster and date for a project. Filter by project and date range.
get-data

rillet-get-vendors

Returns vendors (name, contact, address, payment terms, 1099 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

Every site vendor checked against the ledger

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