Connectors

/

Procore

/

Compare a Procore project roster with NetSuite project time
Report
Cross-Connector

Check who books time against who is on the Procore roster

For operations teams who want a Procore project roster compared with the people who booked NetSuite time by asking their AI assistant.

Try PopdockAI free
Get a live demo
Compare a Procore project roster with NetSuite project time
Compare the people on the Riverside Tower roster in Procore with who booked time to it in NetSuite since 1 October.
Of 31 people with NetSuite time on Riverside Tower, 27 are on the Procore roster and 4 are not. - Time but not on roster: Dana Whitfield, 62.5 hours - Time but not on roster: Sam Patel, 40 hours - On roster with no time: 18 people, mostly subcontractor staff, informational only - Matched: 27 people Shall I show the full list of people not on the roster?
Procore
Sample figures. Your results come from your own account.
procore-get-projects
procore-get-project-people
netsuite-get-projecttime

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 roster and the timesheets rarely agree

People book time to a NetSuite project without being on the Procore roster, and the roster lists people who never book time. Nobody compares the two, so the real team on a project is unclear.

Without PopdockAI

  • Export the people roster from Procore
  • Export the time booked to the project in NetSuite
  • Match first and last names by hand
  • Total each person's hours to see who is missing

With PopdockAI

  • The roster and the time are read for the one project you name
  • People are matched on first and last name, ignoring case
  • Roster only people are labelled informational
  • An ambiguous project name stops the job

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 the Procore project `{project-name}`, compare who is on its people roster with who booked time to the matching NetSuite project since `{date-from}`.

**Step 1: Establish the Procore project**

Call `procore-get-projects` (procore-core server) with `project-name` set to `{project-name}`. If more than one project matches, list them and stop. Keep `project-name` exactly as returned.

**Step 2: Read the Procore roster**

Call `procore-get-project-people` (procore-core server) with `project-name` set to that exact name. Keep `name`, `vendor-name` and `work-classification-name`.

**Step 3: Read the NetSuite time**

Call `netsuite-get-projecttime` (netsuite server) with `project-name.contains` set to the Procore project name and `date.from` set to `{date-from}`. Keep `employee-first-name`, `employee-last-name`, `duration` and `date`. Total `duration` per person.

**Step 4: Report**

List (a) people with NetSuite time but not on the Procore roster, with their total duration, (b) Procore roster people with no NetSuite time, (c) names that matched. Match on first plus last name, ignoring case.

**Rules & Guidelines:**

* `procore-get-projects` and `procore-get-project-people` are on procore-core. `netsuite-get-projecttime` is on netsuite.
* Read only. Do not call any NetSuite add or update tool or any Procore create, update or delete tool.
* Procore rosters include subcontractor staff who never book NetSuite time; label list (b) as informational.

**Validation:**

* If `{date-from}` is empty, use the first day of the current month.
* If NetSuite returns no time entries, say the project name may not match and show the name you searched for.

Who it's for

One answer, three teams that use it

Project administrators

Keep the roster accurate

Find people booking time to a project who are missing from the Procore roster, so access and records are fixed.

Who booked time to Fabrikam Depot in NetSuite this month but is not on the Procore roster?

Operations managers

Check who is really working the job

Compare the roster with the time booked, so the team you plan around is the team that is working.

Compare the Northwind Plaza roster in Procore with NetSuite time since 1 September.

Project accountants

Question time from unknown people

Spot time booked by people who are not on the project team, before it reaches a bill.

Show NetSuite time on Contoso Warehouse from people who are not on the Procore project roster.

How it works

What PopdockAI does when you ask

You name the project in plain words. Your AI assistant compares the roster with the time booked and reports the gaps, without changing either system.

Ask

You name the Procore project and optionally a start date.

Your AI tool

Read

It finds the one matching project, reads its people roster and the time booked in NetSuite.

procore-get-projects
procore-get-project-people
netsuite-get-projecttime

Match

It matches people on first and last name, ignoring case, and totals each person's time.

No items found.

Report

You get people with time but not on the roster, roster people with no time, and the matches.

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

Returns the projects in Procore, with project number, name, stage, active flag and dates. Filter by name, number or status.
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

netsuite-get-projecttime

Returns NetSuite project time read from the NetSuite connector, with the fields people use most. Read-only.
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

The real team on a project, made visible

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