Connectors

/

Procore

/

Reconcile Procore offices with Ramp locations
Report
Cross-Connector

Find Procore offices with no matching Ramp location

For operations and finance systems teams who ask their AI assistant to compare Procore offices with Ramp locations by name.

Try PopdockAI free
Get a live demo
Reconcile Procore offices with Ramp locations
Compare the offices in our Procore company with the locations in Ramp and tell me which are missing on each side.
Procore has 9 offices and Ramp has 8 locations, and 6 match exactly. - Probable match: Denver Office in Procore, Denver in Ramp - Probable match: St. Louis in Procore, Saint Louis in Ramp - Procore offices with no Ramp location: Phoenix, Tampa - Ramp locations with no Procore office: Remote Staff (entity 4471) Want the recommended changes for the unmatched ones?
Procore
Sample figures. Your results come from your own account.
procore-get-offices
ramp-get-location

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

New offices reach one system and not the other

Procore keeps the offices and Ramp keeps the locations, and nobody compares them until something breaks. Spellings like St. and Saint make a by-eye comparison slow and unreliable.

Without PopdockAI

  • Open the office list in Procore
  • Open the locations in Ramp
  • Compare names line by line, allowing for spelling
  • Find the gaps when a record cannot be coded

With PopdockAI

  • Both lists are read and matched on name
  • City-only and differently spelled names are marked probable
  • Each side's unmatched records are listed with counts
  • Changes are recommended but never made

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 Procore company `{company}`, compare the company's offices with the locations in Ramp and report which offices have no Ramp location and which Ramp locations have no Procore office. If `{office-filter}` is given, only look at offices whose name contains it.

**Step 1: Read the offices from Procore**

Call `procore-get-offices` (procore-company-admin server) with `company` set to `{company}`, and `name.contains` set to `{office-filter}` when it is not empty. Keep each office's `name`, `city`, `state-code` and `country-code`. If it returns nothing, say so and stop.

**Step 2: Read the locations from Ramp**

Call `ramp-get-location` (ramp server) with no filters. Keep `id`, `name` and `business-entity-id`. If `{office-filter}` is given, also pass it as `name.contains`. If it returns nothing, report every Procore office as unmatched and stop.

**Step 3: Match across the two systems**

Match an office to a location when the names are equal after ignoring case, punctuation and the words office, branch and HQ. Treat a location named after the office city (for example "Denver" for an office named "Denver Office") as a probable match and mark it probable, not exact. Do not guess beyond that.

**Step 4: Report**

Give three lists: exact matches, probable matches (show both names), and unmatched on each side. For each unmatched Ramp location show its `business-entity-id`. End with a one-line count of each list.

**Rules & Guidelines:**

* `procore-get-offices` is on the procore-company-admin server. `ramp-get-location` is on the ramp server.
* This prompt is read-only. Do not call any create, update or delete tool on either server, including `procore-create-office`, `procore-update-office`, `procore-delete-office`, `ramp-location-add` and `ramp-location-update`.
* Recommend adding or renaming records, but never do it.

**Validation:**

* If either system returns nothing, say which one and stop rather than reporting everything as a mismatch.
* If the two systems spell a place differently (St. vs Saint), show both spellings and mark the pair probable.

Who it's for

One answer, three teams that use it

Operations managers

Keep sites consistent across systems

See which offices exist in Procore but have no Ramp location, so spend can be coded to every site.

Which Procore offices have no Ramp location?

Finance systems owners

Clean up Ramp locations

Find Ramp locations with no Procore office and see each one's business entity, before deciding what to retire or rename.

List Ramp locations that have no matching Procore office and show their business entity.

Controllers

Check new branches are set up

After opening a branch, confirm both systems know about it, including probable matches that need a rename.

Compare the Fabrikam offices in Procore with Ramp locations and show the probable matches.

How it works

What PopdockAI does when you ask

You name the company and your AI assistant reads both lists. It reports what lines up and what does not, and it changes nothing in either system.

Ask

You name the Procore company and optionally part of an office name.

Your AI tool

Read

It reads the company's offices from Procore and the locations from Ramp.

procore-get-offices
ramp-get-location

Match

It matches names, treating city-only names and different spellings as probable.

No items found.

Report

You get exact, probable and unmatched lists on each side, with counts.

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

Returns the offices set up in Procore, with address, city, state, country and phone. Used to compare company offices with other systems.
get-data

ramp-get-location

Returns Ramp locations as read from the Ramp connector. Filters include: business entity id, name, name contains, 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

Offices and locations lined up in one read

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