Connectors

/

Procore

/

Check Procore bid vendors in Rillet
Report
Cross-Connector

Check every bidder is set up in Rillet before award

For finance and preconstruction teams who ask their AI assistant whether the vendors bidding on a Procore project exist in Rillet.

Try PopdockAI free
Get a live demo
Check Procore bid vendors in Rillet
For the Riverside Tower project, check that every bidder exists in Rillet and show their payment terms and open bills.
6 vendors bid on Riverside Tower, and 1 is missing from Rillet. - Not in Rillet: Adventure Works Paving - Fabrikam Concrete: Net 30, 1099 eligible, 2 open bills - Contoso Steel: Net 45, not 1099 eligible, no open bills - Two possible matches, not chosen: Northwind Electric and Northwind Electrical Want the full row for each of the 6 bidders?
Procore
Sample figures. Your results come from your own account.
procore-get-bids
rillet-get-vendors
rillet-get-bills

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

A winning bidder turns out to be missing from the ledger

Bidders are invited without anyone checking they are set up for payment. The gap shows after award, when the vendor has no record in Rillet or is missing payment terms.

Without PopdockAI

  • List the bidders on the Procore project
  • Search Rillet for each vendor name
  • Open each match for terms and the 1099 flag
  • Count open bills one vendor at a time

With PopdockAI

  • Each bidder is matched to a Rillet vendor, ignoring endings like Inc
  • Payment terms, 1099 flag and open bills are shown per vendor
  • Vendors missing from Rillet are listed first
  • Two possible matches are listed, never chosen between

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 the Procore project whose name contains `{project-name}`, check that each vendor who submitted a bid exists as a vendor in Rillet, and show their open bills, looking back `{lookback-days}` days (default 365).

**Step 1: Read the bids (Procore Preconstruction server)**

Call `procore-get-bids` with `project-name.contains` set to `{project-name}`. Keep `project-name` and `vendor-name`. If nothing comes back, say so and stop. If the bids span more than one project name, list the project names and stop.

**Step 2: Read the Rillet vendors (Rillet server)**

Call `rillet-get-vendors` and match each distinct `vendor-name` to the Rillet vendor `name`, ignoring case, punctuation and suffixes such as Inc and LLC. Keep `vendor-id`, `payment-terms` and `1099-eligible`.

**Step 3: Read their bills (Rillet server)**

For each matched vendor call `rillet-get-bills` with `vendor-id` set to the vendor and `bill-date.from` set to today minus `{lookback-days}` days. Count bills that are not paid, using the `status` values returned.

**Step 4: Report**

A table with one row per bidding vendor: vendor, Rillet `vendor-id` or not found, payment terms, 1099 eligible, open bill count. List vendors missing from Rillet first.

**Rules & Guidelines:**

* `procore-get-bids` is on the Procore Preconstruction server; `rillet-get-vendors` and `rillet-get-bills` are on the Rillet server.
* Read-only. Do not call `rillet-add-vendor`, `rillet-update-vendor`, `rillet-add-bill` or any Procore create, update or delete tool.

**Validation:**

* Two Rillet vendors that could match one bidder: list both and do not choose.
* A vendor with no bills returns zero open bills, not an error.

Who it's for

One answer, three teams that use it

Estimators

Invite bidders you can pay

See which bidders are not in Rillet before the bid is awarded, instead of afterwards.

Check the bidders on Fabrikam Depot against Rillet and list those that are not set up.

Accounts payable

Prepare vendor setup early

Know which bidders need a vendor record and which already have open bills, before an award lands.

Which Contoso Warehouse bidders exist in Rillet, and how many open bills does each have in the last 180 days?

Compliance coordinators

Check the 1099 flag

See each bidder's 1099 flag and payment terms in one table, so gaps are fixed before the first invoice.

For Northwind Plaza, show each bidder's payment terms and 1099 eligibility in Rillet.

How it works

What PopdockAI does when you ask

You name the project and your AI assistant reads the bidders and checks each in Rillet. It only reads, and it stops if the project name is unclear.

Ask

You name the Procore project and how far back to look at bills.

Your AI tool

Read

It reads the bidders on the project and keeps each distinct vendor.

procore-get-bids
rillet-get-vendors
rillet-get-bills

Match

It matches each to a Rillet vendor and counts the bills that are not paid.

No items found.

Report

You get a row per bidder, with vendors missing from Rillet listed 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-bids

Returns Procore Preconstruction bids within a project, with the bidding vendor and lump sum amount. Filter by project name.
get-data

rillet-get-vendors

Returns vendors (name, contact, address, payment terms, 1099 status) from Rillet.
get-data

rillet-get-bills

Returns vendor bills (expense number, vendor, dates, 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

Payment-ready bidders before the award

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