How to Import Mailchimp Data to Google Sheets

Discover how to import Mailchimp data into Google Sheets and harness the power of both platforms in your data analysis.

Table of Contents
  1. How to generate an API key
  2. How to import Mailchimp data to Google Sheets (using API key)
  3. How to import Mailchimp data to Google Sheets (without API key)
Table of contents
Chapter 1
Chapter 2
Chapter 3
  1. How to generate an API key
  2. How to import Mailchimp data to Google Sheets (using API key)
  3. How to import Mailchimp data to Google Sheets (without API key)
7 Minutes

Mailchimp, one of the most popular marketing platforms in use today, is primarily designed for email marketing. Its tools allow businesses to effectively manage their email lists and run email campaigns. In this tutorial, we will learn two ways of importing Mailchimp data to Google Sheets. Are you ready?

How to generate an API key

The first method to import Mailchimp data requires you to generate an API key. Once logged in to your Mailchimp account, click the following link:

API Keys | Mailchimp

The page will contain a list of API keys that you can use. If you are starting a new account, you will find an empty list. For our example, we already have a list of keys:

API Keys list from Mailchimp
API Keys list from Mailchimp

To generate an API key, click the Create A Key button below the list. Mailchimp will automatically generate an API key and append it at the top of the list. To copy the key, hover on the API key column and then copy the string of characters inside the textbox. 

Updated API key list with the newly-generated API key
Updated API key list with the newly-generated API key

How to import Mailchimp data to Google Sheets (using API key)

You can use the generated API key to import Mailchimp data to Google Sheets by creating a URL for accessing the data via API. The URL has the following format:

https://dc.api.mailchimp.com/3.0/data_to_be_accessed?apikey=api_key

Where:

  1. dc is for the server where your Mailchimp account is located. You can find this information by simply inspecting the address bar of the tab where your Mailchimp dashboard is currently loaded:
Mailchimp dashboard. The server name is highlighted on the address bar as it is part of the URL.
Mailchimp dashboard. The server name is highlighted on the address bar as it is part of the URL.

  1. data_to_be_accessed refers to the directory where the data you need is located. Some of the options are:

  • automations for the list of classic automations
  • campaigns for the list of campaigns
  • lists for the lists in your account
  • reports for the list of campaign reports

You can check the complete list through Mailchimp documentation:

API Root | Mailchimp Marketing API Reference | Mailchimp Developer

  1. And where api_key is the API key you generated using the steps in the previous section.

Any Google Sheets add-on that allows API string input can be used in this method. For our demonstration, we will use Mixed Analytics API Connector, which we have featured as well in previous tutorials. After inputting the URL into the add-on and loading the data, the result looks like this:

Imported Mailchimp data using API and API Connector.
Imported Mailchimp data using API and API Connector.

You can read more about Mixed Analytics API Connector here.

How to import Mailchimp data to Google Sheets (without API key)

You can also choose not to generate an API key to import Mailchimp data to Google Sheets. This is through the Coupler.io add-on.

Coupler.io
Coupler.io

After installing the add-on, click Extensions on the main toolbar, then click Coupler.io on the drop-down list. Select the Open dashboard option on the drop-down list that will appear beside it. The Coupler.io sidebar will appear on the right side of Google Sheets.

On the sidebar, click Add Importer

Coupler.io sidebar.
Coupler.io sidebar.

A large box will appear, asking you for details needed for importing data. Some of the required data are the following:

Source: this is where you specify the source of your data. A drop-down box appears first where you can select Mailchimp. You will be prompted to connect to your account. Click Connect.

Coupler.io source options. Drop-down list of source applications. Mailchimp selected.
Coupler.io source options. Drop-down list of source applications. Mailchimp selected.

A new browser window will appear where you need to log in to your Mailchimp account:

Mailchimp login page. 
Mailchimp login page. 

After logging in, authorize Coupler.io to allow it to access the data from your account by clicking Allow at the end of the page.

Authorize Coupler.io page after logging in.
Authorize Coupler.io page after logging in.

.

The window will automatically close after this process. Next, you have to specify the specific data you need to input. You can again select from a drop-down list. For our example, we want to input the list of campaigns in our Mailchimp account. Click Continue.

List of possible data entity to input from Mailchimp via Coupler.io
List of possible data entity to input from Mailchimp via Coupler.io

You will then be asked to specify details about the destination sheet. By default, your Google Sheets is selected; however, you may need to authorize Coupler.io to access your Google Sheets. You will be prompted to do so first. After that, you need to input destination details, such as the target spreadsheet and the start of range. By default, the active sheet will be selected. Click Continue after setting the information for each tab.

Destination options. Application, account, and spreadsheet specified. Cell address/Range is also specified. 
Destination options. Application, account, and spreadsheet specified. Cell address/Range is also specified. 

You will also specify whether the new data will be appended to the sheet or the entire sheet replaced for each update or refresh.

Import mode: either replace or append.
Import mode: either replace or append.

Finally, you have to specify the automatic data refresh options. To enable automatic data refresh, click the switch at the upper-right corner. This enables the automatic data refresh scheduling options. When you are done, click Save and Run.

Automatic data refresh options.
Automatic data refresh options.

The imported data looks as follows: 

Imported Mailchimp data using Coupler.io
Imported Mailchimp data using Coupler.io
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

July 31, 2022

Chart with arrows pointing up and down

Mailchimp, one of the most popular marketing platforms in use today, is primarily designed for email marketing. Its tools allow businesses to effectively manage their email lists and run email campaigns. In this tutorial, we will learn two ways of importing Mailchimp data to Google Sheets. Are you ready?

How to generate an API key

The first method to import Mailchimp data requires you to generate an API key. Once logged in to your Mailchimp account, click the following link:

API Keys | Mailchimp

The page will contain a list of API keys that you can use. If you are starting a new account, you will find an empty list. For our example, we already have a list of keys:

API Keys list from Mailchimp
API Keys list from Mailchimp

To generate an API key, click the Create A Key button below the list. Mailchimp will automatically generate an API key and append it at the top of the list. To copy the key, hover on the API key column and then copy the string of characters inside the textbox. 

Updated API key list with the newly-generated API key
Updated API key list with the newly-generated API key

How to import Mailchimp data to Google Sheets (using API key)

You can use the generated API key to import Mailchimp data to Google Sheets by creating a URL for accessing the data via API. The URL has the following format:

https://dc.api.mailchimp.com/3.0/data_to_be_accessed?apikey=api_key

Where:

  1. dc is for the server where your Mailchimp account is located. You can find this information by simply inspecting the address bar of the tab where your Mailchimp dashboard is currently loaded:
Mailchimp dashboard. The server name is highlighted on the address bar as it is part of the URL.
Mailchimp dashboard. The server name is highlighted on the address bar as it is part of the URL.

  1. data_to_be_accessed refers to the directory where the data you need is located. Some of the options are:

  • automations for the list of classic automations
  • campaigns for the list of campaigns
  • lists for the lists in your account
  • reports for the list of campaign reports

You can check the complete list through Mailchimp documentation:

API Root | Mailchimp Marketing API Reference | Mailchimp Developer

  1. And where api_key is the API key you generated using the steps in the previous section.

Any Google Sheets add-on that allows API string input can be used in this method. For our demonstration, we will use Mixed Analytics API Connector, which we have featured as well in previous tutorials. After inputting the URL into the add-on and loading the data, the result looks like this:

Imported Mailchimp data using API and API Connector.
Imported Mailchimp data using API and API Connector.

You can read more about Mixed Analytics API Connector here.

How to import Mailchimp data to Google Sheets (without API key)

You can also choose not to generate an API key to import Mailchimp data to Google Sheets. This is through the Coupler.io add-on.

Coupler.io
Coupler.io

After installing the add-on, click Extensions on the main toolbar, then click Coupler.io on the drop-down list. Select the Open dashboard option on the drop-down list that will appear beside it. The Coupler.io sidebar will appear on the right side of Google Sheets.

On the sidebar, click Add Importer

Coupler.io sidebar.
Coupler.io sidebar.

A large box will appear, asking you for details needed for importing data. Some of the required data are the following:

Source: this is where you specify the source of your data. A drop-down box appears first where you can select Mailchimp. You will be prompted to connect to your account. Click Connect.

Coupler.io source options. Drop-down list of source applications. Mailchimp selected.
Coupler.io source options. Drop-down list of source applications. Mailchimp selected.

A new browser window will appear where you need to log in to your Mailchimp account:

Mailchimp login page. 
Mailchimp login page. 

After logging in, authorize Coupler.io to allow it to access the data from your account by clicking Allow at the end of the page.

Authorize Coupler.io page after logging in.
Authorize Coupler.io page after logging in.

.

The window will automatically close after this process. Next, you have to specify the specific data you need to input. You can again select from a drop-down list. For our example, we want to input the list of campaigns in our Mailchimp account. Click Continue.

List of possible data entity to input from Mailchimp via Coupler.io
List of possible data entity to input from Mailchimp via Coupler.io

You will then be asked to specify details about the destination sheet. By default, your Google Sheets is selected; however, you may need to authorize Coupler.io to access your Google Sheets. You will be prompted to do so first. After that, you need to input destination details, such as the target spreadsheet and the start of range. By default, the active sheet will be selected. Click Continue after setting the information for each tab.

Destination options. Application, account, and spreadsheet specified. Cell address/Range is also specified. 
Destination options. Application, account, and spreadsheet specified. Cell address/Range is also specified. 

You will also specify whether the new data will be appended to the sheet or the entire sheet replaced for each update or refresh.

Import mode: either replace or append.
Import mode: either replace or append.

Finally, you have to specify the automatic data refresh options. To enable automatic data refresh, click the switch at the upper-right corner. This enables the automatic data refresh scheduling options. When you are done, click Save and Run.

Automatic data refresh options.
Automatic data refresh options.

The imported data looks as follows: 

Imported Mailchimp data using Coupler.io
Imported Mailchimp data using Coupler.io

Suscribe to get more data and analytics tips!

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.