Connectors

/

Bloomerang

/

Add missing Bloomerang donors to a Mailchimp audience
Write
Cross-Connector

Bring recent Bloomerang donors into your Mailchimp audience

For nonprofit marketing teams who want recent donors in Mailchimp with consent respected, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Add missing Bloomerang donors to a Mailchimp audience
Add Bloomerang donors since January 1 to our Mailchimp audience Supporters, as pending.
36 donors since January 1 are not yet in the Supporters audience. - Status: pending, which sends a double opt-in email - Already in the audience: 112, left as they are - No email: 4 donors, skipped - Example: Sam Patel, sam@contoso.com Shall I add the 36 as pending?
Bloomerang
Sample figures. Your results come from your own account.
mailchimp-get-list
bloomerang-get-transaction
bloomerang-get-constituent
mailchimp-get-list-member
mailchimp-add-list-member

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Bloomerang

Bloomerang
Run it on your own Bloomerang data.

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

Try PopdockAI free

The problem

New donors miss your appeals because they are not in Mailchimp

New and recent donors often never reach your Mailchimp audience, so they miss updates and appeals. Adding them by hand means exporting gifts, checking each email and not re-adding anyone who unsubscribed or was cleaned.

Without PopdockAI

  • Export recent gifts from Bloomerang
  • Search the Mailchimp audience for each email
  • Work out who unsubscribed or was cleaned
  • Pick a member status and hope it is right

With PopdockAI

  • Recent donors are collected, ignoring refunds
  • Anyone already in the audience is left alone, whatever their status
  • Pending, with double opt-in, is the default status
  • Nothing is written until you confirm who and with what status

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 Bloomerang constituents who gave since `{since-date}` (default 12 months ago) and are not in the Mailchimp audience `{list-name}`, and add them with status `{member-status}` (default pending, which sends a double opt-in email) after the user confirms.

**Step 1: Find the audience**

Call `mailchimp-get-list` with `name` set to `{list-name}`. If nothing matches, retry with `name.contains`, list the audiences found and stop. Note the list-id.

**Step 2: Find recent donors in Bloomerang**

Call `bloomerang-get-transaction` with `date.from` set to `{since-date}` and collect the distinct account-ids, ignoring refunded transactions. Call `bloomerang-get-constituent` with `id` for each to get first-name, last-name, full-name and primary-email. Skip constituents with no email and count them.

**Step 3: Find who is missing from the audience**

For each donor call `mailchimp-get-list-member` with `email` and `list-name` set to `{list-name}`. A donor already in the audience is not missing, whatever their status. Never re-add someone who is unsubscribed or cleaned.

**Step 4: Confirm**

Show the user the donors you will add (name, email) with the count and the status they will get. Remind them that subscribed should only be used for people who have agreed to receive marketing email. Do not write anything until the user says yes.

**Step 5: Write**

For each confirmed donor call `mailchimp-add-list-member` once with `list-id`, `email-address`, `first-name`, `last-name` and `status` set to `{member-status}` (pending if blank).

**Step 6: Report**

Added, already in the audience, skipped for no email, and any failures with their error.

**Rules & Guidelines:**

* Tools starting bloomerang- are on the bloomerang server; tools starting mailchimp- are on the mailchimp server.
* The only write allowed is `mailchimp-add-list-member`, once per confirmed donor, after confirmation. Do NOT call `mailchimp-update-list-member`, `mailchimp-add-segment-member` or any Bloomerang write tool.

**Validation:**

* If Mailchimp rejects a member as already existing or as previously unsubscribed, report it and continue with the rest.
* Match emails case-insensitively.
* If the transaction read hits its `max-records` limit, say some donors may be missed.

Who it's for

One answer, three teams that use it

Communications managers

Reach every new donor

Recent donors join the audience your appeals and newsletters go to.

Add Bloomerang donors since 1 September to our Mailchimp audience Friends of Contoso, as pending.

Development directors

Grow your supporter audience

Donors with no audience record are added after you review the list.

Which Bloomerang donors from this year are not in our Mailchimp audience Supporters?

Compliance leads

Never re-add an opt-out

Existing members are untouched, so unsubscribed and cleaned contacts stay that way.

Add new Bloomerang donors to Mailchimp but leave anyone already in the audience alone.

How it works

What PopdockAI does when you ask

You name the Mailchimp audience, a start date and a status, and your AI assistant finds recent Bloomerang donors to add. Nothing is written until you have seen the list and said yes.

01

Ask

You name the Mailchimp audience, a start date and the member status.

Your AI tool

02

Find

It collects recent Bloomerang donors, ignoring refunds.

bloomerang-get-transaction
bloomerang-get-constituent

03

Check

Anyone already in the audience is left alone, whatever their status.

mailchimp-get-list
mailchimp-get-list-member

04

Confirm

You see who will be added and with what status, then say yes.

Your AI tool

What PopdockAI provides

The tools behind the answer

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

get-data

mailchimp-get-list

Returns Mailchimp lists (audiences) with member counts, open and click rates, and recent campaign activity.
get-data

bloomerang-get-transaction

Returns gift transactions from Bloomerang. Filter by date range, amount range, payment method, transaction number, or whether the gift has been refunded.
get-data

bloomerang-get-constituent

Returns constituents from Bloomerang: the donors, prospects and contacts in your database. Filter by full name, last name, account number, primary email, city, type or status, or fetch one by id.
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.
run-action

mailchimp-add-list-member

Adds a contact to a Mailchimp audience with an email address, name and subscription status.
Read only.Nothing in Bloomerang 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

Recent donors in your audience, consent respected

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