Score and email cleaning quotes from JotForm with Gemini and 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 16 nodes and runs on Jotform events. Along the way it connects Jot Form, Google Gemini Chat Model, Gmail and Google Sheets.
How it runs
Trigger: On Jotform events.
- Set Submission Details (Edit Fields (Set)): sets 7 fields: Full Name, Email Address, Phone Number…
- Filter: keeps only the items that match a condition
- Quote Analysis Agent (AI Agent): runs an AI agent, with model: Gemini Quote Analysis; output parser: Parse Quote Analysis Output
- Normalize Requirements Data (Edit Fields (Set)): sets 12 fields: Full Name, Email Address, Phone Number…
- Compute Labor Hours (Edit Fields (Set)): sets 1 field: Estimated Labor Hours
- Determine Quote Range (Edit Fields (Set)): sets 4 fields: Hourly Rate Low, Hourly Rate High, Quote Low…
- Filter: keeps only the items that match a condition
- Estimator Summary Agent (AI Agent): runs an AI agent, with model: Gemini Estimator Summary; output parser: Parse Estimator Summary Output
- If: checks a condition and branches into true / false
- Update Sheet with Quote Data (Google Sheets): append or update
…plus 1 more step. See the full node list below.
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 - Edit Fields (Set)
n8n-nodes-base.set - Filter
n8n-nodes-base.filter - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail - Google Sheets
n8n-nodes-base.googleSheets
From the author
Quick overview Youtube Video: https://youtu.be/5QmlxcOuuSg This workflow captures commercial cleaning quote requests from Jotform, uses Google Gemini to extract requirements and draft a quote email, calculates an internal quote range, logs the lead to Google…