Connectors

/

Procore

/

Summarize Procore open items by project
Report

See where overdue work is concentrated across Procore projects

For leaders who want open and overdue item counts ranked across their Procore projects by asking their AI assistant.

Try PopdockAI free
Get a live demo
Summarize Procore open items by project
Summarise open items across all our projects and show me where the overdue work is.
Riverside Tower leads with 38 overdue open items, and 2 projects have had no activity in 30 days. - Riverside Tower: 38 overdue, 112 open, 21 upcoming - Fabrikam Depot: 27 overdue, 74 open - Contoso Warehouse: 9 overdue, 40 open - No activity in 30 days: Northwind Plaza, Harbor Annex Want your own items compared to the total for each project?
Procore
Sample figures. Your results come from your own account.
procore-get-open-items-mine
procore-get-open-items-all

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

Asking each project manager is slow and uneven

To see where overdue work sits you ask every project manager for a count. The replies come at different times in different shapes, so you cannot rank projects fairly.

Without PopdockAI

  • Message each project manager for their overdue count
  • Wait for replies in different formats
  • Paste the numbers into one sheet
  • Rank projects by hand and miss the quiet ones

With PopdockAI

  • Open item counts are read for every project you can see
  • Projects are ranked by overdue count on one basis
  • Projects with work but no recent activity are flagged
  • Counts follow your permissions, 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.

Prompt
**Objective:** Summarize open items across projects matching `{project-name}` (default: all) and show where overdue work is concentrated.

**Step 1: Pull the counts**

* `procore-get-open-items-mine` with `project-name.contains` set to `{project-name}` when given: the connected user's own items.
* `procore-get-open-items-all` with the same filter: all items the user can see.

**Step 2: Rank**

* Rank projects by `overdue-count` and show `open-count`, `upcoming-count` and `last-activity`.
* Flag projects with open items but no `last-activity` in 30 days.
* Compare the user's own items against the total for each project.

**Step 3: Report**

A ranked table of the ten worst projects, then a line on projects with no recent activity.

**Rules & Guidelines:**

* This prompt is read-only. Do not call any write tool: Every `procore-create-*`, `procore-update-*`, `procore-delete-*`, `procore-sync-*`, `procore-add-*`, `procore-bulk-*` and `procore-send-*` tool, plus `procore-respond-*`, `procore-terminate-*`, `procore-restart-*`, `procore-refresh-*`, `procore-reset-*`, `procore-link-*` and `procore-retrieve-*`, are off limits.
* Report only values the tools returned. Do not estimate or fill gaps.
* If `{company}` is not blank, pass it as `company` on every call.
* Counts reflect only what the connected user can see. Say so in the report.

**Validation:**

* If no rows return, say so and stop.

Who it's for

One answer, three teams that use it

Executives

See where to step in

Get the projects with the most overdue work ranked in one table, so the portfolio review starts with the right conversations.

Which of our projects have the most overdue open items right now?

Operations directors

Find projects gone quiet

Spot projects with open items but no activity in 30 days, before they become a surprise at the next review.

List projects with open items but no activity in the last 30 days.

Regional managers

Compare your own load to the total

See your own open items alongside everything visible to you for each project in your region.

Summarise open items for projects with Riverside in the name, and compare mine to the total.

How it works

What PopdockAI does when you ask

You say which projects to cover, or leave it open. Your AI assistant reads the counts and ranks them. It notes that figures reflect what your user can see.

Ask

You name a project, or leave it open to cover every project you can see.

Your AI tool

Pull

It reads your own open item counts and the counts for all items visible to you.

procore-get-open-items-mine
procore-get-open-items-all

Rank

It ranks projects by overdue count and flags open work with no activity in 30 days.

No items found.

Report

You get the ten worst projects and a line on projects with no recent activity.

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-open-items-mine

Returns my open items statistics records from the Procore connector. Read-only.
get-data

procore-get-open-items-all

Returns Procore open item statistics per project, including how many items are open and overdue.
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 ranked view of overdue work, without the chasing

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