Connectors

/

Procore

/

Review Procore project vendor spend in Ramp
Report
Cross-Connector

See what each project vendor spends through Ramp

For project teams who ask their AI assistant for the Ramp spend of every vendor on a Procore project roster.

Try PopdockAI free
Get a live demo
Review Procore project vendor spend in Ramp
For the Riverside Tower project, show how much each roster vendor has been paid through Ramp and flag anything over 25,000 in the last year.
Ramp spend is company-wide, not limited to Riverside Tower. 11 roster vendors were checked. - High spend: Fabrikam Concrete, 182,400.00 in the last 365 days - No spend: Contoso Aggregates - Not in Ramp: Northwind Electric - Roster total across Ramp: 410,750.00 Want the table with all four spend periods for each vendor?
Procore
Sample figures. Your results come from your own account.
procore-get-projects
procore-get-project-vendors
ramp-get-vendor

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

Roster vendors and Ramp spend live in two places

Seeing what a project's roster vendors have been paid through Ramp means pulling a vendor list from Procore and matching each name in Ramp. The work is repeated for every project, so it is skipped.

Without PopdockAI

  • Export the project's vendor roster from Procore
  • Look up each vendor in Ramp
  • Copy spend for each period into a sheet
  • Sort and flag high and zero spend by hand

With PopdockAI

  • The roster is read from Procore and each active vendor looked up in Ramp
  • Spend is shown for 30 days, 365 days, year to date and all time
  • Vendors are flagged as high spend, no spend or not in Ramp
  • The report states that Ramp spend is company-wide

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 project `{project-name}`, show how much each vendor on the Procore project roster has been paid through Ramp, and flag roster vendors with large Ramp spend or none. Treat a vendor as high spend when its Ramp spend in the last 365 days is at least `{spend-threshold}` (default 10000).

**Step 1: Read the project and its vendors (Procore)**

Call `procore-get-projects` with `project-name` to confirm the project; if it matches more than one project, list them and stop. Then call `procore-get-project-vendors` with the same `project-name`. Keep `vendor-id`, `name`, `vendor-group`, `active` and `business-phone`.

**Step 2: Read Ramp spend**

For each active vendor call `ramp-get-vendor` with `name` equal to the Procore name, falling back to `name.contains`. Keep `id`, `total-spend-last-30-days`, `total-spend-last-365-days`, `total-spend-ytd` and `total-spend-all-time`.

**Step 3: Report**

A table sorted by Ramp spend in the last 365 days, highest first: vendor, group, Ramp spend last 30 days, last 365 days, year to date, all time, and a flag (high spend, no spend, not in Ramp). End with the number of roster vendors in each flag and the total Ramp spend across the roster.

**Rules & Guidelines:**

* `procore-get-projects` and `procore-get-project-vendors` are on the Procore core server. `ramp-get-vendor` is on the Ramp server.
* Read-only. Do not call `ramp-vendor-add`, `ramp-vendor-update` or any Procore create, update or delete tool.
* Ramp spend is company-wide, not limited to this project. Say so at the top of the report.

**Validation:**

* If the project has no vendors, say so and stop.
* If a name matches several Ramp vendors, list them and leave that vendor's spend blank.
* If Ramp returns no vendors at all, say so and stop.

Who it's for

One answer, three teams that use it

Project managers

See where vendor money goes

Check how much of the roster's spend runs through Ramp and spot vendors with large or no spend.

Show the Ramp spend for every vendor on the Fabrikam Depot roster.

Procurement leads

Find consolidation candidates

See roster vendors with high Ramp spend over the last year to decide who to renegotiate with.

Which vendors on Contoso Warehouse have more than 50,000 in Ramp spend in the last 365 days?

Project controls analysts

Find vendors missing from Ramp

Spot roster vendors with no Ramp record, so onboarding gaps are closed.

List the Northwind Plaza roster vendors that are not in Ramp.

How it works

What PopdockAI does when you ask

You name the project and your AI assistant reads the roster and each vendor's Ramp spend. It only reads, and it leaves spend blank when a name matches several Ramp vendors.

Ask

You name the project and, if you want, the spend level that counts as high.

Your AI tool

Read

It confirms the project in Procore and reads its vendor roster.

procore-get-projects
procore-get-project-vendors
ramp-get-vendor

Check

It finds each active vendor in Ramp and reads spend over four periods.

No items found.

Report

You get a table sorted by yearly spend with flags and the roster total.

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

Returns the projects in Procore, with project number, name, stage, active flag and dates. Filter by name, number or status.
get-data

procore-get-project-vendors

Returns the vendors on a Procore project roster, with contact details. Filter by project.
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.
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

Roster vendor spend visible without two reports

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