使用OpenAI、Google表格和CraftMyPDF的自动化询价请求

• •可能需要目标 API 的认证凭证
• •Google Sheets API 凭证
• •OpenAI API Key

{
  "meta": {
    "instanceId": "783d2046f405cc6ecb20ef185376ed1023323a3da628b9d8156b1fb75c75e037",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "8adfda8f-0d79-4971-81dd-fe6e122b69e8",
      "name": "表单：请求报价",
      "type": "n8n-nodes-base.formTrigger",
      "position": [
        -1104,
        224
      ],
      "webhookId": "FORM-QUOTE-ID",
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "93b03299-bfdc-4da6-8641-099dfb56b75a",
      "name": "Google Sheets：产品",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -816,
        224
      ],
      "parameters": {},
      "typeVersion": 4.7
    },
    {
      "id": "2dbb5986-9d8b-47f1-a090-c5b130d72ce3",
      "name": "LLM：选择与报价（仅限 JSON）",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        -544,
        224
      ],
      "parameters": {},
      "typeVersion": 1.8
    },
    {
      "id": "02cd071e-e579-4b43-be2b-231ea3999544",
      "name": "代码：为 CraftMyPDF 进行映射",
      "type": "n8n-nodes-base.code",
      "position": [
        -192,
        224
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "62b778a3-5663-4621-b7fb-d6795ef606b9",
      "name": "创建 PDF",
      "type": "n8n-nodes-craftmypdf.craftMyPdf",
      "position": [
        64,
        224
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "dbe95252-aadc-4e76-824f-9595e3ec55d2",
      "name": "获取 PDF 文件",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        336,
        224
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "51aa3d33-2ed8-408e-8e44-109b4fed46d7",
      "name": "邮件：发送报价",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        576,
        224
      ],
      "webhookId": "8934d5d2-fe1f-4b79-9445-c794acf61d3d",
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "5e113929-c891-4fba-a8a6-242e29937fc3",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1104,
        -176
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "2b96dde8-578f-42f5-97ff-dfe849de64c3",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -320,
        -176
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "Create a PDF": {
      "main": [
        [
          {
            "node": "Get PDF file",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get PDF file": {
      "main": [
        [
          {
            "node": "Email: Send Quote",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Form: Request a Quote": {
      "main": [
        [
          {
            "node": "Google Sheets: Products",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets: Products": {
      "main": [
        [
          {
            "node": "LLM: Select & Quote (JSON only)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Code: Map for CraftMyPDF": {
      "main": [
        [
          {
            "node": "Create a PDF",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "LLM: Select & Quote (JSON only)": {
      "main": [
        [
          {
            "node": "Code: Map for CraftMyPDF",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}