Connectors

/

Procore

/

Reconcile the Procore vendor directory with Rillet
Report
Cross-Connector

Compare the Procore vendor directory with Rillet

For finance teams who want Procore and Rillet vendor records matched by asking their AI assistant.

Try PopdockAI free
Get a live demo
Reconcile the Procore vendor directory with Rillet
Compare our active Procore vendors with Rillet and tell me who is in only one system or has different details.
Of 142 active Procore vendors, 131 match Rillet, 11 are Procore only and 9 differ in detail. - Procore only: Fabrikam Plant Hire, Contoso Skips and 9 others - Rillet only: 4 vendors with no active Procore record - Differences: Northwind Steel has a different email and city in each system Want the 3 uncertain name only matches listed?
Procore
Sample figures. Your results come from your own account.
procore-get-vendors
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

Two vendor lists that nobody compares properly

The Procore vendor directory and the Rillet vendor list are kept separately and checked by eye. Near-identical names show up as duplicates or gaps, and email and address details drift.

Without PopdockAI

  • Export both vendor lists
  • Sort and compare names by eye
  • Try to match on tax id where it is filled in
  • Miss the vendors whose suffix or spelling differs

With PopdockAI

  • Both lists are read and matched in a fixed order
  • Tax id first, then email, then name
  • Name only matches are labelled uncertain
  • Nothing is created or updated in either system

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** Compare the active vendors in Procore with the vendors in Rillet and report which exist in one system only or disagree on details. If `{name-contains}` is given, restrict the Procore side to vendors whose name contains it (default: all active vendors).

**Step 1: Read the Procore vendors**

Call `procore-get-vendors` (Procore server), with `name.contains` set to `{name-contains}` when given. Keep `vendor-id`, `name`, `abbreviated-name`, `email-address`, `business-id`, `city`, `state` and `active`. Ignore vendors where `active` is false and say how many you ignored. If nothing comes back, say so and stop.

**Step 2: Read the Rillet vendors**

Call `rillet-get-vendors` (Rillet server). Keep `vendor-id`, `name`, `email`, `tax-id`, `city`, `state` and `country`.

**Step 3: Match across**

Match each Procore vendor to a Rillet vendor in this order: Procore `business-id` equals Rillet `tax-id` (digits only); then `email-address` equals `email` (ignore case); then `name` equals `name` after dropping case, punctuation and suffixes such as LLC, Inc, Ltd and Co. Record which rule matched. A name-only match is a possible match, not a confirmed one.

**Step 4: Report**

Three lists: Procore only, Rillet only, and matched with differences (email, city or state differ). End with counts and the matches you consider uncertain.

**Rules & Guidelines:**

* `procore-get-vendors` is on the Procore server. `rillet-get-vendors` is on the Rillet server.
* Read-only. Do not call `rillet-add-vendor`, `rillet-update-vendor`, `procore-create-vendor`, `procore-update-vendor` or any other create, update or delete tool.

**Validation:**

* If two Procore vendors match the same Rillet vendor, list both and do not pick one.
* If either server returns no vendors, state which one and stop.
* Treat a missing `business-id` or `tax-id` as unknown, not as a mismatch.

Who it's for

One answer, three teams that use it

Accounts payable

Clean up the vendor list

See which vendors exist in only one system so they can be added, merged or retired.

List Procore vendors with no match in Rillet, matching on tax id and email first.

Procurement managers

Keep vendor details consistent

Find vendors whose email, city or state differs between the project and finance systems.

Which matched vendors have different emails in Procore and Rillet?

Finance controllers

Spot possible duplicates

Review uncertain name only matches before they turn into duplicate vendor records.

Show me vendors matched by name only between Procore and Rillet, for vendors containing Contoso.

How it works

What PopdockAI does when you ask

You choose which vendors to check and your AI assistant matches the two directories. It lists ambiguous matches rather than choosing one.

Ask

You name part of a vendor name, or leave it open for all active vendors.

Your AI tool

Read

It reads the active Procore vendors and the Rillet vendors and notes how many inactive ones it ignored.

procore-get-vendors
rillet-get-vendors

Match

It matches by tax id, then email, then name, and records which rule matched.

No items found.

Report

You get Procore only, Rillet only and matched with differences, plus counts and uncertain matches.

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

Returns the vendors in the Procore company directory, with name, email, business ID, city, state and active flag. Filter by name, state or other vendor fields.
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

One reliable view of vendors across both systems

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