January 21, 2026

Jotform to Google Sheets, track every repair request

Lisa Granqvist Partner Workflow Automation Expert

Get a free AI assessment → ⬇️ Use template

Maintenance requests have a way of disappearing. An email thread here, a voicemail there, then someone swears they “already told you” about the leak three days ago.

This Jotform Sheets automation hits Property Managers first, honestly. But Facilities teams and busy Operations leads feel it too when the same request gets handled twice, or not at all.

This workflow captures every request, uses AI to classify and prioritize it, emails the right vendor, and logs everything to Google Sheets so you always know what’s happening and what’s overdue.

How This Automation Works

The full n8n workflow, from trigger to final output:

n8n Workflow Template: Jotform to Google Sheets, track every repair request

Click to explore

flowchart LR

    subgraph sg0["Form Intake Flow"]
        direction LR
        n0["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/jotform.dark.svg' width='40' height='40' /></div><br/>Form Intake Trigger"]
        n1["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Normalize Request Payload"]
        n2@{ icon: "mdi:robot", form: "rounded", label: "AI Repair Assessment", pos: "b", h: 48 }
        n3@{ icon: "mdi:brain", form: "rounded", label: "OpenAI Chat Engine", pos: "b", h: 48 }
        n4@{ icon: "mdi:swap-vertical", form: "rounded", label: "Capture AI Output", pos: "b", h: 48 }
        n5["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Combine Request Insights"]
        n6@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Emergency Priority Check", pos: "b", h: 48 }
        n7@{ icon: "mdi:message-outline", form: "rounded", label: "Dispatch Urgent Contractor E..", pos: "b", h: 48 }
        n8@{ icon: "mdi:message-outline", form: "rounded", label: "Send Routine Work Order", pos: "b", h: 48 }
        n9@{ icon: "mdi:message-outline", form: "rounded", label: "Notify Tenant Receipt", pos: "b", h: 48 }
        n10@{ icon: "mdi:database", form: "rounded", label: "Update Maintenance Log", pos: "b", h: 48 }
        n11@{ icon: "mdi:database", form: "rounded", label: "Record Recurring Issues", pos: "b", h: 48 }
        n6 --> n7
        n6 --> n8
        n0 --> n1
        n5 --> n6
        n3 -.-> n2
        n1 --> n2
        n4 --> n5
        n2 --> n4
        n9 --> n10
        n9 --> n11
        n8 --> n9
        n7 --> n9
    end

    %% Styling
    classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
    classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
    classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
    classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
    classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
    classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
    classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
    classDef disabled stroke-dasharray: 5 5,opacity: 0.5
    class n0 trigger
    class n2 ai
    class n3 aiModel
    class n6 decision
    class n10,n11 database
    class n1,n5 code
    classDef customIcon fill:none,stroke:none
    class n0,n1,n5 customIcon

The Problem: Repair Requests Get Lost (and Everyone Pays)

Most maintenance “systems” are really just people doing their best across too many inboxes. A tenant submits a form, then someone copies details into a spreadsheet, then someone else forwards a blurry photo to a vendor, then the tenant follows up because they heard nothing. Meanwhile, emergencies don’t look like emergencies until they’ve already become expensive. The worst part is the mental load. You’re not just tracking repairs. You’re tracking conversations about repairs, across tools that don’t talk to each other.

It adds up fast. Here’s where it breaks down in real life.

Requests arrive in different formats, so the “important details” get missed during copy-paste.
Urgent issues look the same as routine ones until someone reads them carefully, which often happens too late.
Vendor dispatch depends on one person remembering who handles HVAC vs. plumbing for each property.
Without a reliable log, follow-ups become guesswork and reporting becomes a monthly scramble.

The Solution: AI-Categorize Requests, Email Vendors, Log Everything

This workflow turns a tenant’s Jotform submission into a tracked, routed work order in minutes. When a request comes in, n8n normalizes the form fields (unit, urgency, description, photos) so the data is clean and consistent. Then an OpenAI-powered agent reviews the text and classifies the issue (plumbing, HVAC, electrical, general repair) while also detecting urgency signals like “leak,” “no power,” or “sparking.” Based on that AI assessment, the workflow routes the job to the right vendor via Gmail, and sends an acknowledgment message back to the tenant so they’re not left wondering. Finally, it logs the request and key metadata in Google Sheets so you have an audit trail for compliance, reporting, and recurring-issue tracking.

The workflow starts with a Jotform trigger. AI then categorizes and prioritizes the repair, and n8n chooses the right path (emergency vs routine). Gmail sends the work order out, and Google Sheets becomes your living maintenance ledger.

What You Get: Automation vs. Results

What This Workflow Automates

Results You’ll Get

Captures maintenance requests the moment a Jotform is submitted.
Uses OpenAI to categorize the issue type and detect urgency.
Routes emergencies to an urgent contractor email, otherwise sends a routine work order.
Logs every request and recurring patterns into Google Sheets automatically.

Cut average resolution from about a week to under 24 hours when vendors respond normally.
Fewer missed repairs because every request is recorded the same way.
Happier tenants from instant acknowledgment and clearer expectations.
About 10 hours saved weekly by eliminating manual triage and follow-ups.
Cleaner reporting since Sheets becomes your single source of truth.

Example: What This Looks Like

Say you handle about 100 maintenance requests a month. Manually, it’s easy to spend 10 minutes per request just triaging, forwarding, and logging details, which is roughly 16 hours of admin time. With this workflow, the “human time” becomes reviewing the occasional edge case and updating vendor emails, maybe 1–2 minutes per request. The rest runs in the background: AI categorizes, Gmail sends, and Google Sheets logs it. That’s about a workday or two back every month.

What You’ll Need

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
Jotform for tenant maintenance request intake
Gmail to send tenant and vendor emails
Google Sheets to maintain an audit trail log
OpenAI API key (get it from the OpenAI dashboard)

Skill level: Intermediate. You’ll connect accounts, paste a few IDs (like vendor emails), and test with sample submissions.

Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).

How It Works

A tenant submits a maintenance form in Jotform. That submission is the trigger, and it includes structured fields like unit number and urgency, plus optional photos.

The request is cleaned up and standardized. n8n runs a short code step to normalize the payload so “Unit #12B” doesn’t become five different formats in your log.

OpenAI assesses the repair and flags emergencies. The AI agent classifies the issue type, extracts key details, and produces a consistent output your workflow can route on. Then an “emergency check” decides which email path to take.

Gmail sends the right messages and Sheets stores the record. Vendors get a work order with the details they need, tenants get an acknowledgment, and Google Sheets gets updated so you can filter, sort, and report without chasing anyone.

You can easily modify vendor routing to match your properties, or swap Google Sheets logging for a different database based on your needs. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the JotForm Trigger

Set up the intake trigger so new maintenance submissions start the workflow.

Add and open Form Intake Trigger.
Credential Required: Connect your jotFormApi credentials.
Set Form to [YOUR_ID].

⚠️ Common Pitfall: Replace [YOUR_ID] with your actual JotForm ID, or the trigger will never fire.

Step 2: Connect Gmail and Google Sheets

Authorize outbound email and logging destinations used later in the workflow.

Open Dispatch Urgent Contractor Email and connect Gmail. Credential Required: Connect your gmailOAuth2 credentials.
Open Send Routine Work Order and connect Gmail. Credential Required: Connect your gmailOAuth2 credentials.
Open Notify Tenant Receipt and connect Gmail. Credential Required: Connect your gmailOAuth2 credentials.
Open Update Maintenance Log and connect Sheets. Credential Required: Connect your googleSheetsOAuth2Api credentials.
Open Record Recurring Issues and connect Sheets. Credential Required: Connect your googleSheetsOAuth2Api credentials.

Confirm that the Google Sheets file and tab names referenced later exist in your account before testing.

Step 3: Set Up AI Repair Assessment

Configure the AI analysis that categorizes, prioritizes, and recommends vendors.

Open AI Repair Assessment and confirm Prompt Type is define and Text includes the JSON analysis template.
Ensure the prompt interpolations remain intact, such as {{ $json.unitNumber }}, {{ $json.tenantName }}, and {{ $json.issueDescription }}.
Open OpenAI Chat Engine and verify the model is set to gpt-4.1-mini.
Credential Required: Connect your openAiApi credentials in OpenAI Chat Engine. This node is the language model for AI Repair Assessment.

⚠️ Common Pitfall: Do not add credentials to AI Repair Assessment—the credentials must be added to OpenAI Chat Engine.

Step 4: Configure Request Normalization and Insight Merge

Normalize the JotForm payload, capture AI output, and merge the data into a unified request object.

Open Normalize Request Payload and keep the JavaScript mapping that sets fields like requestId, tenantName, issueDescription, and urgencyLevel.
Open Capture AI Output and ensure the assignment aiAnalysis uses {{ $json.output }}.
Open Combine Request Insights and keep the contractor database and priority mapping logic to build fields such as finalPriority, contractorEmail, and workOrderNumber.

Step 5: Configure Routing and Email Outputs

Route emergencies and send work orders to contractors, then notify tenants.

Open Emergency Priority Check and set the condition to {{ $json.finalPriority }} equals emergency.
In Dispatch Urgent Contractor Email, set Send To to {{ $json.contractorEmail }} and Subject to 🚨 EMERGENCY WORK ORDER - {{ $json.workOrderNumber }}.
In Send Routine Work Order, set Send To to {{ $json.contractorEmail }} and Subject to Work Order: {{ $json.workOrderNumber }} - {{ $json.issueCategory }}.
In Notify Tenant Receipt, set Send To to {{ $('Form Intake Trigger').item.json['tenant Email'] }} and Subject to ✅ Maintenance Request Received - {{ $('Normalize Request Payload').item.json.requestId }}.

⚠️ Common Pitfall: Update contractor emails in Combine Request Insights where placeholders like [YOUR_EMAIL] are defined, or messages may go to invalid addresses.

Step 6: Log Requests to Google Sheets

Record each request and recurring issue details after tenant notification.

Open Update Maintenance Log and set Operation to appendOrUpdate.
Set Document ID to [YOUR_ID] and Sheet Name to [YOUR_ID] (Sheet1).
Verify the mapped fields, such as {{ $('Form Intake Trigger').item.json['tenant Name'].first }} and {{ $('Form Intake Trigger').item.json['issue Description'] }}.
Open Record Recurring Issues and keep Operation as appendOrUpdate with Matching Columns set to unitNumber and issueCategory.
Set Document ID to [YOUR_ID] and Sheet Name to [YOUR_ID] (Recurring issue).

Notify Tenant Receipt outputs to both Update Maintenance Log and Record Recurring Issues in parallel.

⚠️ Common Pitfall: Replace all [YOUR_ID] placeholders with actual Google Sheet IDs and sheet names.

Step 7: Test and Activate Your Workflow

Validate the end-to-end flow and then enable it for production use.

Click Test workflow and submit a JotForm entry with realistic maintenance details.
Confirm Emergency Priority Check routes emergency submissions to Dispatch Urgent Contractor Email and non-emergencies to Send Routine Work Order.
Verify that Notify Tenant Receipt sends a confirmation and that both Update Maintenance Log and Record Recurring Issues update correctly in parallel.
When results look correct, toggle the workflow to Active for live routing.

🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Common Gotchas

Gmail credentials can expire or need specific permissions. If things break, check the connected Gmail account in n8n Credentials and confirm it still has send access.
If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
Default prompts in AI nodes are generic. Add your brand voice early or you’ll be editing outputs forever.

Frequently Asked Questions

How long does it take to set up this Jotform Sheets automation automation?

About an hour if your accounts are ready.

Do I need coding skills to automate repair request tracking?

No. You will mostly connect accounts and paste in vendor email addresses. The included workflow notes make the “why” behind each piece much easier to follow.

Is n8n free to use for this Jotform Sheets automation workflow?

Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in OpenAI API costs, which are usually just a few dollars a month at typical request volume.

Where can I host n8n to run this automation?

Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.

Can I customize this Jotform Sheets automation workflow for different vendors per property?

Yes, and it’s one of the best upgrades. You can replace the fixed “send to contractor” email logic with a lookup, for example reading a vendor list from Google Sheets, then routing via the Switch and the Gmail send nodes. Common customizations include separate vendors per building, after-hours escalation rules, and attaching different “work order” templates based on the AI category.

Why is my Gmail connection failing in this workflow?

Usually it’s expired OAuth access or the wrong Gmail account connected. Reconnect Gmail in n8n Credentials, then confirm the Gmail nodes are using that refreshed credential. If you recently changed workspace security settings, Gmail can also block sends until permissions are re-approved. And if you test by firing lots of submissions quickly, rate limiting can show up as intermittent failures.

How many requests can this Jotform Sheets automation automation handle?

On n8n Cloud, it depends on your plan’s monthly executions, but most small teams can run hundreds of requests a month comfortably. If you self-host, there’s no fixed execution cap, so it’s mainly limited by your server and your email/API limits. In practice, a single request runs in seconds, so even busy properties don’t “outgrow” it quickly.

Is this Jotform Sheets automation automation better than using Zapier or Make?

Often, yes, because this is not a simple two-step zap. n8n handles branching logic (emergency vs routine), data shaping, and AI steps in one place without punishing you for complexity. It also gives you the self-hosting option, which can matter when you’re processing lots of requests every month and want predictable costs. Zapier and Make can still be fine if you only need “form submission → email,” and nothing more. If you’re torn, Talk to an automation expert and we’ll help you pick the sensible route.

Once this is running, you stop “managing inboxes” and start managing outcomes. The workflow handles the repetitive follow-ups, and you get clean records you can trust.

Need Help Setting This Up?

Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.

Lisa Granqvist

Workflow Automation Expert

Expert in workflow automation and no-code tools.

{
"id": "",
"name": "Automated Maintenance Request Routing",
"meta": {
"instanceId": "121b33afcfd91f7240b9a9b3083036ad388e8f23221f5b9e073c404d80a7d486",
"templateId": "",
"templateCredsSetupCompleted": ""
},
"versionId": "",
"nodes": [
{
"id": "flowpast-topbar-9649",
"name": "Flowpast Branding",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
115
],
"parameters": {
"color": 7,
"width": 1210,
"height": 80,
"content": "## Flowpast.com | Automation Workflow Library\n**\ud83d\udcd6 Full tutorial & setup guide:** flowpast.com"
},
"typeVersion": 1
},
{
"id": "5661c7cd-d26d-4170-9b40-f62a005ded25",
"name": "Form Intake Trigger",
"type": "n8n-nodes-base.jotFormTrigger",
"position": [
1110,
215
],
"webhookId": "maintenance-request",
"parameters": {
"form": "[YOUR_ID]"
},
"credentials": {
"jotFormApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1
},
{
"id": "1929aeb3-feab-43a0-b755-680568c9e239",
"name": "Normalize Request Payload",
"type": "n8n-nodes-base.code",
"position": [
885,
270
],
"parameters": {
"jsCode": "// Parse maintenance request form data\nconst formData = $input.first().json;\n\nreturn {\n  json: {\n    requestId: formData.submissionID || 'REQ-' + Date.now(),\n    tenantName: formData.tenantName || formData.q3_tenantName,\n    tenantEmail: formData.tenantEmail || formData.q4_tenantEmail,\n    tenantPhone: formData.tenantPhone || formData.q5_tenantPhone,\n    unitNumber: formData.unitNumber || formData.q6_unitNumber,\n    propertyAddress: formData.propertyAddress || formData.q7_propertyAddress,\n    issueDescription: formData.issueDescription || formData.q8_issueDescription,\n    urgencyLevel: formData.urgencyLevel || formData.q9_urgencyLevel || 'normal',\n    photoUrl: formData.photoUrl || formData.q10_photo,\n    accessInstructions: formData.accessInstructions || formData.q11_accessInstructions,\n    preferredContactMethod: formData.preferredContactMethod || formData.q12_preferredContactMethod || 'email',\n    submittedAt: new Date().toISOString(),\n    status: 'new'\n  }\n};"
},
"typeVersion": 2
},
{
"id": "abcf8b09-1c79-49d7-8207-7896070bc9a0",
"name": "AI Repair Assessment",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
660,
330
],
"parameters": {
"text": "=You are an expert property maintenance analyst. Analyze this maintenance request and provide comprehensive categorization and recommendations.\n\n**Request Details:**\n- Unit Number: {{ $json.unitNumber }}\n- Tenant: {{ $json.tenantName }}\n- Urgency Level (Tenant-Reported): {{ $json.urgencyLevel }}\n- Issue Description: {{ $json.issueDescription }}\n\n**Access Instructions:**\n{{ $json.accessInstructions }}\n\nProvide a detailed analysis in JSON format:\n{\n  \"issueCategory\": {\n    \"primary\": \"plumbing|electrical|hvac|appliance|structural|pest_control|lockout|general_repair|other\",\n    \"secondary\": [\"specific sub-categories\"],\n    \"confidence\": 0-100\n  },\n  \"priorityAssessment\": {\n    \"level\": \"emergency|urgent|high|normal|low\",\n    \"reasoning\": \"why this priority was assigned\",\n    \"keywords_detected\": [\"emergency keywords found\"],\n    \"safety_concern\": true|false,\n    \"habitability_issue\": true|false\n  },\n  \"estimatedComplexity\": {\n    \"level\": \"simple|moderate|complex|major\",\n    \"estimated_hours\": number,\n    \"requires_specialist\": true|false\n  },\n  \"recommendedVendor\": {\n    \"type\": \"plumber|electrician|hvac_tech|handyman|locksmith|pest_control|general_contractor\",\n    \"urgency\": \"emergency_dispatch|same_day|within_24h|within_48h|scheduled\",\n    \"specialization_needed\": \"specific expertise if required\"\n  },\n  \"cost_estimate\": {\n    \"range\": \"$min - $max\",\n    \"factors\": [\"cost factors to consider\"]\n  },\n  \"tenant_communication\": {\n    \"initial_response\": \"message to send tenant immediately\",\n    \"estimated_resolution\": \"timeframe estimate\",\n    \"temporary_solutions\": [\"interim fixes tenant can do\"]\n  },\n  \"safety_protocols\": [\n    \"safety step 1\",\n    \"safety step 2\"\n  ],\n  \"recurring_issue_check\": {\n    \"likely_recurring\": true|false,\n    \"warranty_applicable\": true|false,\n    \"preventive_recommendation\": \"suggestion to prevent future issues\"\n  },\n  \"contractor_instructions\": [\n    \"specific instruction 1\",\n    \"specific instruction 2\",\n    \"what to bring/check\"\n  ],\n  \"legal_compliance\": {\n    \"urgent_legal_requirement\": true|false,\n    \"habitability_law_concern\": true|false,\n    \"documentation_needed\": \"what needs to be documented\"\n  }\n}",
"options": {
"systemMessage": "You are an expert property maintenance coordinator with 20+ years of experience in residential and commercial property management. You understand emergency protocols, vendor capabilities, legal requirements, and cost optimization."
},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 1.6
},
{
"id": "7c773bbd-4bd0-427b-8a1c-e97c7822b1b3",
"name": "OpenAI Chat Engine",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
690,
540
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini"
},
"options": []
},
"credentials": {
"openAiApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1.2
},
{
"id": "2f21e918-270c-481d-870c-bff0576ec812",
"name": "Capture AI Output",
"type": "n8n-nodes-base.set",
"position": [
440,
280
],
"parameters": {
"options": [],
"assignments": {
"assignments": [
{
"id": "aiAnalysis",
"name": "aiAnalysis",
"type": "string",
"value": "={{ $json.output }}"
}
]
}
},
"typeVersion": 3.3
},
{
"id": "fc2f820d-a761-4960-8617-5ef22110be24",
"name": "Combine Request Insights",
"type": "n8n-nodes-base.code",
"position": [
220,
245
],
"parameters": {
"jsCode": "// Merge AI analysis with request data\nconst requestData = $input.first().json;\nconst aiAnalysisRaw = requestData.aiAnalysis;\n\n// Parse AI analysis\nlet aiAnalysis;\ntry {\n  aiAnalysis = JSON.parse(aiAnalysisRaw);\n} catch (e) {\n  // Fallback if parsing fails\n  aiAnalysis = {\n    issueCategory: {\n      primary: 'general_repair',\n      secondary: ['maintenance'],\n      confidence: 60\n    },\n    priorityAssessment: {\n      level: 'normal',\n      reasoning: 'Standard maintenance request',\n      keywords_detected: [],\n      safety_concern: false,\n      habitability_issue: false\n    },\n    estimatedComplexity: {\n      level: 'moderate',\n      estimated_hours: 2,\n      requires_specialist: false\n    },\n    recommendedVendor: {\n      type: 'handyman',\n      urgency: 'within_24h',\n      specialization_needed: 'General repair'\n    },\n    cost_estimate: {\n      range: '$100 - $300',\n      factors: ['Labor', 'Materials']\n    },\n    tenant_communication: {\n      initial_response: 'We have received your request and are assigning a technician.',\n      estimated_resolution: '24-48 hours',\n      temporary_solutions: []\n    },\n    safety_protocols: ['Standard safety procedures'],\n    recurring_issue_check: {\n      likely_recurring: false,\n      warranty_applicable: false,\n      preventive_recommendation: 'Regular maintenance'\n    },\n    contractor_instructions: ['Assess issue', 'Provide quote if major repair needed'],\n    legal_compliance: {\n      urgent_legal_requirement: false,\n      habitability_law_concern: false,\n      documentation_needed: 'Before/after photos'\n    }\n  };\n}\n\n// Determine work order priority\nconst priorityMap = {\n  'emergency': 1,\n  'urgent': 2,\n  'high': 3,\n  'normal': 4,\n  'low': 5\n};\n\n// Select contractor based on vendor type\nconst contractorDatabase = {\n  'plumber': { name: 'QuickFix Plumbing', phone: '+1-555-PLUMB', email: '[YOUR_EMAIL]' },\n  'electrician': { name: 'Bright Spark Electric', phone: '+1-555-SPARK', email: '[YOUR_EMAIL]' },\n  'hvac_tech': { name: 'Cool Breeze HVAC', phone: '+1-555-HVAC1', email: '[YOUR_EMAIL]' },\n  'handyman': { name: 'All-Fix Handyman', phone: '+1-555-FIX-IT', email: '[YOUR_EMAIL]' },\n  'locksmith': { name: '24/7 Locksmith', phone: '+1-555-LOCKS', email: '[YOUR_EMAIL]' },\n  'pest_control': { name: 'No-Bug Pest Control', phone: '+1-555-BUGS0', email: '[YOUR_EMAIL]' },\n  'general_contractor': { name: 'BuildRight Contractors', phone: '+1-555-BUILD', email: '[YOUR_EMAIL]' }\n};\n\nconst vendorType = aiAnalysis.recommendedVendor.type;\nconst contractor = contractorDatabase[vendorType] || contractorDatabase['handyman'];\n\nreturn {\n  json: {\n    ...requestData,\n    issueCategory: aiAnalysis.issueCategory.primary,\n    subCategories: aiAnalysis.issueCategory.secondary,\n    aiConfidence: aiAnalysis.issueCategory.confidence,\n    finalPriority: aiAnalysis.priorityAssessment.level,\n    priorityNumber: priorityMap[aiAnalysis.priorityAssessment.level] || 4,\n    priorityReasoning: aiAnalysis.priorityAssessment.reasoning,\n    keywordsDetected: aiAnalysis.priorityAssessment.keywords_detected,\n    safetyConcern: aiAnalysis.priorityAssessment.safety_concern,\n    habitabilityIssue: aiAnalysis.priorityAssessment.habitability_issue,\n    complexity: aiAnalysis.estimatedComplexity.level,\n    estimatedHours: aiAnalysis.estimatedComplexity.estimated_hours,\n    requiresSpecialist: aiAnalysis.estimatedComplexity.requires_specialist,\n    vendorType: vendorType,\n    vendorUrgency: aiAnalysis.recommendedVendor.urgency,\n    specialization: aiAnalysis.recommendedVendor.specialization_needed,\n    costEstimate: aiAnalysis.cost_estimate.range,\n    costFactors: aiAnalysis.cost_estimate.factors,\n    tenantMessage: aiAnalysis.tenant_communication.initial_response,\n    estimatedResolution: aiAnalysis.tenant_communication.estimated_resolution,\n    temporarySolutions: aiAnalysis.tenant_communication.temporary_solutions,\n    safetyProtocols: aiAnalysis.safety_protocols,\n    likelyRecurring: aiAnalysis.recurring_issue_check.likely_recurring,\n    warrantyApplicable: aiAnalysis.recurring_issue_check.warranty_applicable,\n    preventiveRecommendation: aiAnalysis.recurring_issue_check.preventive_recommendation,\n    contractorInstructions: aiAnalysis.contractor_instructions,\n    legalUrgent: aiAnalysis.legal_compliance.urgent_legal_requirement,\n    habitabilityLaw: aiAnalysis.legal_compliance.habitability_law_concern,\n    documentationNeeded: aiAnalysis.legal_compliance.documentation_needed,\n    assignedContractor: contractor.name,\n    contractorPhone: contractor.phone,\n    contractorEmail: contractor.email,\n    workOrderNumber: 'WO-' + Date.now(),\n    aiSummary: `${aiAnalysis.issueCategory.primary} issue - ${aiAnalysis.priorityAssessment.level} priority. ${aiAnalysis.priorityAssessment.reasoning}`\n  }\n};"
},
"typeVersion": 2
},
{
"id": "4e267be8-b8a5-46de-9598-303dbe3e0481",
"name": "Emergency Priority Check",
"type": "n8n-nodes-base.if",
"position": [
10,
230
],
"parameters": {
"options": [],
"conditions": {
"options": {
"version": 1,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "or",
"conditions": [
{
"id": "condition1",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.finalPriority }}",
"rightValue": "emergency"
}
]
}
},
"typeVersion": 2
},
{
"id": "43d6ddfb-7629-4fa2-86bd-1bc09f3a953c",
"name": "Dispatch Urgent Contractor Email",
"type": "n8n-nodes-base.gmail",
"position": [
0,
430
],
"webhookId": "66472a1b-b0a4-4b1b-a99e-a0b08478d100",
"parameters": {
"sendTo": "={{ $json.contractorEmail }}",
"message": "=\ud83d\udea8 EMERGENCY MAINTENANCE REQUEST\n\nWork Order: {{ $json.workOrderNumber }}\nPriority: EMERGENCY\nCategory: {{ $json.issueCategory }}\n\n\ud83d\udccd PROPERTY DETAILS:\nAddress: {{ $json.propertyAddress }}\nUnit: {{ $json.unitNumber }}\n\n\ud83d\udc64 TENANT CONTACT:\nName: {{ $json.tenantName }}\nPhone: {{ $json.tenantPhone }}\nEmail: {{ $json.tenantEmail }}\nPreferred Contact: {{ $json.preferredContactMethod }}\n\n\ud83d\udd27 ISSUE DESCRIPTION:\n{{ $json.issueDescription }}\n\n\ud83e\udd16 AI ANALYSIS:\nCategory: {{ $json.issueCategory }}\nComplexity: {{ $json.complexity }}\nEstimated Hours: {{ $json.estimatedHours }}\nCost Estimate: {{ $json.costEstimate }}\n\n\u26a0\ufe0f PRIORITY ASSESSMENT:\n{{ $json.priorityReasoning }}\nSafety Concern: {{ $json.safetyConcern ? 'YES \u26a0\ufe0f' : 'No' }}\nHabitability Issue: {{ $json.habitabilityIssue ? 'YES - URGENT' : 'No' }}\n\n\ud83d\udd11 ACCESS INSTRUCTIONS:\n{{ $json.accessInstructions }}\n\n\ud83d\udccb CONTRACTOR INSTRUCTIONS:\n{{ $json.contractorInstructions.map((inst, i) => (i + 1) + '. ' + inst).join('\\n') }}\n\n\ud83d\udee1\ufe0f SAFETY PROTOCOLS:\n{{ $json.safetyProtocols.map((protocol, i) => (i + 1) + '. ' + protocol).join('\\n') }}\n\n\ud83d\udcf8 PHOTO: {{ $json.photoUrl || 'No photo provided' }}\n\n\u23f1\ufe0f RESPONSE REQUIRED: IMMEDIATE\nEstimated Resolution: {{ $json.estimatedResolution }}\n\n\ud83d\udcdd DOCUMENTATION REQUIRED:\n{{ $json.documentationNeeded }}\n\n{{ $json.legalUrgent ? '\u2696\ufe0f LEGAL COMPLIANCE URGENT - This repair may be legally required under habitability laws.' : '' }}\n\nPlease respond immediately with ETA.\n\nProperty Management Team\n---\nThis is an AI-enhanced emergency dispatch",
"options": [],
"subject": "=\ud83d\udea8 EMERGENCY WORK ORDER - {{ $json.workOrderNumber }}"
},
"credentials": {
"gmailOAuth2": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 2.1
},
{
"id": "ea9fd8e1-825f-4438-9fc5-46900019e0bc",
"name": "Send Routine Work Order",
"type": "n8n-nodes-base.gmail",
"position": [
260,
430
],
"webhookId": "611a2b01-ed15-4d44-9893-3d65fdec9020",
"parameters": {
"sendTo": "={{ $json.contractorEmail }}",
"message": "=\ud83d\udccb MAINTENANCE WORK ORDER\n\nWork Order: {{ $json.workOrderNumber }}\nPriority: {{ $json.finalPriority.toUpperCase() }}\nCategory: {{ $json.issueCategory }}\nRequested: {{ $json.submittedAt }}\n\n\ud83d\udccd PROPERTY DETAILS:\nAddress: {{ $json.propertyAddress }}\nUnit: {{ $json.unitNumber }}\n\n\ud83d\udc64 TENANT CONTACT:\nName: {{ $json.tenantName }}\nPhone: {{ $json.tenantPhone }}\nEmail: {{ $json.tenantEmail }}\nPreferred Contact: {{ $json.preferredContactMethod }}\n\n\ud83d\udd27 ISSUE DESCRIPTION:\n{{ $json.issueDescription }}\n\n\ud83e\udd16 AI ANALYSIS:\nCategory: {{ $json.issueCategory }} ({{ $json.subCategories.join(', ') }})\nConfidence: {{ $json.aiConfidence }}%\nComplexity: {{ $json.complexity }}\nEstimated Hours: {{ $json.estimatedHours }}\nCost Estimate: {{ $json.costEstimate }}\nSpecialization: {{ $json.specialization }}\n\n\ud83d\udca1 AI INSIGHTS:\n{{ $json.aiSummary }}\n\n\ud83d\udd11 ACCESS INSTRUCTIONS:\n{{ $json.accessInstructions }}\n\n\ud83d\udccb CONTRACTOR INSTRUCTIONS:\n{{ $json.contractorInstructions.map((inst, i) => (i + 1) + '. ' + inst).join('\\n') }}\n\n\ud83d\udee1\ufe0f SAFETY PROTOCOLS:\n{{ $json.safetyProtocols.map((protocol, i) => (i + 1) + '. ' + protocol).join('\\n') }}\n\n\ud83d\udcf8 PHOTO: {{ $json.photoUrl || 'No photo provided' }}\n\n\u23f1\ufe0f TARGET RESPONSE TIME: {{ $json.vendorUrgency }}\nEstimated Resolution: {{ $json.estimatedResolution }}\n\n\ud83d\udcdd DOCUMENTATION REQUIRED:\n{{ $json.documentationNeeded }}\n- Before photos\n- After photos\n- Parts/materials used\n- Time spent\n- Any additional issues found\n\n{{ $json.warrantyApplicable ? '\ud83d\udd27 WARRANTY CHECK: This may be under warranty - please verify before proceeding.' : '' }}\n\n{{ $json.likelyRecurring ? '\ud83d\udd04 RECURRING ISSUE ALERT: Similar issues may have been reported. Check history.' : '' }}\n\n\ud83d\udca1 PREVENTIVE RECOMMENDATION:\n{{ $json.preventiveRecommendation }}\n\nPlease confirm receipt and provide ETA.\n\nBest regards,\nProperty Management Team\n\n---\nThis work order was generated using AI analysis for optimal routing and prioritization.",
"options": [],
"subject": "=Work Order: {{ $json.workOrderNumber }} - {{ $json.issueCategory }}"
},
"credentials": {
"gmailOAuth2": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 2.1
},
{
"id": "06d7272f-ee56-4acd-9731-344995d4e56e",
"name": "Notify Tenant Receipt",
"type": "n8n-nodes-base.gmail",
"position": [
510,
560
],
"webhookId": "9f39bc81-91ed-43c7-b35b-0b50853f4a63",
"parameters": {
"sendTo": "={{ $('Form Intake Trigger').item.json['tenant Email'] }}",
"message": "=Hi, {{ $('Form Intake Trigger').item.json['tenant Name'].first }}\n\nThank you for submitting your maintenance request. We've received your report and are taking immediate action.\n\n\ud83d\udccb **Your Request Details:**\nRequest ID: {{ $json.requestId }}\nUnit: {{ $json.unitNumber }}\nIssue: {{ $json.issueCategory }}\nPriority: {{ $json.finalPriority.toUpperCase() }}\n\n\ud83e\udd16 **AI Analysis Results:**\n{{ $json.tenantMessage }}\n\n\ud83d\udd27 **What's Happening Next:**\n\u2022 A {{ $json.vendorType.replace('_', ' ') }} has been assigned\n\u2022 Contractor: {{ $json.assignedContractor }}\n\u2022 Expected Response: {{ $json.vendorUrgency.replace('_', ' ') }}\n\u2022 Estimated Resolution: {{ $json.estimatedResolution }}\n\u2022 Cost Estimate: {{ $json.costEstimate }}\n\n{{ $json.temporarySolutions.length > 0 ? '\ud83d\udca1 **Temporary Solutions (while you wait):**\\n' + $json.temporarySolutions.map((sol, i) => (i + 1) + '. ' + sol).join('\\n') + '\\n\\n' : '' }}\n\n{{ $json.safetyConcern ? '\u26a0\ufe0f **SAFETY NOTICE:**\\nThis issue involves a potential safety concern. ' + ($json.finalPriority === 'emergency' ? 'A contractor has been dispatched immediately.' : 'Please follow any safety precautions mentioned.') + '\\n\\n' : '' }}\n\n{{ $json.habitabilityIssue ? '\ud83c\udfe0 **IMPORTANT:**\\nThis issue affects the habitability of your unit. We are prioritizing this repair to ensure your home remains safe and comfortable.\\n\\n' : '' }}\n\n\ud83d\udcf1 **Need Immediate Help?**\n{{ $json.finalPriority === 'emergency' ? 'For this emergency, contact us directly at: (555) 123-4567\\n\\n' : 'If the situation worsens, call our emergency line: (555) 123-4567\\n\\n' }}\n\n\ud83d\udcf8 **Documentation:**\nWe've received your photo and it's been shared with the contractor. They will document the repair process with before/after photos.\n\n\ud83d\udd14 **Updates:**\nYou'll receive updates when:\n\u2022 The contractor confirms their ETA\n\u2022 Work begins\n\u2022 Work is completed\n\u2022 Follow-up is needed\n\n{{ $json.likelyRecurring ? '\ud83d\udcca **Note:** Our system detected this may be related to previous issues. We\\'re investigating to prevent future occurrences.\\n\\n' : '' }}\n\nThank you for your patience. We're committed to resolving this quickly and professionally.\n\nBest regards,\nYour Property Management Team\n\n---\nRequest tracked by AI-powered maintenance system\nWork Order: {{ $json.workOrderNumber }}",
"options": [],
"subject": "=\u2705 Maintenance Request Received - {{ $('Normalize Request Payload').item.json.requestId }}"
},
"credentials": {
"gmailOAuth2": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 2.1
},
{
"id": "32332f95-bac9-40ae-88f5-4a29053b7469",
"name": "Update Maintenance Log",
"type": "n8n-nodes-base.googleSheets",
"position": [
760,
400
],
"parameters": {
"columns": {
"value": {
"photo Url": "={{ $('Form Intake Trigger').item.json['photo Url'] }}",
"client Name": "={{ $('Form Intake Trigger').item.json['tenant Name'].first }}",
"unit Number": "={{ $('Form Intake Trigger').item.json['unit Number'] }}",
"tenant Email": "={{ $('Form Intake Trigger').item.json['tenant Email'] }}",
"tenant Phone": "={{ $('Form Intake Trigger').item.json['tenant Phone'].full }}",
"urgency Level": "={{ $('Form Intake Trigger').item.json['urgency Level'] }}",
"property Address": "={{ $('Form Intake Trigger').item.json['property Address'] }}",
"issue Description": "={{ $('Form Intake Trigger').item.json['issue Description'] }}",
"access Instructions": "={{ $('Form Intake Trigger').item.json['access Instructions'] }}",
"preferred Contact Method": "={{ $('Form Intake Trigger').item.json['preferred Contact Method'] }}"
},
"schema": [
{
"id": "client Name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "client Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "tenant Phone",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "tenant Phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "tenant Email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "tenant Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "unit Number",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "unit Number",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "property Address",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "property Address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "issue Description",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "issue Description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "urgency Level",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "urgency Level",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "photo Url",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "photo Url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "access Instructions",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "access Instructions",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "preferred Contact Method",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "preferred Contact Method",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "id",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "id",
"defaultMatch": true,
"canBeUsedToMatch": true
},
{
"id": "threadId",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "threadId",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "labelIds",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "labelIds",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"tenant Email"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "property "
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.4
},
{
"id": "e6d7a830-a24f-41b1-a48f-9d6c828e7c5e",
"name": "Record Recurring Issues",
"type": "n8n-nodes-base.googleSheets",
"position": [
790,
690
],
"parameters": {
"columns": {
"value": [],
"schema": [],
"mappingMode": "autoMapInputData",
"matchingColumns": [
"unitNumber",
"issueCategory"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "Recurring issue"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "property "
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.4
}
],
"pinData": [],
"connections": {
"Emergency Priority Check": {
"main": [
[
{
"node": "Dispatch Urgent Contractor Email",
"type": "main",
"index": 0
}
],
[
{
"node": "Send Routine Work Order",
"type": "main",
"index": 0
}
]
]
},
"Form Intake Trigger": {
"main": [
[
{
"node": "Normalize Request Payload",
"type": "main",
"index": 0
}
]
]
},
"Combine Request Insights": {
"main": [
[
{
"node": "Emergency Priority Check",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Engine": {
"ai_languageModel": [
[
{
"node": "AI Repair Assessment",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Normalize Request Payload": {
"main": [
[
{
"node": "AI Repair Assessment",
"type": "main",
"index": 0
}
]
]
},
"Capture AI Output": {
"main": [
[
{
"node": "Combine Request Insights",
"type": "main",
"index": 0
}
]
]
},
"AI Repair Assessment": {
"main": [
[
{
"node": "Capture AI Output",
"type": "main",
"index": 0
}
]
]
},
"Notify Tenant Receipt": {
"main": [
[
{
"node": "Update Maintenance Log",
"type": "main",
"index": 0
},
{
"node": "Record Recurring Issues",
"type": "main",
"index": 0
}
]
]
},
"Send Routine Work Order": {
"main": [
[
{
"node": "Notify Tenant Receipt",
"type": "main",
"index": 0
}
]
]
},
"Dispatch Urgent Contractor Email": {
"main": [
[
{
"node": "Notify Tenant Receipt",
"type": "main",
"index": 0
}
]
]
}
}
}