Sync Squarespace Newsletter Signups to Mailchimp via Google Sheets

This n8n workflow provides a robust solution for synchronizing newsletter signups from Squarespace to Mailchimp, using Google Sheets as an intermediary. It helps ensure that your Mailchimp audience is always up-to-date with your latest Squarespace signups, enabling consistent communication with your subscribers.

What it does

This workflow automates the following steps:

1. Triggers Manually or on Schedule: The workflow can be initiated manually by clicking 'Execute workflow' or automatically at predefined intervals using the Schedule Trigger.
2. Reads Data from Google Sheets: It connects to a specified Google Sheet to retrieve a list of newsletter signups.
3. Loops Over Items: The workflow processes the retrieved data in batches, ensuring efficient handling of multiple signups.
4. Adds/Updates Subscribers in Mailchimp: For each signup, it adds or updates the subscriber's information in your designated Mailchimp audience.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running instance of n8n.
• Google Sheets Account: An active Google Sheets account with a spreadsheet containing your Squarespace newsletter signups.
  • You will need to configure a Google Sheets credential in n8n.
• Mailchimp Account: An active Mailchimp account.
  • You will need to configure a Mailchimp credential in n8n.

Setup/Usage

1. Import the Workflow:
   • Download the workflow JSON provided.
   • In your n8n instance, click "New" in the workflows section.
   • Click the "Import from JSON" button and paste the workflow JSON.
2. Configure Credentials:
   • Locate the "Google Sheets" node and configure your Google Sheets credentials. You'll need to grant n8n access to your Google Sheets account.
   • Locate the "Mailchimp" node and configure your Mailchimp API Key credentials.
3. Configure Google Sheets Node:
   • Specify the Spreadsheet ID and Sheet Name where your Squarespace newsletter signups are stored.
   • Ensure the columns in your Google Sheet match the data expected by Mailchimp (e.g., email address, first name, last name).
4. Configure Mailchimp Node:
   • Select the Audience ID where you want to add or update subscribers.
   • Map the fields from your Google Sheet (e.g., Email, First Name, Last Name) to the corresponding Mailchimp subscriber fields.
5. Configure Schedule Trigger (Optional):
   • If you want the workflow to run automatically, configure the "Schedule Trigger" node to your desired interval (e.g., every hour, daily).
6. Activate the Workflow:
   • Once all configurations are complete, activate the workflow by toggling the "Active" switch in the top right corner of the n8n editor.
7. Test the Workflow:
   • You can manually execute the workflow by clicking "Execute Workflow" to ensure it runs correctly and syncs data as expected.