Connectors

/

OnePageCRM

/

Review the OnePageCRM deal pipeline
Report

Review your OnePageCRM deal pipeline in one answer

For sales managers who want stalled and incomplete deals flagged, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
Review the OnePageCRM deal pipeline
Review the open deals in OnePageCRM for Sam Patel and tell me which need attention first.
Sam has 14 open deals worth 205,000, with 3 overdue and 2 missing an amount. - Overdue: Pallet racking, Northwind Traders, 12,000, close date 3 weeks ago - Largest: Network upgrade, Contoso, 22,000, Negotiation - Incomplete: Support renewal, Fabrikam, no amount Want the full table grouped by stage?
OnePageCRM
Sample figures. Your results come from your own account.
onepagecrm-get-deal

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

OnePageCRM

OnePageCRM
Run it on your own OnePageCRM data.

Connect OnePageCRM, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

Stalled and half-filled deals slip through

Managers scan the OnePageCRM deal list by hand to spot stalled deals. Overdue and half-filled deals, with no amount or close date, slip through, and nobody agrees which to act on first.

Without PopdockAI

  • Scan the deal list by stage
  • Spot deals past their close date
  • Find deals with no amount or date
  • Argue over which to act on

With PopdockAI

  • Open deals are read for the stage or owner you name
  • Overdue and incomplete deals are flagged
  • Largest and low margin deals are noted
  • Top five to act on, with no amounts or dates invented

The prompt

Use this prompt

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

Prompt
**Objective:** Review the open deals in OnePageCRM, optionally limited to stage `{stage}` or owner `{owner-id}`, and recommend which deals need attention first.

**Step 1: Pull the deals**

Call `onepagecrm-get-deal` with `stage` and `owner-id` when supplied (leave them out when empty), and `status` set to the open value you see in the data. If you are unsure which status value means open, call it once without a status filter, read the distinct values, and pick the open one. Set `max-records` to 200.

**Step 2: Judge each deal**

* Flag a deal as overdue when `expected-close-date` is in the past and it is still open.
* Flag a deal as stale when it has no `expected-close-date` or `amount`.
* Note the largest `amount` deals and any with low `margin`.

**Step 3: Report**

Give a table grouped by `stage` with deal name, company-name, contact-name, amount, expected-close-date and a one-line flag. End with the top 5 deals to act on and why, and the total open amount per stage.

**Rules & Guidelines:**

* This prompt is read-only. Never call `onepagecrm-add-deal`, `onepagecrm-update-deal`, `onepagecrm-delete-deal` or any other write tool.
* Do not invent amounts or dates; leave blank values blank.

**Validation:**

* If no deals come back, say so and state the filters used.
* If `{stage}` matches nothing, show the stages that do exist.

Who it's for

One answer, three teams that use it

Sales managers

Run a sharper pipeline review

The top five deals to act on, with the reason, focus the meeting on what matters.

Review open OnePageCRM deals and tell me the top five to act on this week.

Sales reps

Tidy your own pipeline

Deals missing an amount or close date are listed, so you can complete them.

Which of my OnePageCRM deals are overdue or missing an amount?

Sales leaders

See open value by stage

Open amount per stage shows how the pipeline is spread.

Show the open amount per stage in OnePageCRM for Priya Shah's deals.

How it works

What PopdockAI does when you ask

You name a stage or owner, or ask for all, and your AI assistant reviews the open OnePageCRM pipeline. It only reads.

01

Ask

You name a stage or owner, or ask for every open deal.

Your AI tool

02

Read

It reads the open deals from OnePageCRM.

onepagecrm-get-deal

03

Judge

It flags overdue deals and those missing an amount or close date.

No items found.

04

Report

You get a table by stage, the top five to act on and totals per stage.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for OnePageCRM and one secure connection to your AI tool. No code, no exports.

get-data

onepagecrm-get-deal

Returns deals from OnePageCRM, with their stage, status, amount, expected close date, owner and linked contact or company. Filter by stage, status or date.
Read only.Nothing in OnePageCRM 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

Know which deals to act on first

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

All Ramp use cases

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