{
  "name": "Categorize support tickets with Gemini AI, Typeform, and Google Sheets reporting",
  "nodes": [
    {
      "id": "fc0f2155-ac48-4cd0-97d2-3eb81dac1757",
      "name": "Google Gemini Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        -840,
        120
      ]
    },
    {
      "id": "992c9e1b-ec91-4470-887f-e43c899cfb8c",
      "name": "Sticky Note9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1080,
        -280
      ],
      "parameters": {
        "width": 500,
        "height": 1280,
        "content": "=======================================\n            WORKFLOW ASSISTANCE\n=======================================\nFor any questions or support, please contact:\n    Yaron@nofluff.online\n\nExplore more tip"
      }
    },
    {
      "id": "4c76ce3a-6c1d-493b-b648-12c0d56fd9d8",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -820,
        -640
      ],
      "parameters": {
        "width": 580,
        "height": null,
        "content": "This workflow retrieves support ticket data from Google Sheets, counts how many tickets fall into each category, and sends a summary report via email."
      }
    },
    {
      "id": "ab24dd90-ae20-496d-a963-6c89a65d2340",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -960,
        -180
      ],
      "parameters": {
        "width": 170,
        "height": 80,
        "content": "Triggers the workflow  to start the summary process."
      }
    },
    {
      "id": "968d3213-dafc-415f-8760-31e0fb55d94a",
      "name": "Form Trigger",
      "type": "n8n-nodes-base.typeformTrigger",
      "position": [
        -940,
        -380
      ]
    },
    {
      "id": "d57b9477-f789-4ee2-a664-eba7f787a750",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -680,
        -160
      ],
      "parameters": {
        "width": 190,
        "height": 100,
        "content": "Uses Gemini model to classify or tag each support request into predefined categories."
      }
    },
    {
      "id": "bb7ae6f3-5c32-47a3-a91b-97e4e4b4e0b1",
      "name": "Sticky Note10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -400,
        -160
      ],
      "parameters": {
        "width": 170,
        "height": 100,
        "content": "Parses Gemini's response to extract only the relevant category label from the output."
      }
    },
    {
      "id": "b7eb9e53-916f-4c34-babf-c8b23641b8a2",
      "name": "AI Categorization",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        -740,
        -380
      ]
    },
    {
      "id": "eb3c3d0a-cdad-4792-a954-1de022d968dd",
      "name": "Extract Category",
      "type": "n8n-nodes-base.code",
      "position": [
        -360,
        -380
      ]
    },
    {
      "id": "b3c418d7-9113-46eb-af0a-2372de5a3eec",
      "name": "Store Data",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -120,
        -380
      ]
    },
    {
      "id": "51ef2daa-2c2e-409c-a103-6f915d3ef0d0",
      "name": "Fetch Support Ticket Data",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        100,
        -380
      ]
    },
    {
      "id": "b3258a29-9bfa-4361-83d3-804aac76e976",
      "name": "Increment Counter",
      "type": "n8n-nodes-base.code",
      "position": [
        300,
        -380
      ]
    },
    {
      "id": "5c8193a0-6fab-494a-bd40-b26188c319b0",
      "name": "Email Ticket Summary",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        500,
        -380
      ]
    },
    {
      "id": "3827fa87-5669-4217-88fe-978328f0ec4c",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -140,
        -180
      ],
      "parameters": {
        "width": 170,
        "height": 120,
        "content": "Appends each categorized and data ticket into a central Google Sheet for record keeping and later aggregation."
      }
    },
    {
      "id": "c515d231-f260-4c5a-9895-19fe0c229762",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        80,
        -180
      ],
      "parameters": {
        "width": 170,
        "height": 120,
        "content": "Fetches all categorized entries from the Google Sheet to compute ticket counts by category."
      }
    },
    {
      "id": "f6eb3bd4-c4fa-4b98-bc58-1930118e3b25",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        300,
        -180
      ],
      "parameters": {
        "width": 170,
        "height": 100,
        "content": "Groups tickets by category and counts the total per group to prepare data for reporting."
      }
    },
    {
      "id": "5ec81b1c-14d1-4540-9acb-ad8c97632246",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        520,
        -180
      ],
      "parameters": {
        "width": 170,
        "height": 100,
        "content": "Sends an email with the total number of tickets per category from today’s run."
      }
    }
  ],
  "connections": {
    "Store Data": {
      "main": [
        [
          {
            "node": "Fetch Support Ticket Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Form Trigger": {
      "main": [
        [
          {
            "node": "AI Categorization",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Category": {
      "main": [
        [
          {
            "node": "Store Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "AI Categorization": {
      "main": [
        [
          {
            "node": "Extract Category",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Increment Counter": {
      "main": [
        [
          {
            "node": "Email Ticket Summary",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Gemini Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "AI Categorization",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Fetch Support Ticket Data": {
      "main": [
        [
          {
            "node": "Increment Counter",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}