Mailchimp campaign metrics into Google Sheets

Getting started

We're going to use the Mailchimp API to pull live campaign metrics into Google Sheets, using the SyncWith Google Sheets Addon. You can either install the addon now, or use the steps below to get a Google Sheet with the addon installed.

Step 1

We'll test out the MailChimp API using their Ping endpoint.

Before you can use the Mailchimp API, you need to find your Mailchimp Server.

To find the value for the server parameter log into your Mailchimp account and look at the URL in your browser. You’ll see something like https://us19.admin.mailchimp.com/; the us19 part is the server prefix. Note that your specific value may be different.

Test the Mailchimp API

Please fill in any necessary fields and click Run.

Endpoint

GET

Authentication

server

Preview

View the API data, get a live Google Sheet dashboard

health_status

Get a live Google Sheet

Export your data to a google sheet, with the SyncWith Addon, or download to CSV

Automatically updated

Schedule your data to update hourly or daily

Add data sources

Import additional data from other apps

Build reports & dashboards

Easily build live reports within Google Sheets

Step 2

Now that you've identified your Mailchimp server, and confirmed your connection to their API is working, we can move onto pulling reports to get your campaign metrics.

Using the report endpoint you'll get back one row per campaign, with metrics for each campaign including number of messages sent, number of clicks, opens and more.