使用Gemini、JotForm、Gmail和Jira的自动化客户反馈分诊与跟进

• •Google 账号和 Gmail API 凭证
• •Google Gemini API Key

{
  "nodes": [
    {
      "id": "1219f3dd-e1d0-4e4b-bc55-56b5f9d509c8",
      "name": "JotForm 触发器",
      "type": "n8n-nodes-base.jotFormTrigger",
      "position": [
        -768,
        0
      ],
      "webhookId": "5e462014-b67d-436b-a77b-13edc4d7e2d5",
      "parameters": {
        "form": "252856264643060",
        "resolveData": false
      },
      "typeVersion": 1
    },
    {
      "id": "ce2cad7e-5f0a-4dae-8f03-6f1dc584b227",
      "name": "AI 代理",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        -528,
        -128
      ],
      "parameters": {
        "text": "=You are a business owner responding to customer feedback about your service. Write a concise and thoughtful reply based on the feedback provided.\n\nMention the user’s name: It should be the person name  {{ $json.q3_name.first }}\nHere is the feedback: {{ $json.q6_typeA6 }}\n\nIf the feedback is positive:\n1. express appreciation using gmail tool.\n2. No need to create issue in jira\n\nIf it’s negative:\n1. say Thanks for your feedback, we will ask you some questions. \n2. Also create an issue in jira using jira tool\n\nExample:\nUser Name: {{ $json.q3_name.first }}\nFeedback: The app login feature is not working from two days.\n\nReply:\nHi  {{ $json.q3_name.first }}, sorry to hear about the delay. We’re reviewing our process to ensure your future features work properly. Appreciate your patience and feedback. We will ask you some questions to resolve the issue.\n\nOutput, gmail tool threadid and realfeedback",
        "options": {},
        "promptType": "define",
        "hasOutputParser": true
      },
      "typeVersion": 2.2
    },
    {
      "id": "74fe875c-b6bd-40ef-81de-3f47f4cf588c",
      "name": "Google Gemini 聊天模型",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        -96,
        96
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 1
    },
    {
      "id": "de88c674-be3e-4ed5-b8c3-b6745547a95b",
      "name": "Gmail 触发器",
      "type": "n8n-nodes-base.gmailTrigger",
      "position": [
        384,
        -128
      ],
      "parameters": {
        "simple": false,
        "filters": {
          "readStatus": "unread"
        },
        "options": {},
        "pollTimes": {
          "item": [
            {
              "mode": "everyMinute"
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "79f72cac-ab48-46d3-9b30-1fe3b51f53f4",
      "name": "简单记忆",
      "type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
      "position": [
        688,
        96
      ],
      "parameters": {
        "sessionKey": "={{ $('Gmail Trigger').item.json.threadId }}",
        "sessionIdType": "customKey",
        "contextWindowLength": 10
      },
      "typeVersion": 1.3
    },
    {
      "id": "4c7b7851-c27c-4aae-aea1-f8d0dbea21b3",
      "name": "在Gmail中回复消息",
      "type": "n8n-nodes-base.gmailTool",
      "position": [
        864,
        96
      ],
      "webhookId": "ff90e40e-ad1d-4407-ac63-30359a40c7da",
      "parameters": {
        "message": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Message', ``, 'string') }}",
        "options": {
          "appendAttribution": false
        },
        "emailType": "text",
        "messageId": "={{ $('Gmail Trigger').item.json.id }}",
        "operation": "reply"
      },
      "typeVersion": 2.1
    },
    {
      "id": "366ad755-af22-4322-a49e-fdc3d9edbc0c",
      "name": "AI Agent（聊天）",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        560,
        -128
      ],
      "parameters": {
        "text": "=You are a feedback assistant who handles negative feedbacks.\n\nYou need to reply and ask(Using gmail tool) from client specific information about the issue, until they are facing this which device they were using and any reprodcable steps(if no that's fine), Ask them to stay in touch so we can resolve the issue and team will send a free coupon for free credits.\n\nIf information is already provided:\n1. just send a reply saying thank you we will get back to you \n2. simply summarize and add the details into the project issues using Jira tool\n\nHere is the email: {{ $json.text }}",
        "options": {},
        "promptType": "define"
      },
      "typeVersion": 2.1
    },
    {
      "id": "8a553038-1458-42ac-abf0-7ea72f8d1792",
      "name": "在Gmail中发送消息",
      "type": "n8n-nodes-base.gmailTool",
      "position": [
        -256,
        96
      ],
      "webhookId": "735cec29-eb0f-4aa5-bf68-0feef3614cb9",
      "parameters": {
        "sendTo": "={{ $('JotForm Trigger').item.json.q4_email }} ",
        "message": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Message', ``, 'string') }}",
        "options": {
          "appendAttribution": false
        },
        "subject": "Thank you for your Response",
        "emailType": "text"
      },
      "typeVersion": 2.1
    },
    {
      "id": "4120159b-eeb8-422c-8dd3-a788fb59608b",
      "name": "获取简报",
      "type": "n8n-nodes-base.set",
      "position": [
        -176,
        -128
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "5b0a3503-12e1-4a0b-8ec8-578f3f359626",
              "name": "text",
              "type": "string",
              "value": "={{ $('JotForm Trigger').item.json.q6_typeA6 }}"
            },
            {
              "id": "8dcfb00f-e592-420b-9e93-434c10cb58c9",
              "name": "threadId",
              "type": "string",
              "value": "={{ $json.threadId }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "6335b3ff-7663-471d-8031-e300ae10170f",
      "name": "在Jira Software中创建问题",
      "type": "n8n-nodes-base.jiraTool",
      "position": [
        -416,
        96
      ],
      "parameters": {
        "project": {
          "__rl": true,
          "mode": "list",
          "value": ""
        },
        "summary": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Summary', ``, 'string') }}",
        "issueType": {
          "__rl": true,
          "mode": "list",
          "value": ""
        },
        "additionalFields": {
          "priority": {
            "mode": "list",
            "value": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Priority', ``, 'string') }}"
          }
        }
      },
      "typeVersion": 1
    },
    {
      "id": "94426429-8f02-4410-b54e-bee2380c2b51",
      "name": "结构化输出解析器",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        64,
        96
      ],
      "parameters": {
        "jsonSchemaExample": "{\n\t\"threadId\": \"dw676wer8wer\",\n    \"output\": \"jotform q6_typeA6 field\"\n}"
      },
      "typeVersion": 1.3
    },
    {
      "id": "1df409e1-d7dc-495b-9e3c-92dc11648e57",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -832,
        -208
      ],
      "parameters": {
        "color": 6,
        "width": 256,
        "height": 480,
        "content": "### 获取用户反馈"
      },
      "typeVersion": 1
    },
    {
      "id": "91c1c8c0-b4c9-472f-8fe6-d2867141c853",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -560,
        -208
      ],
      "parameters": {
        "color": 6,
        "width": 832,
        "height": 480,
        "content": "### 识别反馈请求是正面还是负面。基于此在Jira上创建工单并发送初始回复"
      },
      "typeVersion": 1
    },
    {
      "id": "fd3dd2fc-d65a-432f-9424-0181262e31f1",
      "name": "便签 2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        288,
        -208
      ],
      "parameters": {
        "color": 5,
        "width": 736,
        "height": 480,
        "content": "### 该代理通过电子邮件向用户提出适当问题以获取更多见解"
      },
      "typeVersion": 1
    }
  ],
  "connections": {
    "AI Agent": {
      "main": [
        [
          {
            "node": "Edit Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Edit Fields": {
      "main": [
        [
          {
            "node": "AI Agent (Chat)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Gmail Trigger": {
      "main": [
        [
          {
            "node": "AI Agent (Chat)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Simple Memory": {
      "ai_memory": [
        [
          {
            "node": "AI Agent (Chat)",
            "type": "ai_memory",
            "index": 0
          }
        ]
      ]
    },
    "JotForm Trigger": {
      "main": [
        [
          {
            "node": "AI Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send a message in Gmail": {
      "ai_tool": [
        [
          {
            "node": "AI Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Google Gemini Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "AI Agent",
            "type": "ai_languageModel",
            "index": 0
          },
          {
            "node": "AI Agent (Chat)",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output Parser": {
      "ai_outputParser": [
        [
          {
            "node": "AI Agent",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "Reply to a message in Gmail": {
      "ai_tool": [
        [
          {
            "node": "AI Agent (Chat)",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Create an issue in Jira Software": {
      "ai_tool": [
        [
          {
            "node": "AI Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    }
  }
}