基于动态提示和Baserow的AI数据提取
高级
这是一个AI领域的自动化工作流，包含 45 个节点。主要使用 Set, Code, Filter, Switch, Webhook 等节点，结合人工智能技术实现智能自动化。 基于动态提示和Baserow的AI数据提取
前置要求
- •HTTP Webhook 端点（n8n 会自动生成）
- •可能需要目标 API 的认证凭证
- •OpenAI API Key
使用的节点 (45)
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"nodes": [
{
"id": "065d7ec9-edc5-46f6-b8ac-d62ed0e5c8e3",
"name": "Baserow 事件",
"type": "n8n-nodes-base.webhook",
"position": [
-1180,
-140
],
"webhookId": "267ea500-e2cd-4604-a31f-f0773f27317c",
"parameters": {
"path": "267ea500-e2cd-4604-a31f-f0773f27317c",
"options": {},
"httpMethod": "POST"
},
"typeVersion": 2
},
{
"id": "ac1403b4-9d45-404d-9892-0bed39b9ec82",
"name": "事件类型",
"type": "n8n-nodes-base.switch",
"position": [
-220,
-140
],
"parameters": {
"rules": {
"values": [
{
"outputKey": "rows.updated",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "2162daf8-d23d-4b8f-8257-bdfc5400a3a8",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.event_type }}",
"rightValue": "rows.updated"
}
]
},
"renameOutput": true
},
{
"outputKey": "field.created",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "48e112f6-afe8-40bf-b673-b37446934a62",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.event_type }}",
"rightValue": "field.created"
}
]
},
"renameOutput": true
},
{
"outputKey": "field.updated",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "5aa258cd-15c2-4156-a32d-afeed662a38e",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.event_type }}",
"rightValue": "field.updated"
}
]
},
"renameOutput": true
}
]
},
"options": {}
},
"typeVersion": 3.2
},
{
"id": "c501042d-f9e7-4c1a-b01d-b11392b1a804",
"name": "表字段 API",
"type": "n8n-nodes-base.httpRequest",
"position": [
-900,
-140
],
"parameters": {
"url": "=https://api.baserow.io/api/database/fields/table/{{ $json.body.table_id }}/",
"options": {},
"sendQuery": true,
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"queryParameters": {
"parameters": [
{
"name": "user_field_names",
"value": "true"
}
]
}
},
"credentials": {
"httpHeaderAuth": {
"id": "F28aPWK5NooSHAg0",
"name": "Baserow (n8n-local)"
}
},
"typeVersion": 4.2
},
{
"id": "af6c3b7f-bb8b-4037-8e3b-337d81ca5632",
"name": "获取提示字段",
"type": "n8n-nodes-base.code",
"position": [
-720,
-140
],
"parameters": {
"jsCode": "const fields = $input.all()\n .filter(item => item.json.description)\n .map(item => ({\n id: item.json.id,\n order: item.json.order,\n name: item.json.name,\n description: item.json.description,\n }));\n\nreturn { json: { fields } };"
},
"typeVersion": 2
},
{
"id": "e1f8f740-c784-4f07-9265-76db518f3ebc",
"name": "获取事件主体",
"type": "n8n-nodes-base.set",
"position": [
-380,
-140
],
"parameters": {
"mode": "raw",
"options": {},
"jsonOutput": "={{ $('Baserow Event').first().json.body }}"
},
"typeVersion": 3.4
},
{
"id": "e303b7c3-639a-4136-8aa4-074eedeb273f",
"name": "列出表 API",
"type": "n8n-nodes-base.httpRequest",
"position": [
480,
220
],
"parameters": {
"url": "=https://api.baserow.io/api/database/rows/table/{{ $json.table_id }}/",
"options": {
"pagination": {
"pagination": {
"nextURL": "={{ $response.body.next || `https://api.baserow.io/api/database/rows/table/${$json.table_id}/?user_field_names=true&size=20&page=9999` }}",
"maxRequests": 3,
"paginationMode": "responseContainsNextURL",
"requestInterval": 1000,
"limitPagesFetched": true,
"completeExpression": "={{ $response.body.isEmpty() || $response.statusCode >= 400 }}",
"paginationCompleteWhen": "other"
}
}
},
"sendQuery": true,
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"queryParameters": {
"parameters": [
{
"name": "user_field_names",
"value": "true"
},
{
"name": "size",
"value": "20"
},
{
"name": "include",
"value": "id,order,_id,name,created_at,last_modified_at"
},
{
"name": "filters",
"value": "{\"filter_type\":\"AND\",\"filters\":[{\"type\":\"not_empty\",\"field\":\"File\",\"value\":\"\"}],\"groups\":[]}"
}
]
}
},
"credentials": {
"httpHeaderAuth": {
"id": "F28aPWK5NooSHAg0",
"name": "Baserow (n8n-local)"
}
},
"typeVersion": 4.2
},
{
"id": "9ad2e0c8-c92d-460d-be7a-237ce29b34c2",
"name": "获取有效行",
"type": "n8n-nodes-base.code",
"position": [
640,
220
],
"parameters": {
"jsCode": "return $input.all()\n .filter(item => item.json.results?.length)\n .flatMap(item => item.json.results);"
},
"typeVersion": 2
},
{
"id": "72b137e9-2e87-4580-9282-0ab7c5147f68",
"name": "获取文件数据",
"type": "n8n-nodes-base.httpRequest",
"position": [
1320,
320
],
"parameters": {
"url": "={{ $json.File[0].url }}",
"options": {}
},
"typeVersion": 4.2
},
{
"id": "d479ee4e-4a87-4a0e-b9ca-4aa54afdc67a",
"name": "从文件提取",
"type": "n8n-nodes-base.extractFromFile",
"position": [
1480,
320
],
"parameters": {
"options": {},
"operation": "pdf"
},
"typeVersion": 1
},
{
"id": "717e36f8-7dd7-44a6-bcef-9f20735853d2",
"name": "更新行",
"type": "n8n-nodes-base.httpRequest",
"notes": "Execute Once",
"onError": "continueRegularOutput",
"maxTries": 2,
"position": [
2280,
380
],
"parameters": {
"url": "=https://api.baserow.io/api/database/rows/table/{{ $('Event Ref').first().json.table_id }}/{{ $('Row Reference').item.json.id }}/",
"method": "PATCH",
"options": {},
"jsonBody": "={{\n{\n ...$input.all()\n .reduce((acc, item) => ({\n ...acc,\n [item.json.field]: item.json.value\n }), {})\n}\n}}",
"sendBody": true,
"sendQuery": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"queryParameters": {
"parameters": [
{
"name": "user_field_names",
"value": "true"
}
]
}
},
"credentials": {
"httpHeaderAuth": {
"id": "F28aPWK5NooSHAg0",
"name": "Baserow (n8n-local)"
}
},
"executeOnce": true,
"notesInFlow": true,
"retryOnFail": false,
"typeVersion": 4.2,
"waitBetweenTries": 3000
},
{
"id": "b807a9c0-2334-491c-a259-1e0e266f89df",
"name": "获取结果",
"type": "n8n-nodes-base.set",
"position": [
2100,
380
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "3ad72567-1d17-4910-b916-4c34a43b1060",
"name": "field",
"type": "string",
"value": "={{ $('Event Ref').first().json.field.name }}"
},
{
"id": "e376ba60-8692-4962-9af7-466b6a3f44a2",
"name": "value",
"type": "string",
"value": "={{ $json.text.trim() }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "d29a58db-f547-4a4b-bc20-10e14529e474",
"name": "遍历项目",
"type": "n8n-nodes-base.splitInBatches",
"position": [
900,
220
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "233b2e96-7873-42f0-989f-c3df5a8e4542",
"name": "行引用",
"type": "n8n-nodes-base.noOp",
"position": [
1080,
320
],
"parameters": {},
"typeVersion": 1
},
{
"id": "396eb9c0-dcde-4735-9e15-bf6350def086",
"name": "生成字段值",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
1640,
320
],
"parameters": {
"text": "=<file>\n{{ $json.text }}\n</file>\n\nData to extract: {{ $('Event Ref').first().json.field.description }}\noutput format is: {{ $('Event Ref').first().json.field.type }}",
"messages": {
"messageValues": [
{
"message": "=You assist the user in extracting the required data from the given file.\n* Keep you answer short.\n* If you cannot extract the requested data, give you response as \"n/a\"."
}
]
},
"promptType": "define"
},
"typeVersion": 1.5
},
{
"id": "4be0a9e5-e77e-4cea-9dd3-bc6e7de7a72b",
"name": "获取行",
"type": "n8n-nodes-base.httpRequest",
"position": [
640,
-420
],
"parameters": {
"url": "=https://api.baserow.io/api/database/rows/table/{{ $('Event Ref1').first().json.table_id }}/{{ $json.id }}/",
"options": {},
"sendQuery": true,
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"queryParameters": {
"parameters": [
{
"name": "user_field_names",
"value": "true"
}
]
}
},
"credentials": {
"httpHeaderAuth": {
"id": "F28aPWK5NooSHAg0",
"name": "Baserow (n8n-local)"
}
},
"typeVersion": 4.2
},
{
"id": "40fc77b8-a986-40ab-a78c-da05a3f171c2",
"name": "行转列表",
"type": "n8n-nodes-base.splitOut",
"position": [
320,
-420
],
"parameters": {
"options": {},
"fieldToSplitOut": "items"
},
"typeVersion": 1
},
{
"id": "4c5bc9c8-1bcb-48b1-82d0-5cf04535108c",
"name": "要更新的字段",
"type": "n8n-nodes-base.code",
"position": [
1640,
-300
],
"parameters": {
"jsCode": "const row = $('Row Ref').first().json;\nconst fields = $('Get Prompt Fields').first().json.fields;\nconst missingFields = fields\n .filter(field => field.description && !row[field.name]);\n\nreturn missingFields;"
},
"typeVersion": 2
},
{
"id": "85d5c817-e5f8-45ea-bf7f-efc7913f542c",
"name": "遍历项目1",
"type": "n8n-nodes-base.splitInBatches",
"position": [
900,
-420
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "69005b35-9c66-4c14-80a9-ef8e945dab30",
"name": "行引用",
"type": "n8n-nodes-base.noOp",
"position": [
1080,
-300
],
"parameters": {},
"typeVersion": 1
},
{
"id": "1b0e14da-13a8-4023-9006-464578bf0ff5",
"name": "获取文件数据1",
"type": "n8n-nodes-base.httpRequest",
"position": [
1320,
-300
],
"parameters": {
"url": "={{ $('Row Ref').item.json.File[0].url }}",
"options": {}
},
"typeVersion": 4.2
},
{
"id": "47cf67bc-a3e2-4796-b5a7-4f6a6aef3e90",
"name": "从文件1 提取",
"type": "n8n-nodes-base.extractFromFile",
"position": [
1480,
-300
],
"parameters": {
"options": {},
"operation": "pdf"
},
"typeVersion": 1
},
{
"id": "3dc743cc-0dde-4349-975c-fa453d99dbaf",
"name": "更新行1",
"type": "n8n-nodes-base.httpRequest",
"notes": "Execute Once",
"onError": "continueRegularOutput",
"maxTries": 2,
"position": [
2440,
-260
],
"parameters": {
"url": "=https://api.baserow.io/api/database/rows/table/{{ $('Event Ref1').first().json.table_id }}/{{ $('Row Ref').first().json.id }}/",
"method": "PATCH",
"options": {},
"jsonBody": "={{\n{\n ...$input.all()\n .reduce((acc, item) => ({\n ...acc,\n [item.json.field]: item.json.value\n }), {})\n}\n}}",
"sendBody": true,
"sendQuery": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"queryParameters": {
"parameters": [
{
"name": "user_field_names",
"value": "true"
}
]
}
},
"credentials": {
"httpHeaderAuth": {
"id": "F28aPWK5NooSHAg0",
"name": "Baserow (n8n-local)"
}
},
"executeOnce": true,
"notesInFlow": true,
"retryOnFail": false,
"typeVersion": 4.2,
"waitBetweenTries": 3000
},
{
"id": "49c53281-d323-4794-919a-d807d7ccc25e",
"name": "获取结果1",
"type": "n8n-nodes-base.set",
"position": [
2260,
-260
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "3ad72567-1d17-4910-b916-4c34a43b1060",
"name": "field",
"type": "string",
"value": "={{ $('Fields to Update').item.json.name }}"
},
{
"id": "e376ba60-8692-4962-9af7-466b6a3f44a2",
"name": "value",
"type": "string",
"value": "={{ $json.text.trim() }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "bc23708a-b177-47db-8a30-4330198710e0",
"name": "生成字段值1",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
1800,
-300
],
"parameters": {
"text": "=<file>\n{{ $('Extract from File1').first().json.text }}\n</file>\n\nData to extract: {{ $json.description }}\noutput format is: {{ $json.type }}",
"messages": {
"messageValues": [
{
"message": "=You assist the user in extracting the required data from the given file.\n* Keep you answer short.\n* If you cannot extract the requested data, give you response as \"n/a\" followed by \"(reason)\" where reason is replaced with reason why data could not be extracted."
}
]
},
"promptType": "define"
},
"typeVersion": 1.5
},
{
"id": "c0297c19-04b8-4d56-9ce0-320b399f73bd",
"name": "筛选有效行",
"type": "n8n-nodes-base.filter",
"position": [
480,
-420
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "7ad58f0b-0354-49a9-ab2f-557652d7b416",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.File[0].url }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "5aab6971-1d6f-4b82-a218-4e25c7b28052",
"name": "筛选有效字段",
"type": "n8n-nodes-base.filter",
"position": [
320,
220
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "5b4a7393-788c-42dc-ac1f-e76f833f8534",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.field.description }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "bc144115-f3a2-4e99-a35c-4a780754d0fb",
"name": "事件引用",
"type": "n8n-nodes-base.noOp",
"position": [
160,
220
],
"parameters": {},
"typeVersion": 1
},
{
"id": "13fd10c0-d4eb-463a-a8b6-5471380f3710",
"name": "事件引用1",
"type": "n8n-nodes-base.noOp",
"position": [
160,
-420
],
"parameters": {},
"typeVersion": 1
},
{
"id": "e07053a4-a130-41b0-85d3-dfa3983b1547",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1000,
-340
],
"parameters": {
"color": 7,
"width": 480,
"height": 440,
"content": "### 1. 获取表模式"
},
"typeVersion": 1
},
{
"id": "675b9d6a-1ba6-49ce-b569-38cc0ba04dcb",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-260,
-440
],
"parameters": {
"color": 5,
"width": 330,
"height": 80,
"content": "### 2a. 更新最少数量的行"
},
"typeVersion": 1
},
{
"id": "021d51f9-7a5b-4f93-baad-707144aeb7ba",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-320,
140
],
"parameters": {
"color": 5,
"width": 390,
"height": 120,
"content": "### 2b. 更新字段下的每一行"
},
"typeVersion": 1
},
{
"id": "ae49cfb0-ac83-4501-bc01-d98be32798f0",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1780,
-1060
],
"parameters": {
"width": 520,
"height": 1160,
"content": "## 试试看！"
},
"typeVersion": 1
},
{
"id": "23ea63f5-e1ad-4326-95a4-945bf98d03f4",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-500,
-340
],
"parameters": {
"color": 7,
"width": 580,
"height": 440,
"content": "### 2. 事件路由器模式"
},
"typeVersion": 1
},
{
"id": "179f9459-43d0-4342-ab94-e248730182a5",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
100,
-620
],
"parameters": {
"color": 7,
"width": 700,
"height": 400,
"content": "### 3. 筛选仅包含有效输入的行"
},
"typeVersion": 1
},
{
"id": "7124a8c0-549e-4b82-8e1f-c6428d2bfb44",
"name": "便签7",
"type": "n8n-nodes-base.stickyNote",
"position": [
2140,
-480
],
"parameters": {
"color": 7,
"width": 520,
"height": 440,
"content": "### 6. 更新 Baserow 表行"
},
"typeVersion": 1
},
{
"id": "c55ce945-10ba-440b-a444-81cb4ed63539",
"name": "便签8",
"type": "n8n-nodes-base.stickyNote",
"position": [
1260,
-580
],
"parameters": {
"color": 7,
"width": 860,
"height": 580,
"content": "### 5. PDF、LLM 和动态提示？哦，天哪！"
},
"typeVersion": 1
},
{
"id": "1a0ff82e-64aa-479e-8dec-c29b512b0686",
"name": "便签9",
"type": "n8n-nodes-base.stickyNote",
"position": [
820,
-580
],
"parameters": {
"color": 7,
"width": 420,
"height": 460,
"content": "### 4. 使用项目循环"
},
"typeVersion": 1
},
{
"id": "f4562d44-4fc0-4c59-ba90-8b65f1162aac",
"name": "便签 10",
"type": "n8n-nodes-base.stickyNote",
"position": [
100,
40
],
"parameters": {
"color": 7,
"width": 680,
"height": 360,
"content": "### 7. 列出列下的所有行"
},
"typeVersion": 1
},
{
"id": "979983e9-1002-444c-a018-50ce525ef02a",
"name": "便签 11",
"type": "n8n-nodes-base.stickyNote",
"position": [
1260,
140
],
"parameters": {
"color": 7,
"width": 700,
"height": 500,
"content": "### 9. 使用 LLM 生成值"
},
"typeVersion": 1
},
{
"id": "f38aa7a3-479b-4876-87bf-769ada3089f2",
"name": "OpenAI 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
1800,
-140
],
"parameters": {
"options": {}
},
"credentials": {
"openAiApi": {
"id": "8gccIjcuf3gvaoEr",
"name": "OpenAi account"
}
},
"typeVersion": 1.1
},
{
"id": "a5061210-2e6b-4b62-994f-594fc10a0ac6",
"name": "便签12",
"type": "n8n-nodes-base.stickyNote",
"position": [
820,
40
],
"parameters": {
"color": 7,
"width": 420,
"height": 460,
"content": "### 8. 使用项目循环"
},
"typeVersion": 1
},
{
"id": "e47e36d4-bf6d-48d3-9e52-d8bbac06c4b4",
"name": "OpenAI 聊天模型1",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
1640,
500
],
"parameters": {
"options": {}
},
"credentials": {
"openAiApi": {
"id": "8gccIjcuf3gvaoEr",
"name": "OpenAi account"
}
},
"typeVersion": 1.1
},
{
"id": "52501eab-861e-4de9-837d-65879cd43e5b",
"name": "便签13",
"type": "n8n-nodes-base.stickyNote",
"position": [
1980,
200
],
"parameters": {
"color": 7,
"width": 500,
"height": 380,
"content": "### 10. 更新 Baserow 表行"
},
"typeVersion": 1
},
{
"id": "6d9fb2e9-6aca-4276-b9b3-d409be24e40e",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1780,
-1200
],
"parameters": {
"color": 7,
"height": 120,
"content": ""
},
"typeVersion": 1
},
{
"id": "bccfc32b-fd18-4de7-88d5-0aeb02ab7954",
"name": "便签14",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1200,
-1280
],
"parameters": {
"color": 5,
"width": 820,
"height": 800,
"content": "## ⭐️ 创建 Baserow Webhooks"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"Get Row": {
"main": [
[
{
"node": "Loop Over Items1",
"type": "main",
"index": 0
}
]
]
},
"Row Ref": {
"main": [
[
{
"node": "Get File Data1",
"type": "main",
"index": 0
}
]
]
},
"Event Ref": {
"main": [
[
{
"node": "Filter Valid Fields",
"type": "main",
"index": 0
}
]
]
},
"Event Ref1": {
"main": [
[
{
"node": "Rows to List",
"type": "main",
"index": 0
}
]
]
},
"Event Type": {
"main": [
[
{
"node": "Event Ref1",
"type": "main",
"index": 0
}
],
[
{
"node": "Event Ref",
"type": "main",
"index": 0
}
],
[
{
"node": "Event Ref",
"type": "main",
"index": 0
}
]
]
},
"Get Result": {
"main": [
[
{
"node": "Update Row",
"type": "main",
"index": 0
}
]
]
},
"Update Row": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Get Result1": {
"main": [
[
{
"node": "Update Row1",
"type": "main",
"index": 0
}
]
]
},
"Update Row1": {
"main": [
[
{
"node": "Loop Over Items1",
"type": "main",
"index": 0
}
]
]
},
"Rows to List": {
"main": [
[
{
"node": "Filter Valid Rows",
"type": "main",
"index": 0
}
]
]
},
"Baserow Event": {
"main": [
[
{
"node": "Table Fields API",
"type": "main",
"index": 0
}
]
]
},
"Get File Data": {
"main": [
[
{
"node": "Extract from File",
"type": "main",
"index": 0
}
]
]
},
"Row Reference": {
"main": [
[
{
"node": "Get File Data",
"type": "main",
"index": 0
}
]
]
},
"Get Event Body": {
"main": [
[
{
"node": "Event Type",
"type": "main",
"index": 0
}
]
]
},
"Get File Data1": {
"main": [
[
{
"node": "Extract from File1",
"type": "main",
"index": 0
}
]
]
},
"Get Valid Rows": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"List Table API": {
"main": [
[
{
"node": "Get Valid Rows",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "Row Reference",
"type": "main",
"index": 0
}
]
]
},
"Fields to Update": {
"main": [
[
{
"node": "Generate Field Value1",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items1": {
"main": [
[],
[
{
"node": "Row Ref",
"type": "main",
"index": 0
}
]
]
},
"Table Fields API": {
"main": [
[
{
"node": "Get Prompt Fields",
"type": "main",
"index": 0
}
]
]
},
"Extract from File": {
"main": [
[
{
"node": "Generate Field Value",
"type": "main",
"index": 0
}
]
]
},
"Filter Valid Rows": {
"main": [
[
{
"node": "Get Row",
"type": "main",
"index": 0
}
]
]
},
"Get Prompt Fields": {
"main": [
[
{
"node": "Get Event Body",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "Generate Field Value1",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Extract from File1": {
"main": [
[
{
"node": "Fields to Update",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Model1": {
"ai_languageModel": [
[
{
"node": "Generate Field Value",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Filter Valid Fields": {
"main": [
[
{
"node": "List Table API",
"type": "main",
"index": 0
}
]
]
},
"Generate Field Value": {
"main": [
[
{
"node": "Get Result",
"type": "main",
"index": 0
}
]
]
},
"Generate Field Value1": {
"main": [
[
{
"node": "Get Result1",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 人工智能
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
基于动态提示与Airtable的AI数据提取
通过动态提示与Airtable实现AI数据提取
Set
Code
Filter
+11
51 节点Jimleuk
人工智能
使用 n8n、Apify 和 OpenAI o3 自托管 AI 深度研究代理
使用 n8n、Apify 和 OpenAI o3 自托管 AI 深度研究代理
If
Set
Code
+20
87 节点Jimleuk
人工智能
[模板] AI宠物店 v8
🐶 AI宠物店助手 - 集成GPT-4o、Google日历和WhatsApp/Instagram/Facebook
If
N8n
Set
+38
244 节点Amanda Benks
销售
AI 代理餐厅 [模板]
🤖 WhatsApp、Instagram 和 Messenger 的 AI 餐厅助手
If
N8n
Set
+37
239 节点Amanda Benks
其他
宠物店 4
🐶 宠物店预约 AI 代理
If
Set
Code
+41
187 节点Bruno Dias
人工智能
自动化 Discord 垃圾信息审核
结合 AI 和人机协作的自动化 Discord 垃圾信息审核
If
Set
Code
+14
30 节点Jimleuk
人工智能
工作流信息
难度等级
高级
节点数量45
分类1
节点类型13
作者
Jimleuk
@jimleukFreelance consultant based in the UK specialising in AI-powered automations. I work with select clients tackling their most challenging projects. For business enquiries, send me an email at hello@jimle.uk LinkedIn: https://www.linkedin.com/in/jimleuk/ X/Twitter: https://x.com/jimle_uk
外部链接
在 n8n.io 查看 →
分享此工作流