Auto-import contacts from Google Sheets to MailChimp subscriber lists
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 6 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Mailchimp and Google Sheets.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Get Google Sheet Data (Google Sheets): uses Google Sheets
- Edit Fields (Edit Fields (Set)): sets 3 fields: Names, Email address, Phone Number
- Format Subscriber Data (Code): runs custom JavaScript code
- Add to MailChimp (Mailchimp): uses Mailchimp
- Create Import Summary (Edit Fields (Set)): sets 1 field: importSummary
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (5)
- Edit Fields (Set)
n8n-nodes-base.set - Manual Trigger
n8n-nodes-base.manualTrigger - Code
n8n-nodes-base.code - Mailchimp
n8n-nodes-base.mailchimp - Google Sheets
n8n-nodes-base.googleSheets
From the author
Google Sheets to MailChimp Auto-Importer Overview This n8n workflow automatically imports contacts from Google Sheets into your MailChimp mailing list. Perfect for businesses collecting leads through Google Forms, event registrations, or maintaining contact…