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: In the form's storage options, click Connect on Google Drive. Log into your Google account. Click Al

Help me set up the n8n workflow "Sync Squarespace Newsletter Signups to Mailchimp via Google Sheets" (https://n8n.io/workflows/3251). It uses: Google Sheets, Mailchimp. Import the template JSON into my n8n instance, list every credential I need to create, and walk me through testing it.