Workflow 3893

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

{
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "154458b0-dde3-4224-9fa8-d38a025aa0d3",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -640,
        -140
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "hours"
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "0fc88546-50ef-4183-8fb2-dcea939f3bcf",
      "name": "Get Recent Messages",
      "type": "n8n-nodes-base.microsoftOutlook",
      "position": [
        -440,
        -140
      ],
      "parameters": {
        "fields": [
          "body",
          "categories",
          "conversationId",
          "from",
          "hasAttachments",
          "internetMessageId",
          "sender",
          "subject",
          "toRecipients",
          "receivedDateTime",
          "webLink"
        ],
        "output": "fields",
        "options": {},
        "filtersUI": {
          "values": {
            "filters": {
              "receivedAfter": "={{ $now.minus({ \"hour\": 1 }).toISO() }}"
            }
          }
        },
        "operation": "getAll"
      },
      "credentials": {
        "microsoftOutlookOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "d056be7e-43ed-4fea-8aef-36579c656633",
      "name": "OpenAI Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        280,
        40
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4o-mini"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "e4b6fd9d-2506-45bf-bd80-a81a2c04306b",
      "name": "Structured Output Parser",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        480,
        40
      ],
      "parameters": {
        "schemaType": "manual",
        "inputSchema": "{\n  \"type\": \"object\",\n  \"properties\": {\n    \"labels\": {\n      \"type\": \"array\",\n      \"items\": { \"type\": \"string\" }\n    },\n    \"priority\": { \"type\": \"number\" },\n    \"summary\": { \"type\": \"string\" },\n    \"description\": { \"type\": \"string\" }\n  }\n}"
      },
      "typeVersion": 1.2
    },
    {
      "id": "3cef25fc-2581-4556-bf54-7704815d98b3",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        -340
      ],
      "parameters": {
        "color": 7,
        "width": 700,
        "height": 540,
        "content": "## 2. \ud2f0\ucf13 \uc0dd\uc131 \ubc0f \ubd84\ub958 \uc790\ub3d9\ud654\n\n[\uae30\ubcf8 LLM \ub178\ub4dc\uc5d0 \ub300\ud574 \ub354 \uc54c\uc544\ubcf4\uae30](https://docs.n8n.io/integrations/builtin/cluster-nodes/root-nodes/n8n-nodes-langchain.chainllm)\n\n\uc0c8 \ud2f0\ucf13\uc740 \ud56d\uc0c1 \uc801\uc808\ud558\uac8c \ub808\uc774\ube14\ub9c1\ub418\uace0 \uc6b0\uc120\uc21c\uc704\uac00 \ub9e4\uaca8\uc838\uc57c \ud558\uc9c0\ub9cc, \uc778\ub825\uc774 \ubd80\uc871\ud55c \uacbd\uc6b0 \ubaa8\ub4e0 \ub4e4\uc5b4\uc624\ub294 \ud2f0\ucf13\uc744 \uc5c5\ub370\uc774\ud2b8\ud558\ub294 \uac83\uc774 \ud56d\uc0c1 \uac00\ub2a5\ud55c \uac83\uc740 \uc544\ub2d9\ub2c8\ub2e4. AI\ub97c \uc0ac\uc6a9\ud558\ub294 \uac83\uc740 \ud2f0\ucf13 \ubd84\ub958\uc5d0 \ub300\ud55c \ud6cc\ub96d\ud55c \uc6a9\ub840\uc774\uba70, \uadf8 \ub9e5\ub77d\uc801 \uc774\ud574\uac00 \uc774 \ub2e8\uacc4\ub97c \uc790\ub3d9\ud654\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub429\ub2c8\ub2e4."
      },
      "typeVersion": 1
    },
    {
      "id": "d6ba8c9b-3e39-442f-8b79-cafe11c15a18",
      "name": "Markdown",
      "type": "n8n-nodes-base.markdown",
      "position": [
        100,
        -140
      ],
      "parameters": {
        "html": "={{ $json.body.content }}",
        "options": {}
      },
      "typeVersion": 1
    },
    {
      "id": "fb7c6d7c-df30-43de-8f37-9e394a8ad7aa",
      "name": "Create Issue",
      "type": "n8n-nodes-base.jira",
      "position": [
        900,
        -140
      ],
      "parameters": {
        "project": {
          "__rl": true,
          "mode": "id",
          "value": "10000"
        },
        "summary": "={{ $json.output.summary }}",
        "issueType": {
          "__rl": true,
          "mode": "id",
          "value": "10000"
        },
        "additionalFields": {
          "labels": "={{ $json.output.labels }}",
          "priority": {
            "__rl": true,
            "mode": "id",
            "value": "={{ $json.output.priority }}"
          },
          "description": "={{ $json.output.description }}"
        }
      },
      "credentials": {
        "jiraSoftwareCloudApi": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "9e26f402-36da-40e1-a736-db4fe16de54a",
      "name": "Mark as Seen",
      "type": "n8n-nodes-base.removeDuplicates",
      "position": [
        -240,
        -140
      ],
      "parameters": {
        "options": {},
        "operation": "removeItemsSeenInPreviousExecutions",
        "dedupeValue": "={{ $json.id }}"
      },
      "typeVersion": 2
    },
    {
      "id": "b5f49877-e494-4712-a937-1f348198700e",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -740,
        -340
      ],
      "parameters": {
        "color": 7,
        "width": 720,
        "height": 540,
        "content": "## 1. Outlook \ubc1b\uc740 \ud3b8\uc9c0\ud568\uc5d0\uc11c \uc9c0\uc6d0 \uc774\uba54\uc77c \uac10\uc2dc\n\n[Outlook \ub178\ub4dc\uc5d0 \ub300\ud574 \uc790\uc138\ud788 \uc54c\uc544\ubcf4\uae30](https://docs.n8n.io/integrations/builtin/app-nodes/n8n-nodes-base.microsoftoutlook/)\n\n**\uc774 \ud15c\ud50c\ub9bf\uc740 \uc9c0\uc6d0 \ud2f0\ucf13 \uc804\uc6a9 \uacf5\uc720 \ubc1b\uc740 \ud3b8\uc9c0\ud568\uc744 \uac00\uc815\ud569\ub2c8\ub2e4!** \uc77c\ubc18 \ubc1b\uc740 \ud3b8\uc9c0\ud568\uc744 \uac00\uc9c0\uace0 \uc788\ub2e4\uba74, \uac01 \uba54\uc2dc\uc9c0\ub97c \ubd84\ub958\ud558\uace0 \ud544\ud130\ub9c1\ud574\uc57c \ud560 \uc218 \uc788\uc73c\uba70, \uc774\ub294 \ube44\uc6a9\uc774 \ubc1c\uc0dd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \"\uc911\ubcf5 \uc81c\uac70\" \ub178\ub4dc(\uc989, \"\uc77d\uc74c\uc73c\ub85c \ud45c\uc2dc\")\ub294 \uac01 \uc774\uba54\uc77c\uc744 \uc815\ud655\ud788 \ud55c \ubc88\ub9cc \ucc98\ub9ac\ud558\ub3c4\ub85d \ud569\ub2c8\ub2e4."
      },
      "typeVersion": 1
    },
    {
      "id": "b9d08834-14ad-4cdf-bc20-411033eee5b7",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        720,
        -340
      ],
      "parameters": {
        "color": 7,
        "width": 460,
        "height": 440,
        "content": "## 3. JIRA\uc5d0\uc11c \uc774\uc288 \uc0dd\uc131\n\n[JIRA \ub178\ub4dc\uc5d0 \ub300\ud574 \ub354 \uc77d\uae30](https://docs.n8n.io/integrations/builtin/app-nodes/n8n-nodes-base.jira/)\n\n\uc774\uac83\uc740 JIRA\uc5d0\uc11c \uc774\uc288\ub97c \uc0dd\uc131\ud558\ub294 \ub2e8\uc21c\ud55c \uc608\uc81c\uc77c \ubfd0\uc774\uc9c0\ub9cc, \ub354 \ub9ce\uc740 \uac83\uc744 \ucd94\uac00\ud558\uae30 \uc27d\uac8c \ud655\uc7a5\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4!"
      },
      "typeVersion": 1
    },
    {
      "id": "e6942a39-1893-44cf-a846-c6b4d9c37e92",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1160,
        -720
      ],
      "parameters": {
        "width": 380,
        "height": 940,
        "content": "## \uc774\ub97c \uc2dc\ub3c4\ud574 \ubcf4\uc138\uc694!\n### \uc774 n8n \ud15c\ud50c\ub9bf\uc740 \uc544\uc6c3\ub8e9 \uacf5\uc720 \ubc1b\uc740 \ud3b8\uc9c0\ud568\uc5d0\uc11c \uc9c0\uc6d0 \uba54\uc2dc\uc9c0\ub97c \uac10\uc2dc\ud558\uace0, \uc774\uc5d0 \ud574\ub2f9\ud558\ub294 \ubb38\uc81c\ub97c JIRA\uc5d0 \uc0dd\uc131\ud569\ub2c8\ub2e4.\n\n### \uc791\ub3d9 \uc6d0\ub9ac\n* \uc608\uc57d\ub41c \ud2b8\ub9ac\uac70\uac00 \uc9c0\uc6d0 \uc694\uccad\uc744 \uc218\uc9d1\ud558\ub294 \uacf5\uc720 \ubc1b\uc740 \ud3b8\uc9c0\ud568\uc5d0\uc11c \ucd5c\uadfc \uc544\uc6c3\ub8e9 \uba54\uc2dc\uc9c0\ub97c \uac00\uc838\uc635\ub2c8\ub2e4.\n* \uc774\ub7ec\ud55c \uc9c0\uc6d0 \uc694\uccad\uc740 \ud55c \ubc88\ub9cc \ucc98\ub9ac\ub418\ub3c4\ub85d \ud544\ud130\ub9c1\ub418\uba70, HTML \ubcf8\ubb38\uc744 \ub354 \uc27d\uac8c \uad6c\ubb38 \ubd84\uc11d\ud560 \uc218 \uc788\ub3c4\ub85d \ub9c8\ud06c\ub2e4\uc6b4\uc73c\ub85c \ubcc0\ud658\ub429\ub2c8\ub2e4.\n* \uac01 \uc9c0\uc6d0 \uc694\uccad\uc740 AI \uc5d0\uc774\uc804\ud2b8\ub97c \ud1b5\ud574 \ubd84\ub958\ub418\uba70, \uc801\uc808\ud55c \ub808\uc774\ube14\uc744 \ucd94\uac00\ud558\uace0, \uc6b0\uc120\uc21c\uc704\ub97c \ud3c9\uac00\ud558\uba70, \uc6d0\ub798 \uc694\uccad\uc758 \uc81c\ubaa9\uacfc \uc124\uba85\uc744 \uc694\uc57d\ud569\ub2c8\ub2e4.\n* \ub9c8\uc9c0\ub9c9\uc73c\ub85c, AI\uac00 \uc0dd\uc131\ud55c \uac12\uc744 \uc0ac\uc6a9\ud558\uc5ec JIRA\uc5d0\uc11c \ubb38\uc81c\ub97c \uc0dd\uc131\ud558\uc5ec \uc870\uce58\ud569\ub2c8\ub2e4.\n\n### \uc0ac\uc6a9 \ubc29\ubc95\n* \uac00\uc838\uc628 \uba54\uc2dc\uc9c0\uac00 \uc624\ub85c\uc9c0 \uc9c0\uc6d0 \uc694\uccad\ub9cc\uc774\uc5b4\uc57c \ud569\ub2c8\ub2e4. \uadf8\ub807\uc9c0 \uc54a\uc73c\uba74 \ucc98\ub9ac \uc804\uc5d0 \uba54\uc2dc\uc9c0\ub97c \ubd84\ub958\ud574\uc57c \ud569\ub2c8\ub2e4.\n* AI \uc5d0\uc774\uc804\ud2b8\uc758 \uc2dc\uc2a4\ud15c \ud504\ub86c\ud504\ud2b8\uc5d0\uc11c \uc0ac\uc6a9\ud560 \ub808\uc774\ube14\uacfc \uc6b0\uc120\uc21c\uc704\ub97c \uc9c0\uc815\ud569\ub2c8\ub2e4.\n\n### \uc694\uad6c \uc0ac\ud56d\n* \uc544\uc6c3\ub8e9(\uc9c0\uc6d0 \uc694\uccad \uc218\uc2e0\uc6a9)\n* OpenAI(LLM\uc6a9)\n* JIRA(\ubb38\uc81c \uad00\ub9ac\uc6a9)\n\n### \uc774 \uc6cc\ud06c\ud50c\ub85c\uc6b0 \uc0ac\uc6a9\uc790 \uc815\uc758\n* \ubb38\uc81c \uc0dd\uc131 \ud6c4 \ubb38\uc81c \ud574\uacb0 \uc2dc\ub3c4\ub098 \uc6a9\ub7c9 \uacc4\ud68d\uacfc \uac19\uc740 \ucd94\uac00 \ub2e8\uacc4\ub97c \uc790\ub3d9\ud654\ud558\ub294 \uac83\uc744 \uace0\ub824\ud569\ub2c8\ub2e4.\n\n### \ub3c4\uc6c0\uc774 \ud544\uc694\ud558\uc2e0\uac00\uc694?\n[Discord](https://discord.com/invite/XPKeKXeB7d) \uc5d0 \uac00\uc785\ud558\uac70\ub098 [\ud3ec\ub7fc](https://community.n8n.io/)\uc5d0\uc11c \ubb38\uc758\ud558\uc138\uc694!\n\n\uc990\uac70\uc6b4 \ud574\ud0b9!"
      },
      "typeVersion": 1
    },
    {
      "id": "71a906b2-7b01-43a8-aa82-7d9810d95e23",
      "name": "Generate Issue From Support Request",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        300,
        -140
      ],
      "parameters": {
        "text": "=Reported by {{ $json.from.emailAddress.name }} <{{ $json.from.emailAddress.address }}>\nReported at: {{ $now.toISO() }}\nSummary: {{ $json.subject }}\nDescription:\n{{ $json.data.replaceAll('\\n', ' ') }}",
        "messages": {
          "messageValues": [
            {
              "message": "=Your are JIRA triage assistant who's task is to\n1) classify and label the given issue.\n2) Prioritise the given issue.\n3) Rewrite the issue summary and description.\n\n## Labels\nUse one or more. Use words wrapped in \"[]\" (square brackets):\n* Technical\n* Account\n* Access\n* Billing\n* Product\n* Training\n* Feedback\n* Complaints\n* Security\n* Privacy\n\n## Priority\n* 1 - highest\n* 2 - high\n* 3 - medium\n* 4 - low\n* 5 - lowest\n\n## Write Summary and Description\n* Remove emotional and anedotal phrases or information\n* Keep to the facts of the matter\n* Highlight what was attempted and is/was failing"
            }
          ]
        },
        "promptType": "define",
        "hasOutputParser": true
      },
      "typeVersion": 1.6
    }
  ],
  "connections": {
    "Markdown": {
      "main": [
        [
          {
            "node": "Generate Issue From Support Request",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Mark as Seen": {
      "main": [
        [
          {
            "node": "Markdown",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Get Recent Messages",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "Generate Issue From Support Request",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Get Recent Messages": {
      "main": [
        [
          {
            "node": "Mark as Seen",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output Parser": {
      "ai_outputParser": [
        [
          {
            "node": "Generate Issue From Support Request",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "Generate Issue From Support Request": {
      "main": [
        [
          {
            "node": "Create Issue",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

Credentials you'll need

Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.

• jiraSoftwareCloudApi
• microsoftOutlookOAuth2Api
• openAiApi

About this workflow

Workflow 3893. Uses microsoftOutlook, lmChatOpenAi, outputParserStructured, jira. Scheduled trigger; 12 nodes.

Source: https://github.com/n8nKOR/n8n-shared-workflow/blob/62a671327e906c22a40d290b339ff6d2373f8d75/workflows/n8n-workflows-by-Zie619/devops/3893_workflow_3893.json — original creator credit. Request a take-down →

More AI & RAG workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.