/
/
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.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
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.
**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.
Read
It confirms the project in Procore and reads its vendor roster.
Check
It finds each active vendor in Ramp and reads spend over four periods.
Report
You get a table sorted by yearly spend with flags and the roster total.
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-projects
procore-get-project-vendors
ramp-get-vendor
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
Roster vendor spend visible without two reports
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)
