AI Logo表格提取器到Airtable
高级
这是一个Sales, Product, AI, Marketing领域的自动化工作流，包含 44 个节点。主要使用 Set, Code, Html, Merge, Crypto 等节点，结合人工智能技术实现智能自动化。 使用表单、AI、Google Sheet和Airtable从Logo表格中提取信息
前置要求
- •Airtable API Key
- •OpenAI API Key
使用的节点 (44)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "dDAqkobn2pqgdl2N",
"meta": {
"instanceId": "9e331a89ae45a204c6dee51c77131d32a8c962ec20ccf002135ea60bd285dba9"
},
"name": "AI Logo 表格提取器到 Airtable",
"tags": [],
"nodes": [
{
"id": "f7ecadb8-dc5d-4e8c-96b8-52c1dbad49b6",
"name": "表单提交时",
"type": "n8n-nodes-base.formTrigger",
"position": [
-660,
-220
],
"webhookId": "43837a27-f752-40a8-852a-d5d63d647bfd",
"parameters": {
"options": {
"path": "logo-sheet-feeder"
},
"formTitle": "AI Logo Sheet Feeder",
"formFields": {
"values": [
{
"fieldType": "file",
"fieldLabel": "The Logo-Sheet as Image",
"requiredField": true
},
{
"fieldLabel": "Addional Prompt (e.g.: What the meaning of the graphic?) *optional but helps from time to time.",
"placeholder": "It's a graph chart comparing AI Tools"
}
]
},
"formDescription": "Provide a Image with multiple Logos comparing or bringing multiple Tools into Context with one another."
},
"typeVersion": 2.2
},
{
"id": "b1530578-bde9-4ee3-9cdb-545a621cdb84",
"name": "检索和解析代理",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
-180,
-220
],
"parameters": {
"options": {
"systemMessage": "Your task is to retrieve Information from the given Input. Extract Categories and Attributes of all given and shown Tools, Softwares or Products you've got by the user.\n\nProvide the Output Array of Tools with the following Structure as JSON:\n\n[{\n\"name\": \"Name of the Tool, Software, etc.\",\n\"attributes\": [\"Some category or attribute\", \"something else you can see from the context or image\"],\n\"similar\": [\"similar tool, product, etc. from shown context\", \"another similar software, product, tool from context\"]\n},{\n\"name\": \"Name of anotherTool, Software, etc.\",\n\"attributes\": [\"Some category, subcategory or general attribute\", \"something else you can see from the context or image\"],\n\"similar\": [\"similar tool, product, etc. from shown context\", \"another similar software, product, tool from context\"]\n}]\n\nList these structure for all the Products you see!\n\nHere a description of the JSON fields:\n\"name\": Just the Name of the Software.\n\"attribute\": Turn any information from the context or image into multiple useful Attributes for this tool. Could be a category, could be a feature, etc. Try to split this information in multiple specific Attributes or Categories.\n\"similar\": if multiple tools are shown that could compare to this one (like on the same level or in the same category), list those here\n\nTake a deep breath and think step by step.\nTry to extract every mentioned tool. There are for sure multiple listed.",
"passthroughBinaryImages": true
},
"hasOutputParser": true
},
"typeVersion": 1.7
},
{
"id": "51642a02-51a4-4894-adf0-f364736dabc1",
"name": "JSON 化",
"type": "n8n-nodes-base.set",
"position": [
220,
-220
],
"parameters": {
"mode": "raw",
"options": {},
"jsonOutput": "={{ $json.output }}"
},
"typeVersion": 3.4
},
{
"id": "ec0f0575-eb33-48a9-b3fe-c4f5b71ff548",
"name": "结构化输出解析器",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
40,
20
],
"parameters": {
"jsonSchemaExample": "{\n\t\"tools\": [{\n\"name\": \"Name of the Tool, Software, etc.\",\n\"attributes\": [\"Some category or attribute\", \"something else you can see from the context or image\"],\n\"similar\": [\"similar tool, product, etc. from shown context\", \"another similar software, product, tool from context\"]\n},{\n\"name\": \"Name of anotherTool, Software, etc.\",\n\"attributes\": [\"Some category, subcategory or general attribute\", \"something else you can see from the context or image\"],\n\"similar\": [\"similar tool, product, etc. from shown context\", \"another similar software, product, tool from context\"]\n}]}"
},
"typeVersion": 1.2
},
{
"id": "6d78005e-7277-40a9-9f10-e3d8e475cbaf",
"name": "检查属性是否存在",
"type": "n8n-nodes-base.airtable",
"position": [
1380,
0
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appq0gcmxHAZQhswW",
"cachedResultUrl": "https://airtable.com/appq0gcmxHAZQhswW",
"cachedResultName": "AI Tools"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblX2rj8yNAZZRhwt",
"cachedResultUrl": "https://airtable.com/appq0gcmxHAZQhswW/tblX2rj8yNAZZRhwt",
"cachedResultName": "Attributes"
},
"columns": {
"value": {
"Name": "={{$json.attributes}}"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "id",
"defaultMatch": true
},
{
"id": "Name",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Tools",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Tools",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Name"
]
},
"options": {},
"operation": "upsert"
},
"credentials": {
"airtableTokenApi": {
"id": "jMqH6HkKUYTgyHVm",
"name": "Airtable Personal Access Token account"
}
},
"typeVersion": 2.1
},
{
"id": "1c468a4b-4563-4f78-ba1b-138b18ac4821",
"name": "合并",
"type": "n8n-nodes-base.merge",
"position": [
1620,
80
],
"parameters": {
"mode": "combine",
"options": {},
"combineBy": "combineByPosition"
},
"typeVersion": 3
},
{
"id": "4f597962-48e5-4367-a329-bc07d42ff86d",
"name": "映射属性 ID",
"type": "n8n-nodes-base.set",
"position": [
1840,
80
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "675510b1-97e7-4a71-9c9e-d3ee792d9919",
"name": "id",
"type": "string",
"value": "={{ $json.id }}"
},
{
"id": "87cc9086-effd-4f4e-84c1-9adec5774e94",
"name": "attribute",
"type": "string",
"value": "={{ $json.attributes }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "11679757-360c-468f-b624-a9f6853e29f4",
"name": "遍历属性",
"type": "n8n-nodes-base.splitInBatches",
"position": [
720,
-40
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "835a09ae-2e51-488c-b0b3-d895696a135e",
"name": "所有属性",
"type": "n8n-nodes-base.set",
"position": [
940,
-60
],
"parameters": {
"mode": "raw",
"options": {},
"jsonOutput": "={{ $json }}"
},
"typeVersion": 3.4
},
{
"id": "b8ca6d98-ab37-4393-8a2c-561912aeff2b",
"name": "等待属性创建",
"type": "n8n-nodes-base.merge",
"position": [
1120,
-200
],
"parameters": {
"mode": "chooseBranch"
},
"typeVersion": 3
},
{
"id": "9eaf87d4-910b-4a6e-9cdf-ee51ff4180cc",
"name": "将每个属性更改为相应的 RecID",
"type": "n8n-nodes-base.code",
"position": [
1340,
-200
],
"parameters": {
"jsCode": "let knownAttributesOutput = $('All Attributes').all();\nlet knownAttributes = new Map();\nknownAttributesOutput.forEach((nodeOutput)=>{\nknownAttributes.set(nodeOutput.json.attribute.toString().trim(), nodeOutput.json.id);\n});\n\n\nfor (const item of $input.all()) {\n item.json.attributes.forEach((attribute, index)=>{\n item.json.attributes[index] = knownAttributes.get(attribute.toString().trim());\n });\n}\n\nreturn $input.all();"
},
"typeVersion": 2
},
{
"id": "ecfedff4-f6f9-429e-8514-cf8208e70048",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
600,
-280
],
"parameters": {
"color": 5,
"width": 1460,
"height": 600,
"content": "## 属性创建和映射已创建或现有的 ID"
},
"typeVersion": 1
},
{
"id": "ad2fafed-0a42-4615-a882-01306af7caf5",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-260,
-360
],
"parameters": {
"color": 6,
"width": 420,
"height": 540,
"content": "## 处理提供的图像，从中提取信息作为\"工具 -> 属性\"列表。"
},
"typeVersion": 1
},
{
"id": "5eb89e50-7a2f-415c-82f2-99eb8a7ff82f",
"name": "拆分工具",
"type": "n8n-nodes-base.splitOut",
"position": [
440,
-220
],
"parameters": {
"options": {},
"fieldToSplitOut": "tools"
},
"typeVersion": 1
},
{
"id": "680dfb4b-dde4-4d8f-852d-c3eba82e6607",
"name": "拆分每个属性字符串",
"type": "n8n-nodes-base.splitOut",
"position": [
1140,
100
],
"parameters": {
"options": {},
"fieldToSplitOut": "attributes"
},
"typeVersion": 1
},
{
"id": "a33465e9-d469-498f-9178-7c30e15d2782",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
2120,
-280
],
"parameters": {
"color": 4,
"width": 880,
"height": 600,
"content": "## 创建工具（如果不存在）"
},
"typeVersion": 1
},
{
"id": "5b5ab9f2-d4ac-437f-ab0a-b113a8af34ab",
"name": "为名称生成唯一哈希",
"type": "n8n-nodes-base.crypto",
"position": [
2180,
-200
],
"parameters": {
"value": "={{ $json.name.toLowerCase().trim() }}",
"dataPropertyName": "hash"
},
"typeVersion": 1
},
{
"id": "ea8f7e6f-9004-4271-80d3-333701cce488",
"name": "如果不存在则创建",
"type": "n8n-nodes-base.airtable",
"position": [
2400,
-100
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appq0gcmxHAZQhswW",
"cachedResultUrl": "https://airtable.com/appq0gcmxHAZQhswW",
"cachedResultName": "AI Tools"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblrikRHbX1N6P2JI",
"cachedResultUrl": "https://airtable.com/appq0gcmxHAZQhswW/tblrikRHbX1N6P2JI",
"cachedResultName": "Tools"
},
"columns": {
"value": {
"Hash": "={{$json.hash}}",
"Name": "={{$json.name}}"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "id",
"defaultMatch": true
},
{
"id": "Name",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Description",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Website",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Website",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Category",
"type": "array",
"display": true,
"options": [],
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Category",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Attributes",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Attributes",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Hash",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Hash",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Hash"
]
},
"options": {},
"operation": "upsert"
},
"credentials": {
"airtableTokenApi": {
"id": "jMqH6HkKUYTgyHVm",
"name": "Airtable Personal Access Token account"
}
},
"typeVersion": 2.1
},
{
"id": "85ac3cbb-4103-4184-b686-9e5b8d48f421",
"name": "合并旧数据 + RecID",
"type": "n8n-nodes-base.merge",
"position": [
2820,
-180
],
"parameters": {
"mode": "combine",
"options": {},
"fieldsToMatchString": "hash"
},
"typeVersion": 3
},
{
"id": "29d6369f-f233-46f8-8bee-aa3be854bb0c",
"name": "仅我们需要的",
"type": "n8n-nodes-base.set",
"position": [
2600,
-100
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "0ff954ec-1d71-429b-b2e8-dca17ff0478d",
"name": "hash",
"type": "string",
"value": "={{ $json.fields.Hash }}"
},
{
"id": "a7f4c2e7-fa63-45d7-ad22-ce8c3aaae4d6",
"name": "id",
"type": "string",
"value": "={{ $json.id }}"
},
{
"id": "081a7613-7c06-4578-8aa4-25d21952b727",
"name": "existingAttributes",
"type": "array",
"value": "={{ $json.fields.Attributes ? $json.fields.Attributes : [] }}"
},
{
"id": "e3ace89b-d818-4448-8328-b36cdf08da2a",
"name": "existingSimilars",
"type": "array",
"value": "={{ $json.fields.Similar ? $json.fields.Similar : [] }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "bdf9c435-3994-4c25-9520-8dfa76e625eb",
"name": "确定我们应该保存的属性",
"type": "n8n-nodes-base.code",
"position": [
3040,
-180
],
"parameters": {
"mode": "runOnceForEachItem",
"jsCode": "let savingAttributes = $input.item.json.existingAttributes ? $input.item.json.existingAttributes : [];\n$input.item.json.attributes.forEach((attrId)=>{\nif($input.item.json.existingAttributes.indexOf(attrId) == -1) savingAttributes.push(attrId);\n});\n\n$input.item.json.savingAttributes = savingAttributes;\n\nreturn $input.item;"
},
"typeVersion": 2
},
{
"id": "88e9f499-87d3-46e2-b3ea-1833c14aaa1b",
"name": "拆分相似项",
"type": "n8n-nodes-base.splitOut",
"position": [
3300,
20
],
"parameters": {
"options": {},
"fieldToSplitOut": "similar"
},
"typeVersion": 1
},
{
"id": "733a8d0c-c6ea-4386-9fd1-075980289e9c",
"name": "合并1",
"type": "n8n-nodes-base.merge",
"position": [
3960,
0
],
"parameters": {
"mode": "combine",
"options": {},
"combineBy": "combineByPosition"
},
"typeVersion": 3
},
{
"id": "dabb7e11-b4de-44d9-a80f-3302f49194fb",
"name": "为相似项生成唯一哈希",
"type": "n8n-nodes-base.crypto",
"position": [
3520,
-100
],
"parameters": {
"value": "={{ $json.similar.toLowerCase().trim() }}",
"dataPropertyName": "hash"
},
"typeVersion": 1
},
{
"id": "a1bbda24-f75c-4316-b2bd-645827d7af1f",
"name": "它应该存在",
"type": "n8n-nodes-base.airtable",
"position": [
3740,
-100
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appq0gcmxHAZQhswW",
"cachedResultUrl": "https://airtable.com/appq0gcmxHAZQhswW",
"cachedResultName": "AI Tools"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblrikRHbX1N6P2JI",
"cachedResultUrl": "https://airtable.com/appq0gcmxHAZQhswW/tblrikRHbX1N6P2JI",
"cachedResultName": "Tools"
},
"columns": {
"value": {
"Hash": "={{$json.hash}}",
"Name": "={{$json.similar}}"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "id",
"defaultMatch": true
},
{
"id": "Name",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Description",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Website",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Website",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Category",
"type": "array",
"display": true,
"options": [],
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Category",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Attributes",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Attributes",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Hash",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Hash",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Hash"
]
},
"options": {},
"operation": "upsert"
},
"credentials": {
"airtableTokenApi": {
"id": "jMqH6HkKUYTgyHVm",
"name": "Airtable Personal Access Token account"
}
},
"typeVersion": 2.1
},
{
"id": "9853b85d-fcb9-4183-8fe4-6e32d318ab01",
"name": "所有相似项",
"type": "n8n-nodes-base.set",
"position": [
4180,
0
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "675510b1-97e7-4a71-9c9e-d3ee792d9919",
"name": "id",
"type": "string",
"value": "={{ $json.id }}"
},
{
"id": "87cc9086-effd-4f4e-84c1-9adec5774e94",
"name": "similar",
"type": "string",
"value": "={{ $json.similar }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "0e98acd2-4aa5-4df0-b36b-6ac1a8a2263b",
"name": "合并2",
"type": "n8n-nodes-base.merge",
"position": [
4400,
-160
],
"parameters": {
"mode": "chooseBranch"
},
"typeVersion": 3
},
{
"id": "ed94900a-78cd-4f61-a705-30f7cb8eb9b8",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
3200,
-280
],
"parameters": {
"color": 2,
"width": 1600,
"height": 600,
"content": "## 映射竞争对手"
},
"typeVersion": 1
},
{
"id": "74f0f703-ce73-457c-9137-88d613d2e480",
"name": "将每个相似项更改为相应的 RecID",
"type": "n8n-nodes-base.code",
"position": [
4600,
-160
],
"parameters": {
"jsCode": "let knownSimilarsOutput = $('All Similar').all();\nlet knownSimilars = new Map();\nknownSimilarsOutput.forEach((nodeOutput)=>{\n knownSimilars.set(nodeOutput.json.similar.toString().trim(), nodeOutput.json.id);\n});\n\nfor (const item of $input.all()) {\n item.json.similar.forEach((similar, index)=>{\n item.json.similar[index] = knownSimilars.get(similar.toString().trim());\n });\n}\n\nreturn $input.all();"
},
"typeVersion": 2
},
{
"id": "c9187902-f67f-4639-906b-d6b14ace6a0e",
"name": "确定我们应该保存的相似项",
"type": "n8n-nodes-base.code",
"position": [
4880,
-160
],
"parameters": {
"mode": "runOnceForEachItem",
"jsCode": "let savingSimilar = $input.item.json.existingSimilars ? $input.item.json.existingSimilars : [];\n$input.item.json.similar.forEach((simId)=>{\nif($input.item.json.existingSimilars.indexOf(simId) == -1) savingSimilar.push(simId);\n});\n\n$input.item.json.savingSimilars = savingSimilar;\n\nreturn $input.item;"
},
"typeVersion": 2
},
{
"id": "e925a388-05e2-49e4-92ad-984517f44057",
"name": "保存所有这些有价值的数据",
"type": "n8n-nodes-base.airtable",
"position": [
5120,
-160
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appq0gcmxHAZQhswW",
"cachedResultUrl": "https://airtable.com/appq0gcmxHAZQhswW",
"cachedResultName": "AI Tools"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblrikRHbX1N6P2JI",
"cachedResultUrl": "https://airtable.com/appq0gcmxHAZQhswW/tblrikRHbX1N6P2JI",
"cachedResultName": "Tools"
},
"columns": {
"value": {
"Hash": "={{$json.hash}}",
"Name": "={{$json.name}}",
"Similar": "={{ $json.savingSimilars }}",
"Attributes": "={{ $json.savingAttributes }}"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "id",
"defaultMatch": true
},
{
"id": "Name",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Description",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Website",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Website",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Category",
"type": "array",
"display": true,
"options": [],
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Category",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Attributes",
"type": "array",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Attributes",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Hash",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Hash",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Similar",
"type": "array",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Similar",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Hash"
]
},
"options": {},
"operation": "upsert"
},
"credentials": {
"airtableTokenApi": {
"id": "jMqH6HkKUYTgyHVm",
"name": "Airtable Personal Access Token account"
}
},
"typeVersion": 2.1
},
{
"id": "d2532094-9c71-4fc0-8195-fb2e29169086",
"name": "映射代理输入",
"type": "n8n-nodes-base.set",
"position": [
-440,
-220
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "ace29464-a2a1-44a1-87f9-255fbde042cf",
"name": "chatInput",
"type": "string",
"value": "={{$json.Prompt}}"
}
]
},
"includeOtherFields": true
},
"typeVersion": 3.4
},
{
"id": "8fa7273b-ebc8-40e4-9f11-e4b26784f60d",
"name": "gpt-4o",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
-200,
20
],
"parameters": {
"model": "gpt-4o",
"options": {}
},
"credentials": {
"openAiApi": {
"id": "25",
"name": "Key 3 vom 15. Jan. 2023\t"
}
},
"typeVersion": 1
},
{
"id": "fb282ffe-4871-4560-97ce-43cc381db874",
"name": "注释3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1440,
-580
],
"parameters": {
"width": 668,
"height": 786,
"content": "## 说明"
},
"typeVersion": 1
},
{
"id": "9ea45b9b-ac2a-4498-b96f-5f5de50acade",
"name": "表：工具",
"type": "n8n-nodes-base.noOp",
"position": [
-1340,
340
],
"parameters": {},
"typeVersion": 1
},
{
"id": "6dfbc02e-36b3-4640-b9f2-940c7cd6f86e",
"name": "表：属性",
"type": "n8n-nodes-base.noOp",
"position": [
-1000,
340
],
"parameters": {},
"typeVersion": 1
},
{
"id": "d8ffeff8-8df7-4fc0-9f18-49a44d10eb7d",
"name": "注释",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1440,
240
],
"parameters": {
"color": 7,
"width": 668,
"height": 786,
"content": "## Airtable 结构"
},
"typeVersion": 1
},
{
"id": "7023be89-ee1d-41e6-bcf5-ee28f1284e07",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1420,
580
],
"parameters": {
"color": 5,
"width": 300,
"height": 320,
"content": "### 工具表字段"
},
"typeVersion": 1
},
{
"id": "0c999f6f-11fb-472a-aa10-0915fbcd1254",
"name": "使其成为可读列表",
"type": "n8n-nodes-base.html",
"disabled": true,
"position": [
-420,
800
],
"parameters": {
"html": ""
},
"typeVersion": 1.2
},
{
"id": "ae351db3-5c47-4e53-bf9e-e34434ad9522",
"name": "获取架构",
"type": "n8n-nodes-base.airtable",
"disabled": true,
"position": [
-640,
800
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appq0gcmxHAZQhswW",
"cachedResultUrl": "https://airtable.com/appq0gcmxHAZQhswW",
"cachedResultName": "AI Tools"
},
"resource": "base",
"operation": "getSchema"
},
"credentials": {
"airtableTokenApi": {
"id": "jMqH6HkKUYTgyHVm",
"name": "Airtable Personal Access Token account"
}
},
"typeVersion": 2.1
},
{
"id": "9da286e2-2a06-4d2a-bd5b-b6c828683ff2",
"name": "注释1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-720,
660
],
"parameters": {
"color": 7,
"width": 488,
"height": 366,
"content": "## 文档助手（忽略或享受它）"
},
"typeVersion": 1
},
{
"id": "901a0c48-82a9-4fd3-a007-8f4b257348d3",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1080,
580
],
"parameters": {
"color": 5,
"width": 280,
"height": 320,
"content": "### 属性表字段"
},
"typeVersion": 1
},
{
"id": "966243fa-a1a3-4201-9df7-6a01aa762ae8",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-160,
-460
],
"parameters": {
"color": 3,
"width": 220,
"height": 80,
"content": "### 可能想要根据您的\"用例\"调整提示 🤖"
},
"typeVersion": 1
},
{
"id": "1a4e5b87-68a6-499e-9374-e067fae12c84",
"name": "注释4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2440,
-580
],
"parameters": {
"color": 7,
"width": 968,
"height": 646,
"content": "## 示例 Logo 表格"
},
"typeVersion": 1
}
],
"active": true,
"pinData": {
"Retrieve and Parser Agent": [
{
"json": {
"output": {
"tools": [
{
"name": "airOps",
"similar": [
"Cognition",
"Gradial"
],
"attributes": [
"Agentic Application",
"AI infrastructure"
]
},
{
"name": "Cognition",
"similar": [
"airOps",
"Gradial"
],
"attributes": [
"Agentic Application",
"AI infrastructure"
]
},
{
"name": "Gradial",
"similar": [
"Cognition",
"airOps"
],
"attributes": [
"Agentic Application",
"AI infrastructure"
]
},
{
"name": "Cognosys",
"similar": [
"FIXIE",
"continuia"
],
"attributes": [
"Agentic Application",
"AI infrastructure"
]
},
{
"name": "FIXIE",
"similar": [
"Cognosys",
"continuia"
],
"attributes": [
"Agentic Application",
"AI infrastructure"
]
},
{
"name": "continuia",
"similar": [
"Cognosys",
"FIXIE"
],
"attributes": [
"Agentic Application",
"AI infrastructure"
]
},
{
"name": "Agentlabs",
"similar": [
"OpenAI",
"LangChain"
],
"attributes": [
"Presentation Tool",
"Utilizes OpenAI and LangChain"
]
},
{
"name": "TINY FISH",
"similar": [
"Superagent",
"basepilot"
],
"attributes": [
"UI Automation",
"Agent as a Service"
]
},
{
"name": "Superagent",
"similar": [
"TINY FISH",
"basepilot"
],
"attributes": [
"UI Automation",
"Agent as a Service"
]
},
{
"name": "basepilot",
"similar": [
"TINY FISH",
"Superagent"
],
"attributes": [
"UI Automation",
"Agent as a Service"
]
},
{
"name": "Browserbase",
"similar": [
"browsersless",
"APIFY"
],
"attributes": [
"Browser Infrastructure",
"Web services"
]
},
{
"name": "browsersless",
"similar": [
"Browserbase",
"APIFY"
],
"attributes": [
"Browser Infrastructure",
"Web services"
]
},
{
"name": "APIFY",
"similar": [
"Browserbase",
"browsersless"
],
"attributes": [
"Browser Infrastructure",
"Web services"
]
},
{
"name": "Cloudflare",
"similar": [
"bright data",
"platform.sh"
],
"attributes": [
"Browser Infrastructure",
"Web services"
]
},
{
"name": "bright data",
"similar": [
"Cloudflare",
"platform.sh"
],
"attributes": [
"Browser Infrastructure",
"Web services"
]
},
{
"name": "platform.sh",
"similar": [
"Cloudflare",
"bright data"
],
"attributes": [
"Browser Infrastructure",
"Web services"
]
},
{
"name": "ingest",
"similar": [
"hatchet",
"Trigger.dev"
],
"attributes": [
"Persistence Tool",
"Data management"
]
},
{
"name": "hatchet",
"similar": [
"ingest",
"Trigger.dev"
],
"attributes": [
"Persistence Tool",
"Data management"
]
},
{
"name": "Trigger.dev",
"similar": [
"ingest",
"hatchet"
],
"attributes": [
"Persistence Tool",
"Data management"
]
},
{
"name": "DSPy",
"similar": [
"AutoGen",
"Scma4.ai"
],
"attributes": [
"Orchestration Tool",
"AI Workflow Management"
]
},
{
"name": "AutoGen",
"similar": [
"DSPy",
"Scma4.ai"
],
"attributes": [
"Orchestration Tool",
"AI Workflow Management"
]
},
{
"name": "Scma4.ai",
"similar": [
"DSPy",
"AutoGen"
],
"attributes": [
"Orchestration Tool",
"AI Workflow Management"
]
},
{
"name": "WhyHowAI",
"similar": [
"Graphlit",
"LangMem"
],
"attributes": [
"Personalization Tool",
"Memory management"
]
},
{
"name": "Graphlit",
"similar": [
"WhyHowAI",
"LangMem"
],
"attributes": [
"Personalization Tool",
"Memory management"
]
},
{
"name": "LangMem",
"similar": [
"WhyHowAI",
"Graphlit"
],
"attributes": [
"Personalization Tool",
"Memory management"
]
},
{
"name": "Pinecone",
"similar": [
"Chroma",
"Weaviate"
],
"attributes": [
"Storage Tool",
"Memory management"
]
},
{
"name": "Chroma",
"similar": [
"Pinecone",
"Weaviate"
],
"attributes": [
"Storage Tool",
"Memory management"
]
},
{
"name": "Weaviate",
"similar": [
"Pinecone",
"Chroma"
],
"attributes": [
"Storage Tool",
"Memory management"
]
},
{
"name": "MongoDB",
"similar": [
"WhiteLodge",
"Chroma"
],
"attributes": [
"Context Management",
"Data storage"
]
},
{
"name": "LangServe",
"similar": [
"E2B",
"Ollama"
],
"attributes": [
"Agent Hosting",
"Deployment platform"
]
},
{
"name": "E2B",
"similar": [
"LangServe",
"Ollama"
],
"attributes": [
"Agent Hosting",
"Deployment platform"
]
},
{
"name": "Ollama",
"similar": [
"LangServe",
"E2B"
],
"attributes": [
"Agent Hosting",
"Deployment platform"
]
},
{
"name": "LangGraph",
"similar": [
"Semantic Kernel",
"LlamaIndex"
],
"attributes": [
"Framework Tool",
"Graph Management"
]
},
{
"name": "LlamaIndex",
"similar": [
"LangGraph",
"Semantic Kernel"
],
"attributes": [
"Framework Tool",
"Graph Management"
]
},
{
"name": "Semantic Kernel",
"similar": [
"LangGraph",
"LlamaIndex"
],
"attributes": [
"Framework Tool",
"Graph Management"
]
},
{
"name": "agentops",
"similar": [
"context",
"LangSmith"
],
"attributes": [
"Agent Evaluation Tool",
"Performance Assessment"
]
},
{
"name": "context",
"similar": [
"agentops",
"LangSmith"
],
"attributes": [
"Agent Evaluation Tool",
"Performance Assessment"
]
},
{
"name": "LangSmith",
"similar": [
"agentops",
"context"
],
"attributes": [
"Agent Evaluation Tool",
"Performance Assessment"
]
},
{
"name": "WHYLabs",
"similar": [
"griptape",
"braintrust"
],
"attributes": [
"Developer Tools",
"Data Management"
]
},
{
"name": "griptape",
"similar": [
"WHYLabs",
"braintrust"
],
"attributes": [
"Developer Tools",
"Data Management"
]
},
{
"name": "braintrust",
"similar": [
"WHYLabs",
"griptape"
],
"attributes": [
"Developer Tools",
"Data Management"
]
}
]
}
}
}
]
},
"settings": {
"executionOrder": "v1"
},
"versionId": "cd74efad-4f0c-45ea-bc7e-3f7c5554c204",
"connections": {
"Merge": {
"main": [
[
{
"node": "Map Attribute ID",
"type": "main",
"index": 0
}
]
]
},
"Merge1": {
"main": [
[
{
"node": "All Similar",
"type": "main",
"index": 0
}
]
]
},
"Merge2": {
"main": [
[
{
"node": "Change each Smiliar to the corresponding RecID",
"type": "main",
"index": 0
}
]
]
},
"gpt-4o": {
"ai_languageModel": [
[
{
"node": "Retrieve and Parser Agent",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"JSON it": {
"main": [
[
{
"node": "Split Out Tools",
"type": "main",
"index": 0
}
]
]
},
"Get Schema": {
"main": [
[
{
"node": "make it a readable list",
"type": "main",
"index": 0
}
]
]
},
"All Similar": {
"main": [
[
{
"node": "Merge2",
"type": "main",
"index": 1
}
]
]
},
"Table: Tools": {
"main": [
[
{
"node": "Table: Tools",
"type": "main",
"index": 0
},
{
"node": "Table: Attributes",
"type": "main",
"index": 0
}
]
]
},
"All Attributes": {
"main": [
[
{
"node": "Wait for Attribute Creation",
"type": "main",
"index": 1
}
]
]
},
"Map Agent Input": {
"main": [
[
{
"node": "Retrieve and Parser Agent",
"type": "main",
"index": 0
}
]
]
},
"Split Out Tools": {
"main": [
[
{
"node": "Loop Over Attributes",
"type": "main",
"index": 0
},
{
"node": "Wait for Attribute Creation",
"type": "main",
"index": 0
}
]
]
},
"It Should exists": {
"main": [
[
{
"node": "Merge1",
"type": "main",
"index": 0
}
]
]
},
"Map Attribute ID": {
"main": [
[
{
"node": "Loop Over Attributes",
"type": "main",
"index": 0
}
]
]
},
"Only what we need": {
"main": [
[
{
"node": "Merge Old Data + RecID",
"type": "main",
"index": 1
}
]
]
},
"Split Out similar": {
"main": [
[
{
"node": "Generate Unique Hash for Similar",
"type": "main",
"index": 0
},
{
"node": "Merge1",
"type": "main",
"index": 1
}
]
]
},
"Table: Attributes": {
"main": [
[]
]
},
"On form submission": {
"main": [
[
{
"node": "Map Agent Input",
"type": "main",
"index": 0
}
]
]
},
"Create if not Exist": {
"main": [
[
{
"node": "Only what we need",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Attributes": {
"main": [
[
{
"node": "All Attributes",
"type": "main",
"index": 0
}
],
[
{
"node": "Split Out each Attribute String",
"type": "main",
"index": 0
}
]
]
},
"Merge Old Data + RecID": {
"main": [
[
{
"node": "Determine Attributes we should save",
"type": "main",
"index": 0
}
]
]
},
"Structured Output Parser": {
"ai_outputParser": [
[
{
"node": "Retrieve and Parser Agent",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Check if Attribute exists": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 0
}
]
]
},
"Retrieve and Parser Agent": {
"main": [
[
{
"node": "JSON it",
"type": "main",
"index": 0
}
]
]
},
"Wait for Attribute Creation": {
"main": [
[
{
"node": "Change each Attribute to the corresponding RecID",
"type": "main",
"index": 0
}
]
]
},
"Generate Unique Hash for Name": {
"main": [
[
{
"node": "Create if not Exist",
"type": "main",
"index": 0
},
{
"node": "Merge Old Data + RecID",
"type": "main",
"index": 0
}
]
]
},
"Split Out each Attribute String": {
"main": [
[
{
"node": "Check if Attribute exists",
"type": "main",
"index": 0
},
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"Determine Similar we should save": {
"main": [
[
{
"node": "Save all this juicy data",
"type": "main",
"index": 0
}
]
]
},
"Generate Unique Hash for Similar": {
"main": [
[
{
"node": "It Should exists",
"type": "main",
"index": 0
}
]
]
},
"Determine Attributes we should save": {
"main": [
[
{
"node": "Split Out similar",
"type": "main",
"index": 0
},
{
"node": "Merge2",
"type": "main",
"index": 0
}
]
]
},
"Change each Smiliar to the corresponding RecID": {
"main": [
[
{
"node": "Determine Similar we should save",
"type": "main",
"index": 0
}
]
]
},
"Change each Attribute to the corresponding RecID": {
"main": [
[
{
"node": "Generate Unique Hash for Name",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 销售, 产品, 人工智能, 营销
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
实时Notion Todoist双向同步模板
使用Redis的Notion Todoist实时双向同步
If
Set
Code
+26
246 节点Mario
销售
自动化新闻到简报AI代理v13
AI新闻研究团队：24/7简报自动化，含Perplexity引用
Set
Code
Gmail
+15
37 节点Derek Cheung
产品
[模板] AI宠物店 v8
🐶 AI宠物店助手 - 集成GPT-4o、Google日历和WhatsApp/Instagram/Facebook
If
N8n
Set
+38
244 节点Amanda Benks
销售
HDW潜在客户越野车
使用AI代理的自动化LinkedIn潜在客户生成、评分与沟通
If
Code
Sort
+17
86 节点Andrey
销售
WordPress 内容生成器 v3
WordPress 内容生成器 v3
If
Set
Code
+21
102 节点Alex Kim
人工智能
（Duc）深度研究市场模板
集成PerplexityAI研究和OpenAI内容的多层级WordPress博客生成器
If
Set
Xml
+28
132 节点Daniel Ng
人工智能
工作流信息
难度等级
高级
节点数量44
分类4
节点类型14
作者
Marcel Claus-Ahrens
@geckseHey 👋 I'm an Automation Expert with a passion for AI workflow automations and AI agents in general. Coming from a software background, I bring the necessary hard skills but love using NoCode to get the job done faster – hence n8n.
外部链接
在 n8n.io 查看 →
分享此工作流