MailChimp Data/Looker Studio Connection for Google Sheets

Ben Collins is my hero and has created both a campaign data connector and an audience data connector.

Original Article: https://measureschool.com/mailchimp-data-into-google-sheets/

GitHub of script: https://github.com/benlcollins/apps_script_apis/blob/master/api_002_mailchimp/measureSchool3.gs

Important Notes

• Change API_KEY and LIST ID fields to desired accounts list and API keys.
• For audience data, fields that are used to get the growth history have been deprecated. You must replace

      monthlyGrowth.push([el.month, el.existing, el.optins, el.imports]);

to

      monthlyGrowth.push([el.month, el.subscribed, el.unsubscribed]);

Another shout out to Ben Collins – I love this thing!