Import Mailchimp Data To Google Sheets

“What are the most essential MailChimp integrations?”
“How do I connect my Mailchimp to Google Sheets?”
“Can you link Mailchimp to Google Sheets?”

– Email marketer

Mailchimp or email marketing is one of the important channels to reach your audience. But the amount of data you need to track is overwhelming, and manual reporting is a nightmare. As marketers, we have to stay on top of everything from analytics to customer support and email campaigns.

It’s tough to juggle work when you’re also responsible for handling almost all the work, especially on the technical side. You’re switching between your Mailchimp and other tools like a headless chicken. In this article, I’ll show a simple hack on how to automate this nightmarish task.

Who Benefits from this Automation?

I see two groups that might benefit from the automation to export Gmail to Google Sheets. Both teams require time to constantly update email messages.

a) Email marketers: Email marketers are great at building newsletters for their audience. But they don’t have the time to build reports. They need to dedicate hours strategizing how to build sales funnels.

b) Email Outreach teams: An email outreach person benefits from this automation when an email campaign, especially bulk ones, has a high response rate.

Requirements

a) A Mailchimp account. It’s best to use a Mailchimp account with campaigns that have a high volume of data.

b) An Integromat account.

Why Pay for Automation at All?

Automations solve huge problems in organizations. So, most automation tools are paid products. Yes, you can do everything manually for free to save money. But in perspective, instead, you might want to spend a little to save time. The number of hours that you take back to avoid hellish and repetitive work is worth the price. You choose.

busy desktop

I hate a super cluttered desktop. Ever experienced a desktop (or Downloads folder) full of spreadsheet files? I hate them. It increases stress and productivity comes to an all-time low. The amount of time I clicked the Export CSV button is unbearable. Automation avoids all this.

What is Integromat?

Integromat is a powerful integration platform that allows you to visualize, design, and automate your work in minutes. In other words, it lets apps talk to each other so that you can remove repetitive tasks.

Integromat supports a multitude of integrations and apps across the board. From email to spreadsheets, to forms, to to-do lists, Integromat has you covered. Automate any part of your marketing operation one way or another. You’re like Iron Man with different technologies in the palm of your hand.

Create an Integromat account and get started.

How to Connect Mailchimp with Google Sheets

1 – Click on Scenarios. This is where you start building the connection between tools.

integromat 02c

2 – Once inside, click on the HUGE circle with a PLUS SYMBOL.

3 – Search for Mailchimp. Then select Get a Campaign Report.

mailchimp sheets integromat 07

Setting Up Mailchimp Connection

First is setting up the Mailchimp connection.

1 – Under Connection click on Add.

2 – Under Connection name, name the connection. The name is arbitrary so it’s up to you. But I suggest writing a descriptive name for later use.

mailchimp sheets integromat 01

3 – Click on Continue. A pop-up window appears.

4 – Inside the pop-up window, Log-in to the Mailchimp account you want to get data from.

5 – After which, click on Allow. Integromat asks permission to access your Mailchimp account. This is standard procedure. The window closes after clicking it.

mailchimp sheets integromat 02

6 – Back in Integromat, under Campaign ID, select the Mailchimp campaign you want to get data from. Note that yours is different so you need to familiarize yourself with the campaign names.

mailchimp sheets integromat 04

7 – Click on OK.

Done! At this point, you’re finished with the Mailchimp connection side. The tool prompts you if there are missing values in the fields.

Setting Up Google Sheets Connection

Next is setting up the Google Sheets connection. But first, you need to go to Google Drive and create a new Google Sheets file.

1 – Go to your Google Drive workspace.

2 – Click on + New then create a new Google Sheets file.

tmr 0
tmr 00

3 – Name the Google Sheets file. The name is arbitrary so it’s up to you. But I suggest writing a descriptive name for later use.

integromat 07 sheets

4 – Name the tab or sheet on the bottom. The name is arbitrary so it’s up to you. But I suggest writing a descriptive name for later use.

integromat 07 sheets2

5 – Name the headers. It’s helpful to map out the correct data point in the integration process later.

Column A
Column B
Column C
Column D

integromat 07 sheets3

The first steps are done! Go back to Integromat.

1 – Press right-click. Click on + Add a module. Or you can double-click then click on the HUGE circle with a PLUS SYMBOL.

2 – Search for Google Sheets. Then select Add a Row.

mailchimp sheets integromat 06

3 – Under Connection, click on Add.

4 – Name the connection. The name is arbitrary so it’s up to you. But I suggest writing a descriptive name for later use.

gmail to sheets integromat 12b

5 – Click on Continue. A pop-up window appears.

6 – Inside the pop-up window, select the Gmail account that stores the Google Sheets file.

integromat 04

7 – Click on Allow. Integromat asks permission to access your Google account. This is standard procedure. The window closes after clicking it.

gmail to sheets integromat 13

8 – Back in Integromat, under Mode, choose Select spreadsheet and sheet. This is to make the integration simpler.

9 – Under Spreadsheet, select the Google Sheets file you created earlier. Find the name you gave it.

10 – Under Sheet, select the Google Sheets tab from earlier. Find the name you gave it. After which, the Values are created.

integromat 07 sheets5

11 – Under Values is where it gets tricky. The headings from the Google Sheets file are the parameters where you decide the values. Once you click on the field, you’re presented with different parameters. Don’t be overwhelmed. Read the context of the parameters to know which one is mapped to which.

integromat 07 sheets7

Under (A), select Campaign Title.
Under (B), select Opens: Open Rate.
Under (C), select Clicks: Clicks Total.
Under (D), select Ecommerce: Total Orders.

The parameters that appear here are from the Mailchimp API connection. Other parameters are also available. Make sure to add an extra column and name it on the Google Sheets spreadsheet so on and so forth.

12 – Click on Continue. Now it’s time to run and process the integration.

13 – Click on Run once with a play button icon.

integromat 06

A spinning wheel and a Log on the bottom right appear. Wait for the integration to finish. How long the integration takes depends on the Maximum number of results you select. It’s finished when a) green checkmarks appear, and when b) The scenario run was completed appears in the Log.

mailchimp sheets integromat 08

Go to your Google Sheets file and you now see the organic posts successfully exported from Mailchimp. Viola! Congratulations you imported Mailchimp campaign reports to Google Sheets with complete information! You may also add other parameters or fields if you need them.

Schedule Automation and Reports

Integromat can schedule the automation based on cycles. The schedule is up to you.

1 – On the screen, click on the Scheduling button and turn it on.

integromat 06

2 – Under Run scenario, select the schedule you need. What you select on this parameter dictates the next ones.

If you select At regular intervals, you need to select the minutes that Integromat processes the automation.

If you select Once, you need to select the date.

If you select Every day, you need to select the time.

If you select Days of the week or Days of the week, you need to select the days.

gmail to sheets integromat 18b

3 – Click on Activate. Ignore any advanced settings for now.

Viola! Congratulations you’re automating sending Mailchimp data to Google Sheets!

More articles on automation:
Import Shopify Data to Google Sheets
Import Google Ads Data to Google Sheets
Import WooCommerce Data to Google Sheets
Import Facebook Page Insights to Google Sheets
Import LinkedIn Ads API Data to Google Sheets
Import Facebook Ads Data to Google Sheets
Import Mailchimp Data To Google Sheets
Export Gmail to Google Sheets

Conclusion: Send Mailchimp Data to Google Sheets

This is one of the many add-ons to connect Mailchimp campaigns data in Google Sheets. These are the methods that integrate third-party tools. These add-ons cost money, but the benefits outweigh more. Avoid import and export hell. Stop wasting time on repetitive tasks and start taking action.

Running a business is a never-ending cycle of work. This no-code solution doesn’t need you to learn coding or Python. It’s frustrating to juggle all of your responsibilities. Invest in tool automation and avoid repetitive tasks. Integrate apps you use every day. Time is precious for you so get back to doing what matters most: growing your business.


About The Author

Francis Angelo Reyes

Francis is the owner and runs Lupage Digital. With 5 years of experience, Francis writes everything he knows about digital marketing. There’s a large knowledge gap between developers and digital marketers. Francis is the middleman between where the non-technical and technical meet.