Google Sheets Contact Sync to MailChimp Subscribers - n8n Workflow

Email Marketing Specialists who manage subscriber lists manually.
Sales Operations teams needing to synchronize leads from spreadsheets.
Users looking for a customizable n8n template to handle data transformation (like name splitting).
Anyone needing reliable batch processing automation with a manual n8n trigger.

Maintaining accurate and up-to-date email marketing lists can be challenging. This essential n8n workflow provides a robust, low-code solution for automating the synchronization of contact data from Google Sheets into MailChimp. By utilizing this powerful n8n template, businesses can ensure their subscriber lists are consistently current, feeding directly from a single source of truth—the Google Sheet.

This particular n8n workflow addresses a common challenge: splitting full names into separate First Name (FNAME) and Last Name (LNAME) fields, a requirement for many personalized email campaigns. It uses custom logic within an n8n node to perform this complex data preparation automatically, ensuring data integrity when subscribers are added via the MailChimp n8n node. Furthermore, built-in error handling allows the n8n workflow to process large batches efficiently, continuing even if individual contact imports fail.

The synchronization process begins with the manual execution of the n8n trigger, initiating the entire flow. This n8n workflow is designed for batch operations.

1. Retrieve Source Data: The flow starts with the "When clicking 'Execute workflow'" n8n trigger, immediately followed by the "Get Google Sheet Data" n8n node, which fetches all rows from the specified spreadsheet and worksheet ID.


2. Normalize Fields: The “Edit Fields” Set n8n node ensures that the required columns (Names, Email address, Phone Number) are correctly structured for the next steps.


3. Transform Data (Code Node): The critical “Format Subscriber Data” Code n8n node iterates through every retrieved contact. It uses custom JavaScript to set the subscriber status to 'subscribed' and expertly splits the Names field into FNAME (first word) and LNAME (remaining words) for proper MailChimp merge field mapping.


4. Add Subscribers: The "Add to MailChimp" n8n node then processes the items in bulk. Crucially, the configuration uses the onError: continueRegularOutput setting, ensuring that if one contact fails validation, the n8n workflow does not halt, guaranteeing maximum throughput.


5. Generate Report: Finally, the "Create Import Summary" Set n8n node compiles metrics regarding the processed items, providing a timestamped summary of the job run.

To install and activate this n8n workflow template, follow these steps:

1. Import: Copy the provided JSON code and paste it into your n8n instance using the 'New' menu -> 'Import from JSON'.


2. Credentials: Set up or select existing Google Sheets and MailChimp credentials for the respective n8n nodes.


3. Google Sheets Setup: In the "Get Google Sheet Data" n8n node, update the YOURGOOGLESHEETID and YOURSHEETNAME parameters to point to your contact spreadsheet.


4. MailChimp Setup: In the "Add to MailChimp" n8n node, replace YOURMAILCHIMPLISTID with the actual ID of the audience list where you want to add subscribers.


5. Test: Click the "Execute Workflow" button on the start n8n trigger node to ensure connectivity and data flow.


6. Activate: Once tested, set the entire n8n workflow to 'Active'.

This n8n workflow utilizes several key nodes to manage the data lifecycle:

When clicking 'Execute workflow' (Manual Trigger n8n trigger):
Function: Serves as the starting point for execution, perfect for batch processing or manual sync runs.
Get Google Sheet Data (Google Sheets n8n node):
Function: Reads all contact records from the source spreadsheet. It requires configuration of the Document ID and Sheet Name.
Format Subscriber Data (Code n8n node):
Function: The central data transformation logic. This n8n node uses JavaScript to transform raw spreadsheet rows into MailChimp-ready objects, specifically handling the crucial separation of Names into FNAME and LNAME merge fields.
Add to MailChimp (MailChimp n8n node):
Function: Attempts to add or update subscribers in the target MailChimp list. Configured to use the FNAME, LNAME, and PHONE merge fields provided by the previous n8n node.
Key Configuration: Uses the 'Continue Regular Output' error handling, making the n8n workflow highly resilient against minor data issues.
Create Import Summary (Set n8n node):
* Function: Generates a final structured markdown report summarizing the total number of items processed and the execution date of this n8n template.