Connectors

/

Drip

/

Find Drip campaign subscribers with open HubSpot deals
Report
Cross-Connector

Stop marketing and sales working the same prospect

For marketers who want to know which Drip campaign subscribers belong to companies with open HubSpot deals, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Find Drip campaign subscribers with open HubSpot deals
Which subscribers in our Drip Enterprise Nurture series work at companies with open HubSpot deals?
12 Enterprise Nurture subscribers belong to companies with open HubSpot deals. - Largest: Northwind Traders, 85,000, Contract Sent, owner Sam Patel - Closing soon: 3 deals close before 2026-10-31 - Not in HubSpot: 41 subscribers - No company: 9 contacts Want the full overlap table?
Drip
Sample figures. Your results come from your own account.
drip-get-campaign-subscriber
hubspot-get-contacts
hubspot-get-deals
drip-get-campaign

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

Marketing nurtures prospects that sales is already closing

A Drip series can reach companies sales is already negotiating with in HubSpot. Finding the overlap means looking up each subscriber's company and its deals, so it rarely happens and prospects get mixed messages.

Without PopdockAI

  • Export campaign subscribers from Drip
  • Find each contact's company in HubSpot
  • Check that company's deals
  • Prospects get mixed messages meanwhile

With PopdockAI

  • Campaign subscribers are matched to HubSpot contacts and companies
  • Each company's deals are checked once
  • Overlaps are listed with stage, amount and owner
  • Read-only, nobody is removed and no deal is touched

The prompt

Use this prompt

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

Prompt
**Objective:** For the Drip email series campaign named like `{campaign-name}`, find which subscribers already belong to a HubSpot company with a deal in progress, so sales and marketing are not working the same person in two ways. Check up to `{max-records}` (default 50) campaign subscribers.

**Step 1: Campaign subscribers in Drip**

Call `drip-get-campaign-subscriber` with `campaign-name.contains` set to `{campaign-name}` and `max-records` set to `{max-records}` (50 if blank). If the subscribers come from more than one campaign-name, list the campaign names and stop so the user can pick one.

**Step 2: Find their companies in HubSpot**

For each subscriber, take `email` and call `hubspot-get-contacts` with `email` set to it. Keep the company-id and company-name. Skip people with no HubSpot contact or no company-id, but count them.

**Step 3: Find deals for those companies**

For each distinct company-id, call `hubspot-get-deals` with `company-id` set to it. A deal is open when its deal-stage-name is anything other than closed won or closed lost.

**Step 4: Report**

A table of subscribers whose company has an open deal: email, name, campaign-status in Drip, company, deal name, deal stage, amount, close date, deal owner. Then the counts: subscribers checked, not in HubSpot, no company, company with open deal.

**Rules & Guidelines:**

* `drip-get-campaign-subscriber` is on the drip server; `hubspot-get-contacts` and `hubspot-get-deals` are on the hubspot server.
* This prompt is read-only. Do NOT call `drip-remove-subscriber-from-campaign`, `drip-pause-campaign`, `hubspot-update-deal` or `hubspot-add-deal-note`. Suggest actions in the report; do not take them.

**Validation:**

* If no campaign matches `{campaign-name}`, call `drip-get-campaign` with `name.contains` set to it, list the closest names, and stop.
* Call `hubspot-get-deals` once per company, not once per person.

Who it's for

One answer, three teams that use it

Marketing managers

Avoid nurturing active deals

See which subscribers work at companies with deals in progress before the next send.

Which people in our Drip Product Tour series are at companies with open HubSpot deals?

Account executives

Know what marketing is sending your accounts

Find out which of your deal companies are in a Drip series, with stage and close date.

Are any contacts at my open HubSpot deal companies in the Drip Upgrade Offer campaign?

Revenue operations

Coordinate campaigns with the pipeline

Get counts of matched, unmatched and company-less subscribers to keep both teams aligned.

Show overlap between the Drip Free Trial Nurture series and open HubSpot deals, with counts of unmatched people.

How it works

What PopdockAI does when you ask

You name a Drip email series and your AI assistant finds subscribers whose company has an open HubSpot deal. It suggests next steps but changes nothing.

01

Ask

You name a Drip email series.

Your AI tool

02

Read

It reads the campaign subscribers and finds each HubSpot contact and company.

drip-get-campaign
drip-get-campaign-subscriber
hubspot-get-contacts

03

Check

It checks each company's deals once, treating any not closed as open.

hubspot-get-deals

04

Report

You get subscribers with deals in progress, plus counts of those unmatched.

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-campaign-subscriber

Returns the people subscribed to each Drip email series campaign, with the campaign's status and the person's tags and lead score. Filter by campaign id or name, a person's email, subscriber status or minimum lead score.
get-data

hubspot-get-contacts

Returns contact records from HubSpot CRM, with email, phone, company, lifecycle stage, lead status, owner and location from the HubSpot connector. Filter by company id, state region, contact owner, email, last name, create date, company name, record id, lifecycle stage, lead status.
get-data

hubspot-get-deals

Returns deals from HubSpot CRM, with amount, stage, pipeline, close date, owner and associated company and contact from the HubSpot connector. Filter by pipeline name, close date, deal stage name, deal type, record id, company id, deal name, amount, deal owner.
get-data

drip-get-campaign

Returns Drip email series campaigns with status, active and unsubscribed counts, number of emails, sender and opt-in settings. Filter by name, status, minimum active subscribers or created 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

Marketing and sales stop pulling in two directions

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