ManualTrigger Automate

This workflow is ideal for:

• Marketing Teams: Those looking to automate the process of adding newsletter signups from Squarespace into Mailchimp.
• Small Business Owners: Individuals seeking an efficient way to manage their email marketing without manual data entry.
• Content Creators: Bloggers and influencers who want to streamline their audience engagement through automated workflows.
• Nonprofits: Organizations that need to maintain an updated mailing list from various sources, ensuring no potential supporter is missed.

This workflow addresses the challenge of integrating Squarespace newsletter signups directly with Mailchimp. It overcomes the limitation where only new, empty audiences can be utilized, allowing users to create new contacts in an existing Mailchimp audience seamlessly. By automating this process, it saves time and reduces the risk of human error in data entry.

1. Trigger: The workflow starts when the Schedule Trigger activates based on a predefined schedule, or it can be manually triggered by clicking ‘Test workflow’.
2. Data Retrieval: It retrieves the latest Squarespace newsletter submissions from a specified Google Sheet, which contains essential details like submission date, email address, and name.
3. Batch Processing: The workflow uses a Split In Batches node to process each submission individually, ensuring that each entry is handled one at a time.
4. Mailchimp Integration: For each entry, the workflow adds a new member to Mailchimp, setting their status to subscribed and populating their first name with the corresponding data from the sheet.
5. Completion: After all entries are processed, the workflow concludes, successfully updating the Mailchimp audience with new contacts.