/
/
Spot pipeline deals whose contacts are not reachable by email
For sales managers who want to check email engagement on the deals in an Attio stage, using Mailchimp data, by asking their AI assistant.
On this page
Connector
Connect Attio, pick your AI tool and paste the prompt.
The problem
Healthy looking deals with contacts you cannot reach
Managers review a pipeline stage with no idea whether the contacts on those deals are receiving or opening email, because that lives in Mailchimp. A deal can look healthy in Attio while every contact has unsubscribed or never opens.
Without PopdockAI
- List deals in a stage in Attio
- Find the contacts on each deal
- Search Mailchimp for each contact's status and opens
- Miss the deal where nobody is reachable
With PopdockAI
- Deals in the stage and their contacts are read
- Each contact's Mailchimp status and average open rate are checked
- Deals where no contact is reachable or engaged are flagged
- Not in Mailchimp is kept apart from unsubscribed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For Attio deals in stage `{deal-stage}` worth at least `{min-value}` (default 0), check whether each deal's contacts are subscribed and engaging in Mailchimp, and report which deals have cold or unreachable contacts.
**Step 1: List the deals in Attio**
Call `attio-get-record-deals` (Attio) with `deal-stage` set to `{deal-stage}` and `deal-value.min` set to `{min-value}`. Keep `deal-name`, `deal-value`, `deal-owner`, `associated-company` and `associated-people`. If none come back, say so and stop.
**Step 2: Get contact emails from Attio**
For each deal, call `attio-get-record-people` (Attio) with `company.contains` set to the deal's company and keep the people named in `associated-people`, with their `email-addresses`.
**Step 3: Check Mailchimp**
For each email call `mailchimp-get-list-member` (Mailchimp) with `email` set to that address. Keep `status`, `rating` and `average-open-rate`.
**Step 4: Report**
Give a table per deal: deal name, value, owner, each contact with Mailchimp status and open rate. Flag a deal as at risk when every contact is unsubscribed, cleaned, absent from Mailchimp or has an average open rate of zero. Order by deal value, highest first.
**Rules & Guidelines:**
* Tools whose names start with attio are on the Attio server. Tools whose names start with mailchimp are on the Mailchimp server. Both servers must be connected; if a tool from either is missing, say which server is not connected and stop.
* The join key between the two systems is the email address. Compare it case-insensitively and trimmed. Attio people can hold several emails, so match against any of them.
* Do not call any write tool on either server: `attio-add-company`, `attio-add-person`, `attio-add-deal`, `attio-update-company`, `attio-update-person`, `attio-update-deal`, `attio-upsert-company`, `attio-upsert-person`, `attio-delete-company`, `attio-delete-person`, `attio-delete-deal` (Attio), `mailchimp-add-list-member`, `mailchimp-update-list-member`, `mailchimp-add-customer`, `mailchimp-update-customer`, `mailchimp-add-segment-member`, `mailchimp-update-order`, `mailchimp-update-product`, `mailchimp-start-automation`, `mailchimp-pause-automation`, `mailchimp-replicate-campaign` (Mailchimp).
**Validation:**
* A deal with no associated people or no emails is reported as having no reachable contact, not skipped.
* A contact missing from Mailchimp is "not in Mailchimp", which is different from unsubscribed.Who it's for
One answer, three teams that use it
Sales managers
Find deals that email cannot reach
Deals are ordered by value with at risk ones flagged, so you know where to switch to calls or meetings.
Which Negotiation stage deals in Attio have contacts who are all unsubscribed or cold in Mailchimp?
Marketing managers
Support late stage deals with content
See which deals have engaged contacts and which have gone cold, so nurture goes where it helps.
Show open rates for contacts on Attio deals in Discovery worth over 5000.
Account executives
Check your deals before a follow up
Know which contacts are receiving and opening email before you rely on it for the next step.
Are the contacts on my Proposal stage deals reachable in Mailchimp?
How it works
What PopdockAI does when you ask
You name a deal stage and your AI assistant checks every contact on those deals in Mailchimp. Deals with no contacts are reported, and nothing is changed.
01
Ask
You name an Attio deal stage and optionally a minimum deal value.
02
List
It reads the deals in that stage and the contacts on each deal.
03
Check
It looks up each contact's email in Mailchimp for status and average open rate.
04
Report
You get a table per deal, highest value first, with at risk deals flagged.
What PopdockAI provides
The tools behind the answer
Ready made tools for Attio and one secure connection to your AI tool. No code, no exports.
attio-get-record-deals
attio-get-record-people
mailchimp-get-list-member
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 have unreachable contacts
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)
