Before you begin
- Install API Importer for Google Sheets
The following guide is based on the Mailchimp Docs
Create an API Key
Navigate to https://admin.mailchimp.com/account/api and click "Create A Key"
Copy your new API Key
That was easy!. Please note that your API key will end in the datacenter your requests are being routed through. In our case, ours ends in "us19". The url you call needs to have that value in it: e.g. "https://us19.api.mailchimp.com/3.0"
In Google Sheets, go to Add-ons -> API Importer -> My Requests