Connectors

/

Pipedrive

/

Pipedrive person Mailchimp engagement
Report
Cross-Connector

Get one view of a contact across Pipedrive and Mailchimp

For sales and marketing teams who want a contact's Pipedrive record and Mailchimp engagement combined into one profile with a next step.

Try PopdockAI free
Get a live demo
Pipedrive person Mailchimp engagement
Give me a profile of jordan@contoso.com across Pipedrive and Mailchimp.
Jordan Lee is an engaged subscriber with an open 36,000 deal owned by Sam Patel. - Mailchimp: 2 audiences, 14 opens and 5 clicks in 90 days - Pipedrive: demo booked for Thursday - Store spend: 1,240 to date Suggested next step: mention the pricing page he clicked twice.
Pipedrive
Sample figures. Your results come from your own account.
pipedrive-get-person
pipedrive-get-activity
pipedrive-get-note
pipedrive-get-deal
mailchimp-get-list-member
mailchimp-get-campaign-email-activity
mailchimp-get-campaign-unsubscribe
mailchimp-get-customer

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Pipedrive

Pipedrive
Run it on your own Pipedrive data.

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

Try PopdockAI free

The problem

Sales and email history never read together

Getting a full picture of one contact means opening Pipedrive for deals, activities and notes, then Mailchimp for audiences, opens, clicks and orders. The two are rarely read together, so a buyer who unsubscribed looks like any other contact.

Without PopdockAI

  • Open the person in Pipedrive
  • Read their deals, activities and notes
  • Switch to Mailchimp for audiences and engagement
  • Miss that the buyer unsubscribed last month

With PopdockAI

  • The Pipedrive person, owner, activities, notes and deals are read
  • Mailchimp audiences, opens, clicks, unsubscribes and spend are added
  • Several people on one email are listed, never guessed
  • One profile and a suggested next step, nothing written

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 address `{email}`, combining their Pipedrive CRM record with their Mailchimp email engagement over the last `{lookback-days}` days (default 90).

**Step 1: Find the contact in Pipedrive**

Call `pipedrive-get-person` with `email` set to `{email}`. Note `person-id`, `name`, `organization-name`, `organization-id`, `owner-name`, `open-deals`, `won-deals` and `last-activity-date`. If more than one person comes back, list them and stop. If none comes back, record the contact as absent from Pipedrive and skip to Step 3.

**Step 2: Pull the CRM context**

* Call `pipedrive-get-activity` with `person-id` and `done` set to false for open activities.
* Call `pipedrive-get-note` with `person-id` for the five most recent notes.
* If the person has an `organization-id`, call `pipedrive-get-deal` with that `organization-id` and `status` open, and keep the deals whose person name matches this contact.

**Step 3: Pull the Mailchimp side**

* Call `mailchimp-get-list-member` with `email` set to `{email}`. Note each audience, its 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. Count opens, clicks and bounces, and note the last three campaigns clicked.
* Call `mailchimp-get-campaign-unsubscribe` with `email` set to `{email}`.
* Call `mailchimp-get-customer` with `email` set to `{email}` for store orders and total spent.

**Step 4: Report**

A short header (name, organization, Pipedrive owner), then two sections, Pipedrive and Mailchimp, then a three-line Assessment: how engaged the contact is by email, how active the sales relationship is, and one suggested next step.

**Rules & Guidelines:**

* Tools named `pipedrive-*` are on the pipedrive server; tools named `mailchimp-*` are on the mailchimp server.
* This prompt is read-only. Do not call `mailchimp-add-list-member`, `mailchimp-update-list-member`, `mailchimp-add-segment-member`, `mailchimp-add-customer`, `mailchimp-update-customer`, `pipedrive-add-person`, `pipedrive-update-person`, `pipedrive-add-deal`, `pipedrive-update-deal`, `pipedrive-add-activity`, `pipedrive-add-note` or any other add or update tool on either server.

**Validation:**

* Match on email case-insensitively and trim spaces. Pipedrive matches the primary email only, so say so if the contact is missing from Pipedrive.
* If the contact is absent from both systems, say that and stop.
* If the contact is unsubscribed or cleaned in Mailchimp but has open deals in Pipedrive, put that first in the Assessment.

Who it's for

One answer, three teams that use it

Account executives

Know the buyer before you call

See open deals and email engagement together, with a suggested next step.

Give me a profile of priya@contoso.com across Pipedrive and Mailchimp.

Account managers

See store spend next to deals

Mailchimp store spend sits beside open deals, so you know how much the contact already buys.

What has tom@northwindtraders.com spent, and what deals does he have open in Pipedrive?

Email marketers

Check a contact before targeting

Know the contact's sales status and owner before sending them a campaign.

Is alex@fabrikam.com on open Pipedrive deals, and which Mailchimp audiences is he in?

How it works

What PopdockAI does when you ask

You give an email address and your AI assistant builds one profile across Pipedrive and Mailchimp. An unsubscribed contact on open deals is raised first, and it only reads.

01

Ask

You give the contact's email address.

Your AI tool

02

Read

It reads the Pipedrive person, owner, open activities, notes and deals.

pipedrive-get-person
pipedrive-get-activity
pipedrive-get-note
pipedrive-get-deal

03

Check

It pulls Mailchimp audiences, opens, clicks, unsubscribes and spend.

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

04

Report

You get one profile and a suggested next step.

Your AI tool

What PopdockAI provides

The tools behind the answer

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

get-data

pipedrive-get-person

Returns Pipedrive contacts with email, phone, job title, organization, owner and last activity date. Filter by name, email, city, organization or owner.
get-data

pipedrive-get-activity

Returns Pipedrive activities (calls, meetings, tasks, deadlines). Filter by due date range, type, done, assigned user, person, deal or subject text.
get-data

pipedrive-get-note

Returns notes attached to Pipedrive deals, people, organizations and leads. Filter by record, created date range or note text.
get-data

pipedrive-get-deal

Returns Pipedrive deals with stage, pipeline, value, probability, owner and expected close date. Filter by status, stage, owner, organization, value range, expected close date range or title.
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-campaign-unsubscribe

Returns the members who unsubscribed from each Mailchimp campaign, with the date and the reason they gave.
get-data

mailchimp-get-customer

Returns e-commerce customers from the stores connected to Mailchimp, with order counts, total spent and marketing opt-in.
Read only.Nothing in Pipedrive 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

The whole relationship in one read

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