Sync Google Sheets Contacts to Mailchimp Subscribers

# Google Sheets to MailChimp Sync Workflow ## Features: - Simple Setup: Connect your Google Sheets and MailChimp accounts - Automated Processing: Reads contact data from your sheet - Smart Parsing: Splits full names into first and last names - Field Mapping: Maps sheet columns to MailChimp merge fields - Error Handling: Continues processing even if some contacts fail ## Setup Requirements: 1. Google Sheets API credentials 2. MailChimp API credentials ## Expected Sheet Format: Your Google Sheet should have these columns: - Names (Full name of the contact) - Email address (Valid email address) - Phone Number (Optional phone number) ## Configuration Steps: 1. Connect your Google Sheets account 2. Connect your MailChimp account 3. Select your Google Sheet and worksheet 4. Update the MailChimp list ID in the MailChimp node 5. Run the workflow to import your subscribers ## Process Flow: 1. Trigger workflow manually 2. Read all rows from Google Sheet 3. Extract and format contact data 4. Split names into first and last names 5. Add subscribers to MailChimp with merge fields 6. Generate import summary