← All N8N workflows
Data & databasesGoogle SheetsMailchimpManual TriggerSchedule TriggerLoop Over Items

Create Mailchimp contact based on Squarespace newsletter

Configured with Google Sheets, Mailchimp, Schedule Trigger, Loop Over Items. Review the connections and setup before adapting this template.

Workflow preview
TriggerWhen clicking ‘Testworkflow’Manual TriggerTriggerSchedule TriggerSchedule TriggerData storeSquarespace newslettersubmissionsGoogle SheetsRoutingLoop Over each itemLoop Over ItemsIntegrationAdd new member toMailchimpMailchimp

Node categories in this workflow

  • Trigger
  • Data store
  • Routing
  • Integration

Icons describe general node roles, inferred from node types. Inspect the parameters for the configured action.

Drag to pan; use + and − to zoom. Reconstructed from the exported node positions; nothing runs here. Dashed lines represent non-main connections. Full node names and notes appear below.

How it works

The exported workflow contains the following configured nodes. Their connections are shown above; inspect the JSON for the complete logic, expressions, and external actions.

Workflow node names, types, and operations
NodeCategoryTypeOperation
When clicking ‘Test workflow’TriggerManual TriggerSee node parameters
Schedule TriggerTriggerSchedule TriggerSee node parameters
Squarespace newsletter submissionsData storeGoogle SheetsSee node parameters
Loop Over each itemRoutingLoop Over ItemsSee node parameters
Add new member to MailchimpIntegrationMailchimpSee node parameters

Setup

  1. Download the JSON and import it into an isolated n8n instance. Leave the workflow inactive.
  2. Connect your own credentials through n8n’s credential store. Replace REPLACE_WITH_* values with your resource identifiers.
  3. Inspect API destinations, Code nodes, database queries, file paths, and outbound actions.
  4. Run with synthetic data and harmless destinations. Enable triggers only after checking the actual outputs.

Requirements

An n8n instance with the listed node types and compatible versions. Service-connected workflows may require accounts, credentials, or paid APIs.

Credential types declared in the source

  • googleSheetsOAuth2Api
  • mailchimpApi

Workflow notes

Create Mailchimp contact based on Squarespace newsletter

Create Mailchimp contact based on Squarespace newsletter

This workflow will get Squarespace newsletter signups and create new Mailchimp contact in the given Audience on Mailchimp

This overcome the limitation between Squarespace forms and Mailchimp connection where only new, empty audience can be used

You can run the workflow on demand or by schedule

Spreadsheet template

The sheet columns are inspire from Squarespace newsletter block connection, but you can change the node to adapt new columns format

Clone the sample sheet here

  • Submitted On
  • Email Address
  • Name
Create Mailchimp contact based on Squarespace newsletter

Create Mailchimp contact based on Squarespace newsletter

Purpose and structure

This folder contains the Create Mailchimp contact based on Squarespace newsletter workflow. Its executable nodes use googleSheets, mailchimp, manualTrigger, scheduleTrigger, splitInBatches. The table and connection map below are derived from the JSON, not an inferred guarantee of behavior.

Setup

Import inactive. Configure your own credentials and replace REPLACE_WITH_* values. Review external destinations and Code nodes before running.

Entry points

When clicking ‘Test workflow’, Schedule Trigger

Verification

Sanitized source candidate; not runtime-tested. This overview is generated from node metadata. Read the folder README for the connection map, credential types, and license.

Attribution

https://github.com/Zie619/n8n-workflows/blob/94007c1445d9258a7da116646b79473e7c7c3282/workflows/Schedule/0795_Schedule_Mailchimp_Create_Scheduled.json MIT; preserve source notices.

More in Data & databases