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 variation 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.

le Sheets can be a great help when it comes to collecting data from different sources. It lets you connect to a variation 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.