{
  "name": "Jira ticket creation from Google Forms with sheet updates and email notifications",
  "nodes": [
    {
      "id": "8b90ebac-96e0-4b28-8024-edd6692f45c9",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -224,
        -544
      ],
      "parameters": {
        "width": 304,
        "height": 176,
        "content": "## Required\n\n\n• Google Form + response sheet\n• Jira Cloud project (API email + API token)\n• Gmail credential"
      }
    },
    {
      "id": "f7d9bcc1-d9c2-4844-ab4d-7d9d6b8610c3",
      "name": "Trigger when row added",
      "type": "n8n-nodes-base.googleSheetsTrigger",
      "position": [
        208,
        -16
      ]
    },
    {
      "id": "5278e62a-2d6c-4aa5-8621-77e38efd9dc6",
      "name": "Normalize fields",
      "type": "n8n-nodes-base.code",
      "position": [
        416,
        -16
      ]
    },
    {
      "id": "ce1d830b-85af-423f-81d1-36089e5ce1ae",
      "name": "Cretate Jira Ticket",
      "type": "n8n-nodes-base.jira",
      "position": [
        672,
        -16
      ]
    },
    {
      "id": "387f2792-94a0-43ec-b358-a27229c50566",
      "name": "Update the Google sheet with tickets information",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        976,
        -16
      ]
    },
    {
      "id": "5cc9d8ed-dea5-44cc-bc5f-60fcc2a8b464",
      "name": "Notification email",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1296,
        -16
      ]
    },
    {
      "id": "d4016ada-d836-4ff2-9c57-882fda5d1e1f",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        112,
        -544
      ],
      "parameters": {
        "width": 448,
        "height": 704,
        "content": "## 1) Trigger and Normalize \n\nTrigger: New row added to Google Sheets\n\nData Processing:\n- Clean and normalize all fields\n- summary: Single-spaced, trimmed text\n- description: Preserve paragraphs (trim"
      }
    },
    {
      "id": "0df66792-90e8-4802-9e0b-33d46d8f9e0d",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        576,
        -544
      ],
      "parameters": {
        "width": 304,
        "height": 704,
        "content": "## 2) Create Jira ticket\n\nAction: Call Jira API to create ticket\n\nKey Parameters:\n- Project: \n- Type: Story\n- Priority: Mapped to Jira IDs (1-5)\n- Description: Standardized format\n\nOutputs:\n- Ticket k"
      }
    },
    {
      "id": "6379b494-5fd6-4795-8310-2b3b28dbf39a",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        896,
        -544
      ],
      "parameters": {
        "width": 576,
        "height": 704,
        "content": "## 3) Update the sheet and send Gmail notification\nAction: Update source row with Jira information\n\nUpdated Fields:\n- jira_key: Ticket reference\n- jira_url: Ticket link\n- status: \"Created\"\n- created_a"
      }
    }
  ],
  "connections": {
    "Normalize fields": {
      "main": [
        [
          {
            "node": "Cretate Jira Ticket",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Cretate Jira Ticket": {
      "main": [
        [
          {
            "node": "Update the Google sheet with tickets information",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Trigger when row added": {
      "main": [
        [
          {
            "node": "Normalize fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update the Google sheet with tickets information": {
      "main": [
        [
          {
            "node": "Notification email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}