Automate property maintenance requests with GPT-4o-mini, Jotform and Gmail
Needs changesWhat this workflow does
This AI workflow has 12 nodes and runs on Jotform events. Along the way it connects Gmail, Google Sheets, OpenAI Chat Model and Jot Form.
How it runs
Trigger: On Jotform events.
- Parse Request Data (Code): runs custom JavaScript code
- AI Maintenance Analysis (AI Agent): runs an AI agent, with model: OpenAI Chat Model
- Extract AI Response (Edit Fields (Set)): sets 1 field: aiAnalysis
- Merge AI Analysis (Code): runs custom JavaScript code
- Is Emergency? (If): checks a condition and branches into true / false
- Emergency Email to Contractor (Gmail): uses Gmail
- Standard Email to Contractor (Gmail): uses Gmail
- Send Tenant Confirmation (Gmail): uses Gmail
- Log to Google Sheets (Google Sheets): append or update
- Track Recurring Issues (Google Sheets): append or update
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in AI Maintenance Analysis (v1.6): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) AI Maintenance Analysis (v1.6) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (8)
- Code
n8n-nodes-base.code - AI Agent
@n8n/n8n-nodes-langchain.agent - Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail - Google Sheets
n8n-nodes-base.googleSheets - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Jotform Trigger
n8n-nodes-base.jotFormTrigger
From the author
Tired of juggling maintenance calls, lost requests, and slow vendor responses? This workflow streamlines the entire property maintenance process — from tenant request to vendor dispatch — powered by AI categorization and automated communication. Cut…