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:

GitHub of script:

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]);


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

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