Automate Squarespace signups to Mailchimp with n8n

Mailchimp is a powerful email marketing tool, and if you’re using Squarespace, chances are you want an easy way to sync signups from your website to your Mailchimp audience. However, the built-in Squarespace-Mailchimp integration has a few significant drawbacks:

• It’s a premium feature – Only available on the Core, Plus, Advanced, Business, Commerce Basic, and Commerce Advanced plans.

• It requires a new Mailchimp audience – Squarespace tutorial asks you to connect it to a new, empty Mailchimp audience, making it difficult to connect to an existing list.

• Issues with multiple forms – Squarespace warns against using multiple forms with one Mailchimp audience, potentially leading to lost subscriber data.

Instead of dealing with these limitations, you can use n8n to automate the process, allowing any Squarespace newsletter submissions to sync directly with Mailchimp without restrictions.

How It Works

We’ll set up an n8n workflow that:

1. Captures new form submissions from Squarespace.

2. Stores the data in Google Sheets as a storage, this option is available on all Squarespace plans.

3. Adds the subscriber to Mailchimp automatically on a selected audience

Step 1: Capturing Signups from Squarespace

Squarespace allows you to send form submissions to Google Drive, available on all plans. Here’s how to set that up:

1. In your form’s storage options, click Connect on Google Drive.

2. Log into your Google account.

3. Click Allow to permit Squarespace to connect to Google Drive.

4. Enter a Spreadsheet Name – This will store all form submissions.

Newsletter block on Squarspace usually submits these columns in the sheet

• Submitted On

• Email Address

• Name

Step 2: Setting Up Google Sheets in n8n

Now that form submissions are landing in Google Sheets, we need n8n to fetch this data.

1. Create a new workflow in n8n.

2. Add a Google Sheets node and connect it to your Google account.

3. Configure the node to fetch new rows from the spreadsheet containing the form submissions.

Step 3: Sending Data to Mailchimp

Next, we’ll send the captured email addresses to Mailchimp:

1. Add a Mailchimp node in n8n.

2. Connect your Mailchimp account using an API key credential (found in Mailchimp settings).

3. Set the node to Create member.

4. Map the email field from Google Sheets to Mailchimp.

5. Optionally, add tags or custom fields for better segmentation.

Automate Your Squarespace to Mailchimp Workflow

With this setup, every time someone fills out your form on Squarespace, they are automatically added to your Mailchimp list—no premium Squarespace plan required, no lost signups, and full control over your email marketing automation. In case you need to explore Mailchimp form block instead, check out this blog post.