/
/
See where the value sits in your HubSpot pipeline
For sales leaders running pipeline reviews who want stage totals, closing deals and overdue dates in one view, by asking their AI assistant.
On this page
Connector
Connect HubSpot, pick your AI tool and paste the prompt.
The problem
Pipeline totals never add up the same way twice
Pipeline reviews depend on knowing where the value sits, what closes soon and which close dates have passed. In HubSpot that means switching between board views, filters and exports, and the totals rarely match.
Without PopdockAI
- Switch between board views and filters
- Export deals to total each stage
- Work out weighted value by hand
- Find overdue close dates one by one
With PopdockAI
- The pipeline's stages are read in order with every deal
- Value and weighted value are totalled per stage
- Deals closing soon, overdue or with no amount are listed
- Observations are added, and no deal 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:** Review the deal pipeline `{pipeline-name}` (default: every pipeline) and show where the value sits, what is closing in the next `{closing-within-days}` days (default 30), and what is overdue.
**Step 1: Pipeline and stages**
Call `hubspot-get-deal-pipelines` (filter `label` = `{pipeline-name}` when given; if nothing matches, try `label.contains`). Then call `hubspot-get-deal-pipeline-stages` with each `pipeline-id` to get the stages in `display-order`. Treat stages labelled Closed won and Closed lost as closed.
**Step 2: Deals**
Call `hubspot-get-deals` with `pipeline-name` = the pipeline's label. Use a high `max-records` so the totals are complete.
**Step 3: Analyse**
* Per stage: count, total `amount`, total `weighted-amount`.
* Closing soon: open deals with `close-date` between today and today + the window.
* Overdue: open deals with `close-date` before today.
* No amount: open deals with an empty or zero amount.
**Step 4: Report**
* Stage table in display order: stage, deals, amount, weighted amount.
* Closing soon table: deal, stage, amount, close date, owner.
* Overdue table: deal, stage, amount, close date, days overdue, owner.
* No-amount list.
* Two or three observations (for example, value stuck in an early stage, or one owner holding most overdue deals).
**Rules & Guidelines:**
* This prompt is read-only. Do NOT call any write tool: `hubspot-add-contact`, `hubspot-add-company`, `hubspot-add-deal`, `hubspot-add-ticket`, `hubspot-update-contact`, `hubspot-update-company`, `hubspot-update-deal`, `hubspot-update-ticket`, `hubspot-add-contact-note`, `hubspot-add-company-note`, `hubspot-add-deal-note`, `hubspot-add-ticket-note`.
* Do not move deals or change close dates; recommend only.
**Validation:**
* If the pipeline name matches nothing, list the pipelines that exist and stop.
* If the deal list hits `max-records`, say the totals may be understated.Who it's for
One answer, three teams that use it
Sales leaders
Run the weekly pipeline meeting
Start the meeting with value per stage, what closes soon and what is overdue, already worked out.
Review our Enterprise pipeline in HubSpot. What closes in the next 45 days and what is overdue?
Sales managers
See where value is stuck
Spot value piling up in early stages or one owner holding most of the overdue deals.
Where is value stuck in the New business pipeline, and who owns the overdue deals?
Revenue operations
Find deals that need updating
Open deals with no amount or a past close date are listed, ready for owners to fix.
Which deals in the Renewals pipeline have no amount or a close date in the past?
How it works
What PopdockAI does when you ask
You pick a pipeline and a closing window, and your AI assistant reads every deal in it. You get a ready-made review, and no deal or date is changed.
01
Ask
You pick a pipeline and a closing window.
02
Read
It reads the pipeline's stages in order and every deal in it.
03
Analyse
It totals each stage and finds deals closing soon, overdue or with no amount.
04
Report
You get the review with observations, and no deal is changed.
What PopdockAI provides
The tools behind the answer
Ready made tools for HubSpot and one secure connection to your AI tool. No code, no exports.
hubspot-get-deal-pipelines
hubspot-get-deal-pipeline-stages
hubspot-get-deals
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
A pipeline review ready before the meeting
Related use cases
More ways to put this data to work
Create a HubSpot deal for a company
Ask your AI to create a HubSpot deal and it matches the company, checks for a similar open deal, resolves the pipeline and first stage, and saves after you confirm.
Learn More
Log a HubSpot meeting follow-up
Ask your AI to log a HubSpot meeting follow-up and it notes the outcome on the deal, contact and company and moves the deal stage after you confirm.
Learn More
Move a HubSpot deal to a new stage
Ask your AI to move a HubSpot deal and it matches the stage in the deal's own pipeline, warns about odd moves, and updates it with a note after you confirm.
Learn More
HubSpot closed won deals without a Stripe subscription
Ask your AI to check recent HubSpot wins against Stripe and it lists deals with no customer, no live subscription or billing more than 10 percent off the deal.
Learn More
Add a new HubSpot contact
Ask your AI to add a contact to HubSpot and it checks the email for duplicates, matches the company by name and domain, and saves only after you confirm.
Learn More
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.