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.
Once the trigger is added, you’ll have to choose the trigger, the spreadsheet, and the worksheet.
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.
We can select the columns we want to work with and modify the name.
Adding Subscribers
The Mailchimp module comes with a lot of functionalities to help you achieve common tasks.
After we added the Mailchimp module, we must select the mode. Here we want to add a new member to a list.
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.
We have the email, we have the ID, now we can easily configure 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)
Wayscript has some really cool features!