Tri et suivi automatisés des retours clients avec Gemini, JotForm, Gmail et Jira

• •Compte Google et informations d'identification Gmail API
• •Clé API Google Gemini

{
  "nodes": [
    {
      "id": "1219f3dd-e1d0-4e4b-bc55-56b5f9d509c8",
      "name": "Déclencheur 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": "Agent 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": "Google Gemini Modèle de Chat",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        -96,
        96
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 1
    },
    {
      "id": "de88c674-be3e-4ed5-b8c3-b6745547a95b",
      "name": "Gmail Déclencheur",
      "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": "Mémoire 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": "Répondre à un message dans 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": "Agent 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": "Envoyer un message dans 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": "Modifier les Champs",
      "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": "Créer un ticket dans 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": "Analyseur de Sortie Structurée",
      "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": "Note Adhésive",
      "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": "Note Adhésive1",
      "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": "Note Adhésive2",
      "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
          }
        ]
      ]
    }
  }
}