8
n8n 中文网amn8n.com

供应商报价比较器与智能AI摘要表

中级

这是一个Document Extraction, AI Summarization领域的自动化工作流,包含 9 个节点。主要使用 Wait, Webhook, Function, EmailSend, HttpRequest 等节点。 使用 Grok AI 比较供应商报价并导出到 Google Sheets 和邮件

前置要求
  • HTTP Webhook 端点(n8n 会自动生成)
  • 可能需要目标 API 的认证凭证
  • Google Sheets API 凭证
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "id": "I7WH7YAkU7thNKGJ",
  "meta": {
    "instanceId": "dd69efaf8212c74ad206700d104739d3329588a6f3f8381a46a481f34c9cc281",
    "templateCredsSetupCompleted": true
  },
  "name": "供应商报价比较器与智能AI摘要表",
  "tags": [],
  "nodes": [
    {
      "id": "f13d14c0-5c12-49dc-8fdc-09374c800045",
      "name": "上传报价单",
      "type": "n8n-nodes-base.webhook",
      "position": [
        -480,
        -140
      ],
      "webhookId": "vendor-quote-upload",
      "parameters": {
        "path": "vendor-quote-upload",
        "options": {}
      },
      "typeVersion": 1
    },
    {
      "id": "3d583a32-3731-4b44-98b0-b90866128a54",
      "name": "提取文件数据",
      "type": "n8n-nodes-base.function",
      "position": [
        -260,
        -140
      ],
      "parameters": {
        "functionCode": "return items.map(item => {\n  const file = item.binary['data'];\n  return {\n    json: {\n      fileName: file.fileName,\n      fileData: file.data\n    }\n  };\n});"
      },
      "typeVersion": 1
    },
    {
      "id": "bd191a98-5b73-4732-bffa-1c9d09faadb4",
      "name": "AI摘要生成",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -40,
        -140
      ],
      "parameters": {
        "url": "https://api.grok.xai.com/summarize",
        "options": {}
      },
      "typeVersion": 1
    },
    {
      "id": "616fcc3f-2c98-4816-ad3a-5285e47322f5",
      "name": "格式化摘要",
      "type": "n8n-nodes-base.function",
      "position": [
        400,
        -140
      ],
      "parameters": {
        "functionCode": "return items.map(item => {\n  const summary = item.json;\n  return {\n    json: {\n      vendor: summary.vendor || 'Unknown',\n      price: summary.price || 0,\n      deliveryTime: summary.deliveryTime || 'N/A',\n      features: summary.features || []\n    }\n  };\n});"
      },
      "typeVersion": 1
    },
    {
      "id": "e322b3b3-3b5e-4a2b-b734-6d3c2a8a7a51",
      "name": "记录到 Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        620,
        -140
      ],
      "parameters": {
        "range": "QuotationSummary!A:D",
        "options": {},
        "sheetId": "your-google-sheet-id",
        "operation": "append"
      },
      "credentials": {
        "googleApi": {
          "id": "ScSS2KxGQULuPtdy",
          "name": "Google Sheets- test"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "9e515cef-d701-47d3-b1a8-6b5e235ab5bf",
      "name": "等待回复",
      "type": "n8n-nodes-base.wait",
      "position": [
        180,
        -140
      ],
      "webhookId": "4d3d095b-db33-4a57-a49b-bb0314c6c54b",
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "6a812cc2-8d22-4e08-83af-0f0bafe66ac4",
      "name": "发送邮件",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        840,
        -140
      ],
      "webhookId": "98e88dd5-5189-4451-bdcc-7e4077b7d221",
      "parameters": {
        "text": "json: {\n      vendor: summary.vendor || 'Unknown',\n      price: summary.price || 0,\n      deliveryTime: summary.deliveryTime || 'N/A',\n      features: summary.features || []\n    }",
        "options": {},
        "subject": "Vendor Quotation Comparison",
        "toEmail": "team@gmail.com",
        "fromEmail": "admin@gmail.com",
        "emailFormat": "text"
      },
      "credentials": {
        "smtp": {
          "id": "G1kyF8cSWTZ4vouN",
          "name": "SMTP -test"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "54b92d68-e46a-4af9-8fd2-c4cd16c36316",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        300,
        -560
      ],
      "parameters": {
        "color": 4,
        "width": 580,
        "height": 260,
        "content": "## 最小Google Sheets列(前5项):"
      },
      "typeVersion": 1
    },
    {
      "id": "ccf6e6a7-6e08-4cc5-ada8-5e70dd688ef1",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -500,
        -740
      ],
      "parameters": {
        "width": 680,
        "height": 560,
        "content": "### 🧷 **各节点说明:**"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "5b1389b3-0c98-4fb8-8ac1-ba2de9c736c9",
  "connections": {
    "Upload Quotes": {
      "main": [
        [
          {
            "node": "Extract File Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Format Summary": {
      "main": [
        [
          {
            "node": "Log to Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait For Reply": {
      "main": [
        [
          {
            "node": "Format Summary",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "AI Summarization": {
      "main": [
        [
          {
            "node": "Wait For Reply",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract File Data": {
      "main": [
        [
          {
            "node": "AI Summarization",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Log to Google Sheets": {
      "main": [
        [
          {
            "node": "Send email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

中级 - 文档提取, AI 摘要总结

需要付费吗?

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

工作流信息
难度等级
中级
节点数量9
分类2
节点类型7
难度说明

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

作者
Oneclick AI Squad

Oneclick AI Squad

@oneclick-ai

The AI Squad Initiative is a pioneering effort to build, automate and scale AI-powered workflows using n8n.io. Our mission is to help individuals and businesses integrate AI agents seamlessly into their daily operations from automating tasks and enhancing productivity to creating innovative, intelligent solutions. We design modular, reusable AI workflow templates that empower creators, developers and teams to supercharge their automation with minimal effort and maximum impact.

外部链接
在 n8n.io 查看

分享此工作流