/
/
See a customer's pipeline and billing in one view
For sales teams who want a customer's Procore pipeline and Rillet billing together by asking their AI assistant.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
The problem
A customer's full picture sits in two systems
Their pipeline is on the Procore bid board while contracts, invoices and overdue amounts are in Rillet. Seeing both before a sales call means opening two systems and combining the numbers yourself.
Without PopdockAI
- Filter the Procore bid board for the customer
- Find the customer in Rillet
- Open their contracts and add up the invoices
- Combine the figures into one summary
With PopdockAI
- Pipeline, contracts and invoices come back together
- A customer missing from Rillet is reported, not guessed
- Invoiced, due and overdue amounts are totalled for you
- Currencies stay separate and nothing is changed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Build one view of the customer `{customer-name}`: what is in the Procore bid board pipeline for them, and what Rillet shows as contracted, invoiced and overdue. Include only bid board projects with status `{status}` (default: every status).
**Step 1: Pipeline (Procore Preconstruction server)**
Call `procore-get-estimating-bid-board-projects` with `customer-company-name.contains` set to `{customer-name}`, and `status` set to `{status}` when it is not empty. If more than one customer name matches, list them and stop. Keep `name`, `status`, `due-date` and `stats-total`.
**Step 2: Customer in the ledger (Rillet server)**
Call `rillet-get-customers` and match `name` or `invoicing-name` to `{customer-name}`. If there is no match, report the pipeline from Step 1, state that the customer is not in Rillet, and stop.
**Step 3: Billing (Rillet server)**
Call `rillet-get-contracts` with `customer-id` set to the match. Call `rillet-get-invoices`, which has no filters, and keep rows whose `customer-id` equals the match. Sum `total` and `amount-due`, and count rows where `overdue` is true.
**Step 4: Report**
Three short sections: pipeline (project, status, due date, stats-total, with a total), contracts (name, status, total-value, dates), invoicing (invoiced total, amount due, overdue count and amount). Close with one sentence on whether the pipeline looks like work already contracted or new.
**Rules & Guidelines:**
* `procore-get-estimating-bid-board-projects` is on the Procore Preconstruction server; the other tools are on the Rillet server.
* Read-only. Do not call any create, update or add tool on either server.
**Validation:**
* No contracts or invoices in Rillet is a valid result; report it as none, not as an error.
* If invoice currencies differ, total each currency separately.Who it's for
One answer, three teams that use it
Sales reps
Prepare before a customer call
See what you are bidding for them and what they owe, so the conversation starts with the full picture.
Profile Contoso Holdings: bid board pipeline in Procore and billing in Rillet.
Business development managers
Decide where to focus
Compare pipeline against what is already contracted to see whether a customer is new work or existing.
For Fabrikam Developments, show active bid board projects and their Rillet contracts.
Account managers
Raise overdue balances in context
See overdue invoices next to the customer's open bids before you discuss new work.
Does Northwind Traders have overdue invoices in Rillet while we have bids open in Procore?
How it works
What PopdockAI does when you ask
You name the customer and your AI assistant reads Procore and Rillet. If the customer is not in Rillet it says so and still reports the pipeline.
Ask
You name the customer and, optionally, a bid board status.
Pipeline
It reads their bid board projects in Procore and stops if the name matches more than one customer.
Billing
It finds the customer in Rillet and reads their contracts and invoices.
Report
You get pipeline, contracts and invoicing in three sections, with currencies totalled separately.
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-estimating-bid-board-projects
rillet-get-customers
rillet-get-contracts
rillet-get-invoices
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
Know the customer before you pursue them
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)
