Connectors

/

Procore

/

Add missing Procore materials PO vendors to Rillet
Write
Cross-Connector

Add missing materials order suppliers to Rillet, verified

For finance teams who ask their AI assistant to find Procore materials purchase order vendors that Rillet lacks and create them after review.

Try PopdockAI free
Get a live demo
Add missing Procore materials PO vendors to Rillet
For the Riverside Tower project, find materials purchase order vendors that are not in Rillet and add them.
Riverside Tower orders involve 8 vendors, and 2 are missing from Rillet. - Would create: Fabrikam Lumber - Would create: Adventure Works Fasteners - Possible duplicate, left out: Contoso Aggregates against Contoso Aggregate Inc - Already in Rillet: 5 vendors Shall I create the 2 missing vendors with the name only?
Procore
Sample figures. Your results come from your own account.
procore-get-materials-mgmt-purchase-orders-vendors
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

New suppliers block the bill until someone keys them in

A supplier on a materials order has to exist in Rillet before a bill can be booked, so someone retypes it. A near-duplicate spelling then creates a second vendor, and bills start going to the wrong record.

Without PopdockAI

  • List the vendors on the project's materials orders
  • Search Rillet for each name and spelling
  • Create the missing vendors by hand
  • Merge duplicates created by different spellings

With PopdockAI

  • Order vendors are compared with Rillet, ignoring case and endings
  • Close matches are shown as possible duplicates and never created
  • Nothing is written until you confirm the list
  • 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 on its Procore materials purchase orders that have no vendor in Rillet, show them, and after the user confirms create each one in Rillet. If `{vendor-name}` is given (optional), only consider that vendor.

**Step 1: Read the PO vendors (Procore resource management)**

Call `procore-get-materials-mgmt-purchase-orders-vendors` with `project-name.contains` set to `{project-name}`. Keep the distinct `vendor` values, narrowed to `{vendor-name}` if given. If more than one project name comes back, list them and stop. If nothing comes back, say so and stop.

**Step 2: Find the gaps (Rillet)**

Call `rillet-get-vendors` once. Match each Procore vendor to a Rillet vendor `name` (ignore case, punctuation and endings such as Inc and LLC). A vendor with a close but not exact match is not a gap: list it as a possible duplicate with both spellings and exclude it from creation.

**Step 3: Confirm before writing**

Show a table of the vendors that would be created (name exactly as it appears in Procore) and the possible duplicates left out. Ask the user to confirm. Do not call any write tool until they say yes, and if they name a subset, create only that subset.

**Step 4: Create and verify (Rillet)**

For each confirmed vendor call `rillet-add-vendor` with `name` set to the Procore vendor name and no other fields; the Procore purchase order list carries only a vendor name. If the call is rejected for a missing required field, report the vendor and the error, do not invent values, and continue with the next vendor. Afterwards call `rillet-get-vendors` again and confirm each new vendor appears.

**Step 5: Report**

Vendors created (with the new Rillet vendor id), vendors that failed with the reason, possible duplicates left out, and vendors already present. Note that address, email, payment terms and tax details must be completed in Rillet.

**Rules & Guidelines:**

* `procore-get-materials-mgmt-purchase-orders-vendors` is on the Procore resource management server. `rillet-get-vendors` and `rillet-add-vendor` are on the Rillet server.
* `rillet-add-vendor` is the only tool that may write, and only after confirmation. Do not call `rillet-update-vendor`, any other Rillet add, update or apply tool, or any Procore create, update or delete tool.
* Never create a vendor that is already in Rillet or is a possible duplicate.

**Validation:**

* If nothing is missing, say so and write nothing.
* If the user does not confirm, write nothing and say so.
* If `rillet-get-vendors` returns nothing, ask the user to confirm that the Rillet vendor list really is empty before creating anything.

Who it's for

One answer, three teams that use it

Accounts payable

Get suppliers ready for bills

Create the missing vendors for a project's materials orders in one pass, so bills are not rejected for an unknown supplier.

Find vendors on Fabrikam Depot materials purchase orders that are missing from Rillet and add them.

Procurement coordinators

Check before first order bills arrive

See which order suppliers are new to Rillet and which look like existing vendors under another spelling.

List the Contoso Warehouse materials order vendors that have no Rillet vendor, but do not create any yet.

Finance systems owners

Keep the vendor list clean

Possible duplicates are left out and shown with both spellings, so the ledger does not collect near-copies.

Add only Northwind Fasteners from the Northwind Plaza materials orders to Rillet if it is missing.

How it works

What PopdockAI does when you ask

You name the project and your AI assistant finds the gaps. Vendors are created only after you confirm, with the name Procore holds and no invented fields.

Ask

You name the project and optionally a single vendor.

Your AI tool

Check

It reads the order vendors, compares them with Rillet and sets close matches aside.

procore-get-materials-mgmt-purchase-orders-vendors
rillet-get-vendors

Confirm

You see what would be created and the possible duplicates left out, and say yes.

No items found.

Create

It creates each vendor by name, re-reads Rillet to verify and reports what is left to fill in.

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-materials-mgmt-purchase-orders-vendors

Returns the project vendors on Procore materials purchase orders, from Procore Resource Management.
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

Suppliers ready to bill, without duplicate vendors

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