Triage apartment turnovers with Google Sheets, Gemini, Gmail and Slack

by iamvaar ✓ · 3 views · created 2026-09-26 · Document Extraction, AI Summarization

What this workflow does

This AI workflow has 13 nodes and runs when someone submits an n8n form (“Apartment Turnover & Maintenance”). Along the way it connects Google Gemini Chat Model, Gmail, Google Sheets and Slack.

How it runs

Trigger: When someone submits an n8n form (“Apartment Turnover & Maintenance”).

1. Set Submission Details (Edit Fields (Set)): sets 3 fields: unitId, report, submittedAt
2. Read Unit Profiles from Sheets (Google Sheets): uses Google Sheets
3. Read Turnover History from Sheets (Google Sheets): uses Google Sheets
4. AI Turnover Analysis Agent (AI Agent): runs an AI agent, with model: Google Gemini Chat Agent; output parser: Parse Structured Output
5. Prepare Job and SLA Details (Edit Fields (Set)): sets 14 fields: jobId, unitId, report…
6. Append Job to Sheets (Google Sheets): append
7. Read Technician Details (Google Sheets): uses Google Sheets
8. Send Email via Gmail (Gmail): uses Gmail
9. Post Maintenance Notification (Slack): uses Slack
10. Append Job Assignment to Sheets (Google Sheets): append

Services it uses

Google Gemini Chat ModelGmailGoogle SheetsSlack

Before you upgrade to n8n 3.0

Nodes used (8)

• Google Gemini Chat Model@n8n/n8n-nodes-langchain.lmChatGoogleGemini
• Gmailn8n-nodes-base.gmail
• n8n Form Triggern8n-nodes-base.formTrigger
• Edit Fields (Set)n8n-nodes-base.set
• Google Sheetsn8n-nodes-base.googleSheets
• AI Agent@n8n/n8n-nodes-langchain.agent
• Structured Output Parser@n8n/n8n-nodes-langchain.outputParserStructured
• Slackn8n-nodes-base.slack

From the author

Quick overview Youtube Link: https://youtu.be/l5ElbsX1-zs This workflow collects apartment turnover condition reports via an n8n form, looks up unit context in Google Sheets, uses Google Gemini to generate a prioritized maintenance job with an SLA, writes the…

View the original on n8n.io → Check your own copy