Measure School – How to Pull Mailchimp Data into Google Sheets with Google Apps Script ?


Google Sheets can be a great help when it comes to collecting data from different sources. It lets you connect to a variety of tools ,like Google Analytics and Google AdWords, and allows you pull in the data from there. Unfortunately, there is no direct connection yet to get campaign data from the email-marketing service Mailchimp, so we asked Ben Collins, who’s a Spreadsheet Developer & Data Analytics Expert, to help us out.

In this video, he’s going to give you an in-depth tutorial on how to pull data from the Mailchimp API and import it to Google Sheets with the help of Apps Script.