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 에이전트 (채팅)",
      "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": "### Get the feedback from users\n**Sign up for Jotform using:** [https://www.jotform.com/?partner=zainurrehman](https://www.jotform.com/?partner=zainurrehman)"
      },
      "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": "### Identify the feedback request if positive or negative. Based on that create a ticket on jira and send an initial response"
      },
      "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": "### This agent asks appropriate question from the user through email to get more insights"
      },
      "typeVersion": 1
    }
  ],
  "connections": {
    "ce2cad7e-5f0a-4dae-8f03-6f1dc584b227": {
      "main": [
        [
          {
            "node": "4120159b-eeb8-422c-8dd3-a788fb59608b",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "4120159b-eeb8-422c-8dd3-a788fb59608b": {
      "main": [
        [
          {
            "node": "366ad755-af22-4322-a49e-fdc3d9edbc0c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "de88c674-be3e-4ed5-b8c3-b6745547a95b": {
      "main": [
        [
          {
            "node": "366ad755-af22-4322-a49e-fdc3d9edbc0c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "79f72cac-ab48-46d3-9b30-1fe3b51f53f4": {
      "ai_memory": [
        [
          {
            "node": "366ad755-af22-4322-a49e-fdc3d9edbc0c",
            "type": "ai_memory",
            "index": 0
          }
        ]
      ]
    },
    "1219f3dd-e1d0-4e4b-bc55-56b5f9d509c8": {
      "main": [
        [
          {
            "node": "ce2cad7e-5f0a-4dae-8f03-6f1dc584b227",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "8a553038-1458-42ac-abf0-7ea72f8d1792": {
      "ai_tool": [
        [
          {
            "node": "ce2cad7e-5f0a-4dae-8f03-6f1dc584b227",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "74fe875c-b6bd-40ef-81de-3f47f4cf588c": {
      "ai_languageModel": [
        [
          {
            "node": "ce2cad7e-5f0a-4dae-8f03-6f1dc584b227",
            "type": "ai_languageModel",
            "index": 0
          },
          {
            "node": "366ad755-af22-4322-a49e-fdc3d9edbc0c",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "94426429-8f02-4410-b54e-bee2380c2b51": {
      "ai_outputParser": [
        [
          {
            "node": "ce2cad7e-5f0a-4dae-8f03-6f1dc584b227",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "4c7b7851-c27c-4aae-aea1-f8d0dbea21b3": {
      "ai_tool": [
        [
          {
            "node": "366ad755-af22-4322-a49e-fdc3d9edbc0c",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "6335b3ff-7663-471d-8031-e300ae10170f": {
      "ai_tool": [
        [
          {
            "node": "ce2cad7e-5f0a-4dae-8f03-6f1dc584b227",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    }
  }
}