DEV Community

Derrick Sherrill for WayScript

Posted on

How to Automate Reading & writing Mailchimp Subscribers from Google Sheets

Introduction

Tools available to help you better engage with customers are evolving quickly allowing you to make the most out of them and reach your business goals. However, some tasks can be repetitive.

Today we’ll build a script to read or write Mailchimp subscribers from Google Sheet.

Prerequisites

Trigger

A trigger is an event that makes your script run automatically without your supervision or any manual action. Wayscript provides a Google Sheet Trigger useful if you want a script to run on newly added information.

Add it as a trigger.

Adding the trigger

Once the trigger is added, you’ll have to choose the trigger, the spreadsheet, and the worksheet.

Configuring the Trigger

After this, you’ll notice new outputs. Here we want to work with the columns, particularly the email column. Here’s is how my sheet looks like.

Structure of the Sheet

We can select the columns we want to work with and modify the name.

Modifying the outputs

Adding Subscribers

The Mailchimp module comes with a lot of functionalities to help you achieve common tasks.

Adding MailChimp module

After we added the Mailchimp module, we must select the mode. Here we want to add a new member to a list.

Configuring MailChimp

Once you’ve done this, you’ll be asked to enter the list ID. In your Mailchimp audience dashboard, we can easily find the ID of the list. Just check the URL.

Image of the ID

We have the email, we have the ID, now we can easily configure the inputs.

Adding the inputs

The script is ready, now be sure to have your Google Sheet Trigger on and Wayscript will handle the automation for you. :)

Conclusion

Questions about this script or anything else? Join our discord. We're always around to help. If you want to work the full script template, just find it here.

Top comments (1)

Collapse
 
waylonwalker profile image
Waylon Walker

Wayscript has some really cool features!