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:
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:
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.
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:
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:
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.
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.
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.
A new browser window will appear where you need to log in to your Mailchimp account:
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.
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.
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.
You will also specify whether the new data will be appended to the sheet or the entire sheet replaced for each update or refresh.
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.