Connectors

/

Pipedrive

/

Create Pipedrive leads from Mailchimp campaign clicks
Write
Cross-Connector

Turn Mailchimp campaign clickers into owned Pipedrive leads

For sales teams who want people who clicked a Mailchimp campaign, and are not yet in Pipedrive, created as people with leads.

Try PopdockAI free
Get a live demo
Create Pipedrive leads from Mailchimp campaign clicks
Create Pipedrive leads from people who clicked the September newsletter in Mailchimp, owned by sam@contoso.com.
22 people clicked; 8 are not in Pipedrive yet. - Create: 7 people with leads, owned by Sam Patel - Linked: 3 to an existing organization - Skipped: 1 with no name in Mailchimp Shall I create the 7 people and leads?
Pipedrive
Sample figures. Your results come from your own account.
mailchimp-get-campaign
mailchimp-get-campaign-email-activity
pipedrive-get-person
mailchimp-get-campaign-recipient
pipedrive-get-user
pipedrive-get-organization
pipedrive-add-person
pipedrive-add-lead

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

Campaign clickers fall through the gap

People who click a Mailchimp campaign are showing interest, but turning them into Pipedrive leads means exporting clicks, checking who is already in the CRM and entering the rest by hand. Clickers fall through the gap or get entered twice.

Without PopdockAI

  • Export the campaign click report
  • Check who is already in Pipedrive
  • Enter names and companies by hand
  • Enter the same person twice

With PopdockAI

  • Clickers are collected and anyone in Pipedrive is dropped
  • Names and companies come from the campaign recipients
  • An organization is linked only when exactly one matches
  • Each person is read back before a lead is added

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** Take the people who clicked the Mailchimp campaign `{campaign-title}` but do not exist in Pipedrive, and after confirmation create each as a Pipedrive person with a lead in the Leads Inbox, owned by the Pipedrive user with email `{owner-email}` (default: the connecting user).

**Step 1: Find the campaign and its clickers in Mailchimp**

Call `mailchimp-get-campaign` with `title` set to `{campaign-title}`, retrying with `title.contains` if nothing comes back. If more than one matches, list them and stop. Then call `mailchimp-get-campaign-email-activity` with `campaign-id` and `action` set to click (if that filter returns nothing, call without it and keep rows whose action is click). Reduce to distinct emails.

**Step 2: Keep only the ones missing from Pipedrive**

For each email call `pipedrive-get-person` with `email`. Drop everyone who is found.

**Step 3: Get names from Mailchimp**

For each remaining email call `mailchimp-get-campaign-recipient` with `campaign-id` and `email-address` for `first-name`, `last-name` and `company`. If a person has no first or last name, mark them Skip (no name), since Pipedrive requires one.

**Step 4: Resolve the owner and organizations**

* If an owner email was given, call `pipedrive-get-user` with `email` and use its `user-id`. If no user matches, stop and say so.
* For each company, call `pipedrive-get-organization` with `name`. Use its `organization-id` if exactly one matches; otherwise leave the person unlinked. Never create organizations.

**Step 5: Confirm the plan**

Show a table: email, name, company, matched organization, planned action (Create, Skip). Ask the user to confirm. If they do not, stop.

**Step 6: Create, once per person**

For each Create row:

1. Call `pipedrive-add-person` with `name`, `work-email`, `org-id` if matched, and `owner-id` if resolved.
2. Call `pipedrive-get-person` with `email` to read back the new `person-id`. If it is not found, report the failure and do not create a lead.
3. Call `pipedrive-add-lead` with `title` set to the campaign title, a hyphen and the person's name, `person-id`, `owner-id` if resolved, and a `note` saying the person clicked this Mailchimp campaign.

**Step 7: Report**

Created persons and leads, skipped people with the reason, and any failures.

**Rules & Guidelines:**

* Tools named `mailchimp-*` are on the mailchimp server and are only read here. Tools named `pipedrive-*` are on the pipedrive server.
* The only writes allowed are `pipedrive-add-person` and `pipedrive-add-lead`, once each per confirmed person, after Step 5. Do not call `pipedrive-add-organization`, `pipedrive-add-deal`, `pipedrive-add-activity`, `pipedrive-update-person`, `mailchimp-update-list-member` or any other write tool.

**Validation:**

* Match emails case-insensitively and trim spaces before deciding someone is missing.
* If every clicker is already in Pipedrive, say so and stop.
* Never create the same person twice in one run.

Who it's for

One answer, three teams that use it

Sales development reps

Get a fresh list of interested people

Clickers arrive in the Leads Inbox owned by you, ready for a same day follow-up.

Create Pipedrive leads from the clickers on the October Mailchimp newsletter, owned by me.

Email marketers

Show campaigns create pipeline

Turn clicks into leads sales can work, without an export and import.

Turn people who clicked the Contoso webinar invite in Mailchimp into Pipedrive leads.

Sales operations

Keep Pipedrive free of stray records

Organizations are never created and nobody is added twice, so the CRM stays clean.

Create leads from the Mailchimp pricing email clickers for alex@fabrikam.com, without adding new organizations.

How it works

What PopdockAI does when you ask

You name the Mailchimp campaign, and an owner if you like, and your AI assistant plans leads for clickers missing from Pipedrive. It writes only after you approve and never creates organizations.

01

Ask

You name the Mailchimp campaign, and optionally an owner.

Your AI tool

02

Check

It collects the clickers and drops anyone already in Pipedrive.

mailchimp-get-campaign
mailchimp-get-campaign-email-activity
mailchimp-get-campaign-recipient
pipedrive-get-person
pipedrive-get-user
pipedrive-get-organization

03

Confirm

You see each person, company and matched organization, and approve.

No items found.

04

Create

It creates each person, reads it back, then adds a lead.

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

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-email-activity

Returns each member's open, click and bounce events for Mailchimp campaigns, with timestamps and the URLs they clicked.
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

mailchimp-get-campaign-recipient

Returns the members each Mailchimp campaign was sent to, with delivery status and how often each one opened it.
get-data

pipedrive-get-user

Returns Pipedrive users with email, role, timezone, default currency and last login. Filter by name, email or active.
get-data

pipedrive-get-organization

Returns Pipedrive organizations with address, industry, size, owner and open and won deal counts. Filter by name, city, state, country, industry or owner.
run-action

pipedrive-add-person

Creates a contact in Pipedrive with a name, work email, work and mobile phone, owner and organization.
run-action

pipedrive-add-lead

Creates a lead in the Pipedrive Leads Inbox for a person or organization, with a title, value, owner, expected close date and note.
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

Campaign clickers become owned leads the same day

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