This workflow follows the Google Sheets → HTTP Request recipe pattern — see all workflows that pair these two integrations.
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 →
{
"id": "sUGieRWulZJ7scll",
"name": "Fetch Squarespace Blog & Event Collections to Google Sheets ",
"tags": [
{
"id": "oIxDbURnjwrJFwau",
"name": "Squarespace",
"createdAt": "2025-03-06T05:49:51.612Z",
"updatedAt": "2025-03-06T05:49:51.612Z"
}
],
"nodes": [
{
"id": "43bb2c50-a9a9-4647-a470-612ad502283f",
"name": "Schedule Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-240,
420
],
"parameters": {
"rule": {
"interval": [
{}
]
}
},
"typeVersion": 1.2
},
{
"id": "410fa5ad-a8b8-4cde-b9a9-1d16db0880c9",
"name": "When clicking \u2018Test workflow\u2019",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-240,
180
],
"parameters": {},
"typeVersion": 1
},
{
"id": "fa58fb9d-9292-4f25-8326-fad6e59a5513",
"name": "Fetch Squarespace blog",
"type": "n8n-nodes-base.httpRequest",
"position": [
20,
300
],
"parameters": {
"url": "https://beyondspace.studio/blog",
"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
},
{
"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: https://beyondspace.studio/blog\n"
},
"typeVersion": 1
},
{
"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
},
{
"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": "={{ $json. urlId }}",
"addedOn": "={{ new Date($json.addedOn).toISOString().split(\"T\")[0] }}",
"fullUrl": "={{ $json.fullUrl }}",
"assetUrl": "={{ $json.fullUrl }}",
"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": "https://docs.google.com/spreadsheets/d/1yf_RYZGFHpMyOvD3RKGSvIFY2vumvI4474Qm_1t4-jM/edit#gid=0",
"cachedResultName": "Beyondspace blog"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1yf_RYZGFHpMyOvD3RKGSvIFY2vumvI4474Qm_1t4-jM",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1yf_RYZGFHpMyOvD3RKGSvIFY2vumvI4474Qm_1t4-jM/edit?usp=drivesdk",
"cachedResultName": "Make.com template"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.5
},
{
"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\nhttps://docs.google.com/spreadsheets/d/1HGc7o4mqMY1t9fXT6LBhmZixjJYr0eapSUosXMA9v8E/edit?gid=0#gid=0"
},
"typeVersion": 1
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "1a05b7b8-22fb-4f49-a079-583a26401a61",
"connections": {
"Schedule Trigger": {
"main": [
[
{
"node": "Fetch Squarespace blog",
"type": "main",
"index": 0
}
]
]
},
"Fetch Squarespace blog": {
"main": [
[
{
"node": "Iterate the collection items",
"type": "main",
"index": 0
}
]
]
},
"Iterate the collection items": {
"main": [
[
{
"node": "Squarespace collection Spreadsheet",
"type": "main",
"index": 0
}
]
]
},
"When clicking \u2018Test workflow\u2019": {
"main": [
[
{
"node": "Fetch Squarespace blog",
"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.
googleSheetsOAuth2Api
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Fetch Squarespace Blog & Event Collections to Google Sheets. Uses scheduleTrigger, manualTrigger, httpRequest, stickyNote. Scheduled trigger; 7 nodes.
Source: https://github.com/Zie619/n8n-workflows — 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.
This workflow automatically monitors and tracks trending topics across multiple platforms and websites. It helps content creators and marketers stay ahead of the curve by identifying emerging trends b
This workflow automatically generates comprehensive property market reports by scraping real estate listings and market data from multiple sources. It helps real estate professionals save time and pro
This cutting-edge n8n automation is a sophisticated job market intelligence tool designed to transform freelance job tracking into a seamless, data-driven process. By intelligently connecting Apify, d
This cutting-edge n8n automation is a powerful market research tool designed to continuously monitor and capture User-Generated Content (UGC) opportunities on Fiverr. By intelligently scraping, parsin
This workflow retrieves all blog and event collection items from a Squarespace site and saves them into a Google Sheets spreadsheet. It uses pagination to fetch 20 items per request, ensuring all cont