Triaje y seguimiento automatizados de comentarios de clientes con Gemini, JotForm, Gmail y Jira

• •Cuenta de Google y credenciales de API de Gmail
• •Clave de API de Google Gemini

{
  "nodes": [
    {
      "id": "1219f3dd-e1d0-4e4b-bc55-56b5f9d509c8",
      "name": "Activador de 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": "Agentee de IA",
      "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": "Modelo de chat Google Gemini",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        -96,
        96
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 1
    },
    {
      "id": "de88c674-be3e-4ed5-b8c3-b6745547a95b",
      "name": "Activador de 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": "Memoria Simple",
      "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": "Responder a un mensaje en 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": "Agentee de IA (Chat)",
      "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": "Enviar un mensaje en 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": "Editar Campos",
      "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": "Crear un issue en 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": "Analizador de Salida Estructurada",
      "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": "Nota Adhesiva",
      "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": "Nota Adhesiva1",
      "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": "Nota Adhesiva2",
      "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": {
    "Agente de IA": {
      "main": [
        [
          {
            "node": "4120159b-eeb8-422c-8dd3-a788fb59608b",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "4120159b-eeb8-422c-8dd3-a788fb59608b": {
      "main": [
        [
          {
            "node": "Agente de IA (Chat)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "de88c674-be3e-4ed5-b8c3-b6745547a95b": {
      "main": [
        [
          {
            "node": "Agente de IA (Chat)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "79f72cac-ab48-46d3-9b30-1fe3b51f53f4": {
      "ai_memory": [
        [
          {
            "node": "Agente de IA (Chat)",
            "type": "ai_memory",
            "index": 0
          }
        ]
      ]
    },
    "1219f3dd-e1d0-4e4b-bc55-56b5f9d509c8": {
      "main": [
        [
          {
            "node": "Agente de IA",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "8a553038-1458-42ac-abf0-7ea72f8d1792": {
      "ai_tool": [
        [
          {
            "node": "Agente de IA",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Google Gemini Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "Agente de IA",
            "type": "ai_languageModel",
            "index": 0
          },
          {
            "node": "Agente de IA (Chat)",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "94426429-8f02-4410-b54e-bee2380c2b51": {
      "ai_outputParser": [
        [
          {
            "node": "Agente de IA",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "4c7b7851-c27c-4aae-aea1-f8d0dbea21b3": {
      "ai_tool": [
        [
          {
            "node": "Agente de IA (Chat)",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "6335b3ff-7663-471d-8031-e300ae10170f": {
      "ai_tool": [
        [
          {
            "node": "Agente de IA",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    }
  }
}