Google Sheets and Mailchimp integration

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: An active n8n instance (self-hosted or cloud) A Google account with access to Google Sheets A MailChimp account with at least one audience/list created Basic understanding of n8n workflows Initial Setup Step 1: Import the Workflow Copy the workflow JSON In n8n, click "Import from File" or paste the JSON Save the workflow with a meaningful name Step 2: Configure Google Sheets Connection Click on the "Get Google Sheet Data" node Click on "Credential to connect with" Select "Create New" and choose "Google Sheets OAuth2" Follow the OAuth flow to authenticate your Google account Save the credentials Step 3: Configure MailChimp Connection Click on the "Add to MailChimp" node Click on "Credential to connect with" Select "Create New" and choose "MailChimp OAuth2" or "MailChimp API" For API method: Log into MailChimp Go to Account → Extras → API keys Generate a new API key Copy and paste it into n8n Save the credentials Step 4: Configure Your Specific Settings Google Sheets Settings: Open the "Get Google Sheet Data" node Replace YOUR_GOOGLE_SHEET_ID with your actual sheet ID Find this in your Google Sheets URL: https://docs.google.com/spreadsheets/d/[SHEET_ID]/edit Replace YOUR_SHEET_NAME with your worksheet name (e.g., "Sheet1" or "Form Responses 1") MailChimp Settings: Open the "Add to MailChimp" node Replace YOUR_MAILCHIMP_LIST_ID with your audience ID Find this in MailChimp: Audience → Settings → Audience name and defaults Verify the status is set to "subscribed" Google Sheets Format Requirements Your Google Sheet must have the following columns (exact names): Names**: Full name of the contact (e.g., "John Doe") Email address**: Valid email address Phone Number**: Contact phone number (optional) Example: | Names | Email address | Phone Number | |-------|--------------|--------------| | John Doe | [email protected] | +1234567890 | | Jane Smith | [email protected] | +0987654321 | How to Use Manual Execution: Open the workflow in n8n Click "Execute Workflow" Monitor the execution progress Check the output of "Create Import Summary" for results Scheduling (Optional): To run this automatically: Replace the "Manual Trigger" node with a "Schedule Trigger" node Set your desired schedule (e.g., daily at 9 AM) Activate the workflow Customization Options Adding More Fields: To include additional fields like company name or address: Add columns to your Google Sheet Modify the "Edit Fields" node to include new fields Update the "Format Subscriber Data" code to map new fields Add corresponding merge fields in the MailChimp node Handling Duplicates: The workflow uses "continueRegularOutput" error handling, which means: Existing subscribers will be skipped New subscribers will be added The workflow continues processing Adding Email Notifications: To receive import summaries via email: Add a Gmail or Email node after "Create Import Summary" Configure with your email settings Use the import summary data in the email body Troubleshooting Common Issues: "Invalid API Key" (MailChimp) Verify your API key is correct Check that your MailChimp account is active "Sheet not found" (Google Sheets) Verify the sheet ID is correct Ensure the service account has access to the sheet "Email already exists" errors This is normal for existing subscribers The workflow will continue processing other contacts Missing data in MailChimp Check that column names match exactly (case-sensitive) Verify data exists in the Google Sheet Best Practices Test First: Always test with a small dataset first Backup Data: Export your MailChimp list before large imports Clean Data: Ensure email addresses are valid before importing Monitor Regularly: Check import summaries for any issues Respect Privacy: Only import contacts who have consented to receive emails Support For issues specific to: n8n platform: Visit n8n Community Forum Google Sheets API: Check Google Developers Documentation MailChimp API: See MailChimp API Documentation Need help customizing? Contact me for consulting and support or add me on LinkedIn - https://www.linkedin.com/in/femi-adedayo-h44/ License This workflow template is provided free for personal and commercial use. Feel free to modify and share!

Automatically turn your Google Calendar into a fully-automated notification system with email alerts, SMS reminders, and a live performance dashboard - all powered by n8n. This automation helps you never miss an event, while giving you clear visibility into what notifications were sent, when, and how reliably they ran. What This Automation Does This solution is built as 4 connected workflows that run on a schedule and work together: Daily Email Summary (Morning) Every morning, the workflow: Reads today’s events from Google Calendar Formats them into a clean email Sends a daily schedule summary via Mailchimp or SendGrid Daily SMS Summary Shortly after, it: Sends a concise SMS overview of today’s meetings using Twilio 15-Minute Event Reminders Before each event: Sends an individual SMS reminder Skips all-day events automatically Weekly Schedule Preview Every Sunday: Sends a week-ahead summary so you can plan in advance Live Reporting & Dashboard All workflow activity is logged automatically into Google Sheets, which powers a real-time analytics dashboard showing: Number of notifications sent Success vs failure rates Daily and weekly execution stats Visual charts powered by Chart.js No manual tracking needed, everything updates automatically. How the Workflow Is Structured The automation is grouped into 3 clear sections: Section 1: Calendar Data Collection Pulls events from Google Calendar Filters relevant meetings Prepares clean event data Section 2: Notifications & Messaging Formats emails and SMS messages Sends reminders and summaries Handles scheduling logic Section 3: Logging & Reporting Saves every execution to Google Sheets Updates daily stats automatically Feeds the live dashboard SUPPORT & FEEDBACK Questions or issues? Connect with me on LinkedIn Want to see it in action? Try the live report demo: Click here

This workflow captures Squarespace newsletter signups in a Google Sheet and automatically creates new Mailchimp contacts in the selected audience. It overcomes the limitation in Squarespace’s native Mailchimp integration, which only supports new, empty audiences. You can trigger the workflow manually or schedule it for continuous synchronization. Step-by-step tutorial First, you need to connect Squarespace newsletter block submission to Google Drive In Mailchimp node, choose your targeted audience in List Name or ID Connect a Squarespace Form to Google Drive To connect a form to Google Drive: In the form's storage options, click Connect on Google Drive. Log into your Google account. Click Allow to permit Squarespace to connect to Google Drive. Enter a Spreadsheet Name. This creates a new spreadsheet for your form submissions. Columns in my sheet: Submitted On Email Address Name This structure is inspired by Squarespace’s newsletter block connection, but you can modify it based on your preferred data format. 👉 Clone my Google Sheets template Requirements Credentials To use this workflow, you need: Mailchimp API Key** – Required to add contacts to Mailchimp. Google Sheets API credentials** – Required to retrieve signups from the spreadsheet. 📌 Mailchimp API Authentication Guide Explore More Templates 👉 Check out my other n8n templates

Gather leads into Mailchimp, automate marketing, and sales process.