Connectors

/

Procore

/

Match Procore bid board customers to Rillet customers
Report
Cross-Connector

Find bid board customers missing from Rillet

For finance teams who want Procore bid board customers checked against Rillet customers by asking their AI assistant.

Try PopdockAI free
Get a live demo
Match Procore bid board customers to Rillet customers
Which customers on our Procore bid board, any status, are not set up as customers in Rillet?
2 of 9 bid board customers are missing from Rillet and 1 is a close match. - Fabrikam Developments: 3 projects, 1,900,000 pipeline, missing from Rillet - Contoso Holdings: 1 project, 450,000 pipeline, missing from Rillet - Northwind Trader: close match to Northwind Traders, for you to decide Want the full table of all 9 customers?
Procore
Sample figures. Your results come from your own account.
procore-get-estimating-bid-board-projects
rillet-get-customers

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

Spelling hides customers missing from the ledger

Bid board customer names are compared with the Rillet customer list by eye. A small spelling difference hides a customer who was never set up, until the first invoice has nowhere to go.

Without PopdockAI

  • Export the bid board and the Rillet customer list
  • Sort both and compare names by eye
  • Guess whether Northwind Trader is Northwind Traders
  • Lose track of which missing customer matters most

With PopdockAI

  • Both lists are read and matched for you
  • Case, punctuation and endings are ignored
  • Close matches are shown, never merged
  • Missing customers are ranked by pipeline value

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 bid board projects with status `{status}` (default: every status), confirm each project's customer exists as a customer in Rillet and report the ones that do not.

**Step 1: Read the bid board (Procore Preconstruction server)**

Call `procore-get-estimating-bid-board-projects`, passing `status` as `{status}` when it is not empty. Keep `name`, `status`, `customer-company-name` and `stats-total` for each project. If nothing comes back, say so and stop.

**Step 2: Read the ledger customers (Rillet server)**

Call `rillet-get-customers`. It has no filters, so read the whole list and match locally.

**Step 3: Match by customer name**

Compare `customer-company-name` with the Rillet customer `name` and `invoicing-name`. Ignore case, punctuation and suffixes such as Inc, LLC and Ltd. Classify each distinct customer as exact match, close match (list the Rillet candidate), or missing from Rillet.

**Step 4: Report**

A table of distinct customers with: Procore customer name, number of projects, total of `stats-total`, Rillet `customer-id`, and the match class. List the missing customers first, largest `stats-total` first.

**Rules & Guidelines:**

* `procore-get-estimating-bid-board-projects` is on the Procore Preconstruction server; `rillet-get-customers` is on the Rillet server.
* This prompt is read-only. Do not call `rillet-add-customer`, `rillet-update-customer` or any Procore create, update or delete tool.
* Never merge two customers because their names are similar; report close matches and let the user decide.

**Validation:**

* If Rillet returns no customers, report that the Rillet side is empty and stop.
* If a project has no `customer-company-name`, list it under projects with no customer.

Who it's for

One answer, three teams that use it

Accounts receivable

Set up customers before invoicing

See which bid board customers have no Rillet record so they can be created before the first invoice.

List the Procore bid board customers with won projects that are not in Rillet.

Finance controllers

Prioritise by pipeline

Start with the missing customers that carry the most pipeline value.

Which missing Rillet customers have the largest bid board pipeline?

Estimating managers

Check customer names are consistent

Find where a customer is spelled differently in Procore and the ledger so the names can be aligned.

Which Procore bid board customers are only a close match to a Rillet customer?

How it works

What PopdockAI does when you ask

You choose a status and your AI assistant reads Procore and Rillet. Close matches are shown for you to decide and nothing is merged or changed.

Ask

You give a bid board status, or leave it open for every status.

Your AI tool

Read

It reads the bid board projects in Procore and the full customer list in Rillet.

procore-get-estimating-bid-board-projects
rillet-get-customers

Match

It compares names ignoring case, punctuation and endings and classes each as exact, close or missing.

No items found.

Report

You get the customers table with missing ones first, largest pipeline 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-estimating-bid-board-projects

Returns Procore Preconstruction bid board projects, with status and the assigned estimator.
get-data

rillet-get-customers

Returns customers (name, address, payment terms, invoicing settings) 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 bid board customer set up before it is needed

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