/
/
Give your top Mailchimp store buyers a Capsule CRM owner
For sales teams who want to know which high-spending store customers have no contact or open deal in Capsule CRM, by asking their AI assistant.
On this page
Connector
Connect Mailchimp, pick your AI tool and paste the prompt.
The problem
Top store buyers sitting in nobody's pipeline
Your best online customers may have no contact or open deal in Capsule CRM, so nobody manages the relationship. Finding them means comparing Mailchimp store spend with the CRM by hand.
Without PopdockAI
- Export top store customers from Mailchimp
- Search Capsule CRM for each email
- Check each person for open opportunities
- Add up the spend nobody is managing
With PopdockAI
- The top store customers are read by spend
- Each is matched to Capsule CRM by email only
- Buyers split into not in CRM, no opportunity and open opportunity
- Combined uncovered spend is shown and nothing is written
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 e-commerce customers who have spent at least `{min-total-spent}` and show which have no Capsule CRM contact or no open Capsule opportunity, checking at most `{max-customers}` customers (default 25).
**Step 1: Read the top customers**
Call `mailchimp-get-customer` with `total-spent.min` set to `{min-total-spent}` and `max-records` set to `{max-customers}` (default 25). Sort by `total-spent`, highest first.
**Step 2: Carry each customer across**
For each customer `email`, call `capsule-crm-get-party` with `email` set to it.
* One match: call `capsule-crm-get-opportunity` with `party-name.contains` set to the party name; keep only exact `party-name` matches and opportunities with no `closed-on-date`.
* No match or several: record that and continue.
**Step 3: Report**
Three groups, each a table:
1. "Not in Capsule CRM": email, name, company, total-spent, orders-count, store-id.
2. "In Capsule CRM, no open opportunity": the same plus owner-name and last-contacted-date.
3. "In Capsule CRM with open opportunities": the same plus opportunity name, milestone-name and value.
Finish with counts and the combined total-spent of groups 1 and 2.
**Rules & Guidelines:**
* Tools whose names start with mailchimp are on the mailchimp MCP server; tools whose names start with capsule-crm are on the capsule-crm MCP server. If a tool from either server is not available, stop and say which server is not connected rather than working around it.
* Match records across the two systems on email address only, compared case-insensitively with surrounding spaces trimmed. Never match on name alone.
* This prompt is read-only. Do not call any write tool on either server: on Mailchimp `mailchimp-add-list-member`, `mailchimp-update-list-member`, `mailchimp-add-segment-member`, `mailchimp-add-customer`, `mailchimp-update-customer`, `mailchimp-update-order`, `mailchimp-update-product`, `mailchimp-start-automation`, `mailchimp-pause-automation`, `mailchimp-replicate-campaign`; on Capsule CRM `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`.
* Report money values in the currency the source system gives; do not convert between currencies.
**Validation:**
* If no customer meets the threshold, say so and suggest a lower minimum.
* Customer records without an email cannot be matched; count them separately.Who it's for
One answer, three teams that use it
Sales managers
Assign owners to your biggest buyers
See high spending customers with no CRM record or no open opportunity, with the combined spend at stake.
Which Mailchimp store customers who spent over 3,000 are not in Capsule CRM?
Account managers
Open conversations with loyal buyers
Find known contacts who buy a lot online but have no open opportunity, ready for an upsell call.
List our top 30 Mailchimp store buyers who are in Capsule CRM but have no open opportunity.
Business owners
See revenue nobody is managing
Get the total spend of top buyers who sit outside the sales pipeline.
How much store spend from our top Mailchimp customers has no Capsule CRM opportunity behind it?
How it works
What PopdockAI does when you ask
You set a minimum spend and how many customers to check, and your AI assistant matches them to Capsule CRM. It only reads and groups them.
01
Ask
You set a minimum spend and how many customers to check.
02
Read
It reads the Mailchimp store customers who spent the most.
03
Match
Each is matched to Capsule CRM by email, with any open opportunities.
04
Report
You get three groups and the combined spend of the uncovered buyers.
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
capsule-crm-get-party
capsule-crm-get-opportunity
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
Every top buyer with an owner and a conversation
Related use cases
More ways to put this data to work
Mailchimp and Capsule CRM contact profile
Ask your AI for a contact profile and it combines Capsule CRM history, tasks and opportunities with Mailchimp audiences, clicks and orders, then flags what needs attention.
Learn More
Match Mailchimp campaign clickers to Capsule CRM
Ask your AI to match a Mailchimp campaign's clickers to Capsule CRM and it ranks them by open opportunities, owner and last contact, without changing anything.
Learn More
Log Mailchimp unsubscribes as Capsule CRM notes
Ask your AI to log recent Mailchimp unsubscribes in Capsule CRM and it adds a note to each matching contact, after you confirm, skipping any already noted.
Learn More
Find Mailchimp subscribers missing from Capsule CRM
Ask your AI to compare a Mailchimp audience with Capsule CRM and it lists subscribed members with no contact, highest rated first, without changing anything.
Learn More
Add a contact to a Mailchimp audience safely
Ask your AI to add someone to a Mailchimp audience and it checks for an existing member, refuses to re-add anyone who opted out, and writes only after you confirm.
Learn More
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.