/
/
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.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
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.
**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.
Read
It reads the company's offices from Procore and the locations from Ramp.
Match
It matches names, treating city-only names and different spellings as probable.
Report
You get exact, probable and unmatched lists on each side, with counts.
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-offices
ramp-get-location
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
Offices and locations lined up in one read
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)
