{ "edges": [ { "to": "40c59fba-2e1d-4518-8769-7a23a33eff55", "from": "bf05ebb3-69ed-4ac7-9a3d-8dcf3bc44a72", "toPort": "0", "fromPort": "0" }, { "to": "9bf9b0eb-e740-48c1-85d4-034b4e837675", "from": "c654df39-64c8-4ca8-9830-7248b29a320f", "toPort": "0", "fromPort": "0" }, { "to": "deaa23e1-68ff-4454-8ce8-0ffce19684be", "from": "9bf9b0eb-e740-48c1-85d4-034b4e837675", "toPort": "0", "fromPort": "0" }, { "to": "c654df39-64c8-4ca8-9830-7248b29a320f", "from": "db4577d0-7cf2-487c-b9d8-374200d6dd3a", "toPort": "0", "fromPort": "0" }, { "to": "3da652b3-7c58-42fb-8d03-d34d0371b022", "from": "61b4de42-9a80-4931-bed4-ccc58c96e638", "toPort": "0", "fromPort": "0" }, { "to": "bf05ebb3-69ed-4ac7-9a3d-8dcf3bc44a72", "from": "3da652b3-7c58-42fb-8d03-d34d0371b022", "toPort": "0", "fromPort": "0" }, { "to": "c654df39-64c8-4ca8-9830-7248b29a320f", "from": "3fc62e02-5028-47b6-ad2a-944b27d78184", "toPort": "0", "fromPort": "ai_languageModel" }, { "to": "c654df39-64c8-4ca8-9830-7248b29a320f", "from": "575ea7f1-69e7-45ee-a139-bab28b7f69b4", "toPort": "0", "fromPort": "ai_outputParser" }, { "to": "c654df39-64c8-4ca8-9830-7248b29a320f", "from": "ce07f8f6-e487-4b5b-a7df-2fa42e95cbca", "toPort": "0", "fromPort": "ai_tool" }, { "to": "c654df39-64c8-4ca8-9830-7248b29a320f", "from": "b8e86678-089c-48c9-a82a-9f5a9c47153b", "toPort": "0", "fromPort": "ai_tool" } ], "nodes": [ { "id": "db4577d0-7cf2-487c-b9d8-374200d6dd3a", "name": "JotForm Trigger", "type": "integration", "params": { "form": "252855912400050", "service": "jotformtrigger", "operation": "run", "__originalType": "n8n-nodes-base.jotFormTrigger" }, "position": [ -2720, -400 ] }, { "id": "c654df39-64c8-4ca8-9830-7248b29a320f", "name": "AI Agent", "type": "llm", "params": { "text": "=1. Analyze the content \"{{ $json['Please describe the issue or complaint in detail.'] }}\" and then classify the complaint into one of the five predefined categories:\n\n- Disciplinary / Behavior Issues\n- Interpersonal / Team Conflicts\n- Payroll / Compensation Issues\n- Harassment / Discrimination\n- Resource / Infrastructure Problems\n\n2. Use \"Issue Resolver Allotment Logic Sheets tool\" to know which type of issue should be alloted to which person in company. If in case the issue is caused by the Normal Resolver (Primary Assignee) allot the case to alternative resolver.\n\n3. Use \"Resolver Details Sheets tool\" to get the alloted person's email addresses.\n\n\nBefore giving an output make sure you ran step 2 and step 3 and used the both tools and then give the output in this form:\n\nexample output:\n{\n \"email\":\"email@example.com\",\n \"case_awarded_to\": \"HR Team\",\n \"Status\": \"Pending\",\n \"email_subject\": \"Confidential: Harassment / Discrimination\",\n \"email_body_html\": \"\\n\\n\\n\\n\\n\\n

\\n

Confidential Compliance Issue Assigned

\\n

Dear HR Team,

\\n

An internal compliance issue has been automatically logged and assigned to you for investigation and resolution. Please handle this matter with the utmost confidentiality and urgency.

\\n \\n

Issue Details:

\\n

Issue Classification: Harassment / Discrimination
Team Member Involved: Jane Smith

\\n\\n

Detailed Description from Submission:

\\n

\\n Jane Smith has been making inappropriate and biased comments during team meetings. She consistently interrupts female colleagues and has created a hostile environment for several members of the team. This has been ongoing for the past two months.\\n

\\n\\n

Next Steps:

\\n

Please conduct a thorough and impartial investigation into this matter. Upon completion, you are required to report your findings and proposed resolution to the External Compliance Officer.

\\n\\n \\n

\\n\\n\"\n}", "prompt": "=1. Analyze the content \"{{ $json['Please describe the issue or complaint in detail.'] }}\" and then classify the complaint into one of the five predefined categories:\n\n- Disciplinary / Behavior Issues\n- Interpersonal / Team Conflicts\n- Payroll / Compensation Issues\n- Harassment / Discrimination\n- Resource / Infrastructure Problems\n\n2. Use \"Issue Resolver Allotment Logic Sheets tool\" to know which type of issue should be alloted to which person in company. If in case the issue is caused by the Normal Resolver (Primary Assignee) allot the case to alternative resolver.\n\n3. Use \"Resolver Details Sheets tool\" to get the alloted person's email addresses.\n\n\nBefore giving an output make sure you ran step 2 and step 3 and used the both tools and then give the output in this form:\n\nexample output:\n{\n \"email\":\"email@example.com\",\n \"case_awarded_to\": \"HR Team\",\n \"Status\": \"Pending\",\n \"email_subject\": \"Confidential: Harassment / Discrimination\",\n \"email_body_html\": \"\\n\\n\\n\\n\\n\\n

\\n

Confidential Compliance Issue Assigned

\\n

Dear HR Team,

\\n

An internal compliance issue has been automatically logged and assigned to you for investigation and resolution. Please handle this matter with the utmost confidentiality and urgency.

\\n \\n

Issue Details:

\\n

Issue Classification: Harassment / Discrimination
Team Member Involved: Jane Smith

\\n\\n

Detailed Description from Submission:

\\n

\\n Jane Smith has been making inappropriate and biased comments during team meetings. She consistently interrupts female colleagues and has created a hostile environment for several members of the team. This has been ongoing for the past two months.\\n

\\n\\n

Next Steps:

\\n

Please conduct a thorough and impartial investigation into this matter. Upon completion, you are required to report your findings and proposed resolution to the External Compliance Officer.

\\n\\n \\n

\\n\\n\"\n}", "options": {}, "provider": "openai", "promptType": "define", "approximated": true, "hasOutputParser": true }, "position": [ -2496, -400 ] }, { "id": "3fc62e02-5028-47b6-ad2a-944b27d78184", "name": "Google Gemini Chat Model", "type": "llm", "params": { "options": {}, "provider": "google" }, "position": [ -2736, -176 ] }, { "id": "575ea7f1-69e7-45ee-a139-bab28b7f69b4", "name": "Structured Output Parser", "type": "passthrough", "params": { "mode": "noOp", "jsonSchemaExample": "{\n \"email\":\"user@example.com\",\n \"case_awarded_to\": \"HR Team\",\n \"Status\": \"Pending\",\n \"email_subject\": \"Confidential: Harassment / Discrimination\",\n \"email_body_html\": \"\\n\\n\\n\\n\\n\\n

\\n

Confidential Compliance Issue Assigned

\\n

Dear HR Team,

\\n

An internal compliance issue has been automatically logged and assigned to you for investigation and resolution. Please handle this matter with the utmost confidentiality and urgency.

\\n \\n

Issue Details:

\\n

Issue Classification: Harassment / Discrimination
Team Member Involved: Jane Smith

\\n\\n

Detailed Description from Submission:

\\n

\\n Jane Smith has been making inappropriate and biased comments during team meetings. She consistently interrupts female colleagues and has created a hostile environment for several members of the team. This has been ongoing for the past two months.\\n

\\n\\n

Next Steps:

\\n

Please conduct a thorough and impartial investigation into this matter. Upon completion, you are required to report your findings and proposed resolution to the External Compliance Officer.

\\n\\n \\n

\\n\\n\"\n}" }, "position": [ -2112, -176 ] }, { "id": "deaa23e1-68ff-4454-8ce8-0ffce19684be", "name": "Send a message", "type": "integration", "params": { "sendTo": "={{ $json.resolver_email }}", "message": "={{ $('AI Agent').item.json.output.email_body_html }}", "options": { "appendAttribution": false }, "service": "gmail", "subject": "={{ $('AI Agent').item.json.output.email_subject }}", "operation": "read" }, "position": [ -1904, -400 ] }, { "id": "ce07f8f6-e487-4b5b-a7df-2fa42e95cbca", "name": "Resolver Details Sheets tool", "type": "integration", "params": { "options": {}, "service": "googleSheets", "operation": "read", "sheetName": { "__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1NxWZ5zitUp1zZDnieyOhv1ACEvmkpFUd7oYG7y_2sqs/edit#gid=0", "cachedResultName": "Sheet1" }, "documentId": { "__rl": true, "mode": "list", "value": "1NxWZ5zitUp1zZDnieyOhv1ACEvmkpFUd7oYG7y_2sqs", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1NxWZ5zitUp1zZDnieyOhv1ACEvmkpFUd7oYG7y_2sqs/edit?usp=drivesdk", "cachedResultName": "Resolver Details" }, "authentication": "serviceAccount" }, "position": [ -2528, -176 ] }, { "id": "b8e86678-089c-48c9-a82a-9f5a9c47153b", "name": "Issue Resolver Allotment Logic Sheets tool", "type": "integration", "params": { "options": {}, "service": "googleSheets", "operation": "read", "sheetName": { "__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1xEq6Nq9jR7BUBzwLoPd3HyhElzawjY4kKwWsfSzlX-A/edit#gid=0", "cachedResultName": "Sheet1" }, "documentId": { "__rl": true, "mode": "list", "value": "1xEq6Nq9jR7BUBzwLoPd3HyhElzawjY4kKwWsfSzlX-A", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1xEq6Nq9jR7BUBzwLoPd3HyhElzawjY4kKwWsfSzlX-A/edit?usp=drivesdk", "cachedResultName": "Issue Resolver Allotment Logic" }, "authentication": "serviceAccount" }, "position": [ -2320, -176 ] }, { "id": "61b4de42-9a80-4931-bed4-ccc58c96e638", "name": "Schedule Trigger", "type": "trigger", "params": { "kind": "n8n-nodes-base.scheduleTrigger", "rule": { "interval": [ { "triggerAtHour": 10 } ] } }, "position": [ -2704, 176 ] }, { "id": "bf05ebb3-69ed-4ac7-9a3d-8dcf3bc44a72", "name": "If", "type": "if", "params": { "options": {}, "conditions": { "options": { "version": 2, "leftValue": "", "caseSensitive": true, "typeValidation": "loose" }, "combinator": "and", "conditions": [ { "id": "668e2c22-0e4f-4477-8cdd-2a0f18b91d24", "operator": { "type": "number", "operation": "gte" }, "leftValue": "={{ Math.floor(Math.abs(DateTime.fromFormat($json.submitted_time, 'dd-MM-yyyy HH:mm').diff($now, 'days').days)) }}", "rightValue": "=3" } ] }, "looseTypeValidation": true }, "position": [ -2208, 176 ] }, { "id": "40c59fba-2e1d-4518-8769-7a23a33eff55", "name": "Send a message1", "type": "integration", "params": { "sendTo": "={{ $json.resolver_email }}", "message": "=Hey,\n\nIt's been {{ Math.floor(Math.abs(DateTime.fromFormat($json.submitted_time, 'dd-MM-yyyy HH:mm').diff($now, 'days').days)) }} days since I shared below issue with you. What was the update? \n\nThe Issue:\n{{ $json.Issue }}\n\nPlease reply to this email about the status of this issue.\n\nThanks,\nCEO Internal Compliance Team", "options": { "appendAttribution": false }, "service": "gmail", "subject": "What's the update this issue?", "emailType": "text", "operation": "read" }, "position": [ -1952, 160 ] }, { "id": "9bf9b0eb-e740-48c1-85d4-034b4e837675", "name": "Save Complaint", "type": "integration", "params": { "columns": { "value": { "Issue": "={{ $('JotForm Trigger').item.json['Please describe the issue or complaint in detail.'] }}", "email_subject": "={{ $json.output.email_subject }}", "resolver_email": "={{ $json.output.email }}", "submitted_time": "={{ $now.toFormat('dd-MM-yyyy HH:mm') }}", "case_awarded_to": "={{ $json.output.case_awarded_to }}", "email_body_html": "={{ $json.output.email_body_html }}", "The person Caused by": "={{ $('JotForm Trigger').item.json['What is the name of the team member involved? (Optional, you may leave blank for anonymity)'] }}" }, "schema": [ { "id": "Issue", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Issue", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "The person Caused by", "type": "string", "display": true, "required": false, "displayName": "The person Caused by", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "case_awarded_to", "type": "string", "display": true, "required": false, "displayName": "case_awarded_to", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "resolver_email", "type": "string", "display": true, "removed": false, "required": false, "displayName": "resolver_email", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "email_subject", "type": "string", "display": true, "required": false, "displayName": "email_subject", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "email_body_html", "type": "string", "display": true, "required": false, "displayName": "email_body_html", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "submitted_time", "type": "string", "display": true, "required": false, "displayName": "submitted_time", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "status", "type": "string", "display": true, "removed": false, "required": false, "displayName": "status", "defaultMatch": false, "canBeUsedToMatch": true } ], "mappingMode": "defineBelow", "matchingColumns": [ "Issue" ], "attemptToConvertTypes": false, "convertFieldsToString": false }, "options": {}, "service": "googleSheets", "operation": "appendOrUpdate", "sheetName": { "__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1KU7cqmE5xmi1EmDs81mC8-EPJcrn-U-JrvRBe2dcZ9I/edit#gid=0", "cachedResultName": "Sheet1" }, "documentId": { "__rl": true, "mode": "list", "value": "1KU7cqmE5xmi1EmDs81mC8-EPJcrn-U-JrvRBe2dcZ9I", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1KU7cqmE5xmi1EmDs81mC8-EPJcrn-U-JrvRBe2dcZ9I/edit?usp=drivesdk", "cachedResultName": "Issue Logs" }, "authentication": "serviceAccount" }, "position": [ -2176, -400 ] }, { "id": "3da652b3-7c58-42fb-8d03-d34d0371b022", "name": "Get Complaint Logs", "type": "integration", "params": { "options": {}, "service": "googleSheets", "operation": "read", "sheetName": { "__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1KU7cqmE5xmi1EmDs81mC8-EPJcrn-U-JrvRBe2dcZ9I/edit#gid=0", "cachedResultName": "Sheet1" }, "documentId": { "__rl": true, "mode": "list", "value": "1KU7cqmE5xmi1EmDs81mC8-EPJcrn-U-JrvRBe2dcZ9I", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1KU7cqmE5xmi1EmDs81mC8-EPJcrn-U-JrvRBe2dcZ9I/edit?usp=drivesdk", "cachedResultName": "Issue Logs" }, "authentication": "serviceAccount" }, "position": [ -2464, 176 ] } ] }

Automate internal complaint resolution with Jotform, Gemini AI & Google Sheets