Two-way property repair management system with Google Sheets & Drive

This workflow automates the repair request process between tenants and building managers, keeping all updates organized in a single spreadsheet. It is composed of two coordinated workflows, as two separate triggers are required — one for new repair submissions and another for repair updates. A Unique Unit ID that corresponds to individual units is attributed to each request, and timestamps are used to coordinate repair updates with specific requests.

General use cases include: - Property managers who manage multiple buildings or units. - Building owners looking to centralize tenant repair communication. - Automation builders who want to learn multi-trigger workflow design in n8n.

---

⚙️ How It Works

Workflow 1 – New Repair Requests

Behind the Scenes: A tenant fills out a Google Form (“Repair Request Form”), which automatically adds a new row to a linked Google Sheet.

Steps:

1. Trigger: Google Sheets rowAdded – runs when a new form entry appears. 2. Extract & Format: Collects all relevant form data (address, unit, urgency, contacts). 3. Generate Unit ID: Creates a standardized identifier (e.g., BUILDING-UNIT) for tracking. 4. Email Notification: Sends the building manager a formatted email summarizing the repair details and including a link to a Repair Update Form (which activates Workflow 2).