Connectors

/

Procore

/

Match Procore bidders to Ramp vendors
Report
Cross-Connector

Check every bidder on a project is set up in Ramp

For finance teams who want each Procore bidder matched to a Ramp vendor before award, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Match Procore bidders to Ramp vendors
Which bidders on the Riverside Tower project are already vendors in Ramp?
9 bidders on Riverside Tower were checked and 3 are not ready in Ramp. - Matched: 5 vendors, including Fabrikam Steel and Contoso Glazing - Inactive in Ramp: 1, Northwind Paving - Several matches: 1, Riverside Concrete has two Ramp vendors - Missing from Ramp: 2, Contoso Roofing and Fabrikam Electric Want the missing vendors listed again with their bid details?
Procore
Sample figures. Your results come from your own account.
procore-get-bids
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

Bidder names are searched in Ramp one by one

Before an award, someone copies bidder names from the bid list and searches Ramp for each. A name spelled differently looks like a missing vendor, and the same vendor ends up set up twice.

Without PopdockAI

  • Copy the bidding vendors from the Procore bid list
  • Search Ramp for each name in turn
  • Try other spellings when nothing comes back
  • List the genuinely missing vendors by hand

With PopdockAI

  • The distinct bidding vendors are read from the project's bids
  • Each is searched in Ramp by name, then by legal name
  • Case, punctuation and suffixes like LLC or Inc are ignored
  • Every candidate is listed when several match, 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 bids on the Procore project `{project-name}`, check that each bidding vendor exists as a vendor in Ramp. Company: `{company}` (default: the only company on the connection).

**Step 1: Read the bids (procore-preconstruction server)**

Call `procore-get-bids` with `project-name.contains` set to `{project-name}` and `company` set. Keep `vendor-name` and `project-name`. If more than one project name comes back, list them and stop. If no bids come back, say so and stop.

**Step 2: Look each vendor up (ramp server)**

For each distinct `vendor-name`, call `ramp-get-vendor` with `name.contains` set to it. Keep `name`, `active`, `vendor-type` and `total-spend-all-time`. Try `legal-name.contains` if `name.contains` finds nothing.

**Step 3: Report**

One table: vendor name from Procore, Ramp vendor name, `active`, and a verdict of Matched, Several matches, Inactive in Ramp or Missing from Ramp. List the missing vendors again below the table.

**Rules & Guidelines:**

* `procore-get-bids` is on the procore-preconstruction 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 create, update or delete tool on either server.

**Validation:**

* Ignore case, punctuation and suffixes such as LLC or Inc when matching names. List every candidate when more than one vendor matches, and do not pick one.
* If `ramp-get-vendor` returns nothing for every vendor, say the Ramp connection may be empty or unreachable.

Who it's for

One answer, three teams that use it

Accounts payable

Get vendors ready before award

See which bidders still need setting up in Ramp, so the winner can be paid without delay.

Which bidders on Fabrikam Depot are missing from Ramp?

Preconstruction managers

Check the field before you award

Know whether any bidders are inactive in Ramp before one is chosen.

Check the Contoso Warehouse bidders against Ramp vendors and show any inactive ones.

Procurement leads

Avoid duplicate vendors

Several matches are listed rather than guessed, so you decide before a new vendor is created.

Match the Northwind Plaza bidders to Ramp vendors and list every candidate where a name matches twice.

How it works

What PopdockAI does when you ask

You name the project. Your AI assistant reads the bids and Ramp and gives you one table of verdicts.

Ask

You name the project and, if needed, the company.

Your AI tool

Read bids

It reads the bids on the project and lists each distinct bidding vendor.

procore-get-bids
ramp-get-vendor

Look up

It searches Ramp for each vendor by name and by legal name, ignoring case and suffixes.

No items found.

Report

It gives one table with a verdict of Matched, Several matches, Inactive in Ramp or Missing from Ramp.

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

Returns Procore Preconstruction bids within a project, with the bidding vendor and lump sum amount. Filter by project name.
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

Bidders sorted into ready, inactive and missing before award

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