/
/
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.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
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.
**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.
Read
It reads the bidders on the project and keeps each distinct vendor.
Match
It matches each to a Rillet vendor and counts the bills that are not paid.
Report
You get a row per bidder, with vendors missing from Rillet listed first.
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.
procore-get-bids
rillet-get-vendors
rillet-get-bills
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.
The outcome
Payment-ready bidders before the award
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.

.webp)
