{
  "name": "Automate internal complaint resolution with Jotform, Gemini AI & Google Sheets",
  "nodes": [
    {
      "id": "db4577d0-7cf2-487c-b9d8-374200d6dd3a",
      "name": "JotForm Trigger",
      "type": "n8n-nodes-base.jotFormTrigger",
      "position": [
        -2720,
        -400
      ]
    },
    {
      "id": "c654df39-64c8-4ca8-9830-7248b29a320f",
      "name": "AI Agent",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        -2496,
        -400
      ]
    },
    {
      "id": "3fc62e02-5028-47b6-ad2a-944b27d78184",
      "name": "Google Gemini Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        -2736,
        -176
      ]
    },
    {
      "id": "575ea7f1-69e7-45ee-a139-bab28b7f69b4",
      "name": "Structured Output Parser",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        -2112,
        -176
      ]
    },
    {
      "id": "deaa23e1-68ff-4454-8ce8-0ffce19684be",
      "name": "Send a message",
      "type": "n8n-nodes-base.gmail",
      "position": [
        -1904,
        -400
      ]
    },
    {
      "id": "7d84068a-e287-4490-b609-9998ccacdd24",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2784,
        -544
      ],
      "parameters": {
        "width": null,
        "height": 288,
        "content": "#### The workflow gets triggered when jotform got submitted\n* Grabs the user submitted details in form"
      }
    },
    {
      "id": "ce07f8f6-e487-4b5b-a7df-2fa42e95cbca",
      "name": "Resolver Details Sheets tool",
      "type": "n8n-nodes-base.googleSheetsTool",
      "position": [
        -2528,
        -176
      ]
    },
    {
      "id": "b8e86678-089c-48c9-a82a-9f5a9c47153b",
      "name": "Issue Resolver Allotment Logic Sheets tool",
      "type": "n8n-nodes-base.googleSheetsTool",
      "position": [
        -2320,
        -176
      ]
    },
    {
      "id": "61b4de42-9a80-4931-bed4-ccc58c96e638",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -2704,
        176
      ]
    },
    {
      "id": "bf05ebb3-69ed-4ac7-9a3d-8dcf3bc44a72",
      "name": "If",
      "type": "n8n-nodes-base.if",
      "position": [
        -2208,
        176
      ]
    },
    {
      "id": "40c59fba-2e1d-4518-8769-7a23a33eff55",
      "name": "Send a message1",
      "type": "n8n-nodes-base.gmail",
      "position": [
        -1952,
        160
      ]
    },
    {
      "id": "593fb913-e305-41bf-8083-1680f1b75fa0",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2528,
        -544
      ],
      "parameters": {
        "width": 272,
        "height": 288,
        "content": "#### AI Agent Node\n* Understands the context of issue and allot the issue to relevent department"
      }
    },
    {
      "id": "e41da37d-d5aa-4a96-af02-744e2b5ab2c0",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2240,
        -544
      ],
      "parameters": {
        "width": null,
        "height": 288,
        "content": "#### Google Sheets Node\n* Saves the complaint in the log with relevent department allotment, email subject and body for sending to the problem solver"
      }
    },
    {
      "id": "4cee949d-a6f7-4aa4-8c44-d1744cc9e04a",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1984,
        -544
      ],
      "parameters": {
        "width": null,
        "height": 288,
        "content": "#### Gmail Node\n* Sends an email with dynamic AI written Email subject and body"
      }
    },
    {
      "id": "dcfc4819-1b09-4005-a7bf-1434e90f0bb3",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2784,
        48
      ],
      "parameters": {
        "width": null,
        "height": 288,
        "content": "#### Schedule Trigger\n* Runs the workflow once per day"
      }
    },
    {
      "id": "27afe67e-dd43-4a86-aabb-d173670f8ed5",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2528,
        48
      ],
      "parameters": {
        "width": null,
        "height": 288,
        "content": "#### Google Sheets Node\n* Get the issue logs that we have saved in our google sheets"
      }
    },
    {
      "id": "9bf9b0eb-e740-48c1-85d4-034b4e837675",
      "name": "Save Complaint",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -2176,
        -400
      ]
    },
    {
      "id": "3da652b3-7c58-42fb-8d03-d34d0371b022",
      "name": "Get Complaint Logs",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -2464,
        176
      ]
    },
    {
      "id": "804184a2-71b0-44ad-84c7-da2cc5c259e8",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2272,
        48
      ],
      "parameters": {
        "width": null,
        "height": 288,
        "content": "#### IF Node\n* Checks if there is an pending issue which is older than 3 days"
      }
    },
    {
      "id": "80ab7718-8d0f-46cd-a7a4-c9ac56e5a6e4",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2016,
        48
      ],
      "parameters": {
        "width": null,
        "height": 288,
        "content": "#### Gmail Node\n* Sends a follow up email about the issue status."
      }
    },
    {
      "id": "27148215-6ccf-46fc-b028-78c1fd67dfb9",
      "name": "Sticky Note8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -3072,
        -464
      ],
      "parameters": {
        "width": null,
        "height": 80,
        "content": "#### Part 1 - Collects Issues and allot them to the relevent department"
      }
    },
    {
      "id": "85a85d67-3d9a-40b4-9e3c-d8be5af5399e",
      "name": "Sticky Note9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -3072,
        160
      ],
      "parameters": {
        "width": null,
        "height": 80,
        "content": "#### Part 2 - Daily Follow-Ups After 3 Days Until Resolution"
      }
    }
  ],
  "connections": {
    "If": {
      "main": [
        [
          {
            "node": "Send a message1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "AI Agent": {
      "main": [
        [
          {
            "node": "Save Complaint",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Save Complaint": {
      "main": [
        [
          {
            "node": "Send a message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "JotForm Trigger": {
      "main": [
        [
          {
            "node": "AI Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Get Complaint Logs",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Complaint Logs": {
      "main": [
        [
          {
            "node": "If",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Gemini Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "AI Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output Parser": {
      "ai_outputParser": [
        [
          {
            "node": "AI Agent",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "Resolver Details Sheets tool": {
      "ai_tool": [
        [
          {
            "node": "AI Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Issue Resolver Allotment Logic Sheets tool": {
      "ai_tool": [
        [
          {
            "node": "AI Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    }
  }
}