/
/
Reconcile open ActiveCampaign deals with Nutshell leads
For sales managers who track pipeline in two systems and want their AI assistant to match deals to leads and flag the differences.
On this page
Connector
Connect ActiveCampaign, pick your AI tool and paste the prompt.
The problem
A pipeline split across deals and leads that drift apart
Deals in ActiveCampaign and leads in Nutshell describe the same pipeline but are updated separately. Matching them by hand is slow, and the differences surface only at quarter end.
Without PopdockAI
- List open deals in ActiveCampaign
- Search each deal name in Nutshell
- Compare values, currencies and statuses by hand
- Discover the drift at quarter end
With PopdockAI
- Open deals are read with a status and minimum you set
- Each is matched to a Nutshell lead by name
- Several possible matches are listed, not guessed
- Currencies are never converted, and nothing is written
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Compare ActiveCampaign deals with status {deal-status} (default 0, open) against Nutshell leads, for deals at or above {min-value} in value (default 0).
**Step 1: Read the ActiveCampaign deals**
Call `activecampaign-get-deal` with `status` set to {deal-status} (use 0 if empty) and `value.min` set to {min-value} (omit if empty). Keep id, title, value, currency, status and primary-contact-id.
**Step 2: Find the matching Nutshell lead**
For each deal call `nutshell-get-lead` with `name` set to the deal title; if nothing matches, retry with `name.contains`. When the title is a person or company name you may match on the lead's `people` or `companies` instead. If several leads match, list them and do not choose one.
**Step 3: Report**
Table: deal title, ActiveCampaign value and currency, Nutshell lead (name, number, value, status), verdict. Verdicts: matched, value differs, currency differs, status differs, no lead in Nutshell, ambiguous. Also list Nutshell leads from `nutshell-get-lead` with `status` open that matched no deal.
**Rules & Guidelines:**
* `activecampaign-*` tools are on the activecampaign server; `nutshell-*` tools are on the nutshell server. Both servers must be connected.
* Read only. Do NOT call any `activecampaign-*` or `nutshell-*` tool that adds, updates, deletes, syncs or tracks anything (for example `activecampaign-contact-add`, `activecampaign-contact-update`, `activecampaign-note-add`, `nutshell-add-person`, `nutshell-update-lead`, `nutshell-delete-person`).
* Do not convert currencies. If currencies differ, report both amounts as they are.
**Validation:**
* If either side returns no records, report that and stop.
* Say that matching is by name and may miss renamed records.Who it's for
One answer, three teams that use it
Sales managers
Review the pipeline with confidence
See which open deals disagree with their Nutshell lead before you commit a number.
Reconcile open ActiveCampaign deals worth at least 10,000 with Nutshell leads.
Sales operations
Find deals with no lead
List ActiveCampaign deals that have no Nutshell lead and Nutshell leads that match no deal.
Which open ActiveCampaign deals have no matching lead in Nutshell?
Finance managers
Check values before forecasting
Compare deal values and currencies across both systems before you roll them into a forecast.
Show me value and currency differences between our open ActiveCampaign deals and Nutshell leads.
How it works
What PopdockAI does when you ask
You choose the status and an optional minimum value, and your AI assistant matches each deal to a Nutshell lead. It only reads, and it tells you that name matching can miss renamed records.
Ask
You choose the deal status, with open as the default, and an optional minimum value.
Read
It reads the matching ActiveCampaign deals with their values and currencies.
Match
It finds each deal's Nutshell lead by name and lists several matches without choosing.
Report
You get a verdict per deal and the open Nutshell leads that matched no deal.
What PopdockAI provides
The tools behind the answer
Ready made tools for ActiveCampaign and one secure connection to your AI tool. No code, no exports.
activecampaign-get-deal
nutshell-get-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
Pipeline differences caught before quarter end
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)
