Pipedrive Deal Stage Automation
Automatically review deals for stage progression criteria, update stages, and log notes explaining why deals were moved.
The Challenge
Deals sit in stages longer than they should because nobody has time to review every opportunity against your progression criteria. Reps forget to move deals forward, and managers spend hours in pipeline reviews asking "why is this still in Qualified?" This prompt automates the review process, advances qualifying deals, and documents every transition.
What This Prompt Does
Criteria Check
Reviews each deal against stage progression requirements
Auto-Advance
Moves qualifying deals to the next stage automatically
Transition Notes
Logs a note on every moved deal explaining the reason
Gap Flagging
Identifies deals that are close but missing one criterion
The Prompt
The Prompt
Task
Use @Pipedrive/List Pipelines and @Pipedrive/List StagesName it "Pipedrive/List Stages" and call it with @Pipedrive/List Stages to map your pipeline structure, then @Pipedrive/List Deals and @Pipedrive/Get DealName it "Pipedrive/Get Deal" and call it with @Pipedrive/Get Deal to review each open deal against stage progression criteria. For deals that qualify, use @Pipedrive/Update DealName it "Pipedrive/Update Deal" and call it with @Pipedrive/Update Deal to advance the stage and @Pipedrive/Create NoteName it "Pipedrive/Create Note" and call it with @Pipedrive/Create Note to document why the transition was made.
Example: Review all deals in the "Qualified" stage and advance any that have had 3+ activities and a note within the last 7 days to "Proposal Sent."
Input
The user will provide either:
- A pipeline to review (e.g., "Sales Pipeline")
- Specific progression criteria (e.g., "move deals with 3+ activities to next stage")
- A stage to audit (e.g., "check all deals in Negotiation")
Example: "Review deals in my Sales Pipeline and advance any that meet the criteria" or "Check which Qualified deals are ready for Proposal"
Context
Progression Criteria
Stage advancement signals:
- Number of activities logged (calls, meetings, emails)
- Recency of last activity or note
- Deal age in current stage vs. average
- Whether key fields are filled (contact person, value, expected close date)
- Notes containing specific keywords (e.g., "proposal sent", "contract reviewed")
What to check per deal:
- Total activities since entering current stage
- Days in current stage vs. pipeline average
- Last note content and date
- Whether required fields for the next stage are populated
- Deal value and expected close date status
Automation Strategy
- List all pipelines and their stages with ordering
- Pull all open deals and group by current stage
- For each deal, check progression criteria against stage requirements
- Identify deals that qualify for advancement
- Update deal stage for qualifying deals
- Create a note on each moved deal explaining the transition reason
Safety Rules
- Never skip stages (always advance to the immediately next stage)
- Only move deals forward, never backward
- Always log a note explaining the reason for the transition
- Flag deals that are close to qualifying but missing one criterion
- Present a preview of changes before executing updates
Output
Pipeline Review Summary:
| Pipeline | Deals Reviewed | Deals Advanced | Deals Flagged | |----------|---------------|----------------|---------------| | [Pipeline] | X | Y | Z |
Deals Advanced:
| Deal | From Stage | To Stage | Reason | |------|-----------|----------|--------| | [Deal 1] | Qualified | Proposal Sent | 4 activities, note from yesterday | | [Deal 2] | Proposal Sent | Negotiation | Contract sent, response received |
Deals Flagged (Almost Ready):
| Deal | Current Stage | Missing Criteria | Suggestion | |------|-------------|-----------------|------------| | [Deal 3] | Qualified | Only 2 activities (need 3) | Schedule one more call | | [Deal 4] | Qualified | No expected close date | Ask rep to add close date |
Notes Created: [count] transition notes logged to Pipedrive.
All stage updates have been applied and documented.
Example Usage
Try asking:
- →"Review all deals in my Sales Pipeline and advance any that meet stage criteria"
- →"Which Qualified deals have enough activities to move to Proposal Sent?"
- →"Run a stage progression audit on deals that have been in Negotiation for over 2 weeks"