/
/
Turn Constant Contact clickers into Pipedrive leads
For sales teams who want people who clicked a Constant Contact campaign added as Pipedrive leads, skipping anyone already being worked.
On this page
Connector
Connect Pipedrive, pick your AI tool and paste the prompt.
The problem
Two reps chasing the same campaign clicker
Turning Constant Contact clickers into Pipedrive leads by hand means checking each for an existing person, open lead or open deal, then creating the person and lead. Skip a check and two reps end up chasing the same prospect.
Without PopdockAI
- Export the campaign clickers
- Check each one for a person, lead or deal in Pipedrive
- Create people and leads one at a time
- Link the organization by guesswork
With PopdockAI
- Clickers are collected and unsubscribes dropped
- Anyone with an open lead or deal is skipped
- An organization is linked only when exactly one matches
- People and leads are created after your yes, with a campaign note
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Turn the people who clicked the Constant Contact campaign `{campaign-name}` and have no open sales record in Pipedrive into Pipedrive leads, creating the person first when they are not yet in Pipedrive. Only include contacts with at least `{min-clicks}` clicks (default 1). Write nothing until the user confirms the plan.
**Step 1: Find the engaged contacts (Constant Contact)**
Call `constant-contact-get-campaign` with `name` set to `{campaign-name}` (fall back to `name.contains`; if more than one matches, list them and stop). Call `constant-contact-get-campaign-click` with the `campaign-id`, group by `email-address`, and keep contacts with at least `{min-clicks}` clicks (default 1).
For each, call `constant-contact-get-contact` with `email-address` to get `first-name`, `last-name`, `company-name`, `job-title`, `phone-number` and `permission-to-send`. Drop anyone whose `permission-to-send` is unsubscribed.
**Step 2: Check Pipedrive**
For each contact, call `pipedrive-get-person` with `email`.
* Person found: call `pipedrive-get-lead` with `person-id` and `archived` set to false, and, if they have an `organization-id`, `pipedrive-get-deal` with it and `status` set to open. If either returns anything, skip them; they are already being worked.
* Person not found: call `pipedrive-get-organization` with `name` set to the contact's `company-name`. Use its `organization-id` only if exactly one organization comes back.
**Step 3: Confirm the plan**
Show two tables: "Lead for existing person" (name, email, clicks) and "New person and lead" (name, email, company, matched organization or none). The lead title is "<campaign name> - <company-name, or the person's name if there is no company>". Ask the user to confirm. Do not continue without an explicit yes.
**Step 4: Create (Pipedrive)**
* For each new person, call `pipedrive-add-person` with `name`, `work-email`, `work-phone` if known, and `org-id` if matched. Use the returned id.
* For every row, call `pipedrive-add-lead` with `title`, `person-id`, `organization-id` if known, and a `note` naming the campaign, the click count and the links clicked.
**Step 5: Confirm**
Call `pipedrive-get-lead` with each `person-id` and report what was created, what was skipped and why, and any call that failed.
**Rules & Guidelines:**
* `constant-contact-get-campaign`, `constant-contact-get-campaign-click` and `constant-contact-get-contact` are on the constant-contact server. Every other tool is on the pipedrive server.
* The only tools allowed to write are `pipedrive-add-person` and `pipedrive-add-lead`, after Step 3 is confirmed. Do NOT call `pipedrive-add-organization`, `pipedrive-add-deal`, `pipedrive-update-person`, or any Constant Contact add or update tool. A company with no matching organization is named in the lead note instead.
**Validation:**
* If nobody qualifies, say so and stop without writing.
* If `pipedrive-add-person` fails for a contact, do not create their lead; report the failure.Who it's for
One answer, three teams that use it
Sales development reps
Follow up while interest is fresh
Clickers become leads the same day, with a note naming the campaign and links they clicked.
Create Pipedrive leads from people who clicked the November product update in Constant Contact.
Marketing managers
Hand engaged people to sales
Pass campaign clickers to sales as leads without exporting lists or entering them by hand.
Turn anyone who clicked the Contoso case study email at least twice into Pipedrive leads.
Sales managers
Keep reps off each other's prospects
People already on an open lead or deal are skipped, so nobody steps on a colleague's opportunity.
Create leads from the Spring event invite clickers, skipping anyone already being worked in Pipedrive.
How it works
What PopdockAI does when you ask
You name the Constant Contact campaign and your AI assistant checks every clicker in Pipedrive first. It shows the leads it will create and writes only after you confirm.
01
Ask
You name the campaign, and optionally a minimum number of clicks.
02
Check
It gathers the clickers, drops unsubscribes and checks each in Pipedrive.
03
Confirm
You see leads for existing people and new people with leads.
04
Create
It creates the people and leads with a campaign note, then reads them back.
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.
constant-contact-get-campaign
constant-contact-get-campaign-click
constant-contact-get-contact
pipedrive-get-person
pipedrive-get-lead
pipedrive-get-deal
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 interest becomes leads without duplicates
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)
