/
/
Reconcile open deals between ActiveCampaign and Pipedrive
For sales teams who run deals in two CRMs and want their AI assistant to match them by title and flag what differs.
On this page
Connector
Connect ActiveCampaign, pick your AI tool and paste the prompt.
The problem
Two CRMs that no longer agree on the same deals
Deals tracked in both ActiveCampaign and Pipedrive slowly diverge in value and even existence. Comparing them by hand is slow, and a cents against whole units mismatch can make every number look wrong.
Without PopdockAI
- List matching deals in ActiveCampaign
- List the same deals in Pipedrive
- Match titles and compare values by hand
- Trip over cents versus whole units
With PopdockAI
- Deals are read from both systems with a cap per side
- Matching is by title, ignoring case and spacing
- Duplicate titles are listed as ambiguous
- The cents assumption is stated, 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 whose title contains `{title-text}` with Pipedrive deals of the same title, and report what is missing or different. Look at no more than `{max-deals}` deals per side (default 25).
**Step 1: Read the ActiveCampaign deals**
Call `activecampaign-get-deal` (ActiveCampaign server) with `title.contains` set to `{title-text}` and `max-records` set to `{max-deals}`. Keep each deal's id, title, value, currency and status.
**Step 2: Read the Pipedrive deals**
Call `pipedrive-get-deal` (Pipedrive server) with `title.contains` set to `{title-text}` and `max-records` set to `{max-deals}`. Keep each deal's id, title, value, currency and status.
**Step 3: Match and report**
Match deals on title, ignoring letter case and surrounding spaces. Report three lists: in ActiveCampaign only, in Pipedrive only, and in both. For the deals in both, show the value and currency on each side and mark any difference. If two deals on one side share a title, list them as ambiguous and do not match them.
**Rules & Guidelines:**
* `activecampaign-get-deal` is on the ActiveCampaign server. `pipedrive-get-deal` is on the Pipedrive server.
* This is read-only. Do not call `activecampaign-deal-update`, `pipedrive-update-deal`, `pipedrive-add-deal` or any other write tool.
* ActiveCampaign values may be stored in cents and Pipedrive values in whole units. State which you assumed when the numbers differ by exactly a factor of 100.
**Validation:**
* If `{title-text}` is empty, ask for it and stop.
* If either side returns nothing, say so and still report the other side as unmatched.Who it's for
One answer, three teams that use it
Sales managers
Check pipeline consistency
See which deals exist in only one CRM and where the values differ before you review the pipeline.
Compare ActiveCampaign and Pipedrive deals with Fabrikam in the title.
Account executives
Confirm your deals are in both places
Make sure the deals for one customer are recorded with the same value in both systems.
Do the Northwind deals in ActiveCampaign match the ones in Pipedrive? Check up to 10 per side.
Sales operations
Find unit and value mismatches
Find value gaps and spot when a difference is just cents versus whole units.
Reconcile deals titled Adventure Works between ActiveCampaign and Pipedrive and tell me about any value differences.
How it works
What PopdockAI does when you ask
You give some title text and your AI assistant reads the matching deals from both CRMs. It only reads, and it never matches deals whose titles repeat on one side.
Ask
You give the text to look for in deal titles and how many deals to check per side.
Read
It reads the matching deals from ActiveCampaign and from Pipedrive.
Match
It matches on title, ignoring case and spacing, and sets duplicate titles aside as ambiguous.
Report
You get deals in one system only, deals in both with values and a note on the cents assumption.
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
pipedrive-get-deal
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
See which deals exist in only one CRM
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)
