Connectors

/

Mailchimp

/

Mailchimp campaign engagement of Granola meeting guests
Report
Cross-Connector

See which meeting guests engage with your campaigns

For marketers who want Granola meeting guests checked against Mailchimp campaign opens, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
Mailchimp campaign engagement of Granola meeting guests
For the Northwind Traders partner workshop, show which guests opened our Mailchimp campaigns in the last 90 days.
Of 4 guests at the Northwind Traders partner workshop, 2 opened a campaign in the last 90 days. - Dana Whitfield: 4 received, 3 opened, latest Autumn product update - Sam Patel: 2 received, 1 opened, latest Pricing news - Never opened: Priya Raman, 3 campaigns received - No Mailchimp activity: Lee Chen Want the campaign names for each guest?
Mailchimp
Sample figures. Your results come from your own account.
granola-get-note
granola-get-attendee
granola-get-invitee
mailchimp-get-campaign-open
mailchimp-get-campaign-recipient

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Mailchimp

Mailchimp
Run it on your own Mailchimp data.

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

Try PopdockAI free

The problem

Not knowing who in the room reads your emails

Marketers want to know whether meeting guests engage with campaigns, but the guest list is in Granola and the engagement is in Mailchimp. Checking each guest by hand is slow, so warm and cold leads stay unclear.

Without PopdockAI

  • Copy attendees and invitees from the meeting notes
  • Remove duplicates across the two lists
  • Search Mailchimp for each person's opens
  • Lose track of guests with no activity

With PopdockAI

  • Attendees and invitees are merged by email
  • Campaigns received and opened are read per person
  • Guests who never opened are listed separately
  • It stops if several meetings match and changes nothing

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 the Granola meeting matching {meeting-title}, report each attendee's and invitee's Mailchimp campaign opens and clicks over the last {lookback-days} days (default 90).

**Step 1: Find the meeting (granola)**

Call `granola-get-note` with `title.contains` set to {meeting-title}. If several match, list them and stop.

**Step 2: Collect people (granola)**

Call `granola-get-attendee` and `granola-get-invitee` with `note-id` set to the note `id`. Merge by email and drop duplicates and blanks.

**Step 3: Pull engagement (mailchimp)**

For each email call `mailchimp-get-campaign-open` with `email` set to it, and `mailchimp-get-campaign-recipient` with `email-address` set to it. Keep only activity within the lookback window. Count opens per campaign, and name the campaign.

**Step 4: Report**

Per person: campaigns received, opens, most recent campaign opened. Finish with the people who received campaigns but never opened, since they are the weakest warm leads in the room.

**Rules & Guidelines:**

* Match emails case-insensitively after trimming spaces. Granola tools (`granola-*`) are on the granola server; Mailchimp tools (`mailchimp-*`) are on the mailchimp server.
* Read-only. Do not call any write tool on the Mailchimp server (`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`, `mailchimp-update-order`).

**Validation:**

* If a person has no Mailchimp activity, say so rather than omitting them.
* If the lookback is not a number, use 90.

Who it's for

One answer, three teams that use it

Field marketers

Plan follow up by engagement

See which guests open your campaigns and which never do, so follow up fits each person.

Which guests from the Contoso product briefing opened our Mailchimp campaigns in the last 60 days?

Account executives

Know who is warm before you follow up

The most recent campaign each guest opened gives you a natural opener for the next email.

For yesterday's Fabrikam demo, what was the last Mailchimp campaign each guest opened?

Event managers

Find guests your emails are missing

Guests who received campaigns but never opened, or have no activity, are named, not left out.

Who from the Northwind Traders roadmap session has received our Mailchimp emails but never opened one?

How it works

What PopdockAI does when you ask

You give the meeting title and a lookback period, and your AI assistant checks every guest's campaign engagement. It only reads.

01

Ask

You give the meeting title and how many days to look back.

Your AI tool

02

Collect

It finds the meeting in Granola and merges attendees and invitees by email.

granola-get-note
granola-get-attendee
granola-get-invitee

03

Check

It reads each person's Mailchimp campaigns received and opened in that window.

mailchimp-get-campaign-open
mailchimp-get-campaign-recipient

04

Report

You get engagement per person and those who never opened.

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

granola-get-note

Returns Granola meeting notes with their summaries and metadata. Filter by date range, title or owner to find the meetings you need.
get-data

granola-get-attendee

Returns the people who attended each Granola meeting note, so you can see who was actually in the room.
get-data

granola-get-invitee

Returns the people invited to each Granola meeting note, so you can compare invitations with attendance.
get-data

mailchimp-get-campaign-open

Returns the members who opened each Mailchimp campaign and how many times they opened it.
get-data

mailchimp-get-campaign-recipient

Returns the members each Mailchimp campaign was sent to, with delivery status and how often each one opened it.
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.

How Popdock AI secures your data

The outcome

Warm and cold guests clear before the follow up

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