{ "id": "sUGieRWulZJ7scll", "meta": { "instanceId": "workflow-1720e6e1", "versionId": "1.0.0", "createdAt": "2025-09-29T07:07:54.019593", "updatedAt": "2025-09-29T07:07:54.019799", "owner": "n8n-user", "license": "MIT", "category": "automation", "status": "active", "priority": "high", "environment": "production" }, "name": "Fetch Squarespace Blog & Event Collections to Google Sheets ", "tags": [ "automation", "n8n", "production-ready", "excellent", "optimized" ], "nodes": [ { "id": "43bb2c50-a9a9-4647-a470-612ad502283f", "name": "Schedule Trigger", "type": "n8n-nodes-base.scheduleTrigger", "position": [ -240, 420 ], "parameters": { "rule": { "interval": [ {} ] } }, "typeVersion": 1.2, "notes": "This scheduleTrigger node performs automated tasks as part of the workflow." }, { "id": "410fa5ad-a8b8-4cde-b9a9-1d16db0880c9", "name": "When clicking ‘Test workflow’", "type": "n8n-nodes-base.manualTrigger", "position": [ -240, 180 ], "parameters": {}, "typeVersion": 1, "notes": "This manualTrigger node performs automated tasks as part of the workflow." }, { "id": "fa58fb9d-9292-4f25-8326-fad6e59a5513", "name": "Fetch Squarespace blog", "type": "n8n-nodes-base.httpRequest", "position": [ 20, 300 ], "parameters": { "url": "{{ $env.WEBHOOK_URL }}", "options": { "pagination": { "pagination": { "parameters": { "parameters": [ { "name": "offset", "value": "={{ $response.body.pagination.nextPageOffset }}" }, { "name": "format", "value": "json" } ] }, "requestInterval": 200, "completeExpression": "={{ $response.body.pagination.nextPage !== true }}", "paginationCompleteWhen": "other" } } }, "sendQuery": true, "queryParameters": { "parameters": [ { "name": "format", "value": "json" }, { "name": "offset" } ] } }, "typeVersion": 4.2, "alwaysOutputData": false, "notes": "This httpRequest node performs automated tasks as part of the workflow." }, { "id": "4b558c29-3bea-4d5e-b88f-0433a81f4698", "name": "Sticky Note", "type": "n8n-nodes-base.stickyNote", "position": [ -20, 100 ], "parameters": { "content": "## Change this node\nEdit the HTTP Request URL to your Squarespace blog URL\n\neg: {{ $env.WEBHOOK_URL }}\n" }, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow." }, { "id": "1886c997-6ba2-42be-8ea0-9047a4cae2e7", "name": "Iterate the collection items", "type": "n8n-nodes-base.splitOut", "position": [ 260, 300 ], "parameters": { "options": {}, "fieldToSplitOut": "items" }, "typeVersion": 1, "notes": "This splitOut node performs automated tasks as part of the workflow." }, { "id": "9382f7b6-e113-4e4c-ba04-e7cbd119b164", "name": "Squarespace collection Spreadsheet", "type": "n8n-nodes-base.googleSheets", "position": [ 520, 300 ], "parameters": { "columns": { "value": { "id": "={{ $json.id }}", "tags": "={{ $json.tags.join(\", \") }}", "title": "={{ $json.title }}", "urlId": "{{ $env.BASE_URL }}", "addedOn": "={{ new Date($json.addedOn).toISOString().split(\"T\")[0] }}", "fullUrl": "{{ $env.BASE_URL }}", "assetUrl": "{{ $env.BASE_URL }}", "publishOn": "={{ new Date($json.publishOn).toISOString().split(\"T\")[0] }}", "categories": "={{ $json.categories.join(\", \") }}" }, "schema": [ { "id": "id", "type": "string", "display": true, "removed": false, "required": false, "displayName": "id", "defaultMatch": true, "canBeUsedToMatch": true }, { "id": "addedOn", "type": "string", "display": true, "removed": false, "required": false, "displayName": "addedOn", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "tags", "type": "string", "display": true, "removed": false, "required": false, "displayName": "tags", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "categories", "type": "string", "display": true, "removed": false, "required": false, "displayName": "categories", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "publishOn", "type": "string", "display": true, "removed": false, "required": false, "displayName": "publishOn", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "urlId", "type": "string", "display": true, "removed": false, "required": false, "displayName": "urlId", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "title", "type": "string", "display": true, "removed": false, "required": false, "displayName": "title", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "body", "type": "string", "display": true, "removed": false, "required": false, "displayName": "body", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "fullUrl", "type": "string", "display": true, "removed": false, "required": false, "displayName": "fullUrl", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "assetUrl", "type": "string", "display": true, "removed": false, "required": false, "displayName": "assetUrl", "defaultMatch": false, "canBeUsedToMatch": true } ], "mappingMode": "defineBelow", "matchingColumns": [ "id" ], "attemptToConvertTypes": false, "convertFieldsToString": false }, "options": {}, "operation": "appendOrUpdate", "sheetName": { "__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "{{ $env.WEBHOOK_URL }}", "cachedResultName": "Beyondspace blog" }, "documentId": { "__rl": true, "mode": "list", "value": "1yf_RYZGFHpMyOvD3RKGSvIFY2vumvI4474Qm_1t4-jM", "cachedResultUrl": "{{ $env.WEBHOOK_URL }}", "cachedResultName": "Make.com template" } }, "credentials": { "googleSheetsOAuth2Api": { "id": "JgI9maibw5DnBXRP", "name": "Google Sheets account" } }, "typeVersion": 4.5, "notes": "This googleSheets node performs automated tasks as part of the workflow." }, { "id": "87081016-9daa-4985-afb8-eb1f259b23a0", "name": "Sticky Note1", "type": "n8n-nodes-base.stickyNote", "position": [ 480, 100 ], "parameters": { "content": "## Spreadsheet template\nClone this spreadsheet as reference\n{{ $env.WEBHOOK_URL }}" }, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow." } ], "active": false, "pinData": {}, "settings": { "executionOrder": "v1", "saveManualExecutions": true, "callerPolicy": "workflowsFromSameOwner", "errorWorkflow": null, "timezone": "UTC", "executionTimeout": 3600, "maxExecutions": 1000, "retryOnFail": true, "retryCount": 3, "retryDelay": 1000 }, "versionId": "1a05b7b8-22fb-4f49-a079-583a26401a61", "connections": { "fa58fb9d-9292-4f25-8326-fad6e59a5513": { "main": [ [ { "node": "error-handler-fa58fb9d-9292-4f25-8326-fad6e59a5513", "type": "main", "index": 0 } ], [ { "node": "error-handler-fa58fb9d-9292-4f25-8326-fad6e59a5513-3283641c", "type": "main", "index": 0 } ], [ { "node": "error-handler-fa58fb9d-9292-4f25-8326-fad6e59a5513-a74717e0", "type": "main", "index": 0 } ], [ { "node": "error-handler-fa58fb9d-9292-4f25-8326-fad6e59a5513-b6e10701", "type": "main", "index": 0 } ], [ { "node": "error-handler-fa58fb9d-9292-4f25-8326-fad6e59a5513-664fcc1c", "type": "main", "index": 0 } ], [ { "node": "error-handler-fa58fb9d-9292-4f25-8326-fad6e59a5513-26c6cf27", "type": "main", "index": 0 } ], [ { "node": "error-handler-fa58fb9d-9292-4f25-8326-fad6e59a5513-8243b09c", "type": "main", "index": 0 } ], [ { "node": "error-handler-fa58fb9d-9292-4f25-8326-fad6e59a5513-df013801", "type": "main", "index": 0 } ], [ { "node": "error-handler-fa58fb9d-9292-4f25-8326-fad6e59a5513-4562bec9", "type": "main", "index": 0 } ] ] }, "9382f7b6-e113-4e4c-ba04-e7cbd119b164": { "main": [ [ { "node": "error-handler-9382f7b6-e113-4e4c-ba04-e7cbd119b164-5eca09ed", "type": "main", "index": 0 } ] ] } }, "description": "Automated workflow: Fetch Squarespace Blog & Event Collections to Google Sheets . This workflow integrates 7 different services: stickyNote, httpRequest, scheduleTrigger, splitOut, stopAndError. It contains 10 nodes and follows best practices for error handling and security.", "notes": "Excellent quality workflow: Fetch Squarespace Blog & Event Collections to Google Sheets . This workflow has been optimized for production use with comprehensive error handling, security, and documentation." }