Connectors

/

Procore

/

Add missing Procore site log vendors to Rillet
Write
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Add missing Procore site log vendors to Rillet
Which vendors in the Riverside Tower site logs since 1 October are not in Rillet? Add the ones I confirm with 30 day terms.
Site logs on Riverside Tower since 1 October name 14 vendors, and 3 have no Rillet record. - No match: Fabrikam Crane Hire - No match: Adventure Works Traffic Control - No match: Northwind Portable Toilets - Partial match for you to judge: Contoso Concrete against Contoso Concrete Pumping Which of these should I create? Address, email and tax details will be blank.
Procore
Sample figures. Your results come from your own account.
procore-get-manpower-logs
procore-get-equipment-logs
procore-get-delivery-logs
rillet-get-vendors
rillet-add-vendor

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

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

Your AI tool

Check

It lists the vendors in the site logs and compares each with Rillet, showing partial matches.

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

Confirm

You see the vendors with no match and choose which to create.

No items found.

Create

It creates each confirmed vendor by name and re-reads Rillet to confirm it appears.

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

rillet-get-vendors

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

rillet-add-vendor

Creates a vendor in Rillet with an address.
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

Site vendors in the ledger, from confirmed names

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