Mailchimp

Mailchimp is an email marketing platform that lets you manage audiences, send campaigns, and track performance. Connecting Mailchimp to Coupler.io lets you export your contacts, campaign reports, automations, and audience insights into the tools you already use — automatically and without code.

Why connect Mailchimp to Coupler.io?

• Centralize your email data — pull contacts, campaign reports, and audience growth into Google Sheets, BigQuery, Excel, or Looker Studio in one place

• Automate reporting — schedule regular exports so your dashboards always reflect the latest campaign performance

• Combine with other sources — use Append or Join transformations to merge Mailchimp data with CRM, ad, or website analytics data

• Send data to AI tools — route campaign performance data to ChatGPT, Claude, Gemini, Perplexity, or Cursor for AI-driven analysis

Prerequisites

• An active Mailchimp account (any plan)

• Admin or Manager-level access to the Mailchimp account you want to connect — read-only access may cause permission errors

• A Coupler.io account

Quick start

If you want campaign performance data, start with the Campaigns report entity — it gives you open rates, click rates, and delivery stats in one place without needing to join multiple entities.

How to connect

1

Create a new data flow. In Coupler.io, click Add data flow, then search for and select Mailchimp as your source.

2

Authorize your Mailchimp account. Click Connect and sign in to Mailchimp via the OAuth popup. Coupler.io will request read access to your account data. Once authorized, your account will appear in the source settings.

3

Select an entity. Choose the data entity you want to export — for example, Campaigns report, Audience (list of contacts), or Audience growth history. If you select an audience-level entity, also pick the specific audience from the dropdown.

4

Choose your destination. Select where you want the data sent — Google Sheets, Excel, BigQuery, Looker Studio, or an AI destination like ChatGPT or Claude — and configure the destination settings.

5

Run the data flow. Click Run to execute a manual run. Once it completes successfully, your data will appear in the destination.

Available entities

Entity	What it contains
Audience (list of contacts)	All contacts in an audience with profile and subscription data
Audience activity	Per-contact activity events (opens, clicks, etc.)
Audience clients	Email client usage breakdown for an audience
Audience growth history	Monthly subscriber/unsubscribe counts over time
Audience interest categories	Interest groups defined in an audience
Audience locations	Geographic distribution of audience contacts
Automations	Automation workflows and their settings
List of audiences	All audiences in your Mailchimp account
Campaigns	Campaign metadata (name, status, type, send time)
Campaigns report	Aggregated performance metrics per campaign