/
/
Find Mailchimp big spenders who are missing from Nutshell
For marketers who want top buyers in the CRM, just by asking their AI assistant to compare the two.
On this page
Connector
Connect Mailchimp, pick your AI tool and paste the prompt.
The problem
Valuable buyers with no owner in the CRM
Customers who spend heavily in a Mailchimp connected store do not always exist in Nutshell. Nobody notices without exporting both lists and comparing them, so valuable buyers never get an owner.
Without PopdockAI
- Export store customers above a spend level
- Search Nutshell people and companies for each
- Guess at name only matches
- Never get round to it
With PopdockAI
- Store customers above your threshold are listed
- Each is looked up in Nutshell by email first
- Name only matches are marked as possible
- It only reads and adds nothing
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Find Mailchimp customers who spent at least `{min-spent}` and check whether each is a contact in Nutshell, looking at up to `{max-customers}` customers (default 20).
**Step 1: List the buyers**
Call `mailchimp-get-customer` (Mailchimp server) with `total-spent.min` set to `{min-spent}` and `max-records` set to `{max-customers}`. Keep email, first-name, last-name, company, total-spent, orders-count and customer-id. If none, say so and stop.
**Step 2: Look each one up in Nutshell**
For each customer call `nutshell-get-contact` (Nutshell server) with `name.contains` set to the last name. Nutshell cannot filter by email, so confirm a match by checking that one of the returned `emails` equals the customer's email (case-insensitive), or that first and last name both match and the company agrees. If the last name returns many people, only accept an email match. If a customer is not matched by contact, try `nutshell-get-account` with `name.contains` set to the company, and report an account-only match as partial.
**Step 3: Report**
Three tables: matched (customer, Nutshell contact id, open leads count if shown), partial (account only), and missing from Nutshell (name, email, company, total-spent). Sort each by total-spent descending and give the total spend of the missing group.
**Rules & Guidelines:**
* `mailchimp-get-customer` is on the Mailchimp server; `nutshell-get-contact` and `nutshell-get-account` are on the Nutshell server.
* Read-only. Do not call `nutshell-add-person`, `nutshell-add-company`, or any write tool. Suggest additions in the report only.
**Validation:**
* Never treat a name-only match as certain when emails differ; list it as possible.
* If a customer has no email in Mailchimp, list it as unmatchable.Who it's for
One answer, three teams that use it
Marketing managers
Hand sales your best buyers
Find high spending store customers missing from Nutshell, so they can be added on purpose.
Which Mailchimp store customers who spent over 750 are missing from Nutshell?
Sales reps
Find customers worth an owner
See buyers with real spend who have no person or company record yet.
List Mailchimp big spenders over 2,000 that I cannot find in Nutshell people or companies.
CRM administrators
Review possible matches before adding
Name only matches are shown as possible, so you can check them before creating anything new.
Check our top Mailchimp customers against Nutshell and show which ones only match by name.
How it works
What PopdockAI does when you ask
You give a spend threshold, and your AI assistant checks those store customers against Nutshell. It reports who is missing and leaves adding them to you.
01
Ask
You give a spend threshold.
02
Find
It lists Mailchimp store customers above it.
03
Match
It looks for each in Nutshell people and companies, by email first.
04
Report
It lists who is missing and marks name-only matches as possible.
What PopdockAI provides
The tools behind the answer
Ready made tools for Mailchimp and one secure connection to your AI tool. No code, no exports.
mailchimp-get-customer
nutshell-get-contact
nutshell-get-account
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.
The outcome
Big spenders listed so sales can add them
Related use cases
More ways to put this data to work
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.

.webp)
