Connectors

/

Mailchimp

/

Capture Mailchimp campaign clickers as Salesforce leads
Write
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Capture Mailchimp campaign clickers as Salesforce leads
Create Salesforce leads for everyone who clicked our May product update campaign in Mailchimp, lead source Email Campaign.
The May product update had 64 unique clickers, and 18 can become new leads. - Already in Salesforce: 39 as contacts or leads - Unsubscribed: 3 dropped - Missing fields: 4 rows lack a company, such as Jordan Lee - Ready: 18 leads with lead source Email Campaign Shall I create the 18 leads, or do you want to fill in the 4 first?
Mailchimp
Sample figures. Your results come from your own account.
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

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

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.

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

Your AI tool

02

Filter

It gathers unique clickers and drops existing Salesforce contacts, leads and unsubscribes.

mailchimp-get-campaign
mailchimp-get-campaign-email-activity
mailchimp-get-campaign-recipient
salesforce-get-contact
salesforce-get-lead
mailchimp-get-campaign-unsubscribe

03

Confirm

You review the list, filling any missing last name or company, and say yes.

No items found.

04

Create

It creates each lead once and reports totals for every skip reason.

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

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

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

salesforce-get-contact

Returns Salesforce contacts with their account, title, department, email, phone, mailing address, owner and lead source. Filter by name, email, account, title, owner, lead source and mailing city or state.
get-data

salesforce-get-lead

Returns Salesforce leads with their company, status, source, owner, contact details, location and whether they are converted. Filter by name, company, email, status, lead source, owner, state, converted flag and created date.
get-data

mailchimp-get-campaign-unsubscribe

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

salesforce-add-lead

Creates a Salesforce lead with name, company, title, email, phone, industry, status and lead source.
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

Engaged clickers become 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