Integration spotlight: Mailchimp

Overview

Want to manage your Mailchimp CRM from a spreadsheet? Well, that’s exactly what you can do using our Mailchimp integration :smile:.

Functions

To help you manage your MailChimp CRM, our integration has the following functions:

Function Description
GET_LIST_MAILCHIMP Get an overview of a Mailchimp list’s stats.
GET_LISTS_MAILCHIMP Get your Mailchimp lists.
GET_SUBSCRIBERS_MAILCHIMP Get subscribers from a Mailchimp List.
SUBSCRIBE_MAILCHIMP Add a subscriber to a Mailchimp list.
UNSUBSCRIBE_MAILCHIMP Remove a subscriber from a Mailchimp list.

:memo:Note: Just be aware that Mailchimp uses the term list and audience interchangeably. So whenever you see that you need the ID or name of a list, it means Audience ID.

GET_LIST_MAILCHIMP

Use GET_LIST_MAILCHIMP to get key statistics and information about a list. For example, the number of subscribers and list owner details. Use these recommended rows to make your life a bit easier:

  • List statistics to get the number of subscribers and the list’s creation date.
  • List contact info to get the contact info of the list’s owner.
  • List defaults to get the default name and email address of the list.

Syntax

GET_LIST_MAILCHIMP(list)

Parameter Mandatory Description
list Yes The MailChimp list name or ID. For example: "Summer 2020" or "27b4c4a3ce".

Example

To get details about a list with an ID of 27b4c4a3ce:

=GET_LIST_MAILCHIMP("27b4c4a3ce")

Get list example

GET_LISTS_MAILCHIMP

Use GET_LISTS_MAILCHIMP to get all your Mailchimp lists. To quickly get the list ID, name, and some key stats, use the Lists recommended table.

Syntax

GET_LISTS_MAILCHIMP([created_after])

Parameter Mandatory Description
created_after No Use to get lists created after a given date. For example: "2018-10-20".

Example

To get all your Mailchimp lists:

=GET_LISTS_MAILCHIMP()

To get all you Mailchimp lists created after 2020-01-02:

=GET_LISTS_MAILCHIMP("2020-01-01")

Get lists example

GET_SUBSCRIBERS_MAILCHIMP

Use GET_SUBSCRIBERS_MAILCHIMP to get all the subscribers in a given list. To make things a bit easier, try using these recommended tables:

  • Emails to get the email address of all your subscribers
  • Names and contact info to quickly get the names, addresses, and phone numbers of the subscribers.

Syntax

GET_SUBSCRIBERS_MAILCHIMP(list, [page], [status])

Parameter Mandatory Description
list Yes The Mailchimp Audience ID. For example: "27b4c4a3ce".
page No The page of results to get, starting at 0. Each page returns 10 records. For example: "1" returns results 11-20.
status No Status of the subscribers to get. Choose either:- "subscribed"- "unsubscribed"

Example

To get all the subscibers in for your list with an ID of 27b4c4a3ce:

=GET_SUBSCRIBERS_MAILCHIMP("27b4c4a3ce")

To get subscribers 1-10 (that is, from the first page) in your list with an ID of 27b4c4a3ce that are subscribed:

=GET_SUBSCRIBERS_MAILCHIMP("27b4c4a3ce",0,"subscribed")

Get subscribers example

SUBSCRIBE_MAILCHIMP

Use SUBSCRIBE_MAILCHIMP when you want to add new contacts to a list. The Subscriber status recommended row is pretty useful here if you need to get the generated ID, email address, and status of your created contact.

Syntax

SUBSCRIBE_MAILCHIMP(list, email, [status], [firstName], [lastName], [update])

Parameter Mandatory Description
list Yes The Mailchimp Audience name or ID. For example: "Summer 2020" or "27b4c4a3ce".
email Yes The email address of the subscriber to add. For example: "john@doe.com".
status No Status for the new subscriber. Choose either:- "subscribed" (default)- "pending"- "cleaned"
firstName No Subscriber’s first name. For example: "John".
lastName No Subscriber’s last name. For example: "Snow".
update No Indicates whether to update the status of the subscriber. Choose either:- "true" (default) to updates the status- "false" to not update the status

Examples

To add a new subscriber whose email is d***********@gmail.com to a list with the ID of 27b4c4a3ce:

=SUBSCRIBE_MAILCHIMP("27b4c4a3ce","d***********@gmail.com")

To add a new subscriber whose email is d***********@gmail.com to a list with the ID of 27b4c4a3ce with a status of subscribed, a first name of John and a last name of Doe:
=SUBSCRIBE_MAILCHIMP("27b4c4a3ce","d***********@gmail.com","subscribed","John","Doe",false)

Subscribe example

UNSUBSCRIBE_MAILCHIMP

Use UNSUBSCRIBE_MAILCHIMP when you want to unsubscribe a contact from a Mailchimp list. You can then use the Subscriber status recommended row to quickly check their ID, email address, and subscription status.

Syntax

UNSUBSCRIBE_MAILCHIMP(list, email)

Parameter Mandatory Description
list Yes The Mailchimp Audience name or ID. For example: "Summer 2020" "27b4c4a3ce".
email Yes The email address of the subscriber to remove. For example: "john@doe.com".

Example

To unsubscribe d***********@gmail.com from a list with an ID of 27b4c4a3ce:

=UNSUBSCRIBE_MAILCHIMP("27b4c4a3ce","d***********@gmail.com")

Unsubscribe example

Summary

Now it shouldn’t be a problem for you to manage your Mailchimp lists quickly and easily straight from a spreadsheet. And, if you want to get more info on your subscribers, then you really need to check out our Enrich Mailchimp subscribers template.

Right, well then, get going - get building :rocket:!

1 Like