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
- 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]);
monthlyGrowth.push([el.month, el.subscribed, el.unsubscribed]);
Another shout out to Ben Collins – I love this thing!