Connectors

/

Procore

/

Trace a vendor across Procore and Ramp
Report
Cross-Connector

See a vendor's net exposure across Procore and Ramp

For finance leaders who ask their AI assistant for one view of a vendor's Ramp spend, bills and credits next to their Procore claims.

Try PopdockAI free
Get a live demo
Trace a vendor across Procore and Ramp
Show me Fabrikam Concrete's exposure: what they have been paid and are owed in Ramp, and what they have claimed on Riverside Tower.
Fabrikam Concrete is a single Ramp vendor, and net exposure on Riverside Tower is 41,900.00. - Ramp: 182,400.00 spent in the last 365 days, 2 unpaid bills for 18,550.00 - Ramp: 2,000.00 in unused vendor credits - Procore: 4 requisitions, 96,000.00 claimed, 3 not yet approved - Net exposure: claims not billed in Ramp, plus open bills, less credits Want the Procore requisitions listed one by one?
Procore
Sample figures. Your results come from your own account.
ramp-get-vendor
ramp-get-bill
ramp-get-vendor-credit
procore-get-requisitions

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 vendor's exposure is split across two systems

Ramp holds a vendor's spend, bills and credits and Procore holds what they have claimed on a project, so working out what is owed means two searches and a manual sum. Figures lose their source on the way.

Without PopdockAI

  • Look the vendor up in Ramp for spend and unpaid bills
  • Find any unused vendor credits
  • Dig through Procore requisitions for the project
  • Add it up and hope you labelled each figure

With PopdockAI

  • The vendor is established in Ramp, and several matches stop the job
  • Spend, unpaid bills and unused credits are read together
  • Their Procore requisitions on the project are added
  • Every figure is labelled with its source system

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 a single exposure view for the vendor `{vendor-name}`, combining what Ramp has paid and still owes with what the vendor has claimed on Procore project `{project-name}`.

**Step 1: Establish the vendor in Ramp**

Call `ramp-get-vendor` (Ramp server) with `name.contains` set to `{vendor-name}`. If it matches more than one vendor, list the names and ids and stop. Keep `id`, `name`, `total-spend-ytd`, `total-spend-last-365-days` and `active`.

**Step 2: Read the open money in Ramp**

Call `ramp-get-bill` (Ramp server) with `vendor-name` set to the vendor's exact Ramp `name`, and list bills whose `payment-status` is not paid. Then call `ramp-get-vendor-credit` (Ramp server) with `vendor-id` set to the vendor `id` and keep `remaining-amount` for each credit.

**Step 3: Read the vendor's claims in Procore**

Call `procore-get-requisitions` (Procore server) with `project-name.contains` set to `{project-name}`. Procore cannot filter requisitions by vendor, so keep only the rows whose `vendor` matches the Ramp vendor name once case and punctuation are ignored. Keep `total-claimed-amount`, `current-payment-due`, `status` and `billing-date`.

**Step 4: Report**

Sections: Vendor in Ramp (name, spend year to date, last 365 days); Open Ramp bills (count and total); Unused vendor credits (total remaining); Procore claims on the project (count, total claimed, total currently due, and how many are not yet approved). End with one sentence on net exposure: Procore amounts claimed but not yet billed in Ramp, plus open Ramp bills, less unused credits.

**Rules & Guidelines:**

* `ramp-get-vendor`, `ramp-get-bill` and `ramp-get-vendor-credit` are on the Ramp server. `procore-get-requisitions` is on the Procore server.
* Read only. Do not call `ramp-vendor-update`, `ramp-vendor-add`, `ramp-vendor-delete` or any `procore-create-`, `procore-update-` or `procore-delete-` tool.
* Show every figure with its source system so the reader can tell which is which.

**Validation:**

* If the vendor is not in Ramp, report that, still do Step 3, and mark the Ramp sections Not found.
* If the vendor has no requisitions on the project, say so and report the Ramp side only.
* If the vendor name matches under a different spelling in Procore, show both spellings and ask the user to confirm they are one vendor.

Who it's for

One answer, three teams that use it

Finance directors

Judge vendor risk quickly

See what a vendor has claimed, what is open in Ramp and what credit they hold in one answer.

Trace Contoso Steel across Ramp and the Fabrikam Depot project and give me the net exposure.

Project executives

Prepare for a vendor conversation

Walk into a call knowing a vendor's open bills, credits and unapproved claims on your project.

What does Northwind Electric have outstanding in Ramp and claimed on Northwind Plaza?

Controllers

Check claims against billing

Spot Procore claims not yet billed in Ramp for a vendor, with figures labelled by system.

Show Fabrikam Lumber's Ramp bills and credits next to their Procore claims on Contoso Warehouse.

How it works

What PopdockAI does when you ask

You name the vendor and the project, and your AI assistant reads both systems. It only reads, and it asks before treating two spellings as one vendor.

Ask

You name the vendor and the Procore project.

Your AI tool

Check

It finds the vendor in Ramp and reads spend, unpaid bills and unused credits.

ramp-get-vendor
ramp-get-bill
ramp-get-vendor-credit
procore-get-requisitions

Read

It reads that vendor's requisitions on the project in Procore.

No items found.

Report

You get four sections and one sentence on net exposure, each figure labelled.

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

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

ramp-get-vendor-credit

Returns Ramp vendor credits as read from the Ramp connector. Filters include: id, created at to, created at from, maximum records, remaining amount currency code.
get-data

procore-get-requisitions

Returns Procore subcontractor requisitions (invoices), with vendor, vendor invoice number, status, total claimed, payment due and billing date. Filter by project name and billing date range.
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

One page for what a vendor is owed

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