/
/
Know which late RFI contractors are also owed money
For project managers who ask their AI assistant to list overdue Procore RFIs and show each responsible contractor's unpaid Ramp bills.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
The problem
Late RFI chasing ignores who is waiting on payment
You can list overdue RFIs in Procore, but whether those contractors are owed money sits in Ramp. Without that, a follow-up to someone waiting on payment reads the same as every other chaser.
Without PopdockAI
- List overdue RFIs and their contractors in Procore
- Search Ramp for each contractor by name
- Add up unpaid bills one contractor at a time
- Send the follow-ups without the payment context
With PopdockAI
- Overdue, open RFIs are read from Procore
- Contractors are matched to Ramp vendors by exact name
- Possible matches are flagged and left out of totals
- Contractors both late and owed money are listed last
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 `{project-name}`, list RFIs past their due date and show the open Ramp bills for each responsible contractor, looking at RFIs due before `{due-before}` (default: today).
**Step 1: Find the overdue RFIs (Procore)**
Call `procore-get-rfis` with `project-name` set to `{project-name}` and `due-date.to` set to `{due-before}`. Keep only RFIs whose `status` is not closed. If the project name matches more than one project, list the matches and stop.
**Step 2: Carry each contractor across to Ramp**
For each distinct `responsible-contractor-name`, call `ramp-get-vendor` with `name` set to that value. If nothing matches, retry with `name.contains`. If still nothing, record the contractor as not in Ramp and continue.
Then call `ramp-get-bill` with `vendor-name` set to the matched vendor name. Keep bills whose `payment-status` is not paid.
**Step 3: Report**
A table with one row per RFI: `full-number`, `subject`, `due-date`, `responsible-contractor-name`, Ramp vendor match (yes/no), count of unpaid bills, total unpaid `amount` and `total-spend-last-365-days`. End with the contractors that are both late on RFIs and owed money, since those are the leverage and relationship risks.
**Rules & Guidelines:**
* `procore-*` tools belong to the procore-project-management server; `ramp-*` tools belong to the ramp server. Both servers must be connected.
* This prompt is read-only. Do not call any Procore create, update, delete, send or recycle tool, and do not call any Ramp add, update, delete, archive, suspend or terminate tool.
**Validation:**
* If Procore returns no overdue RFIs, say so and stop.
* Vendor names are free text in both systems. Treat a match as exact only when names are equal ignoring case and punctuation; flag partial matches as "possible match" and do not total their bills.
* Never mix currencies: group totals by `currency-code`.Who it's for
One answer, three teams that use it
Project managers
Time your RFI chasers
See which late contractors are also waiting on Ramp payments before you send the follow-up.
Show overdue RFIs on Fabrikam Depot and the unpaid Ramp bills for each contractor.
Construction managers
Judge relationship risk
Find contractors that are both late on RFIs and owed money, who may need a different conversation.
On Contoso Warehouse, which contractors are late on RFIs and have unpaid bills in Ramp?
Accounts payable
Know which payments hold up the design team
See which unpaid bills belong to contractors with overdue RFIs, to prioritise a payment run.
For Northwind Plaza, list overdue RFI contractors and their open Ramp bill totals.
How it works
What PopdockAI does when you ask
You name the project and your AI assistant finds the overdue RFIs and checks each contractor in Ramp. It reads only, and totals are never mixed across currencies.
Ask
You name the project and optionally the due date to check against.
Read
It lists RFIs past due and not closed, with the responsible contractor.
Check
It finds each contractor in Ramp and reads unpaid bills and yearly spend.
Report
You get a row per RFI and the contractors who are both late and owed money.
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-rfis
ramp-get-vendor
ramp-get-bill
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
Chase late RFIs knowing who is owed money
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)
