Add subscribers to Mailchimp when Trello cards are moved to lists

Add subscribers to Mailchimp when Trello cards are moved to lists
3 min. read

In this guide, we will look at an example of creating or changing the status of a subscriber in MailChimp, at the moment when the card in Trello got into a certain column. You can also set up similar links with MailChimp, with other CRM systems, or when creating a card in Trello, the configuration will be similar.

In Trello, you must have custom fields where the email will be stored. There are no standard fields in Trello for this. The email itself must be in a separate field, putting it in the description, you will not be able to pass the data (only if there is nothing else in the description besides the email itself)

Before creating bundles, connect the services to Albato:

  • Connecting Trello
  • Connecting MailChimp

In the top menu open «My Bundles» tab and click «Create a bundle» button. Select Trello as the data source service and «Card moved from list to list» event to trigger the bundle. Then specify your Trello connection, as well as Board, click on «Continue».

Снимок экрана 2022-04-29 в 10.39.43.png

Next set up the service to receive the data. Select «Find card by ID» as an action and specify your Trello account, as well as Board. This is necessary to immediately add an additional action «Find card by ID». The fact is that initially, when moving the card to Trello, its additional fields and description do not come, to get them, you need to make an additional request. If you want to transfer data when creating a card, then you can immediately select MailChimp in «Send data to» and go to the settings of the MailChimp step. Click on «Continue»:

Снимок экрана 2022-04-29 в 10.48.10.png

Now we proceed to filling in the bundle fields. Enter the «Card ID» parameter in the «ID» field from the drop-down list on the right and click on «Continue»:

Снимок экрана 2022-04-29 в 10.51.33.png

Adding the MailChimp step to a bundle

Now that the bundle is created, add an action with the MailChimp service. Click on the «+» and select an Action:

Снимок экрана 2022-04-29 в 10.53.21.png

Choose MailChimp, Select «Add list member» as an action and your MailChimp connection. Select your list to enter subscribers in, if it is not visible, click «Refresh data»:

Снимок экрана 2022-04-29 в 11.02.25.png

Set up the required step fields. Select which field to pass which parameter from Trello to. There are two drop-down lists on the right: the first is the initial data about the card, and the second is the card data with already custom fields. For example, in the «Email» field, pass the «Email» parameter from Trello by selecting it in the second drop-down list:

Снимок экрана 2022-04-29 в 11.04.31.png

In the «Status for new subscribers» field, select from the list the status with which you want to create new subscribers, if the email is sent for the first time:

Снимок экрана 2022-04-29 в 11.05.53.png

In the «Status for existing subscribers» field, select the status to transfer subscribers to from the list if a duplicate email is found:

Снимок экрана 2022-04-29 в 11.07.18.png

You can also fill in other fields as desired, including custom fields in your MailChimp list:

Снимок экрана 2022-04-29 в 11.08.55.png

After filling in all the fields click on «Save».

Additional bundle settings

Now, if necessary, you can configure the incoming data filter so that only the necessary cards from Trello are included in the bundle. If you have the «Card created» event, you don’t need to configure the filter — this bundle will always be triggered for new cards only. If you have the «Card moved from list to list» event, then you need to configure the filter so that only cards from a certain stage are included in the bundle. This way, you can make several similar bundles, and depending on which column the card falls into, you can record subscribers in different sheets.

Open the link to the parameters of the selected «Trello» connection:

Снимок экрана 2022-04-29 в 11.11.31.png

Open the «Boards» tab:

Снимок экрана 2022-04-29 в 11.12.46.png

Select the Trello column you need from the «Lists» column and copy its ID. For example, the column «To MailChimp «ID is» 626b24da2ff8503c2731603e»:

Снимок экрана 2022-04-29 в 11.14.07.png

Go back to the created bundle and open the incoming data filter:

Снимок экрана 2022-04-29 в 11.15.27.png

Click on the «Add condition» button and select the «Current list ID» condition from the list. In the right field, paste the column ID you copied. In our case, it is «626b24da2ff8503c2731603e»:

Снимок экрана 2022-04-29 в 11.19.16.png

If necessary, you can also add conditions for other fields. Read more about the filter here.

After setting up the filter, click «Save».

Done! The bundle is created, don’t forget to run it:

Снимок экрана 2022-04-29 в 11.21.09.png

After running the bundle, all cards that fall into the selected column will automatically create or update the subscriber status in MailChimp, taking Email From Trello. You can make several such bundles, on different Trello boards/columns, and select different subscriber lists in MailChimp.