Connectors

/

Attio

/

Review Attio deal stage email engagement in Mailchimp
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Review Attio deal stage email engagement in Mailchimp
Review the Proposal stage deals over 10000 in Attio and tell me whether their contacts are engaging with our Mailchimp emails.
5 deals are in the Proposal stage over 10000, and 2 are flagged as at risk. - Northwind Traders, 18000: 2 contacts, both subscribed, open rate 41 percent - Contoso, 12500: at risk, the only contact is unsubscribed - Fabrikam, 11000: at risk, contact not in Mailchimp - Adatum, 10500: no associated people, no reachable contact Want the full table for every deal?
Attio
Sample figures. Your results come from your own account.
attio-get-record-deals
attio-get-record-people
mailchimp-get-list-member

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Attio

Attio
Run it on your own Attio data.

Connect Attio, pick your AI tool and paste the prompt.

Try PopdockAI free

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.

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

Your AI tool

02

List

It reads the deals in that stage and the contacts on each deal.

attio-get-record-deals
attio-get-record-people

03

Check

It looks up each contact's email in Mailchimp for status and average open rate.

mailchimp-get-list-member

04

Report

You get a table per deal, highest value first, with at risk deals flagged.

Your AI tool

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.

get-data

attio-get-record-deals

Returns deals from Attio CRM. Read-only; filter by the fields the tool offers.
get-data

attio-get-record-people

Returns people from Attio CRM. Read-only; filter by the fields the tool offers.
get-data

mailchimp-get-list-member

Returns the members (subscribers) of Mailchimp audiences, with subscription status, tags and engagement rating. Filter by email address or status to look someone up.
Read only.Nothing in Attio 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

See which deals have unreachable contacts

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