Connectors

/

Procore

/

Profile a customer's Procore pipeline and Rillet billing
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Profile a customer's Procore pipeline and Rillet billing
Give me a profile of Northwind Traders: what is in our Procore bid board for them and what Rillet shows as contracted, invoiced and overdue.
Northwind Traders has 1,900,000 in the bid board pipeline and 42,000 overdue in Rillet. - Pipeline: 3 projects, including Riverside Tower Phase 2, due 30 April - Contracts: 2 active, total value 2,400,000 - Invoicing: 1,150,000 invoiced, 96,500 due, 3 invoices overdue The pipeline looks like new work rather than contracted work. Want the invoice list?
Procore
Sample figures. Your results come from your own account.
procore-get-estimating-bid-board-projects
rillet-get-customers
rillet-get-contracts
rillet-get-invoices

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

Prompt
**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.

Your AI tool

Pipeline

It reads their bid board projects in Procore and stops if the name matches more than one customer.

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

Billing

It finds the customer in Rillet and reads their contracts and invoices.

No items found.

Report

You get pipeline, contracts and invoicing in three sections, with currencies totalled separately.

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.
get-data

rillet-get-contracts

Returns customer contracts (term, status, total value, invoicing) from Rillet.
get-data

rillet-get-invoices

Returns customer invoices (number, customer, dates, status, totals, amount due) 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

Know the customer before you pursue them

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