/
/
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.
On this page
Connector
Connect Pipedrive, pick your AI tool and paste the prompt.
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.
**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.
02
Check
It collects the clickers and drops anyone already in Pipedrive.
03
Confirm
You see each person, company and matched organization, and approve.
04
Create
It creates each person, reads it back, then adds a lead.
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.
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
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
Campaign clickers become owned leads the same day
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)
