Connectors

/

Procore

/

Compare Procore project team to scheduled staff
Report

Compare a Procore project team with the staffing schedule

For project managers and resource planners who want the project team matched to scheduled staff, asking their AI assistant for the gaps in both directions.

Try PopdockAI free
Get a live demo
Compare Procore project team to scheduled staff
Compare the Riverside Tower project team with who is scheduled on it from today.
Riverside Tower has 27 team members, and 6 do not match the schedule. - On the team and scheduled: 21 people, with start and end days - On the team but not scheduled: 3 people - Scheduled but not on the team: 3 people - No employee number: 5 people, labelled vendor staff Want the names in each list?
Procore
Sample figures. Your results come from your own account.
procore-get-project-people
procore-get-nested-workforce-planning-assignments-data-assig

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

The team list and the schedule tell different stories

A project manager checks the Procore team against the staffing schedule by eye. People are on the team but never scheduled, or scheduled but not on the team, and employee numbers do not always match.

Without PopdockAI

  • Open the project team in Procore
  • Open the staffing schedule for the project
  • Match people by employee number by hand
  • Work out who is vendor staff and has no number

With PopdockAI

  • The team and the scheduled staff are both read
  • People are matched by employee number, ignoring formats
  • Three lists show the gaps in both directions
  • People with no number are listed, not guessed

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 project `{project-name}`, compare the project team with the people scheduled on that project in Resource Management, looking at assignments from `{from-date}` (default: today).

**Step 1: Read the project team (Core server)**

Call `procore-get-project-people` filtered by `project-name`. Keep `name`, `employee-id`, `vendor-name` and `work-classification-name`. If more than one project name matches, list the matching project names and stop. If no one comes back, say so and stop.

**Step 2: Read the scheduled staff (Resource Management server)**

Call `procore-get-nested-workforce-planning-assignments-data-assig` with `date-updated.from` omitted and `end-day` handled in the report. Keep rows whose `project-name` or `project-number` matches the project, using `assignment-data-employee-number`, `start-day`, `end-day` and `assignment-status-name`. Drop assignments that ended before `{from-date}`.

**Step 3: Carry the join across**

Match a Procore person to an assignment where `employee-id` equals `assignment-data-employee-number` (ignore spaces and leading zeros). People with no `employee-id` cannot be matched; list them separately.

**Step 4: Report**

Three lists: on the team and scheduled (with start and end days), on the team but not scheduled, scheduled but not on the team. Add counts.

**Rules & Guidelines:**

* `procore-get-project-people` is on the Core server. `procore-get-nested-workforce-planning-assignments-data-assig` is on the Resource Management server.
* Read-only. Do not call `procore-create-project-person`, `procore-add-company-user-to-project`, `procore-create-resource-request` or any other create, update or delete tool.
* Employees who are vendor staff usually have no employee number; label them vendor staff rather than unscheduled.

**Validation:**

* If the Resource Management server returns no assignments for the project, report that the project has no schedule yet and show only the team list.
* If a number format differs between the servers, say which format you normalised.

Who it's for

One answer, three teams that use it

Project managers

Check your team is scheduled

See who is on the project team but not in the schedule, so nobody turns up without an assignment behind them.

Who is on the Fabrikam Depot team but not scheduled from next Monday?

Resource planners

Find scheduling that has no team record

Spot people scheduled on a project who were never added to its team, so they can be added before they need access.

Who is scheduled on Contoso Warehouse in Resource Management but missing from the Procore team?

Project administrators

Clean up access

Match the team to assignments to find people who may no longer belong, as part of a regular project check.

Compare the Northwind Plaza team with its schedule and list anyone who does not match.

How it works

What PopdockAI does when you ask

You name the project. Your AI assistant matches the team to the schedule by employee number and reports the gaps both ways, changing nothing.

Ask

You name the project and optionally the date to look from.

Your AI tool

Read

It reads the project team and the people scheduled on that project.

procore-get-project-people
procore-get-nested-workforce-planning-assignments-data-assig

Match

It matches by employee number and lists people without one separately.

No items found.

Report

You get scheduled, unscheduled and not on the team lists, 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-project-people

Returns the people on a Procore project roster with their company, role and contact details. Filter by project. Procore connector; read only.
get-data

procore-get-nested-workforce-planning-assignments-data-assig

Returns Procore Resource Management assignments: who is scheduled on which project, with employee number, start and end day and assignment status.
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

A team list and a schedule that agree

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