Automated Subscriber Sync from Google Sheets to Mailchimp

This n8n workflow automates the process of syncing contact information from a Google Sheets spreadsheet directly into a Mailchimp mailing list, streamlining email marketing campaigns. The workflow begins with a manual trigger, allowing users to initiate the process with a click. It then retrieves data from a specified Google Sheet, which should contain columns for full names, email addresses, and optionally phone numbers.

Next, a code node processes each contact, splitting full names into first and last names, and formats the data into Mailchimp-compatible subscriber objects with merge fields for personalized communication. These subscriber objects are then sent to Mailchimp, where contacts are added or updated as ‘subscribed’ recipients.

The workflow concludes by generating a summary report for each contact processed, including the date, total processed contacts, email, status, and the source of data. This setup is ideal for marketers or team members who maintain contact lists in Google Sheets and want a simple, automated way to keep their Mailchimp audiences updated without manual data entry.