Auto-import contacts from Google Sheets to MailChimp subscriber lists

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 lists in spreadsheets.

Key Features - 📊 Bulk Import: Process entire Google Sheets at once - 🔄 Smart Name Parsing: Automatically splits full names into first and last names - 📱 Phone Number Support: Includes phone numbers as merge fields - ⚡ Error Resilience: Continues processing even if individual contacts fail - 📝 Import Summary: Generates a summary of processed contacts

Prerequisites Before using this workflow, ensure you have: 1. An active n8n instance (self-hosted or cloud) 2. A Google account with access to Google Sheets 3. A MailChimp account with at least one audience/list created 4. Basic understanding of n8n workflows

Initial Setup

Step 1: Import the Workflow 1. Copy the workflow JSON 2. In n8n, click "Import from File" or paste the JSON 3. Save the workflow with a meaningful name

Step 2: Configure Google Sheets Connection 1. Click on the "Get Google Sheet Data" node 2. Click on "Credential to connect with" 3. Select "Create New" and choose "Google Sheets OAuth2" 4. Follow the OAuth flow to authenticate your Google account 5. Save the credentials

Step 3: Configure MailChimp Connection 1. Click on the "Add to MailChimp" node 2. Click on "Credential to connect with" 3. Select "Create New" and choose "MailChimp OAuth2" or "MailChimp API" 4. For API method: - Log into MailChimp - Go to Account → Extras → API keys - Generate a new API key - Copy and paste it into n8n 5. Save the credentials