Connectors

/

Procore

/

Add missing Procore vendors to Rillet
Write
Cross-Connector

Add active Procore vendors to Rillet in confirmed batches

For operations teams who ask their AI assistant to find active Procore vendors absent from Rillet and add the ones they approve.

Try PopdockAI free
Get a live demo
Add missing Procore vendors to Rillet
Find active Procore vendors with Fabrikam in the name that are not in Rillet, and add them once I confirm.
3 active Procore vendors with Fabrikam in the name are missing from Rillet. - Fabrikam Concrete, Tampa, FL, orders@fabrikam.com - Fabrikam Rentals, Austin, TX, no email on file, flagged - Fabrikam Lumber, Boise, ID, lumber@fabrikam.com Which of these should I create in Rillet?
Procore
Sample figures. Your results come from your own account.
procore-get-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

Vendors added in Procore never reach Rillet

New vendors are set up in Procore and then retyped into Rillet, so some are forgotten and some are entered twice. Nobody finds out until a bill cannot be booked.

Without PopdockAI

  • Export active vendors from Procore
  • Search Rillet for each by name
  • Retype the missing ones into Rillet
  • Clean up the duplicates created along the way

With PopdockAI

  • Vendors are matched on tax id, email and name
  • Each missing vendor is checked in Rillet a second time
  • You confirm a capped batch before anything is created
  • Each vendor is created once, never retried, then verified

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 active Procore vendors whose name contains `{name-contains}` (default: all) that are not in Rillet and, once the user confirms, create them in Rillet.

**Step 1: Find the gaps**

Call `procore-get-vendors` (Procore server) and keep active vendors, filtering with `name.contains` when `{name-contains}` is given. Keep `name`, `email-address`, `business-id`, `city` and `state`. Call `rillet-get-vendors` (Rillet server). A Procore vendor is present in Rillet if `business-id` equals `tax-id`, or `email-address` equals `email`, or the names match after dropping case, punctuation and suffixes such as LLC and Inc. Anything left is missing. Re-check each missing vendor by calling `rillet-get-vendors` once more, to confirm none was created since.

**Step 2: Confirm**

Show a table of the missing vendors with the values you would send: `name`, `email`, `city`, `state`. Cap the list at `{max-vendors}` (default 10). Ask the user to confirm which to create and stop until they answer. Do not create anything without that answer.

**Step 3: Create**

For each confirmed vendor, call `rillet-add-vendor` with `name`, `email`, `city`, `state` and `country` set to US only if Procore shows a US state. Leave `payment-terms`, `account-code` and `ten-ninety-nine-eligible` unset; do not guess them. After each call, report the returned id.

**Step 4: Verify**

Call `rillet-get-vendors` again and confirm each created vendor now appears. Report created, failed and skipped vendors.

**Rules & Guidelines:**

* `procore-get-vendors` is on the Procore server. `rillet-get-vendors` and `rillet-add-vendor` are on the Rillet server.
* The only write allowed is `rillet-add-vendor`, only for vendors the user confirmed. Never call `rillet-update-vendor`, `rillet-add-bill`, any other Rillet write, or any Procore create, update or delete tool.
* Never create the same vendor twice; if a call fails, report it and do not retry.

**Validation:**

* If nothing is missing, say so and stop.
* If a Procore vendor has no email, still list it and flag it.
* If vendors look like duplicates of each other, list them and ask before creating.

Who it's for

One answer, three teams that use it

Operations managers

Keep both systems in step

Find the vendors added in Procore that Rillet has never heard of, without comparing exports.

List active Procore vendors that are not in Rillet, 10 at most.

Accounts payable

Fix the gap before a bill fails

Add the missing vendors you approve, so incoming bills have somewhere to land.

Add the missing Contoso vendors from Procore to Rillet once I confirm the list.

Finance systems owners

Avoid duplicate vendors

Matching on tax id and email as well as name catches duplicates that a name search misses.

Check Procore vendors in Texas against Rillet and flag any that look like duplicates of each other.

How it works

What PopdockAI does when you ask

You say which vendors to look at and your AI assistant finds the gaps. It writes only after you confirm, and it never retries a failed creation.

Ask

You say which vendors to look at, or leave it open for all.

Your AI tool

Check

It compares active Procore vendors with Rillet by tax id, email and name, then re-checks the gaps.

procore-get-vendors
rillet-get-vendors

Confirm

You see a capped table of what would be created and choose which to add.

No items found.

Create

It creates each confirmed vendor once and reads Rillet again to verify.

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

Vendors in both systems, without double entry

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