The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"meta": {
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "a5f5621a-bd4c-45b8-be09-ebdda13ebb3e",
"name": "When clicking \u2018Test workflow\u2019",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-280,
120
],
"parameters": {},
"typeVersion": 1
},
{
"id": "9447f0d4-1be3-4b8c-b172-3ff856f2197b",
"name": "Schedule Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-280,
-160
],
"parameters": {
"rule": {
"interval": [
{}
]
}
},
"typeVersion": 1.2
},
{
"id": "4ffd30f6-6f56-42cd-9f1c-07b58adbe312",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-740,
-260
],
"parameters": {
"color": 4,
"width": 371.1995072042308,
"height": 600.88409546716,
"content": "## Squarespace \ub274\uc2a4\ub808\ud130\ub97c \uae30\ubc18\uc73c\ub85c Mailchimp \uc5f0\ub77d\ucc98 \uc0dd\uc131\n\n\uc774 \uc6cc\ud06c\ud50c\ub85c\ub294 Squarespace \ub274\uc2a4\ub808\ud130 \uac00\uc785\uc790\ub97c \uac00\uc838\uc640\uc11c \uc9c0\uc815\ub41c Mailchimp \uc624\ub514\uc5b8\uc2a4\uc5d0 \uc0c8\ub85c\uc6b4 Mailchimp \uc5f0\ub77d\ucc98\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4.\n\n\uc774\ub294 Squarespace \ud3fc\uacfc Mailchimp \uc5f0\uacb0\uc758 \uc81c\ud55c\uc744 \uadf9\ubcf5\ud569\ub2c8\ub2e4. \uc5ec\uae30\uc11c \uc0c8\ub85c\uc6b4 \ube48 \uc624\ub514\uc5b8\uc2a4\ub9cc \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.\n\n\uc774 \uc6cc\ud06c\ud50c\ub85c\ub97c \ud544\uc694\uc5d0 \ub530\ub77c \ub610\ub294 \uc77c\uc815\uc5d0 \ub530\ub77c \uc2e4\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.\n\n## \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8 \ud15c\ud50c\ub9bf\n\n\uc2dc\ud2b8 \uc5f4\uc740 Squarespace \ub274\uc2a4\ub808\ud130 \ube14\ub85d \uc5f0\uacb0\uc5d0\uc11c \uc601\uac10\uc744 \ubc1b\uc558\uc2b5\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \uc0c8 \uc5f4 \ud615\uc2dd\uc744 \uc801\uc6a9\ud558\uae30 \uc704\ud574 \ub178\ub4dc\ub97c \ubcc0\uacbd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.\n\n[\uc0d8\ud50c \uc2dc\ud2b8 \uc5ec\uae30\ub97c \ubcf5\uc81c\ud558\uc138\uc694](https://docs.google.com/spreadsheets/d/1wi2Ucb4b35e0-fuf-96sMnyzTft0ADz3MwdE_cG_WnQ/edit?usp=sharing)\n\n- \uc81c\ucd9c\ub428\t\n- \uc774\uba54\uc77c \uc8fc\uc18c\t\n- \uc774\ub984"
},
"typeVersion": 1
},
{
"id": "7af3d027-ffb8-4ca0-84d4-06dbf3902e80",
"name": "Squarespace newsletter submissions",
"type": "n8n-nodes-base.googleSheets",
"position": [
0,
0
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/15A3ZWzIBfONL4U_1XGJvtsS8HtMQ69qrpxd5C5L6Akg/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "15A3ZWzIBfONL4U_1XGJvtsS8HtMQ69qrpxd5C5L6Akg",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/15A3ZWzIBfONL4U_1XGJvtsS8HtMQ69qrpxd5C5L6Akg/edit?usp=drivesdk",
"cachedResultName": "n8n-submission"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.5
},
{
"id": "f0fe2c40-2971-4068-b5b0-57e70f65ff72",
"name": "Loop Over each item",
"type": "n8n-nodes-base.splitInBatches",
"position": [
260,
0
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "ebad2d00-56b3-4dec-9e3b-d9cb6cc4aaf1",
"name": "Add new member to Mailchimp",
"type": "n8n-nodes-base.mailchimp",
"onError": "continueErrorOutput",
"position": [
540,
20
],
"parameters": {
"email": "={{ $json['Email Address'] }}{{ $json.row_number }}",
"status": "subscribed",
"options": {
"timestampSignup": "={{ $json['Submitted On'] }}"
},
"mergeFieldsUi": {
"mergeFieldsValues": [
{
"name": "FNAME",
"value": "={{ $json.Name }}"
}
]
}
},
"credentials": {
"mailchimpApi": {
"name": "<your credential>"
}
},
"typeVersion": 1,
"alwaysOutputData": false
}
],
"connections": {
"Schedule Trigger": {
"main": [
[
{
"node": "Squarespace newsletter submissions",
"type": "main",
"index": 0
}
]
]
},
"Loop Over each item": {
"main": [
[],
[
{
"node": "Add new member to Mailchimp",
"type": "main",
"index": 0
}
]
]
},
"Add new member to Mailchimp": {
"main": [
[
{
"node": "Loop Over each item",
"type": "main",
"index": 0
}
],
[]
]
},
"When clicking \u2018Test workflow\u2019": {
"main": [
[
{
"node": "Squarespace newsletter submissions",
"type": "main",
"index": 0
}
]
]
},
"Squarespace newsletter submissions": {
"main": [
[
{
"node": "Loop Over each item",
"type": "main",
"index": 0
}
]
]
}
}
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
googleSheetsOAuth2ApimailchimpApi
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Workflow 3251. Uses googleSheets, mailchimp. Event-driven trigger; 6 nodes.
Source: https://github.com/n8nKOR/n8n-shared-workflow/blob/62a671327e906c22a40d290b339ff6d2373f8d75/workflows/n8n-workflows-by-Zie619/devops/3251_workflow_3251.json — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
Schedule Mailchimp. Uses manualTrigger, scheduleTrigger, stickyNote, googleSheets. Event-driven trigger; 6 nodes.
This workflow captures Squarespace newsletter signups in a Google Sheet and automatically creates new Mailchimp contacts in the selected audience.
Google Sheet to Mailchimp. Uses manualTrigger, googleSheets, mailchimp, interval. Event-driven trigger; 4 nodes.
This n8n workflow automatically imports contacts from Google Sheets into your MailChimp mailing list. Perfect for businesses collecting leads through Google Forms, event registrations, or maintaining
Marketing Teams Email Marketers Small Business Owners Community Managers Read from Google Sheets: The workflow begins by reading all contact rows from your designated Google Sheet. Check for Existing