{"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  ","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,"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":{"Fetch Squarespace blog":{"main":[[],[],[],[],[],[],[],[],[]]},"Squarespace collection Spreadsheet":{"main":[[]]}},"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."}