/
/
Turn Mailchimp campaign clickers into Salesforce leads the same day
For sales teams who want people who clicked a campaign in Salesforce as leads, without duplicates, by asking their AI assistant.
On this page
Connector
Connect Mailchimp, pick your AI tool and paste the prompt.
The problem
Campaign clickers go cold before anyone logs them
People who click a campaign should become Salesforce leads, but each email has to be checked against contacts and leads first. Rushing it creates duplicates or leads without the last name and company Salesforce requires.
Without PopdockAI
- Export clickers from the Mailchimp campaign report
- Search Salesforce contacts and leads for each email
- Fill in missing last names and companies by hand
- Create leads one by one and lose track of who was skipped
With PopdockAI
- Unique clickers are gathered with names and companies
- Existing contacts, leads and unsubscribes are dropped
- Rows missing required fields are marked for you to fill
- Leads are created once, only after you confirm
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Create a Salesforce lead for each person who clicked the Mailchimp campaign titled `{campaign-title}` and has no contact or lead in Salesforce, with lead source `{lead-source}` (default Email Campaign).
**Step 1: Find the campaign and its clickers**
Call `mailchimp-get-campaign` with `title.contains` set to `{campaign-title}`. If more than one campaign matches, list them and stop so the user can choose. Call `mailchimp-get-campaign-email-activity` with that `campaign-id` and `action` set to click, and reduce to unique email addresses. Use `mailchimp-get-campaign-recipient` with the `campaign-id` and `email-address` for each person's first-name, last-name and company.
**Step 2: Remove anyone already in Salesforce**
For each email, call `salesforce-get-contact` with `email`, then `salesforce-get-lead` with `email`. Drop anyone either call returns. Also drop anyone `mailchimp-get-campaign-unsubscribe` returns for that `campaign-id` and `email`.
**Step 3: Confirm**
Show the remaining people as a table: email, first name, last name, company. Salesforce requires a last name and a company; mark any row missing either, and leave those rows out unless the user supplies the values. Ask the user to confirm before creating anything. Do not continue without an explicit yes.
**Step 4: Create**
For each confirmed row, call `salesforce-add-lead` once with `email`, `first-name`, `last-name`, `company` and `lead-source` set to `{lead-source}`. Leave `status` unset so Salesforce applies its default.
**Step 5: Report**
List each lead created with its email, plus any row that failed and the error. Give the totals: clickers, already in Salesforce, unsubscribed, skipped for missing fields, created.
**Rules & Guidelines:**
* `mailchimp-get-campaign`, `mailchimp-get-campaign-email-activity`, `mailchimp-get-campaign-recipient` and `mailchimp-get-campaign-unsubscribe` are on the mailchimp server. `salesforce-get-contact`, `salesforce-get-lead` and `salesforce-add-lead` are on the salesforce server.
* The only write this prompt may make is `salesforce-add-lead`, once per confirmed person, after the user confirms. Do not call `salesforce-add-contact`, `salesforce-update-lead` or any mailchimp add or update tool.
**Validation:**
* Compare email addresses case-insensitively before deciding someone is new; a duplicate lead is worse than a missed one.
* If no clickers remain after Step 2, say so and stop without asking for confirmation.
* If a create fails, report it and carry on with the rest; do not retry it automatically.Who it's for
One answer, three teams that use it
Sales development reps
Work fresh leads while interest is high
Get the people who clicked into Salesforce on the day of the send, so follow up happens while the email is still fresh.
Make Salesforce leads from everyone who clicked the October webinar invite in Mailchimp, lead source Webinar.
Demand generation
Turn campaign clicks into pipeline
Move engaged clickers into Salesforce with the right lead source, so campaign results show up in pipeline reports.
Who clicked our Fabrikam case study email in Mailchimp and is not already in Salesforce?
Salesforce admins
Add leads without duplicates or gaps
Existing contacts and leads are skipped and incomplete rows are held back, so the org stays clean.
Create leads from the Mailchimp Spring Launch clickers, but skip anyone already a Salesforce contact or lead.
How it works
What PopdockAI does when you ask
You name the campaign and a lead source, and your AI assistant filters the clickers against Salesforce. You review the list and confirm before any lead is created.
01
Ask
You name the Mailchimp campaign and optionally a lead source.
02
Filter
It gathers unique clickers and drops existing Salesforce contacts, leads and unsubscribes.
03
Confirm
You review the list, filling any missing last name or company, and say yes.
04
Create
It creates each lead once and reports totals for every skip reason.
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-campaign
mailchimp-get-campaign-email-activity
mailchimp-get-campaign-recipient
salesforce-get-contact
salesforce-get-lead
mailchimp-get-campaign-unsubscribe
salesforce-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
Engaged clickers become 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)
