Sync Squarespace Newsletter Signups to Mailchimp via Google Sheets

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:

1. In the form's storage options, click Connect on Google Drive .
2. Log into your Google account.
3. Click Allow to allow Squarespace to connect to Google Drive.
4. 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