{
  "name": "Multi-channel feedback to Jira pipeline with AI analysis & Notion reporting",
  "nodes": [
    {
      "id": "dc69068a-911d-4fbc-b613-d550a4ba637a",
      "name": "google form trigger",
      "type": "n8n-nodes-base.googleSheetsTrigger",
      "position": [
        736,
        304
      ]
    },
    {
      "id": "27892223-b214-4537-99cd-cbd21395ff15",
      "name": "Gmail Trigger",
      "type": "n8n-nodes-base.gmailTrigger",
      "position": [
        736,
        496
      ]
    },
    {
      "id": "412a97e2-e756-4bbe-bd89-9382fea15acb",
      "name": "data normalizer",
      "type": "n8n-nodes-base.code",
      "position": [
        1008,
        304
      ]
    },
    {
      "id": "ba9e2e00-38c4-402d-9189-042ec8e425f1",
      "name": "instant reply",
      "type": "n8n-nodes-base.telegram",
      "position": [
        1216,
        304
      ]
    },
    {
      "id": "bcde33d7-c039-4855-84e8-8edff8836e8a",
      "name": "user enrichment",
      "type": "n8n-nodes-base.code",
      "position": [
        1424,
        304
      ]
    },
    {
      "id": "63cb7b9a-2338-4e13-ba87-e2abfa70d22c",
      "name": "priority calculator",
      "type": "n8n-nodes-base.code",
      "position": [
        2288,
        304
      ]
    },
    {
      "id": "9b46d82b-efbf-45a8-bc4b-92fe546800a1",
      "name": "Create an issue",
      "type": "n8n-nodes-base.jira",
      "position": [
        2512,
        304
      ]
    },
    {
      "id": "caff0f41-fdd9-4895-8939-c9489d4a468d",
      "name": "send result to user",
      "type": "n8n-nodes-base.telegram",
      "position": [
        3136,
        176
      ]
    },
    {
      "id": "14fdc3e7-f458-4c3f-aecb-27dfb1867cc8",
      "name": "log to analytics",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        3328,
        320
      ]
    },
    {
      "id": "70cd5a1c-b68d-4810-8ce0-6a8c8494e20d",
      "name": "end notification",
      "type": "n8n-nodes-base.gmail",
      "position": [
        3552,
        320
      ]
    },
    {
      "id": "7fa7aeb3-d306-4233-9174-3938ab5a8f2b",
      "name": "parse json",
      "type": "n8n-nodes-base.code",
      "position": [
        2096,
        304
      ]
    },
    {
      "id": "1a84a28c-db1c-448d-8dd2-005b923496f1",
      "name": "Create a page",
      "type": "n8n-nodes-base.notion",
      "position": [
        3760,
        320
      ]
    },
    {
      "id": "e98e99da-4257-48bc-95b9-3bb16002d98a",
      "name": "Message a model1",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        1616,
        960
      ]
    },
    {
      "id": "c3ea0b0b-93d4-4bfb-b1d0-e4056ae55cde",
      "name": "monthly report",
      "type": "n8n-nodes-base.notion",
      "position": [
        2640,
        960
      ]
    },
    {
      "id": "18ce849f-45c1-4554-a467-4c0bd561edd6",
      "name": "Telegram Trigger",
      "type": "n8n-nodes-base.telegramTrigger",
      "position": [
        736,
        144
      ]
    },
    {
      "id": "7c294a16-6b04-4548-a6a2-867c36514903",
      "name": "post processing",
      "type": "n8n-nodes-base.code",
      "position": [
        2720,
        304
      ]
    },
    {
      "id": "cbc5c39c-0751-47c1-ad97-595f610a4522",
      "name": "If",
      "type": "n8n-nodes-base.if",
      "position": [
        2928,
        304
      ]
    },
    {
      "id": "e7aa9fab-61bd-4fe5-a577-1f80a4e6efde",
      "name": "query google sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1024,
        960
      ]
    },
    {
      "id": "e853f0f4-2ea0-47fd-9e7e-d03b7d9c5575",
      "name": "1 month Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        720,
        960
      ]
    },
    {
      "id": "03417a8a-514d-4c2c-8de0-1d5bab4418da",
      "name": "aggregate monthly stats",
      "type": "n8n-nodes-base.code",
      "position": [
        1360,
        960
      ]
    },
    {
      "id": "b8bd6bed-4b92-40c6-835c-1d199d24e660",
      "name": "parse response",
      "type": "n8n-nodes-base.code",
      "position": [
        2096,
        960
      ]
    },
    {
      "id": "b318e791-fac0-4b18-8254-3f8d16b58b36",
      "name": "montly report log",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        3136,
        960
      ]
    },
    {
      "id": "a0997a78-e13f-4bcc-a7fd-13223166132e",
      "name": "Message a model",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        1808,
        304
      ]
    },
    {
      "id": "05030e93-1a04-490e-9029-4d66d888d55e",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        432,
        0
      ],
      "parameters": {
        "width": 528,
        "height": 656,
        "content": "## 1) Trigger\n3 possible triggers when a message is received:\n- Telegram\n- Google Sheet\n- Gmail"
      }
    },
    {
      "id": "aa170b87-f7a7-4858-9055-bdc647ad250a",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        976,
        0
      ],
      "parameters": {
        "width": 1072,
        "height": 656,
        "content": "## 2) Requests treated and enriched\n\nThe request is analysed and enriched with the AI model. A Telegram message is sent to the requester to confirm."
      }
    },
    {
      "id": "fc87d894-1efa-46ff-9d64-ee2b16345d2f",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2064,
        0
      ],
      "parameters": {
        "width": 1904,
        "height": 656,
        "content": "## 3)  Priority calculation and Jira ticket creation\n\nThe priority is calculated and a ticket is created in Jira. If the request comes from Telegram, another notification will be sent.\nA log is done i"
      }
    },
    {
      "id": "82a664f3-ef6f-448d-81ef-ed1fb19cc7bd",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        432,
        768
      ],
      "parameters": {
        "width": 3536,
        "height": 352,
        "content": "## 4) Monthly reporting\n\nMonthly trigger.\nThe data are gathered then a report will be built by AI model. \nA page is created on Notions, the Google sheet updated.\nThe report is sent to the stakeholders"
      }
    },
    {
      "id": "c62ccc12-755c-454d-b727-dda5dce5e79a",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        0
      ],
      "parameters": {
        "width": 400,
        "height": 1120,
        "content": "##  How it works\n\nThis workflow consolidates product feedback coming from three different entry points: a Telegram bot, a Google Form/Sheet, and incoming emails. Each new piece of feedback is captured"
      }
    },
    {
      "id": "3b83d0c6-0a42-4dc0-befb-8fa9ca7f81f0",
      "name": "Email reporting",
      "type": "n8n-nodes-base.gmail",
      "position": [
        3744,
        960
      ]
    }
  ],
  "connections": {
    "If": {
      "main": [
        [
          {
            "node": "send result to user",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "log to analytics",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "parse json": {
      "main": [
        [
          {
            "node": "priority calculator",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Gmail Trigger": {
      "main": [
        [
          {
            "node": "data normalizer",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "instant reply": {
      "main": [
        [
          {
            "node": "user enrichment",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "monthly report": {
      "main": [
        [
          {
            "node": "montly report log",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "parse response": {
      "main": [
        [
          {
            "node": "monthly report",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "1 month Trigger": {
      "main": [
        [
          {
            "node": "query google sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create an issue": {
      "main": [
        [
          {
            "node": "post processing",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Message a model": {
      "main": [
        [
          {
            "node": "parse json",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "data normalizer": {
      "main": [
        [
          {
            "node": "instant reply",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "post processing": {
      "main": [
        [
          {
            "node": "If",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "user enrichment": {
      "main": [
        [
          {
            "node": "Message a model",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Message a model1": {
      "main": [
        [
          {
            "node": "parse response",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Telegram Trigger": {
      "main": [
        [
          {
            "node": "data normalizer",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "end notification": {
      "main": [
        [
          {
            "node": "Create a page",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "log to analytics": {
      "main": [
        [
          {
            "node": "end notification",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "montly report log": {
      "main": [
        [
          {
            "node": "Email reporting",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "query google sheet": {
      "main": [
        [
          {
            "node": "aggregate monthly stats",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "google form trigger": {
      "main": [
        [
          {
            "node": "data normalizer",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "priority calculator": {
      "main": [
        [
          {
            "node": "Create an issue",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "send result to user": {
      "main": [
        [
          {
            "node": "log to analytics",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "aggregate monthly stats": {
      "main": [
        [
          {
            "node": "Message a model1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}