Connectors

/

Procore

/

Match Procore planning staff to Ramp users
Report
Cross-Connector

Keep your planning roster and Ramp users in step

For IT and finance systems teams who ask their AI assistant to compare Procore workforce planning people with Ramp users by employee number.

Try PopdockAI free
Get a live demo
Match Procore planning staff to Ramp users
Compare the active people in Procore workforce planning with Ramp users, up to 50 people, and tell me who has no Ramp account.
Of 50 active planning people, 41 have an active Ramp user and 9 need attention. - No Ramp user: 5 people, for example employee 20418, hired 3 March - Ramp user inactive or leaving: 4 people, one deactivating on 30 November - No employee number, cannot be matched: 2 people - Active and matched: 41 people, mostly the Employee role Want the full list for each group?
Procore
Sample figures. Your results come from your own account.
procore-get-workforce-planning-people
ramp-get-user

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

Planning rosters and Ramp accounts drift apart

Comparing the Resource Management roster with Ramp users by hand means matching names across two screens. People end up scheduled on jobs with no card or account, or keep one long after they have left.

Without PopdockAI

  • Export the planning roster and the Ramp user list
  • Match people by name across the two
  • Check each Ramp user's status and role one by one
  • Miss leavers who still have an active account

With PopdockAI

  • People are matched on employee number, not names
  • People with no number are listed apart, never guessed
  • Inactive and leaving users are separated from active ones
  • Nobody is added or deactivated

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** Compare the people in Procore workforce planning with status `{person-status}` (default Active) against Ramp users, matched on employee number, looking at up to `{max-people}` people (default 50).

**Step 1: Read the planning roster (Procore Resource Management server)**

Call `procore-get-workforce-planning-people` with `status` set to `{person-status}` (Active when empty) and `max-records` set to `{max-people}` (50 when empty). Keep each person's `employee-number`, `hired-date` and `status`. Drop any person with no employee number and list them separately as unmatchable.

**Step 2: Find each person in Ramp (Ramp server)**

For each employee number, call `ramp-get-user` with `employee-id` set to that number. Note the Ramp `id`, `status`, `role`, `email` and `scheduled-deactivation-date`.

**Step 3: Report**

Three lists: (a) planning people with no Ramp user, (b) planning people whose Ramp user is not active or has a scheduled deactivation date, (c) planning people whose Ramp user is active. For each row give the employee number, hired date, and the Ramp status and role.

**Rules & Guidelines:**

* Procore Resource Management tools (names starting procore-get) and Ramp tools (names starting ramp-get) live on two different MCP servers; both must be connected. If either set of tools is missing, say which server is not connected and stop.
* This is a read-only review. Never call any write tool on either server, including `ramp-user-add`, `ramp-user-deactivate`, `ramp-user-update`, `ramp-vendor-add`, `ramp-vendor-update`, `ramp-location-add`, or any Procore tool whose name starts procore-create, procore-update or procore-delete.
* If the Procore tools ask for a `company` and more than one is available, ask which company to use before reading.
* Report only data the tools return; never guess a match.

**Validation:**

* If a Procore call returns nothing, report that and stop.
* If a Ramp call returns nothing for a record, report it as present in Procore and absent from Ramp, and continue with the next record.
* If a name or number matches more than one Ramp record, list the candidates and do not pick one.

Who it's for

One answer, three teams that use it

IT administrators

Spot missing and stale accounts

See which planned people have no Ramp user and which leavers still have an active one, without exporting two lists.

List active Procore planning people who have no Ramp user, up to 100 people.

Finance systems owners

Check access before spend starts

Confirm the people being scheduled on jobs have working Ramp accounts, and see their role and status.

Check the first 30 active planning people against Ramp and show the role each one has.

HR operations

Close the loop on leavers

Find planning people whose Ramp user is inactive or has a scheduled deactivation date, so offboarding is complete.

Which planning people have a Ramp user that is inactive or being deactivated?

How it works

What PopdockAI does when you ask

You set the status and head count, and your AI assistant reads both systems. It matches on employee number only and leaves every account untouched.

Ask

You choose the person status and how many people to look at.

Your AI tool

Read

It reads the planning roster and sets aside people with no employee number.

procore-get-workforce-planning-people
ramp-get-user

Match

It looks each employee number up in Ramp and notes status, role and any scheduled deactivation.

No items found.

Report

You get three lists: no Ramp user, inactive or leaving, and active.

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-workforce-planning-people

Returns the Procore Resource Management people roster with employee number, status and hired date.
get-data

ramp-get-user

Returns Ramp users as read from the Ramp connector. Filters include: scheduled invitation date to, status, last name, maximum records, role.
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

Every planned person accounted for in Ramp

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