/
/
Reconcile ActiveCampaign deals with Capsule CRM opportunities
For sales teams who keep deals in two systems and want their AI assistant to flag value, stage and outcome differences.
On this page
Connector
Connect ActiveCampaign, pick your AI tool and paste the prompt.
The problem
Deals in two systems that no longer agree
ActiveCampaign deals and Capsule CRM opportunities describe the same work but drift apart in value and stage. Finding each match by hand takes a customer lookup and a search for every deal, and the forecast suffers.
Without PopdockAI
- Open each deal in ActiveCampaign
- Find the customer in Capsule CRM
- Search for the matching opportunity
- Compare value and stage and repeat for every deal
With PopdockAI
- Deals are read with a status and cap you choose
- Each customer is matched by email in Capsule CRM
- Only clear opportunity matches are accepted
- Value, currency and stage differences are flagged, with no writes
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For ActiveCampaign deals with status `{deal-status}` (default 0 for open; use 1 for won, 2 for lost), find the Capsule CRM opportunity for the same customer and report mismatches, for up to `{max-deals}` deals (default 20).
**Step 1: Read the deals**
Call `activecampaign-get-deal` (ActiveCampaign server) with `status` set to `{deal-status}` and `max-records` set to `{max-deals}`. Keep `id`, `title`, `value`, `currency`, `primary-contact-id`, `stage-id` and `status`.
**Step 2: Resolve each deal's customer**
Call `activecampaign-get-contact` (ActiveCampaign server) with `id` set to the deal's `primary-contact-id` to get the `email`. Then call `capsule-crm-get-party` (Capsule CRM server) with that `email`. If no party is found, record the deal as "customer not in Capsule CRM" and move on.
**Step 3: Find the opportunity**
Call `capsule-crm-get-opportunity` (Capsule CRM server) with `party-name.contains` set to the party `name` and `name.contains` set to the deal `title`. If nothing matches, retry with only `party-name.contains`. Accept a match only when the name or title is clearly the same piece of work; otherwise record "no matching opportunity" and list any candidates.
**Step 4: Report**
One row per deal: deal title, ActiveCampaign value, Capsule `value`, Capsule `milestone-name`, Capsule `closed-on-date`, and a status (aligned, value differs, stage or outcome differs, no opportunity, customer missing). Finish with counts per status.
**Rules & Guidelines:**
* `activecampaign-*` tools belong to the ActiveCampaign server and `capsule-crm-*` tools to the Capsule CRM server; both must be connected.
* This prompt is read-only. Never call any add, update, delete, sync or move tool on either server.
**Validation:**
* Compare values only when both sides use the same currency; otherwise flag the currency instead.
* The ActiveCampaign `value` may be stored in cents; say which assumption you used if the numbers are exactly 100 times apart.
* If either system returns no deals or opportunities, say so and stop.Who it's for
One answer, three teams that use it
Sales managers
Clean up the forecast before the review
See which deals disagree between the two systems so the numbers you present are the right ones.
Reconcile open ActiveCampaign deals with Capsule CRM opportunities before Friday's forecast call.
Account executives
Check your deals line up
Confirm each of your deals has a matching opportunity with the same value and stage.
Check my 10 open ActiveCampaign deals against Capsule CRM and show any that do not match.
Revenue operations
Review won deals for consistency
Check won deals match their opportunities so reporting on closed revenue is consistent.
Reconcile won ActiveCampaign deals (status 1) with Capsule CRM opportunities for the last 20 deals.
How it works
What PopdockAI does when you ask
You pick the deal status and your AI assistant matches each deal to a Capsule CRM opportunity. It only reads, and a cents mismatch is called out rather than assumed.
Ask
You choose the deal status (open, won or lost) and how many deals to check.
Resolve
It reads the ActiveCampaign deals and finds each customer in Capsule CRM by email.
Match
It looks for the opportunity by customer and name, accepting only clear matches.
Report
You get one row per deal with a status and counts, flagging value, currency and stage gaps.
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
activecampaign-get-contact
capsule-crm-get-party
capsule-crm-get-opportunity
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
A forecast you can fix at the source
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)
