Connectors

/

Procore

/

Compare Procore project vendors with Ramp vendors
Report
Cross-Connector

Check every project vendor exists in Ramp

For accounts payable teams who want a Procore project roster compared with Ramp vendors, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Compare Procore project vendors with Ramp vendors
Compare the vendors on the Riverside Tower project with Ramp. Which ones are missing or inactive?
38 active vendors on Riverside Tower were checked and 6 need attention in Ramp. - Not in Ramp: 3 vendors, including Contoso Glazing - In Ramp but inactive: 1 vendor, Northwind Paving - Possible matches to confirm: 2, such as Fabrikam Steel and Fabrikam Steel LLC - Inactive Procore vendors left out: 4 Want the Ramp spend over the last 365 days for the matched vendors?
Procore
Sample figures. Your results come from your own account.
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

Vendor rosters are compared by eye

A project roster in Procore and the vendor list in Ramp are compared by scrolling. Names that differ by an Inc or an abbreviation get missed or duplicated, and the gap shows up at payment time.

Without PopdockAI

  • Export the project vendor roster from Procore
  • Search Ramp for each vendor by name
  • Judge whether near names are the same company
  • Build the missing and inactive lists by hand

With PopdockAI

  • The active project roster is read from Procore
  • Each vendor is looked up in Ramp by exact and abbreviated name
  • Fuzzy matches are shown as possible and never confirmed for you
  • Missing, inactive and possible lists come with counts, and nothing is changed

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}`, compare the vendors on the Procore project roster with the vendors in Ramp and report which ones are missing from Ramp or inactive there. Only include roster vendors created or updated on or after `{updated-since}` (default: all of them).

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

Call `procore-get-project-vendors` filtered by `project-name`, adding `date-updated.from` when `{updated-since}` is given. Keep `vendor-id`, `name`, `abbreviated-name`, `email-address`, `active` and `vendor-group`. Drop vendors where `active` is false and say how many you dropped. If nothing comes back, say so and stop.

**Step 2: Find each vendor in Ramp**

For each remaining vendor call `ramp-get-vendor` with `name` set to the Procore `name`. If nothing matches, call it again with `name.contains` set to the `abbreviated-name`, or to the first two words of the name if there is no abbreviation, and treat that as a possible match only. Keep Ramp `id`, `name`, `active`, `vendor-type` and `total-spend-last-365-days`.

**Step 3: Report**

A table with one row per Procore vendor: Procore vendor id, Procore name, Ramp id, Ramp name, match type (exact, possible, none), Ramp active flag and Ramp spend in the last 365 days. Then three lists: not in Ramp, in Ramp but inactive, and possible matches that need a person to confirm. End with the counts.

**Rules & Guidelines:**

* `procore-get-project-vendors` is on the Procore core server. `ramp-get-vendor` is on the Ramp server.
* Read-only. Do not call `ramp-vendor-add`, `ramp-vendor-update`, `ramp-vendor-delete` or any Procore create, update or delete tool.
* Never treat a possible match as a confirmed match.

**Validation:**

* If a name matches more than one Ramp vendor, list all of them and do not pick one.
* If Ramp returns no vendors at all, state that the Ramp server returned nothing and stop rather than reporting every vendor as missing.
* Ignore case, punctuation and the words Inc, LLC and Ltd when judging whether two names are the same.

Who it's for

One answer, three teams that use it

Accounts payable

Prepare for a new project's invoices

See which project vendors still need setting up in Ramp before their first invoice arrives.

Which vendors on the Fabrikam Depot project are missing from Ramp?

Procurement coordinators

Catch near-duplicate names

Review the possible matches, such as a name with and without LLC, before a duplicate vendor is created.

Compare Contoso Warehouse project vendors with Ramp and show the possible matches I need to confirm.

Finance controllers

Audit vendor setup

Check recent roster changes against Ramp, using a date to see only what has been added.

Compare vendors added to Northwind Plaza since 1 May with Ramp vendors.

How it works

What PopdockAI does when you ask

You name the project. Your AI assistant reads the roster and Ramp and gives you the three lists, with every doubtful name left for you to confirm.

Ask

You name the project and, optionally, a date to include only recent changes.

Your AI tool

Read roster

It reads the project's active vendors from Procore and says how many inactive ones it left out.

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

Look up

It finds each vendor in Ramp by exact name, then by abbreviated name as a possible match only.

No items found.

Report

It lists each vendor with match type and spend, then those missing, inactive or needing a person to confirm.

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

Project vendors ready in Ramp before the first bill

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