Connectors

/

Procore

/

Review overdue Procore RFI contractors in Ramp
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Review overdue Procore RFI contractors in Ramp
Which RFIs on Riverside Tower are overdue, and are any of those contractors waiting on payment in Ramp?
Riverside Tower has 6 overdue RFIs across 4 contractors, and 2 of them have unpaid Ramp bills. - RFI-0042: Slab penetration, due 3 November, Fabrikam Concrete - Fabrikam Concrete: 2 unpaid bills, 18,550.00 total - Contoso Steel: 1 unpaid bill, 6,200.00, RFI-0051 overdue - Possible match, not totalled: Northwind Elec Want the full row for each of the 6 RFIs?
Procore
Sample figures. Your results come from your own account.
procore-get-rfis
ramp-get-vendor
ramp-get-bill

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

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.

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

Your AI tool

Read

It lists RFIs past due and not closed, with the responsible contractor.

procore-get-rfis
ramp-get-vendor
ramp-get-bill

Check

It finds each contractor in Ramp and reads unpaid bills and yearly spend.

No items found.

Report

You get a row per RFI and the contractors who are both late and owed money.

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

Returns Procore requests for information (RFIs) for a project, with status, due date and the responsible contractor.
get-data

ramp-get-vendor

Returns Ramp vendors as read from the Ramp connector. Filters include: name contains, created at to, legal name contains, vendor owner id, maximum records.
get-data

ramp-get-bill

Returns Ramp bills as read from the Ramp connector. Filters include: vendor name, approval status, id, vendor name contains, due date to.
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

Chase late RFIs knowing who is owed money

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