Connectors

/

Nutshell

/

Review Nutshell open pipeline
Report

Review your open Nutshell pipeline for deals at risk

For sales reps who want closing deals ranked by risk and value, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
Review Nutshell open pipeline
Review my open Nutshell pipeline for deals closing in the next 30 days.
7 open leads close in the next 30 days, worth 31,400 USD weighted. - Northwind Traders, Renewal 2027: 9,800 USD weighted, 1 overdue task - Contoso Ltd, Expansion: 5,740 USD weighted, on track - Fabrikam, Pilot: 1,750 USD weighted, past its close date - 4 more, no risks found Want the overdue tasks for the at-risk deals?
Nutshell
Sample figures. Your results come from your own account.
No items found.

On this page

The problem

The problem

The prompt

Who it's for

How it works

Connector

Nutshell

Nutshell
Run it on your own Nutshell data.

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

Try PopdockAI free

The problem

Deals slip past their close date unnoticed

Reps scan the CRM by hand for leads about to close. Ones past due, or with tasks nobody has done, are easy to miss, so deals slip without warning.

Without PopdockAI

  • Filter open leads by close date
  • Open each lead to check its tasks
  • Spot leads already past their close date
  • Weigh value and confidence in your head

With PopdockAI

  • Open leads closing in the window and their tasks are read
  • Past due leads and overdue tasks are flagged
  • Leads are ranked by weighted value
  • Status values are not guessed, and nothing changes

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 leads owned by {owner} (default: all owners) that are due or expected to close within the next {days-ahead} days (default 30) and recommend where to focus.

**Step 1: Pull the open leads**

Call 
utshell-get-lead with status set to the open value (call it once without a status filter with a small max-records if you are unsure what the status values are), anticipated-close-time.from set to today and anticipated-close-time.to set to today plus {days-ahead} days. If {owner} is given, filter with owner.contains. If it matches several users, call 
utshell-get-user filtered by 
ame.contains, list the matches and stop.

**Step 2: Find risk**

Also call 
utshell-get-lead for open leads whose due-time.to or anticipated-close-time.to is before today (past due). For each lead in either set call 
utshell-get-task with related-record-id set to the lead id and overdue true. Flag a lead when it is past due, has an overdue task, or has confidence under 30 with a large value.

**Step 3: Report**

A table of lead number, name, owner, value, confidence, anticipated close date and risk flag, sorted by value times confidence, highest first. End with the top three leads to act on and why, and the total weighted value.

**Rules & Guidelines:**

* Do not call any write tool: 
utshell-add-company, 
utshell-add-person, 
utshell-add-lead, 
utshell-add-activity, 
utshell-update-company, 
utshell-update-person, 
utshell-update-lead, 
utshell-delete-company, 
utshell-delete-person or 
utshell-delete-lead. This prompt only reads.
* Do not guess status values. Use what the data returns.

**Validation:**

* If no leads match, say so and show the filters used.
* If {days-ahead} is not a positive number, use 30.

Who it's for

One answer, three teams that use it

Account executives

Plan your week around closing deals

At risk deals ranked by weighted value tell you where to focus first.

Review my open Nutshell leads closing in the next 14 days.

Sales managers

Prepare for pipeline reviews

Past due leads and overdue tasks for each rep give you the questions to ask.

Review Sam Patel's Nutshell pipeline for deals closing this quarter.

Revenue operations

Clean up past due close dates

Leads past their close date are flagged, so forecasts are not built on stale dates.

Which of Dana Lee's open Nutshell leads are past their close date?

How it works

What PopdockAI does when you ask

You name an owner and a closing window, and your AI assistant reviews their Nutshell pipeline for risk. It only reads.

01

Ask

You name the owner and the closing window.

Your AI tool

02

Gather

It reads their open leads closing in that window and the tasks on them.

No items found.

03

Flag

It marks leads that are past due or have overdue tasks.

No items found.

04

Rank

It ranks the leads by weighted value.

Your AI tool

The outcome

Start the week knowing which deals are at risk

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