Connectors

/

Nutshell

/

Show open Nutshell leads for Mailchimp campaign openers
Report
Cross-Connector

See which campaign openers already have open Nutshell leads

For sales reps who want to follow up warm interest, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
Show open Nutshell leads for Mailchimp campaign openers
Which repeat openers of the October Product News campaign have open leads in Nutshell?
18 repeat openers. 5 have open Nutshell leads. - Dana Whitfield, Northwind Traders: Renewal 2027, 14,000 USD, owner Sam Patel - Luis Ortega, Contoso Ltd: Expansion, 8,200 USD, owner Priya Raman - Mei Tan, Fabrikam: Pilot, 3,500 USD, owner Sam Patel - 1 match is ambiguous and flagged Want to see the remaining 2?
Nutshell
Sample figures. Your results come from your own account.
mailchimp-get-campaign
mailchimp-get-campaign-open
nutshell-get-contact
nutshell-get-lead

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

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

Warm campaign interest goes unfollowed

A Mailchimp campaign shows who opened it, but not whether those people have live deals. Reps do not know which openers are already in the pipeline, so warm interest goes unfollowed.

Without PopdockAI

  • Export repeat openers from Mailchimp
  • Look up each one in Nutshell
  • Check whether they have open leads
  • Pass the list to reps days later

With PopdockAI

  • Repeat openers of the campaign are found
  • Each is matched to Nutshell by email, or by name and company
  • Open leads and their owners are shown
  • Ambiguous matches are flagged, 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:** For Mailchimp campaign `{campaign-id}`, list the people who opened it at least `{min-opens}` times (default 2) and show their open leads in Nutshell.

**Step 1: Get the campaign and its openers**

Call `mailchimp-get-campaign` (Mailchimp server) with `campaign-id` to confirm the campaign and note its title, subject and send-date. Then call `mailchimp-get-campaign-open` with `campaign-id` and `opens.min` set to `{min-opens}`. Keep email, first-name, last-name, company and opens. If nobody qualifies, say so and stop.

**Step 2: Match openers to Nutshell**

For each opener call `nutshell-get-contact` (Nutshell server) with `name.contains` set to the last name, and accept only a contact whose `emails` include the opener's email (case-insensitive), or whose full name and company both match. For each matched contact call `nutshell-get-lead` with `person-id` set to the contact id and the open status, to get open leads (number, name, value, due-time, owner).

**Step 3: Report**

A table of matched openers with their opens, leads, lead value and owner, sorted by lead value descending, then a short list of openers with no Nutshell record. Suggest follow-up for the top few, naming the lead owner.

**Rules & Guidelines:**

* `mailchimp-get-campaign` and `mailchimp-get-campaign-open` are on the Mailchimp server; `nutshell-get-contact` and `nutshell-get-lead` are on the Nutshell server.
* Read-only. Do not call `nutshell-add-activity`, `mailchimp-replicate-campaign` or any write tool.

**Validation:**

* If the campaign id matches nothing, stop and say so.
* Flag ambiguous matches instead of guessing.

Who it's for

One answer, three teams that use it

Account executives

Call openers who already have deals

See which repeat openers are on your open deals, so you follow up while they are engaged.

Which repeat openers of the November Pricing Update campaign have open Nutshell leads?

Email marketers

Hand warm openers to sales

A list of openers with live deals and owners is ready to pass to the right reps.

Who opened the Q4 Webinar Invite campaign more than once and has an open lead in Nutshell?

Sales managers

Spot buying signals in your pipeline

Repeat opens on deal contacts are a signal worth raising in pipeline reviews.

Show open Nutshell leads and owners for repeat openers of the Spring Launch campaign.

How it works

What PopdockAI does when you ask

You name a Mailchimp campaign, and your AI assistant finds repeat openers with open Nutshell leads. It only reads.

01

Ask

You name the Mailchimp campaign.

Your AI tool

02

Gather

It finds the repeat openers and stops if the campaign is not found.

mailchimp-get-campaign
mailchimp-get-campaign-open

03

Match

It matches each to Nutshell by email, or by name and company together.

nutshell-get-contact
nutshell-get-lead

04

Report

It shows their open leads and owners and flags ambiguous matches.

Your AI tool

What PopdockAI provides

The tools behind the answer

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

get-data

mailchimp-get-campaign

Returns Mailchimp email campaigns with their status, audience, send date and headline results. Filter by status or send date to find drafts, scheduled sends or recent campaigns.
get-data

mailchimp-get-campaign-open

Returns the members who opened each Mailchimp campaign and how many times they opened it.
get-data

nutshell-get-contact

Returns Nutshell people (contacts) with their emails, phones and linked companies. Filter by name, email, owner and other fields.
get-data

nutshell-get-lead

Returns Nutshell leads (deals) with status, value, confidence, close date, owner and source. Filter by status, owner and dates.
Read only.Nothing in Nutshell 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

Follow up while the interest is fresh

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