Connectors

/

Procore

/

Add missing Procore bid customers to Rillet
Write
Cross-Connector

Add won Procore bid customers to Rillet once

For operations and finance teams who ask their AI assistant to find bid board customers missing from Rillet and add them after review.

Try PopdockAI free
Get a live demo
Add missing Procore bid customers to Rillet
Check Won bid board projects in Procore and add any customers that are not in Rillet yet.
6 customers on Won bid board projects are in Procore, and 3 are missing from Rillet. - Would create: Fabrikam Developments - Would create: Adventure Works Hospitality - Would create: Northwind Holdings - Close match, not created: Contoso Properties and Contoso Properties LLC Shall I create these 3 customers with the name only?
Procore
Sample figures. Your results come from your own account.
procore-get-estimating-bid-board-projects
rillet-get-customers
rillet-add-customer

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

Won customers are retyped into Rillet, or forgotten

When a bid is won the customer has to be keyed into Rillet by hand. Someone forgets, or enters it twice with a slightly different name, and the problem appears when the first invoice cannot be raised.

Without PopdockAI

  • Check the bid board for newly won projects
  • Search Rillet for each customer name
  • Retype the customer into Rillet
  • Clean up the duplicate with the different spelling

With PopdockAI

  • Customers on won projects are compared with Rillet by name
  • Close matches are listed apart and never created
  • You confirm the list before anything is written
  • Only the name is filled, never a guessed address or terms

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 customers on Procore bid board projects with status `{status}` (default: Won) that do not exist in Rillet, and, after confirmation, create them in Rillet. Limit to the customer `{customer-name}` when it is not empty.

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

Call `procore-get-estimating-bid-board-projects` with `status` set to `{status}` (use Won when empty), and `customer-company-name.contains` set to `{customer-name}` when it is not empty. Collect the distinct `customer-company-name` values. If none, say so and stop.

**Step 2: Compare with Rillet (Rillet server)**

Call `rillet-get-customers` and match each name to `name` or `invoicing-name`, ignoring case, punctuation and suffixes such as Inc and LLC. Anything that matches exactly or closely is not missing. List close matches separately and do not create them.

**Step 3: Confirm**

Show the user the customers that would be created. Do not call any write tool until the user explicitly confirms the list.

**Step 4: Create (Rillet server)**

For each confirmed customer call `rillet-add-customer` with `name` set to the Procore customer name. Fill no other field: Procore does not hold the address or payment terms, so do not guess them. After each call, report the result.

**Step 5: Report**

Created, skipped as close matches, and failed, with the reason for each failure.

**Rules & Guidelines:**

* `procore-get-estimating-bid-board-projects` is on the Procore Preconstruction server; `rillet-get-customers` and `rillet-add-customer` are on the Rillet server.
* `rillet-add-customer` is the only tool that may write, and only after Step 3 confirmation. Never call `rillet-update-customer`, `rillet-add-invoice`, or any Procore create, update or delete tool.
* Tell the user the Rillet add tools may be Inactive; if the call is refused, report that and stop.

**Validation:**

* Never create a customer whose name is already in Rillet.
* Stop at the first error that looks like a permission or connection problem.

Who it's for

One answer, three teams that use it

Operations managers

Hand over won bids cleanly

Make sure every customer on a won bid exists in Rillet, without retyping them from the bid board.

Find customers on Won Procore bids that are missing from Rillet and add them.

Accounts receivable

Have a customer ready to invoice

See which won customers are not yet in Rillet, so billing can start without a delay.

Which customers on Won bid board projects have no Rillet customer? Only list them for now.

Finance systems owners

Avoid near-duplicate customers

Close matches are separated out, so spelling differences do not turn into second customer records.

Check bid board customers containing Contoso against Rillet and show any close matches before creating.

How it works

What PopdockAI does when you ask

You give the bid status and your AI assistant compares the bid board with Rillet. Nothing is created until you have seen the list and confirmed it.

Ask

You give the bid status, usually Won, and optionally a single customer.

Your AI tool

Check

It reads the bid board customers and compares each with Rillet, setting close matches aside.

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

Confirm

You see the customers it would create and say yes to the list.

No items found.

Create

It creates each confirmed customer by name and reports created, skipped and failed.

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

rillet-add-customer

Creates a customer in Rillet with a billing 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

Customers set up once, before the first invoice

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