Automatisation de la priorisation des tickets de support

Intermédiaire

Ceci est unTicket Management, AI Summarizationworkflow d'automatisation du domainecontenant 15 nœuds.Utilise principalement des nœuds comme If, Gmail, Slack, ClickUp, GoogleSheets. Automatiser la priorisation des tickets de support avec JotForm, Gemini AI et les tâches ClickUp

Prérequis
  • Compte Google et informations d'identification Gmail API
  • Token Bot Slack ou URL Webhook
  • Informations d'identification Google Sheets API
  • Clé API Google Gemini
Aperçu du workflow
Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement
Exporter le workflow
Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow
{
  "nodes": [
    {
      "id": "599a57cf-d6a0-41c7-9bdd-920dd2cca88c",
      "name": "Slack",
      "type": "n8n-nodes-base.slack",
      "position": [
        -256,
        64
      ],
      "parameters": {
        "text": "=Email: {{ $('JotForm Trigger').item.json.q4_email }}\nName: {{ $('JotForm Trigger').item.json.q3_name.first }} {{ $('JotForm Trigger').item.json.q3_name.last }}\nSeverity: {{ $('JotForm Trigger').item.json.q5_severity }}\n\nProblem:{{ $('JotForm Trigger').item.json.q6_issue }}\n\nDescription: {{ $('JotForm Trigger').item.json.q7_description }}\n",
        "channel": "C083NTTSZ7F",
        "attachments": [],
        "otherOptions": {},
        "authentication": "oAuth2"
      },
      "typeVersion": 1
    },
    {
      "id": "3dc5adf0-7417-4d0f-a5b4-db2f5ea9f434",
      "name": "Envoyer un message",
      "type": "n8n-nodes-base.gmail",
      "position": [
        -256,
        240
      ],
      "webhookId": "3b9b79c7-db0e-4bf7-8e77-680a546a683a",
      "parameters": {
        "sendTo": "={{$node[\"JotForm Trigger\"].data[\"q4_email\"]}} ",
        "message": "=Email: {{ $('JotForm Trigger').item.json.q4_email }}\nName:  {{ $('JotForm Trigger').item.json.q3_name.first }} {{ $('JotForm Trigger').item.json.q3_name.last }}\nSeverity:  {{ $('JotForm Trigger').item.json.q5_severity }}\n\nProblem: {{ $('JotForm Trigger').item.json.q6_issue }}\nDescription: {{ $('JotForm Trigger').item.json.q7_description }}",
        "options": {
          "appendAttribution": false
        },
        "subject": "New Support Ticket ",
        "emailType": "text"
      },
      "typeVersion": 2.1
    },
    {
      "id": "a257919d-2b68-49aa-b4ae-b344d0803f9b",
      "name": "Déclencheur JotForm",
      "type": "n8n-nodes-base.jotFormTrigger",
      "position": [
        -896,
        80
      ],
      "webhookId": "8a780d53-f8aa-4fb8-81aa-24beb7386109",
      "parameters": {
        "form": "252875809016060",
        "resolveData": false
      },
      "typeVersion": 1
    },
    {
      "id": "df97876e-0f8f-4b00-98c4-b87cafe114e1",
      "name": "Condition",
      "type": "n8n-nodes-base.if",
      "position": [
        -464,
        80
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "3b4b190f-7c81-4f40-a2a8-e32f0fa360ce",
              "operator": {
                "type": "string",
                "operation": "notEquals"
              },
              "leftValue": "={{ $json.Severity[0] }}",
              "rightValue": "Low"
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "7de690e5-961a-461c-8139-417439c4e922",
      "name": "Créer une tâche",
      "type": "n8n-nodes-base.clickUp",
      "position": [
        288,
        64
      ],
      "parameters": {
        "list": "900901763830",
        "name": "={{ $('JotForm Trigger').item.json.q6_issue }}",
        "team": "36299117",
        "space": "66018999",
        "folder": "90090948711",
        "additionalFields": {
          "content": "={{ $('AI Agent').item.json.output }}"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "97321d5f-0dbd-48e7-b565-2f98d5e627ed",
      "name": "Agent IA",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        -80,
        64
      ],
      "parameters": {
        "text": "=You are a project manager. Based on the following support ticket details, create a clear and professional task description that summarizes the issue and highlights key points.\n\nTicket Details:\n\nName: {{ $('JotForm Trigger').item.json.q3_name.first }} {{ $('JotForm Trigger').item.json.q3_name.last }}\n\nSeverity: {{ $('JotForm Trigger').item.json.q5_severity }}\n\nIssue: {{ $('JotForm Trigger').item.json.q6_issue }}\n\nDescription: {{ $('JotForm Trigger').item.json.q7_description }}\n\nOutput Format:\nReturn a concise task description suitable for a ClickUp task.\n\ndon't add this:\nHere's a concise and professional task description for ClickUp:\\\njust need the details for clickup\n\n\n\n",
        "options": {},
        "promptType": "define"
      },
      "typeVersion": 2.2
    },
    {
      "id": "e460a1a7-f96c-4339-9232-9c2dbbffa82f",
      "name": "Google Gemini Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        16,
        272
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 1
    },
    {
      "id": "2ab1c20b-d509-493f-863e-d95317db278f",
      "name": "Ajouter une ligne dans la feuille",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -672,
        80
      ],
      "parameters": {
        "columns": {
          "value": {
            "Name": "={{ $json.q3_name.first }}",
            "Email": "={{ $json.q4_email }}",
            "Issue": "={{ $json.q6_issue }}",
            "Severity": "={{ $json.q5_severity }}",
            "Description": "={{ $json.q7_description }}"
          },
          "schema": [
            {
              "id": "Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Severity",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Severity",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Issue",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Issue",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Description",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Description",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1hF3MboFa_BppnGPXNs6cjHpGgoRPlYOlnDSAlofsKyg/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1hF3MboFa_BppnGPXNs6cjHpGgoRPlYOlnDSAlofsKyg"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "3d26b89a-1b6e-493a-bbec-3ee9f2b554b1",
      "name": "Note adhésive",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -944,
        -16
      ],
      "parameters": {
        "color": 6,
        "width": 208,
        "height": 304,
        "content": "### JotForm Trigger on Form Submission"
      },
      "typeVersion": 1
    },
    {
      "id": "7b309ae1-7c90-4270-b59c-ae6d381f7cd6",
      "name": "Note adhésive1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -720,
        -16
      ],
      "parameters": {
        "color": 5,
        "width": 192,
        "height": 304,
        "content": "### Add the details in Google Sheet"
      },
      "typeVersion": 1
    },
    {
      "id": "44d3e42a-adf4-466b-9c0b-a366c3c22a86",
      "name": "Note adhésive2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -512,
        -16
      ],
      "parameters": {
        "color": 5,
        "width": 192,
        "height": 304,
        "content": "### If low severity then email otherwise slack"
      },
      "typeVersion": 1
    },
    {
      "id": "26e3ac60-3b94-4fe3-8a20-b1860902d5e7",
      "name": "Note adhésive3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -304,
        -16
      ],
      "parameters": {
        "color": 5,
        "width": 192,
        "height": 432,
        "content": "### If low severity then email otherwise slack"
      },
      "typeVersion": 1
    },
    {
      "id": "409ecc97-68e7-4d00-8c6d-bb7eb0f804c3",
      "name": "Note adhésive4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -96,
        224
      ],
      "parameters": {
        "color": 5,
        "width": 304,
        "height": 192,
        "content": "### AI Model"
      },
      "typeVersion": 1
    },
    {
      "id": "6ba99483-09e1-4c54-bdb3-b3fb776d285d",
      "name": "Note adhésive5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        224,
        -16
      ],
      "parameters": {
        "color": 6,
        "width": 208,
        "height": 304,
        "content": "### Create a task on clickup"
      },
      "typeVersion": 1
    },
    {
      "id": "169abab9-dc80-48b9-9cf3-47ab02502319",
      "name": "Note adhésive6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -96,
        -16
      ],
      "parameters": {
        "color": 6,
        "width": 304,
        "height": 224,
        "content": "### AI Agent to summarize the details to be added in clickup"
      },
      "typeVersion": 1
    }
  ],
  "connections": {
    "df97876e-0f8f-4b00-98c4-b87cafe114e1": {
      "main": [
        [
          {
            "node": "599a57cf-d6a0-41c7-9bdd-920dd2cca88c",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "3dc5adf0-7417-4d0f-a5b4-db2f5ea9f434",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "599a57cf-d6a0-41c7-9bdd-920dd2cca88c": {
      "main": [
        [
          {
            "node": "97321d5f-0dbd-48e7-b565-2f98d5e627ed",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "97321d5f-0dbd-48e7-b565-2f98d5e627ed": {
      "main": [
        [
          {
            "node": "7de690e5-961a-461c-8139-417439c4e922",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "a257919d-2b68-49aa-b4ae-b344d0803f9b": {
      "main": [
        [
          {
            "node": "2ab1c20b-d509-493f-863e-d95317db278f",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2ab1c20b-d509-493f-863e-d95317db278f": {
      "main": [
        [
          {
            "node": "df97876e-0f8f-4b00-98c4-b87cafe114e1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "e460a1a7-f96c-4339-9232-9c2dbbffa82f": {
      "ai_languageModel": [
        [
          {
            "node": "97321d5f-0dbd-48e7-b565-2f98d5e627ed",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    }
  }
}
Foire aux questions

Comment utiliser ce workflow ?

Copiez le code de configuration JSON ci-dessus, créez un nouveau workflow dans votre instance n8n et sélectionnez "Importer depuis le JSON", collez la configuration et modifiez les paramètres d'authentification selon vos besoins.

Dans quelles scénarios ce workflow est-il adapté ?

Intermédiaire - Gestion des tickets, Résumé IA

Est-ce payant ?

Ce workflow est entièrement gratuit et peut être utilisé directement. Veuillez noter que les services tiers utilisés dans le workflow (comme l'API OpenAI) peuvent nécessiter un paiement de votre part.

Workflows recommandés

Informations sur le workflow
Niveau de difficulté
Intermédiaire
Nombre de nœuds15
Catégorie2
Types de nœuds9
Description de la difficulté

Adapté aux utilisateurs expérimentés, avec des workflows de complexité moyenne contenant 6-15 nœuds

Auteur
Zain Khan

Zain Khan

@zain

I partner with businesses to streamline processes and accelerate growth through intelligent AI automation and Web/mobile Development. Leveraging deep expertise in GPT-4, LangChain, and n8n, I develop AI-powered agents and sophisticated LLM pipelines.

Liens externes
Voir sur n8n.io

Partager ce workflow

Catégories

Catégories: 34