Google Sheet Lead Synchronization to Mailchimp - n8n Workflow

• Marketing Managers who use Google Sheets for initial lead tracking.


• Businesses needing reliable, automatic data synchronization between lead sources and email platforms.


• Users looking for ready-to-use n8n templates for CRM and email marketing integration.


• n8n users wanting to implement scheduled data synchronization flows quickly.

This n8n workflow solves the critical problem of keeping marketing lists synchronized without manual intervention. By utilizing a scheduled n8n trigger, this powerful n8n template ensures that every new row added to your designated Google Sheet (specifically reading the sheetone!A:C range) is automatically processed and added to your chosen Mailchimp audience list as a subscribed member. This setup reduces potential data entry errors, ensures your Mailchimp list is always current, and maximizes the effectiveness of lead nurturing campaigns. Implementing this n8n automation means your leads move directly from capture to campaign execution swiftly and reliably.

The core of this n8n workflow is scheduled data retrieval and subsequent API action.

1. Scheduled Start: The Interval n8n node acts as the primary scheduler, designed to initiate the flow periodically (set to every 2 hours in this configuration). While the initial start uses a manual n8n trigger, the Interval node ensures the recurrent execution.


2. Lead Data Retrieval: The Google Sheets n8n node connects using established credentials. It is configured to read a specific range (sheetone!A:C) from the linked Sheet ID, retrieving lead information, including the crucial email address field.


3. Dynamic Data Extraction: The workflow automatically processes the output from the Google Sheets n8n node. It uses an expression to dynamically pull the email address for each item: ={{$node["Google Sheets"].json["email"]}}.


4. Mailchimp Subscription: The Mailchimp n8n node takes the extracted email address and creates a new member or updates an existing member in the specified Mailchimp audience list (90d12734de). The status is explicitly set to subscribed, ensuring the lead is immediately actionable. This completes the automatic sync, powered by this efficient n8n node connection.

To install and deploy this n8n workflow, follow these steps:

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


2. Set up Credentials: This n8n workflow requires two separate sets of credentials, although they are named the same in the provided JSON:

1. Configure Google Sheets Node: Update the Sheet ID and the Range parameter (sheetone!A:C) within the Google Sheets n8n node to point to your specific lead tracking spreadsheet.


2. Configure Mailchimp Node: Update the List ID in the Mailchimp n8n node to match the audience list you wish to populate.


3. Activate and Test: Activate the n8n workflow. Use the Manual Trigger node (or the Interval node's test function) to run a test execution and verify that leads are correctly transferred from your sheet to Mailchimp.

On clicking 'execute' (Manual Trigger n8n trigger): Initiates the first run of the n8n workflow manually. This is useful for initial testing and setup before relying on the schedule.
Interval (Interval n8n node): Controls the scheduling frequency of the data sync. It is currently configured to wait 2 hours between executions, ensuring the Google Sheets lookup happens periodically.
Google Sheets (Google Sheets n8n node): Function is to read lead data. Key Configuration includes a specific Sheet ID and the Range set to sheetone!A:C, specifying the columns containing the lead information required for Mailchimp.
Mailchimp (Mailchimp n8n node): Function is to add or update list members. It uses an expression to dynamically pass the email from the previous Google Sheets output. It ensures all imported records are set with the subscribed status in the designated list.