自动同步公众号文章工作流

1
{
2
  "name": "自动同步公众号文章工作流",
3
  "nodes": [
4
    {
5
      "parameters": {},
6
      "type": "n8n-nodes-base.manualTrigger",
7
      "typeVersion": 1,
8
      "position": [
9
        -1540,
10
        180
11
      ],
12
      "id": "5a254125-e659-40e4-b4ff-785d341941e5",
13
      "name": "When clicking ‘Execute workflow’"
14
    },
15
    {
16
      "parameters": {
17
        "assignments": {
18
          "assignments": [
19
            {
20
              "id": "1aead2d8-db32-4837-a7bc-4f654b159db4",
21
              "name": "biz",
22
              "value": "[\"MzIzNjc1NzUzMw==\",\"MzI3MTA0MTk1MA==\",\"MzA3MzI4MjgzMw==\"]",
23
              "type": "array"
24
            },
25
            {
26
              "id": "3152a413-b0db-4206-a571-c80df9a90b2b",
27
              "name": "name",
28
              "value": "[\"量子位\",\"新智元\",\"机器之心\"]",
29
              "type": "array"
30
            },
31
            {
32
              "id": "742495c8-fb2c-4664-8fb0-91dea7d4ce94",
33
              "name": "key",
34
              "value": "极致了ID【需改为自己的】",
35
              "type": "string"
36
            }
37
          ]
38
        },
39
        "options": {}
40
      },
41
      "type": "n8n-nodes-base.set",
42
      "typeVersion": 3.4,
43
      "position": [
44
        -1320,
45
        180
46
      ],
47
      "id": "bbe2617a-d9a4-4d01-aac5-a0523aafa230",
48
      "name": "Edit Fields"
49
    },
50
    {
51
      "parameters": {
52
        "options": {}
53
      },
54
      "type": "n8n-nodes-base.splitInBatches",
55
      "typeVersion": 3,
56
      "position": [
57
        -660,
58
        180
59
      ],
60
      "id": "e7eb8ed5-0da1-40c5-a26f-ce52a4aeef5f",
61
      "name": "Loop Over Items"
62
    },
63
    {
64
      "parameters": {
65
        "method": "POST",
66
        "url": "https://www.dajiala.com/fbmain/monitor/v3/post_history",
67
        "sendHeaders": true,
68
        "headerParameters": {
69
          "parameters": [
70
            {
71
              "name": "Content-Type",
72
              "value": "application/json"
73
            }
74
          ]
75
        },
76
        "sendBody": true,
77
        "specifyBody": "json",
78
        "jsonBody": "={\n  \"biz\": \"{{ $json.key }}\",\n  \"url\": \"\",\n  \"name\": \"{{ $json.value }}\",\n  \"page\": 1,\n  \"key\": \"{{ $('Edit Fields').item.json.key }}\",\n  \"verifycode\": \"\"\n}",
79
        "options": {
80
          "redirect": {
81
            "redirect": {}
82
          }
83
        }
84
      },
85
      "type": "n8n-nodes-base.httpRequest",
86
      "typeVersion": 4.2,
87
      "position": [
88
        -440,
89
        100
90
      ],
91
      "id": "9f4cde6a-561e-4251-abcb-dd5f5091a430",
92
      "name": "HTTP Request"
93
    },
94
    {
95
      "parameters": {
96
        "url": "={{ $json.url }}",
97
        "sendHeaders": true,
98
        "headerParameters": {
99
          "parameters": [
100
            {
101
              "name": "Accept",
102
              "value": "*/*"
103
            },
104
            {
105
              "name": "Accept-Encoding",
106
              "value": "deflate, gzip"
107
            },
108
            {
109
              "name": "User-Agent",
110
              "value": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36"
111
            },
112
            {
113
              "name": "Host",
114
              "value": "mp.weixin.qq.com"
115
            }
116
          ]
117
        },
118
        "options": {}
119
      },
120
      "type": "n8n-nodes-base.httpRequest",
121
      "typeVersion": 4.2,
122
      "position": [
123
        0,
124
        0
125
      ],
126
      "id": "fdcf74f5-ce95-41d3-9fa1-9d4320160b0b",
127
      "name": "HTTP Request1"
128
    },
129
    {
130
      "parameters": {
131
        "operation": "extractHtmlContent",
132
        "extractionValues": {
133
          "values": [
134
            {
135
              "key": "data",
136
              "cssSelector": "#page-content"
137
            }
138
          ]
139
        },
140
        "options": {}
141
      },
142
      "type": "n8n-nodes-base.html",
143
      "typeVersion": 1.2,
144
      "position": [
145
        220,
146
        0
147
      ],
148
      "id": "a2b2458c-b9db-4f4d-a320-46260906cc92",
149
      "name": "HTML"
150
    },
151
    {
152
      "parameters": {},
153
      "type": "n8n-nodes-base.limit",
154
      "typeVersion": 1,
155
      "position": [
156
        -880,
157
        180
158
      ],
159
      "id": "00347ab9-2584-4a24-8758-5e5eaf7af2cb",
160
      "name": "Limit"
161
    },
162
    {
163
      "parameters": {
164
        "fieldToSplitOut": "data",
165
        "options": {}
166
      },
167
      "type": "n8n-nodes-base.splitOut",
168
      "typeVersion": 1,
169
      "position": [
170
        -220,
171
        100
172
      ],
173
      "id": "8b84e033-3f81-4162-a775-117a24f70142",
174
      "name": "Split Out1"
175
    },
176
    {
177
      "parameters": {
178
        "jsCode": "/**\n * 将Markdown文本转换为纯文本\n * @param {string} markdown - 输入的Markdown格式文本\n * @returns {string} - 转换后的纯文本字符串\n */\nfunction markdownToText(markdown) {\n    if (!markdown) return '';\n\n    let text = markdown;\n\n    // 移除代码块\n    text = text.replace(/```[\\s\\S]*?```/g, '');\n    text = text.replace(/`([^`]+)`/g, '$1');\n\n    // 移除标题符号\n    text = text.replace(/^#{1,6}\\s+/gm, '');\n\n    // 移除粗体和斜体\n    text = text.replace(/[*_]{2}([^*_]+)[*_]{2}/g, '$1'); // 粗体\n    text = text.replace(/[*_]([^*_]+)[*_]/g, '$1'); // 斜体\n\n    // 处理链接\n    text = text.replace(/\\[([^\\]]+)\\]\\([^)]+\\)/g, '$1'); // [文本](链接)\n    text = text.replace(/\\[([^\\]]+)\\]\\[[^\\]]*\\]/g, '$1'); // [文本][引用]\n\n    // 移除图片标记\n    text = text.replace(/!\\[([^\\]]*?)\\]\\([^)]+\\)/g, '$1');\n    \n    // 处理各种非标准格式的图片标记\n    text = text.replace(/!图片\\s*\\)/g, '');\n    text = text.replace(/!图片\\s*$/g, '');\n    text = text.replace(/!图片[\\s\\S]*?\\)/g, '');\n    text = text.replace(/^\\s*\\)\\s*$/gm, '');\n    text = text.replace(/^\\s*$/gm, '');\n\n    // 处理列表\n    text = text.replace(/^[\\s]*[\\-*+]\\s+/gm, ''); // 无序列表\n    text = text.replace(/^[\\s]*\\d+\\.\\s+/gm, ''); // 有序列表\n\n    // 处理引用\n    text = text.replace(/^\\s*>\\s+/gm, '');\n\n    // 处理水平分割线\n    text = text.replace(/^\\s*[-*_]{3,}\\s*$/gm, '\\n');\n\n    // 移除SVG相关标签及其内容\n    text = text.replace(/<svg[^>]*>(([\\s\\S]*?)<\\/svg>)?/gi, '');\n    \n    // 增强SVG标签清理\n    const svgElements = 'svg|rect|circle|path|line|polygon|polyline|g|defs|use|symbol|ellipse|text|image|clipPath|mask|pattern|filter|marker|linearGradient|radialGradient|stop|tspan|textPath|animate|animateMotion|animateTransform|set|foreignObject|switch|desc|title|metadata';\n    text = text.replace(new RegExp(`<(${svgElements})(\\\\s[^>]*)?\\\\/?>`,'gi'), '');\n    text = text.replace(new RegExp(`<\\\\/(${svgElements})>`,'gi'), '');\n    \n    // 移除单独的SVG标签片段\n    text = text.replace(/[\\s']+(?:rect|circle|path|g|svg|defs|use|symbol)\\s*\\/?/gi, ' ');\n    text = text.replace(/[\\s']+\\/(?:rect|circle|path|g|svg|defs|use|symbol)\\s*/gi, ' ');\n    \n    // 移除括号内的SVG标签片段\n    text = text.replace(/\\([^\\)]*?(?:rect|circle|path|g|svg)[^\\)]*?\\)/gi, '');\n    \n    // 清理SVG属性和标签片段\n    text = text.replace(/['\"\\s]+(fill|x|y|width|height|rx|ry|cx|cy|r|d|points|viewBox|xmlns)=['\"]?[^'\">\\s]*['\"]?/gi, ' ');\n    text = text.replace(/\\s+(?:\\/)?(?:rect|circle|path|g|svg|defs|use|symbol|ellipse|text)(?:\\s+|\\/)/gi, ' ');\n    text = text.replace(/\\s+\\/(?:rect|circle|path|g|svg|defs|use|symbol|ellipse|text)(?:\\s+|$)/gi, ' ');\n    \n    // 移除SVG和HTML常见属性\n    const commonAttributes = 'xmlns|version|viewBox|width|height|class|style|id|fill|stroke|d|points|transform|x|y|cx|cy|r|x1|y1|x2|y2|dx|dy|offset|gradientUnits|spreadMethod|patternUnits|patternTransform|markerWidth|markerHeight|refX|refY|orient|font-size|font-family|text-anchor|alignment-baseline|href|xlink:href|preserveAspectRatio';\n    text = text.replace(new RegExp(`\\\\s+(${commonAttributes})=[\\\"\\']([^\\\"\\']*)[\\\"\\'](?:\\\\s+|$)`,'gi'), ' ');\n    \n    // 移除data URI和编码内容\n    text = text.replace(/data:(?:[^;]+;)*(?:base64,)?[a-zA-Z0-9+/]+={0,2}/g, '');\n    text = text.replace(/%[0-9a-fA-F]{2}/g, ' ');\n    \n    // 最终清理：移除任何剩余的SVG相关内容\n    text = text.replace(/\\([^\\)]*(?:svg|rect|g|path|circle)[^\\)]*\\)/gi, '');\n    text = text.replace(/'[^']*(?:svg|rect|g|path|circle)[^']*'/gi, '');\n    text = text.replace(/\"[^\"]*(?:svg|rect|g|path|circle)[^\"]*\"/gi, '');\n    text = text.replace(/(?:\\/)?(?:svg|rect|g|path|circle|defs|use|symbol)(?:\\/)?/gi, '');\n    \n    // 移除其他HTML标签\n    text = text.replace(/<[^>]+>/g, '');\n\n    // 处理转义字符\n    text = text.replace(/\\\\([\\\\`*_{}\\[\\]()#+\\-.!])/g, '$1');\n\n    // 清理多余的空行\n    text = text.replace(/\\n\\s*\\n/g, '\\n\\n');\n    text = text.replace(/^\\s+|\\s+$/g, '');\n\n    return text;\n}\n\n/**\n * 将文本按指定长度分段\n * @param {string} text - 输入文本\n * @param {number} segmentLength - 每段文本的最大长度\n * @returns {string[]} - 分段后的文本数组\n */\nfunction splitTextIntoSegments(text, segmentLength = 1800) {\n    const segments = [];\n    let remainingText = text;\n\n    while (remainingText.length > 0) {\n        if (remainingText.length <= segmentLength) {\n            segments.push(remainingText);\n            break;\n        }\n\n        let endIndex = segmentLength;\n        // 尝试在句子或段落边界处分段\n        const nextParagraph = remainingText.indexOf('\\n\\n', endIndex - 100);\n        const nextSentence = remainingText.indexOf('. ', endIndex - 100);\n\n        if (nextParagraph !== -1 && nextParagraph < endIndex + 100) {\n            endIndex = nextParagraph;\n        } else if (nextSentence !== -1 && nextSentence < endIndex + 100) {\n            endIndex = nextSentence + 1;\n        }\n\n        segments.push(remainingText.substring(0, endIndex).trim());\n        remainingText = remainingText.substring(endIndex).trim();\n    }\n\n    return segments;\n}\n\n// 获取所有输入数据项\nconst inputItems = $input.all();\nconst results = [];\n\n// 遍历处理每个输入数据项\nfor (let i = 0; i < inputItems.length; i++) {\n    const currentItem = inputItems[i];\n    const markdownInput = currentItem.json.data;\n    \n    if (!markdownInput) {\n        // 如果没有数据，跳过这个项目\n        continue;\n    }\n    \n    const plainText = markdownToText(markdownInput);\n    const textSegments = splitTextIntoSegments(plainText);\n\n    // 将文本段落转换为规范的block对象格式\n    const blocks = textSegments.map(segment => ({\n        object: 'block',\n        type: 'paragraph',\n        paragraph: {\n            rich_text: [\n                {\n                    type: 'text',\n                    annotations: {\n                        bold: false,\n                        strikethrough: false,\n                        underline: false,\n                        italic: false,\n                        code: false,\n                        color: 'default'\n                    },\n                    text: {\n                        content: segment\n                    }\n                }\n            ]\n        }\n    }));\n\n    // 只返回blocks字段\n    results.push({\n        json: {\n            blocks: blocks\n        }\n    });\n}\n\nreturn results;\n"
179
      },
180
      "type": "n8n-nodes-base.code",
181
      "typeVersion": 2,
182
      "position": [
183
        440,
184
        0
185
      ],
186
      "id": "aa48ed34-8002-42c1-84e4-8412ccbc994a",
187
      "name": "将Markdown文本转换为纯文本"
188
    },
189
    {
190
      "parameters": {
191
        "method": "PATCH",
192
        "url": "=https://api.notion.com/v1/blocks/{{ $json.id }}/children",
193
        "authentication": "predefinedCredentialType",
194
        "nodeCredentialType": "notionApi",
195
        "sendBody": true,
196
        "bodyParameters": {
197
          "parameters": [
198
            {
199
              "name": "children",
200
              "value": "={{ $json.blocks }}"
201
            }
202
          ]
203
        },
204
        "options": {
205
          "batching": {
206
            "batch": {
207
              "batchSize": 1,
208
              "batchInterval": 5000
209
            }
210
          }
211
        }
212
      },
213
      "type": "n8n-nodes-base.httpRequest",
214
      "typeVersion": 4.2,
215
      "position": [
216
        880,
217
        180
218
      ],
219
      "id": "d90ab579-1acf-4e0f-a6f5-b3bf30df1787",
220
      "name": "HTTP Request2",
221
      "credentials": {
222
        "notionApi": {
223
          "id": "p9ESbt4TrdVy1Eq0",
224
          "name": "Notion account"
225
        }
226
      },
227
      "onError": "continueRegularOutput"
228
    },
229
    {
230
      "parameters": {
231
        "mode": "combine",
232
        "combineBy": "combineByPosition",
233
        "options": {}
234
      },
235
      "type": "n8n-nodes-base.merge",
236
      "typeVersion": 3.2,
237
      "position": [
238
        660,
239
        100
240
      ],
241
      "id": "f8cda93f-baa4-4f00-8323-f18ed5768cbc",
242
      "name": "Merge"
243
    },
244
    {
245
      "parameters": {
246
        "jsCode": "const array1 = $input.first().json.biz;\nconst array2 = $input.first().json.name;\nconst combined = [];\n\nfor (let i = 0; i < array1.length; i++) {\n  combined.push({\n    key: array1[i],\n    value: array2[i]\n  });\n}\n\nreturn combined.map(item => ({ json: item }));\n"
247
      },
248
      "type": "n8n-nodes-base.code",
249
      "typeVersion": 2,
250
      "position": [
251
        -1100,
252
        180
253
      ],
254
      "id": "44c229a5-fb2a-49db-a037-d35cc816f145",
255
      "name": "Code"
256
    },
257
    {
258
      "parameters": {
259
        "content": "## 文章同步完成后动作\n- 发送Telegram通知\n- 执行内容加工工作流，如：日报工作流、小红书发布工作流等",
260
        "height": 360,
261
        "color": 6
262
      },
263
      "type": "n8n-nodes-base.stickyNote",
264
      "position": [
265
        -720,
266
        20
267
      ],
268
      "typeVersion": 1,
269
      "id": "c8a3ef38-5ccf-41db-b97f-2e6c9bc2251d",
270
      "name": "Sticky Note"
271
    },
272
    {
273
      "parameters": {
274
        "resource": "databasePage",
275
        "databaseId": {
276
          "__rl": true,
277
          "value": "22c977e7-bf54-80fe-8606-e6291091d347",
278
          "mode": "list",
279
          "cachedResultName": "AI资讯",
280
          "cachedResultUrl": "https://www.notion.so/22c977e7bf5480fe8606e6291091d347"
281
        },
282
        "title": "={{ $json.title }}",
283
        "propertiesUi": {
284
          "propertyValues": [
285
            {
286
              "key": "标题|title",
287
              "title": "={{ $json.title }}"
288
            },
289
            {
290
              "key": "url|rich_text",
291
              "textContent": "={{ $json.url }}"
292
            },
293
            {
294
              "key": "时间|rich_text",
295
              "textContent": "={{ $json.post_time_str }}"
296
            },
297
            {
298
              "key": "来源|rich_text",
299
              "textContent": "={{ $('Loop Over Items').item.json.value }}"
300
            }
301
          ]
302
        },
303
        "options": {}
304
      },
305
      "type": "n8n-nodes-base.notion",
306
      "typeVersion": 2.2,
307
      "position": [
308
        380,
309
        200
310
      ],
311
      "id": "76a42023-6d48-49e9-8e2d-bcb83fac8469",
312
      "name": "Create a database page",
313
      "credentials": {
314
        "notionApi": {
315
          "id": "p9ESbt4TrdVy1Eq0",
316
          "name": "Notion account"
317
        }
318
      }
319
    }
320
  ],
321
  "pinData": {},
322
  "connections": {
323
    "When clicking ‘Execute workflow’": {
324
      "main": [
325
        [
326
          {
327
            "node": "Edit Fields",
328
            "type": "main",
329
            "index": 0
330
          }
331
        ]
332
      ]
333
    },
334
    "Edit Fields": {
335
      "main": [
336
        [
337
          {
338
            "node": "Code",
339
            "type": "main",
340
            "index": 0
341
          }
342
        ]
343
      ]
344
    },
345
    "Loop Over Items": {
346
      "main": [
347
        [],
348
        [
349
          {
350
            "node": "HTTP Request",
351
            "type": "main",
352
            "index": 0
353
          }
354
        ]
355
      ]
356
    },
357
    "HTTP Request": {
358
      "main": [
359
        [
360
          {
361
            "node": "Split Out1",
362
            "type": "main",
363
            "index": 0
364
          }
365
        ]
366
      ]
367
    },
368
    "HTTP Request1": {
369
      "main": [
370
        [
371
          {
372
            "node": "HTML",
373
            "type": "main",
374
            "index": 0
375
          }
376
        ]
377
      ]
378
    },
379
    "HTML": {
380
      "main": [
381
        [
382
          {
383
            "node": "将Markdown文本转换为纯文本",
384
            "type": "main",
385
            "index": 0
386
          }
387
        ]
388
      ]
389
    },
390
    "Limit": {
391
      "main": [
392
        [
393
          {
394
            "node": "Loop Over Items",
395
            "type": "main",
396
            "index": 0
397
          }
398
        ]
399
      ]
400
    },
401
    "Split Out1": {
402
      "main": [
403
        [
404
          {
405
            "node": "HTTP Request1",
406
            "type": "main",
407
            "index": 0
408
          },
409
          {
410
            "node": "Create a database page",
411
            "type": "main",
412
            "index": 0
413
          }
414
        ]
415
      ]
416
    },
417
    "将Markdown文本转换为纯文本": {
418
      "main": [
419
        [
420
          {
421
            "node": "Merge",
422
            "type": "main",
423
            "index": 0
424
          }
425
        ]
426
      ]
427
    },
428
    "Merge": {
429
      "main": [
430
        [
431
          {
432
            "node": "HTTP Request2",
433
            "type": "main",
434
            "index": 0
435
          }
436
        ]
437
      ]
438
    },
439
    "Code": {
440
      "main": [
441
        [
442
          {
443
            "node": "Limit",
444
            "type": "main",
445
            "index": 0
446
          }
447
        ]
448
      ]
449
    },
450
    "HTTP Request2": {
451
      "main": [
452
        [
453
          {
454
            "node": "Loop Over Items",
455
            "type": "main",
456
            "index": 0
457
          }
458
        ]
459
      ]
460
    },
461
    "Create a database page": {
462
      "main": [
463
        [
464
          {
465
            "node": "Merge",
466
            "type": "main",
467
            "index": 1
468
          }
469
        ]
470
      ]
471
    }
472
  },
473
  "active": false,
474
  "settings": {
475
    "executionOrder": "v1"
476
  },
477
  "versionId": "cd2c82a4-1f94-406d-88c1-844e20e7f548",
478
  "meta": {
479
    "templateCredsSetupCompleted": true,
480
    "instanceId": "ee5a0f120935b4b9d760798993ffeb282a815d20023e81bf0157ea4e4d3aad64"
481
  },
482
  "id": "kn2URDK94wsWOj4F",
483
  "tags": []
484
}