Connectors

/

Pipedrive

/

Create Pipedrive leads from Constant Contact campaign clicks
Write
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Create Pipedrive leads from Constant Contact campaign clicks
Create Pipedrive leads from everyone who clicked the October webinar invite in Constant Contact.
14 people clicked; 9 can become Pipedrive leads. - Lead for existing person: 4 people - New person and lead: 5 people, 2 linked to an organization - Skipped: 5 already have an open lead or deal Shall I create the 9 leads?
Pipedrive
Sample figures. Your results come from your own account.
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

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

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.

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

Your AI tool

02

Check

It gathers the clickers, drops unsubscribes and checks each in Pipedrive.

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

03

Confirm

You see leads for existing people and new people with leads.

No items found.

04

Create

It creates the people and leads with a campaign note, then reads them back.

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

constant-contact-get-campaign

Returns Constant Contact email campaigns with their status and headline counts: sends, opens, not opened, clicks, bounces, forwards and opt-outs. Filter by name, status, type and last sent date.
get-data

constant-contact-get-campaign-click

Returns Constant Contact campaign clicks with the link clicked and the device used. Filter by campaign, campaign activity, contact, email address or domain, device type and date.
get-data

constant-contact-get-contact

Returns Constant Contact contacts with their name, email, company, job title, phone, location, tags and email permission. Filter by email address or domain, last name, company, state, permission and created date.
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

pipedrive-get-lead

Returns Pipedrive leads with value, source, labels, owner and next activity date. Filter by created date range, source, owner, person, organization, archived or title.
get-data

pipedrive-get-deal

Returns Pipedrive deals with stage, pipeline, value, probability, owner and expected close date. Filter by status, stage, owner, organization, value range, expected close date range or title.
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 interest becomes leads without duplicates

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