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": {
"1c468a4b-4563-4f78-ba1b-138b18ac4821": {
"main": [
[
{
"node": "4f597962-48e5-4367-a329-bc07d42ff86d",
"type": "main",
"index": 0
}
]
]
},
"733a8d0c-c6ea-4386-9fd1-075980289e9c": {
"main": [
[
{
"node": "9853b85d-fcb9-4183-8fe4-6e32d318ab01",
"type": "main",
"index": 0
}
]
]
},
"0e98acd2-4aa5-4df0-b36b-6ac1a8a2263b": {
"main": [
[
{
"node": "74f0f703-ce73-457c-9137-88d613d2e480",
"type": "main",
"index": 0
}
]
]
},
"8fa7273b-ebc8-40e4-9f11-e4b26784f60d": {
"ai_languageModel": [
[
{
"node": "b1530578-bde9-4ee3-9cdb-545a621cdb84",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"51642a02-51a4-4894-adf0-f364736dabc1": {
"main": [
[
{
"node": "5eb89e50-7a2f-415c-82f2-99eb8a7ff82f",
"type": "main",
"index": 0
}
]
]
},
"ae351db3-5c47-4e53-bf9e-e34434ad9522": {
"main": [
[
{
"node": "0c999f6f-11fb-472a-aa10-0915fbcd1254",
"type": "main",
"index": 0
}
]
]
},
"9853b85d-fcb9-4183-8fe4-6e32d318ab01": {
"main": [
[
{
"node": "0e98acd2-4aa5-4df0-b36b-6ac1a8a2263b",
"type": "main",
"index": 1
}
]
]
},
"9ea45b9b-ac2a-4498-b96f-5f5de50acade": {
"main": [
[
{
"node": "9ea45b9b-ac2a-4498-b96f-5f5de50acade",
"type": "main",
"index": 0
},
{
"node": "6dfbc02e-36b3-4640-b9f2-940c7cd6f86e",
"type": "main",
"index": 0
}
]
]
},
"835a09ae-2e51-488c-b0b3-d895696a135e": {
"main": [
[
{
"node": "b8ca6d98-ab37-4393-8a2c-561912aeff2b",
"type": "main",
"index": 1
}
]
]
},
"d2532094-9c71-4fc0-8195-fb2e29169086": {
"main": [
[
{
"node": "b1530578-bde9-4ee3-9cdb-545a621cdb84",
"type": "main",
"index": 0
}
]
]
},
"5eb89e50-7a2f-415c-82f2-99eb8a7ff82f": {
"main": [
[
{
"node": "11679757-360c-468f-b624-a9f6853e29f4",
"type": "main",
"index": 0
},
{
"node": "b8ca6d98-ab37-4393-8a2c-561912aeff2b",
"type": "main",
"index": 0
}
]
]
},
"a1bbda24-f75c-4316-b2bd-645827d7af1f": {
"main": [
[
{
"node": "733a8d0c-c6ea-4386-9fd1-075980289e9c",
"type": "main",
"index": 0
}
]
]
},
"4f597962-48e5-4367-a329-bc07d42ff86d": {
"main": [
[
{
"node": "11679757-360c-468f-b624-a9f6853e29f4",
"type": "main",
"index": 0
}
]
]
},
"29d6369f-f233-46f8-8bee-aa3be854bb0c": {
"main": [
[
{
"node": "85ac3cbb-4103-4184-b686-9e5b8d48f421",
"type": "main",
"index": 1
}
]
]
},
"88e9f499-87d3-46e2-b3ea-1833c14aaa1b": {
"main": [
[
{
"node": "dabb7e11-b4de-44d9-a80f-3302f49194fb",
"type": "main",
"index": 0
},
{
"node": "733a8d0c-c6ea-4386-9fd1-075980289e9c",
"type": "main",
"index": 1
}
]
]
},
"6dfbc02e-36b3-4640-b9f2-940c7cd6f86e": {
"main": [
[]
]
},
"f7ecadb8-dc5d-4e8c-96b8-52c1dbad49b6": {
"main": [
[
{
"node": "d2532094-9c71-4fc0-8195-fb2e29169086",
"type": "main",
"index": 0
}
]
]
},
"ea8f7e6f-9004-4271-80d3-333701cce488": {
"main": [
[
{
"node": "29d6369f-f233-46f8-8bee-aa3be854bb0c",
"type": "main",
"index": 0
}
]
]
},
"11679757-360c-468f-b624-a9f6853e29f4": {
"main": [
[
{
"node": "835a09ae-2e51-488c-b0b3-d895696a135e",
"type": "main",
"index": 0
}
],
[
{
"node": "680dfb4b-dde4-4d8f-852d-c3eba82e6607",
"type": "main",
"index": 0
}
]
]
},
"85ac3cbb-4103-4184-b686-9e5b8d48f421": {
"main": [
[
{
"node": "bdf9c435-3994-4c25-9520-8dfa76e625eb",
"type": "main",
"index": 0
}
]
]
},
"ec0f0575-eb33-48a9-b3fe-c4f5b71ff548": {
"ai_outputParser": [
[
{
"node": "b1530578-bde9-4ee3-9cdb-545a621cdb84",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"6d78005e-7277-40a9-9f10-e3d8e475cbaf": {
"main": [
[
{
"node": "1c468a4b-4563-4f78-ba1b-138b18ac4821",
"type": "main",
"index": 0
}
]
]
},
"b1530578-bde9-4ee3-9cdb-545a621cdb84": {
"main": [
[
{
"node": "51642a02-51a4-4894-adf0-f364736dabc1",
"type": "main",
"index": 0
}
]
]
},
"b8ca6d98-ab37-4393-8a2c-561912aeff2b": {
"main": [
[
{
"node": "9eaf87d4-910b-4a6e-9cdf-ee51ff4180cc",
"type": "main",
"index": 0
}
]
]
},
"5b5ab9f2-d4ac-437f-ab0a-b113a8af34ab": {
"main": [
[
{
"node": "ea8f7e6f-9004-4271-80d3-333701cce488",
"type": "main",
"index": 0
},
{
"node": "85ac3cbb-4103-4184-b686-9e5b8d48f421",
"type": "main",
"index": 0
}
]
]
},
"680dfb4b-dde4-4d8f-852d-c3eba82e6607": {
"main": [
[
{
"node": "6d78005e-7277-40a9-9f10-e3d8e475cbaf",
"type": "main",
"index": 0
},
{
"node": "1c468a4b-4563-4f78-ba1b-138b18ac4821",
"type": "main",
"index": 1
}
]
]
},
"c9187902-f67f-4639-906b-d6b14ace6a0e": {
"main": [
[
{
"node": "e925a388-05e2-49e4-92ad-984517f44057",
"type": "main",
"index": 0
}
]
]
},
"dabb7e11-b4de-44d9-a80f-3302f49194fb": {
"main": [
[
{
"node": "a1bbda24-f75c-4316-b2bd-645827d7af1f",
"type": "main",
"index": 0
}
]
]
},
"bdf9c435-3994-4c25-9520-8dfa76e625eb": {
"main": [
[
{
"node": "88e9f499-87d3-46e2-b3ea-1833c14aaa1b",
"type": "main",
"index": 0
},
{
"node": "0e98acd2-4aa5-4df0-b36b-6ac1a8a2263b",
"type": "main",
"index": 0
}
]
]
},
"74f0f703-ce73-457c-9137-88d613d2e480": {
"main": [
[
{
"node": "c9187902-f67f-4639-906b-d6b14ace6a0e",
"type": "main",
"index": 0
}
]
]
},
"9eaf87d4-910b-4a6e-9cdf-ee51ff4180cc": {
"main": [
[
{
"node": "5b5ab9f2-d4ac-437f-ab0a-b113a8af34ab",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 销售, 产品, 人工智能, 营销
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
自动化新闻到简报AI代理v13
AI新闻研究团队：24/7简报自动化，含Perplexity引用
Set
Code
Gmail
+
Set
Code
Gmail
37 节点Derek Cheung
产品
[模板] AI宠物店 v8
🐶 AI宠物店助手 - 集成GPT-4o、Google日历和WhatsApp/Instagram/Facebook
If
N8n
Set
+
If
N8n
Set
244 节点Amanda Benks
销售
HDW潜在客户越野车
使用AI代理的自动化LinkedIn潜在客户生成、评分与沟通
If
Code
Sort
+
If
Code
Sort
86 节点Andrey
销售
WordPress 内容生成器 v3
WordPress 内容生成器 v3
If
Set
Code
+
If
Set
Code
102 节点Alex Kim
人工智能
🗞️ AI驱动的可持续性营销简报（使用Gmail、GPT-4o）
🗞️ AI驱动的可持续性营销简报（使用Gmail、GPT-4o）
If
Set
Code
+
If
Set
Code
21 节点Samir Saci
人工智能
AI营销代理：Reddit + OpenRouter + Gmail 潜在客户生成
AI营销代理：通过Reddit、OpenRouter和Gmail进行潜在客户生成
If
Set
Code
+
If
Set
Code
23 节点Ari Nakos
销售
工作流信息
难度等级
高级
节点数量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 查看 →
分享此工作流