Automate internal complaint resolution with Jotform, Gemini AI & Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 12 nodes and runs on Jotform events (plus 1 other trigger). Along the way it connects Jot Form, Google Gemini Chat Model, Gmail and Google Sheets.
How it runs
Trigger: On Jotform events (plus 1 other trigger).
- AI Agent: runs an AI agent, with model: Google Gemini Chat Model; 2 tools (Resolver Details Sheets tool, Issue Resolver Allotment Logic Sheets tool); output parser: Structured Output Parser
- Get Complaint Logs (Google Sheets): uses Google Sheets
- Save Complaint (Google Sheets): append or update
- If: checks a condition and branches into true / false
- Send a message (Gmail): uses Gmail
- Send a message (Gmail): uses Gmail
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (9)
- Jotform Trigger
n8n-nodes-base.jotFormTrigger - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Gmail
n8n-nodes-base.gmail - Google Sheets Tool
n8n-nodes-base.googleSheetsTool - Schedule Trigger
n8n-nodes-base.scheduleTrigger - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets
From the author
Workflow explaination video: https://youtu.be/z1grVuNOXMk Prerequisites Before running this workflow, you need to have the following set up: 1. JotForm: A form with fields for describing the issue and optionally naming the team member involved. 2. Google…