Connectors

/

Mailchimp

/

Mailchimp and Capsule CRM contact profile
Report
Cross-Connector

One profile of a contact across Capsule CRM and Mailchimp

For sales teams who want a contact's deals, tasks and email engagement in one answer, by asking their AI assistant with just an email.

Try PopdockAI free
Get a live demo
Mailchimp and Capsule CRM contact profile
Give me a profile of jordan.lee@contoso.com from Capsule CRM and Mailchimp for the last 90 days.
Jordan Lee, Contoso, owned by Sam Patel in Capsule CRM. - Capsule CRM: 1 open opportunity, Renewal 2027, 2 open tasks - Mailchimp: subscribed to Customers, 6 clicks in 90 days - Orders: 2 store orders, 1,140 USD - Signal: frequent clicker, but the last note is 45 days old Want me to list the open tasks?
Mailchimp
Sample figures. Your results come from your own account.
capsule-crm-get-party
capsule-crm-get-entry
capsule-crm-get-task
capsule-crm-get-opportunity
mailchimp-get-list-member
mailchimp-get-campaign-email-activity
mailchimp-get-customer
mailchimp-get-order

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Mailchimp

Mailchimp
Run it on your own Mailchimp data.

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

Try PopdockAI free

The problem

Two systems to scroll before you understand one contact

To understand one contact you check Capsule CRM for deals, tasks and history, then Mailchimp for audiences, clicks and orders. That is two systems and a lot of scrolling, and connecting the dots is still left to you.

Without PopdockAI

  • Open the person in Capsule CRM for history and deals
  • Check open tasks and opportunities
  • Search Mailchimp for audiences, clicks and orders
  • Piece the signals together yourself

With PopdockAI

  • The Capsule CRM record comes with history, tasks and opportunities
  • Mailchimp audiences, opens, clicks and orders are added
  • Up to five signals that need attention are called out
  • Email matching only, 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:** Build a single profile of the contact with email `{email}`, combining their Capsule CRM record with their Mailchimp subscription, engagement and purchases over the last `{lookback-days}` days (default 90).

**Step 1: Find the contact in Capsule CRM**

Call `capsule-crm-get-party` with `email` set to `{email}`. If more than one party comes back, list them (name, organization-name, owner-name, party-id) and stop. If none comes back, note "not in Capsule CRM" and continue to Step 3.

**Step 2: Capsule CRM context**

With the party's `party-id`:
* Call `capsule-crm-get-entry` with `party-id` and `date.from` set to today minus the lookback window. Keep the 10 most recent entries.
* Call `capsule-crm-get-task` with `party-id` and `status` set to open.
* Call `capsule-crm-get-opportunity` with `party-name.contains` set to the party's `name`, then keep only rows whose `party-name` exactly equals that name.

**Step 3: Mailchimp context**

* Call `mailchimp-get-list-member` with `email` set to `{email}`. Report every audience they belong to with status, tags, rating and average open and click rates.
* Call `mailchimp-get-campaign-email-activity` with `email-address` set to `{email}` and `activity-date.from` set to today minus the lookback window. Summarize opens, clicks (with URLs) and bounces by campaign.
* Call `mailchimp-get-customer` with `email` set to `{email}`. If a customer comes back, call `mailchimp-get-order` with `customer-email-address` set to `{email}`.

**Step 4: Report**

A short header (name, organization, Capsule owner), then two sections, "Capsule CRM" and "Mailchimp", then a "Signals" list of at most five bullets pointing out anything that needs attention, such as an open opportunity whose contact has unsubscribed, a frequent clicker with no open task, or a buyer with no CRM record.

**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`.

**Validation:**

* If the email is in neither system, say so and stop.
* If it is in only one system, report that system's section and state plainly that the other system has no record for this email.
* Report dates exactly as returned; do not convert time zones.

Who it's for

One answer, three teams that use it

Sales reps

Prepare for a call in one message

See deals, tasks and recent email engagement together before you pick up the phone.

Profile dana@fabrikam.com from Capsule CRM and Mailchimp before my call this afternoon.

Account managers

Spot conflicts between sales and email

Signals like an open opportunity whose contact unsubscribed are called out, so nothing surprises you.

What do Capsule CRM and Mailchimp say about sam.patel@northwindtraders.com over the last 60 days?

Marketing managers

Find buyers with no CRM record

A Mailchimp buyer with no Capsule CRM record is flagged, so you can pass them to sales.

Give me a contact profile for tom.reyes@contoso.com and tell me if he is missing from Capsule CRM.

How it works

What PopdockAI does when you ask

You give an email address and a lookback period, and your AI assistant builds one profile from both systems. It only reads.

01

Ask

You give an email address and how far back to look.

Your AI tool

02

Read

It finds the person in Capsule CRM with history, open tasks and opportunities.

capsule-crm-get-party
capsule-crm-get-entry
capsule-crm-get-task
capsule-crm-get-opportunity

03

Add

It reads their Mailchimp audiences, opens, clicks and store orders.

mailchimp-get-list-member
mailchimp-get-campaign-email-activity
mailchimp-get-customer
mailchimp-get-order

04

Report

You get one profile ending with up to five signals.

Your AI tool

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.

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-entry

Returns Capsule CRM history entries (notes, emails and completed activities) with subject, content, creator and activity type. Filter by date range, type, activity type, creator, subject, party, opportunity or project.
get-data

capsule-crm-get-task

Returns Capsule CRM tasks with due date, status, owner, category and the linked party, opportunity or project. Filter by status, due date range, owner, category, party or description.
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.
get-data

mailchimp-get-list-member

Returns the members (subscribers) of Mailchimp audiences, with subscription status, tags and engagement rating. Filter by email address or status to look someone up.
get-data

mailchimp-get-campaign-email-activity

Returns each member's open, click and bounce events for Mailchimp campaigns, with timestamps and the URLs they clicked.
get-data

mailchimp-get-customer

Returns e-commerce customers from the stores connected to Mailchimp, with order counts, total spent and marketing opt-in.
get-data

mailchimp-get-order

Returns e-commerce orders from the stores connected to Mailchimp, with the customer, order total and the campaign or automation the order is attributed to.
Read only.Nothing in Mailchimp 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

One contact profile across sales and marketing

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