Mailchimp API in Google Sheets

Knowledge Base

Importing Mailchimp API data to a spreadsheet doesn't have to be painful! In this guide, we'll walk you through the basics of importing Mailchimp API data to Google Sheets.

Before you begin

  1. 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"

Create an API 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"

Copy your new API Key/

In Google Sheets, go to Add-ons -> API Importer -> My Requests

mailchimp



You can run this command with =api("mailchimp")