/
/
Find Procore leavers who are still active in Ramp
For IT and integration teams who want Procore users compared with Ramp users by email, by asking their AI assistant.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
The problem
Leavers stay active in Ramp
Admins export user lists from Procore and Ramp and match emails in a spreadsheet. Leavers stay active in Ramp, and a different spelling of an email makes a person look missing.
Without PopdockAI
- Export active and inactive users from Procore
- Export users from Ramp
- Match email addresses in a spreadsheet
- Chase the leavers who are still active
With PopdockAI
- Active and inactive Procore users are read with their emails
- Both lists are matched on lower-cased email only
- Three tables show who is missing, who is still active and name differences
- Duplicates and unmatchable users are listed, 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.
**Objective:** Compare Procore company users with Ramp users, matched on email address, and report who is missing from Ramp and who is still active in Ramp after being made inactive in Procore. Limit the Procore side to users whose company is `{company-name}` when it is given (default: all).
**Step 1: Read Procore users**
Call `procore-get-users` for active users, adding `company.contains` set to `{company-name}` when given. Keep `user-id`, `name`, `email-address`, `job-title`, `company` and `active`. Then call `procore-get-users-inactive` and keep `id`, `name` and `vendor-name`. For each inactive user, call `procore-get-users` with `user-id` set to that id to get the `email-address`. If a call returns no email, list the user as unmatchable.
**Step 2: Read Ramp users**
Call `ramp-get-user` once and keep `id`, `first-name`, `last-name`, `email`, `role`, `status` and `employee-id`. Match to Procore on lower-cased email.
**Step 3: Report**
Three tables. Active in Procore, not in Ramp (name, email, job title). Inactive in Procore, active in Ramp (name, email, Ramp role, Ramp status). Matched but names differ (both names). End with counts and the number of users that could not be matched for lack of an email.
**Rules & Guidelines:**
* `procore-get-users` and `procore-get-users-inactive` are on the Procore core server. `ramp-get-user` is on the Ramp server.
* Read-only. Do not call `ramp-user-add`, `ramp-user-update`, `ramp-user-deactivate`, `ramp-user-reactivate` or any Procore create, update or delete tool.
* Do not treat a name match without an email match as a match.
**Validation:**
* If two users share an email in either system, list both and do not pick one.
* If either side returns no users, say which one and stop.
* Ramp status values are used as returned; do not assume what an unfamiliar status means, report it.Who it's for
One answer, three teams that use it
IT administrators
Run the leaver check
See who is inactive in Procore and still active in Ramp, with their Ramp role and status.
Which Procore inactive users are still active in Ramp?
Finance systems owners
Find people missing from Ramp
List active Procore users who have no Ramp account so access can be arranged.
Show Contoso Construction Procore users who are not in Ramp.
Security and compliance
Check joiner and leaver controls
Get counts and tables matched on email only, with the unmatchable users shown separately.
Compare Procore and Ramp users and show the number with no email.
How it works
What PopdockAI does when you ask
You ask for the comparison, optionally for one company. Your AI assistant reads both systems and reports what to look at.
Ask
You ask for the comparison and, optionally, name a company.
Read Procore
It reads active users and inactive users with their email addresses.
Match
It reads the Ramp users and matches both lists on lower-cased email only.
Report
It gives three tables of missing, leavers still active and name differences, with counts and unmatchable users.
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-users
procore-get-users-inactive
ramp-get-user
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
Leavers and gaps found without a spreadsheet
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)
