Connectors

/

Drip

/

Find hot Drip leads with no Capsule CRM opportunity
Report
Cross-Connector

Find engaged Drip leads with no deal in Capsule CRM

For sales teams who want high-scoring Drip subscribers with no open Capsule CRM opportunity, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Find hot Drip leads with no Capsule CRM opportunity
Which Drip leads with a score over 60 have no open opportunity in Capsule CRM?
28 Drip leads score over 60, and 15 have no open deal. - No open deal: 9 people in Capsule CRM, led by Sam Patel at Fabrikam, score 90 - Not in Capsule CRM: 6 people - Covered: 13 already have an open opportunity - Duplicates: 1 email matches two Capsule CRM people Want both ranked tables?
Drip
Sample figures. Your results come from your own account.
drip-get-subscriber
capsule-crm-get-party
capsule-crm-get-opportunity

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Drip

Drip
Run it on your own Drip data.

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

Try PopdockAI free

The problem

Engaged subscribers never get a sales conversation

Engaged Drip subscribers often never reach a deal because nobody checks for one. Finding the gap means looking up each high scorer in Capsule CRM, then their opportunities and their organization's.

Without PopdockAI

  • Export high scorers from Drip
  • Search Capsule CRM for each email
  • Check the person's and organization's opportunities
  • Duplicates muddy the picture

With PopdockAI

  • Each high scorer is looked up by email only
  • Open opportunities are checked on person and organization
  • Two ranked tables show no deal and not in Capsule CRM
  • Duplicate emails are listed 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:** Find active Drip subscribers with a lead score of at least `{min-lead-score}` (default 50) who have no open sales opportunity in Capsule CRM, checking at most `{max-records}` subscribers (default 50).

**Step 1: List engaged subscribers in Drip**

Call `drip-get-subscriber` with `lead-score.min` set to `{min-lead-score}` (default 50), `status` set to active and `max-records` set to `{max-records}` (default 50). Keep `email`, `first-name`, `last-name`, `lead-score`, `lifetime-value` and `tags`.

**Step 2: Find each one in Capsule CRM**

For each subscriber, call `capsule-crm-get-party` with `email` set to the subscriber's email. Keep `party-id`, `name`, `organization-name` and `owner-name`.

**Step 3: Check for open opportunities**

For each person found, call `capsule-crm-get-opportunity` with `party-name.contains` set to the party's `name`, and if they have an `organization-name`, call it again with `party-name.contains` set to the organization name. An opportunity counts only if its `party-name` equals the person's or organization's name exactly and it has no `closed-on-date`.

**Step 4: Report**

Two tables, each sorted by lead score, highest first:

1. **In Capsule CRM, no open opportunity** - name, organization, email, lead score, lifetime value, Capsule owner.
2. **Not in Capsule CRM** - name, email, lead score, lifetime value, tags.

Leave out subscribers who already have an open opportunity, but give their count.

**Rules & Guidelines:**

* Tools whose names start with drip- are on the drip MCP server; tools whose names start with capsule-crm- are on the capsule-crm MCP server. If either set is missing, stop and say which server is not connected.
* Match people across the two systems by email address only, compared case-insensitively after trimming spaces. Never match on name alone.
* This prompt is read-only. To act on the result, use `engaged-leads-to-capsule-tasks` or `add-drip-subscribers-to-capsule`.
* Do NOT call these Drip tools: `drip-add-subscriber`, `drip-update-subscriber`, `drip-add-subscriber-tag`, `drip-remove-subscriber-tag`, `drip-add-subscriber-to-campaign`, `drip-remove-subscriber-from-campaign`, `drip-remove-subscriber-from-all-campaigns`, `drip-unsubscribe-subscriber`, `drip-start-subscriber-workflow`, `drip-remove-subscriber-from-workflow`, `drip-activate-campaign`, `drip-pause-campaign`, `drip-activate-workflow`, `drip-pause-workflow`.
* Do NOT call these Capsule CRM tools: `capsule-crm-add-party`, `capsule-crm-update-party`, `capsule-crm-add-note`, `capsule-crm-update-note`, `capsule-crm-add-task`, `capsule-crm-update-task`, `capsule-crm-add-opportunity`, `capsule-crm-update-opportunity`, `capsule-crm-add-case`, `capsule-crm-update-case`.

**Validation:**

* If Drip returns nobody at that score, say so and suggest a lower `{min-lead-score}`.
* If an email matches more than one Capsule CRM party, list it separately as a duplicate rather than guessing.

Who it's for

One answer, three teams that use it

Sales reps

Work leads with no open deal

Get engaged people already in Capsule CRM who have no deal in progress, ranked by score.

Which Capsule CRM contacts with a Drip score over 70 have no open opportunity?

Sales managers

See engaged leads outside the pipeline

Know how many hot leads have no deal and how many are not in the CRM at all.

How many hot Drip leads are not in Capsule CRM or have no open deal?

CRM administrators

Find duplicate records

Emails matching several Capsule CRM records are listed instead of guessed, ready for clean up.

Show any Drip leads whose email matches more than one Capsule CRM record.

How it works

What PopdockAI does when you ask

You set a lead score and your AI assistant finds engaged Drip leads with no open Capsule CRM deal. It reports only.

01

Ask

You set a minimum lead score, 50 by default.

Your AI tool

02

Find

It looks up each high-scoring subscriber in Capsule CRM by email.

drip-get-subscriber
capsule-crm-get-party

03

Check

It checks open opportunities on the person and their organization.

capsule-crm-get-opportunity

04

Report

You get two ranked tables, no open deal and not in Capsule CRM.

Your AI tool

What PopdockAI provides

The tools behind the answer

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

get-data

drip-get-subscriber

Returns Drip people (subscribers) with name, email, location, tags, status, GDPR consent, lead score and lifetime value. Filter by exact email, email domain, tag, status, country, minimum lead score, minimum lifetime value or date added.
get-data

capsule-crm-get-party

Returns people and organizations from Capsule CRM with email, phone, job title, organization, location, owner and last contacted date. Filter by name, email, type, organization, owner, city, state or country.
get-data

capsule-crm-get-opportunity

Returns Capsule CRM sales opportunities with milestone, value, currency, probability, expected close date, owner and lost reason. Filter by name, party, owner, milestone, value range, expected close date or closed date.
Read only.Nothing in Drip 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 call list of leads with no deal

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