8
n8n 中文网amn8n.com

获取Squarespace博客和活动集合并保存到Google Sheets

中级

这是一个Marketing领域的自动化工作流，包含 7 个节点。主要使用 SplitOut, HttpRequest, GoogleSheets, ManualTrigger, ScheduleTrigger 等节点。 将Squarespace博客和活动集合获取到Google Sheets

前置要求
  • •可能需要目标 API 的认证凭证
  • •Google Sheets API 凭证

使用的节点 (7)

SplitOut
StickyNote
HttpRequest
GoogleSheets
ManualTrigger
ScheduleTrigger

分类

营销
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "id": "sUGieRWulZJ7scll",
  "meta": {
    "instanceId": "e634e668fe1fc93a75c4f2a7fc0dad807ca318b79654157eadb9578496acbc76"
  },
  "name": "获取 Squarespace 博客和活动集合并保存到 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": "计划触发器",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -240,
        420
      ],
      "parameters": {
        "rule": {
          "interval": [
            {}
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "410fa5ad-a8b8-4cde-b9a9-1d16db0880c9",
      "name": "点击“测试工作流”时",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -240,
        180
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "fa58fb9d-9292-4f25-8326-fad6e59a5513",
      "name": "获取 Squarespace",
      "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": "便签",
      "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": {
          "id": "JgI9maibw5DnBXRP",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "87081016-9daa-4985-afb8-eb1f259b23a0",
      "name": "便签 1",
      "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,
  "pinData": {},
  "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 ‘Test workflow’": {
      "main": [
        [
          {
            "node": "Fetch Squarespace blog",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。

这个工作流适合什么场景？

中级 - 营销

需要付费吗？

本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。

相关工作流推荐

获取Squarespace所有订单到Google表格
将Squarespace所有订单获取到Google表格
Set
Split Out
Http Request
+4
8 节点bangank36
销售
将Trustpilot评论抓取到Google Sheets
抓取Trustpilot评论到Google Sheets + 兼容HelpfulCrowd的CSV格式
Set
Code
Split Out
+5
13 节点bangank36
产品
将Shopify所有订单获取到Google表格
将Shopify所有订单获取到Google表格
If
Set
Code
+6
11 节点bangank36
其他
同步 Shopify 客户到 Google Sheets + Squarespace 兼容 CSV
将 Shopify 客户数据同步到 Google Sheets 并生成 Squarespace 兼容的 CSV
If
Set
Code
+7
13 节点bangank36
销售
备份 Squarespace 代码注入到 Github
备份 Squarespace 代码注入到 Github
If
Set
Code
+7
17 节点bangank36
工程
使用 Browserflow 和 Google Sheets 自动化 LinkedIn 请求与破冰消息
使用 Browserflow 和 Google Sheets 自动化 LinkedIn 请求与破冰消息
If
Set
Sort
+15
44 节点PollupAI
销售
工作流信息
难度等级
中级
节点数量7
分类1
节点类型6
难度说明

适合有一定经验的用户，包含 6-15 个节点的中等复杂度工作流

作者
bangank36

bangank36

@bangank36

Automation specialist with 10+ years of experience helping SME website owners streamline their workflows—specializing in Squarespace, Shopify, and WordPress. Book an initial consultation for custom n8n automation using my link.

外部链接
在 n8n.io 查看 →

分享此工作流