Report

Cross-Connector

Catch people who unsubscribed in Mailchimp but not in HubSpot

For marketing teams who want consent gaps between Mailchimp and HubSpot found before anyone is emailed again, by asking their AI assistant.

Reconcile Mailchimp unsubscribes with HubSpot consent

Check whether people who unsubscribed in Mailchimp in the last 30 days are still subscribed in HubSpot.

58 people unsubscribed in Mailchimp in the last 30 days. - Still subscribed in HubSpot: 14, such as Jordan Lee - On an open deal: 5, owned by Sam Patel and Dana Whitfield - Not in HubSpot: 9 Nothing was changed. Want the 14 still subscribed contacts?

Mailchimp

Sample figures. Your results come from your own account.

mailchimp-get-campaign-unsubscribe

hubspot-get-contacts

hubspot-get-contact-subscriptions

hubspot-get-deals

On this page

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Mailchimp

Run it on your own Mailchimp data.

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

The problem

Unsubscribed in Mailchimp, still subscribed in HubSpot

Someone who unsubscribes in Mailchimp can still look subscribed in HubSpot, and may even sit on an open deal. Without a regular check, the CRM keeps emailing people who asked you to stop.

Without PopdockAI

Export recent unsubscribes from Mailchimp
Search HubSpot for each email
Check subscription status, owner and deals
Find the gaps only after a complaint

With PopdockAI

Recent unsubscribes are read, optionally for one campaign
Each email is checked for HubSpot subscriptions and owner
Open deals are shown, still subscribed people first
It never changes a subscription

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt

**Objective:** Find everyone who unsubscribed in Mailchimp in the last `{lookback-days}` days (default 30 if blank) and check whether HubSpot still treats them as reachable, optionally limited to campaigns whose name contains `{campaign-name}`.

**Step 1: Recent Mailchimp unsubscribes**

Call `mailchimp-get-campaign-unsubscribe` with `unsubscribe-date.from` set to today minus the lookback. If `{campaign-name}` is not blank, also set `campaign-name.contains` to it. Note `email`, `unsubscribe-date`, `reason` and `campaign-name`. If nothing comes back, report that there were no unsubscribes in the window and stop.

**Step 2: Carry each email into HubSpot**

For each distinct `email`:

* Call `hubspot-get-contacts` with `email` set to it. Note `record-id`, `contact-owner`, `lifecycle-stage` and `company-id`. If none comes back, record the person as "Not in HubSpot" and move on.
* Call `hubspot-get-contact-subscriptions` with `recipient-email` set to it. Record each subscription's `name` and `status`.
* If the contact has a `company-id`, call `hubspot-get-deals` with `company-id` set to it and count deals whose `deal-stage-name` is not a closed stage.

**Step 3: Report**

A table with columns: email, unsubscribed on, campaign, reason, HubSpot owner, HubSpot subscriptions still subscribed, open deals. Sort rows that are still subscribed in HubSpot first, then rows with open deals. Below the table give the counts: total unsubscribes, still subscribed in HubSpot, on an open deal, not in HubSpot.

**Rules & Guidelines:**

* `mailchimp-get-campaign-unsubscribe` is on the Mailchimp server; the hubspot- tools are on the HubSpot server.
* Match on email address only, compared case-insensitively with surrounding spaces trimmed. Never match on name alone.
* This prompt is read-only. Do not call `hubspot-add-contact`, `hubspot-update-contact`, `hubspot-add-contact-note`, `hubspot-add-company`, `hubspot-update-company`, `hubspot-add-company-note`, `hubspot-add-deal`, `hubspot-update-deal`, `hubspot-add-deal-note`, `hubspot-add-ticket`, `hubspot-update-ticket` or `hubspot-add-ticket-note` on HubSpot, and do not call `mailchimp-add-list-member`, `mailchimp-update-list-member`, `mailchimp-add-customer`, `mailchimp-update-customer`, `mailchimp-add-segment-member`, `mailchimp-start-automation`, `mailchimp-pause-automation`, `mailchimp-replicate-campaign`, `mailchimp-update-product` or `mailchimp-update-order` on Mailchimp.
* Do not change anyone's subscription status. This prompt only reports; the user decides what to change.

**Validation:**

* If `hubspot-get-contact-subscriptions` returns nothing for an email, show "No HubSpot subscriptions" rather than treating them as subscribed.
* If the same email unsubscribed from more than one campaign, show one row with the most recent date and list the campaigns.

Who it's for

One answer, three teams that use it

Marketing operations

Audit consent across tools

See who is still subscribed in HubSpot after opting out in Mailchimp, with counts for each group.

Who unsubscribed in Mailchimp this quarter but is still subscribed in HubSpot?

Privacy officers

Find consent conflicts fast

A single table puts the people most at risk of an unwanted email first.

Check whether last week's Mailchimp unsubscribes are still marked subscribed in HubSpot.

Sales managers

Warn owners about opted out deal contacts

People on open deals are listed with their owner, so reps know to avoid email.

Which Mailchimp unsubscribes from the Product Update campaign are on open HubSpot deals?

How it works

What PopdockAI does when you ask

You set a lookback period, and your AI assistant checks every recent unsubscribe in HubSpot. It only reads, so you decide what to fix.

Ask

You set a lookback period and optionally a campaign.

Your AI tool

Read

It takes recent Mailchimp unsubscribes.

mailchimp-get-campaign-unsubscribe

Check

Each email is checked in HubSpot for subscriptions, owner and open deals.

hubspot-get-contacts

hubspot-get-contact-subscriptions

hubspot-get-deals

Report

You get one table, still subscribed first, with counts per group.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Mailchimp and one secure connection to your AI tool. No code, no exports.

get-data

mailchimp-get-campaign-unsubscribe

Returns the members who unsubscribed from each Mailchimp campaign, with the date and the reason they gave.

get-data

hubspot-get-contacts

Returns contact records from HubSpot CRM, with email, phone, company, lifecycle stage, lead status, owner and location from the HubSpot connector. Filter by company id, state region, contact owner, email, last name, create date, company name, record id, lifecycle stage, lead status.

get-data

hubspot-get-contact-subscriptions

Returns each recipient's email subscription statuses and legal basis from the HubSpot connector. Filter by id, name, status, recipient email.

get-data

hubspot-get-deals

Returns deals from HubSpot CRM, with amount, stage, pipeline, close date, owner and associated company and contact from the HubSpot connector. Filter by pipeline name, close date, deal stage name, deal type, record id, company id, deal name, amount, deal owner.

Read only.Nothing in Mailchimp 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.

The outcome

Consent gaps caught before the next email

Related use cases

More ways to put this data to work

Route Mailchimp campaign clickers to HubSpot owners

Ask your AI to route a Mailchimp campaign's clickers to HubSpot owners and it groups them by owner with lifecycle stage and open deals, creating nothing.

Learn More

Add Mailchimp store customers missing from HubSpot

Ask your AI to find Mailchimp store customers over a spend threshold who are not in HubSpot, and it creates only the contacts you confirm, with no duplicates.

Learn More

Log Mailchimp campaign clicks as HubSpot contact notes

Ask your AI to log a Mailchimp campaign's clicks in HubSpot and it adds one note per contact with the links clicked, after you review and confirm every note.

Learn More

Check Mailchimp reachability for overdue HubSpot invoices

Ask your AI to check overdue HubSpot invoices against Mailchimp and it classes each billing contact as reachable, doubtful or unreachable, with balances per class.

Learn More

Add a contact to a Mailchimp audience safely

Ask your AI to add someone to a Mailchimp audience and it checks for an existing member, refuses to re-add anyone who opted out, and writes only after you confirm.

Learn More

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.