Gather Leads from Google Sheets to Mailchimp

This n8n workflow streamlines lead management by automatically reading contact data from a specified Google Sheet range (Sheet1!A:C) and adding the email addresses as subscribed members to a Mailchimp audience list (ID: 90d12734de). It uses an interval trigger set to run every 2 minutes, ensuring frequent syncing without manual intervention, alongside an optional manual trigger for on-demand execution.

Key benefits include time savings on manual data entry, reduced errors in list building, and seamless integration between spreadsheet-based lead capture (e.g., from forms or webhooks) and email marketing tools. It supports marketing automation by keeping your Mailchimp list up-to-date, enabling targeted campaigns, newsletters, and sales nurturing right away.

Ideal use cases: Automate lead intake from Google Forms submissions dumped into Sheets, sync event registrations or webinar signups, or integrate with sales pipelines where leads are logged in spreadsheets. Customize by adjusting the sheet range, interval, or adding error handling for robust production use. Note: Requires Google Sheets and Mailchimp API credentials.