Maintenance‑report workflow that watches Google Sheets form responses, normalizes fields and timestamps, routes each submission by severity, logs high‑severity safety hazards to a critical repairs sheet and broadcasts a Slack alert, logs routine maintenance to a general sheet and confirms receipt to the reporter by email, with a dedicated error alert for critical sheet write failures.
Make · workflow canvasproduction build
Context
Facilities operations needed a way to automatically triage maintenance reports, escalate safety‑critical issues in real time, and keep routine items in a separate log while still confirming to the reporter that the issue was received.
Approach
Built a Make.com scenario that watches form responses in Google Sheets, normalizes report IDs and timestamps, routes the submission into high‑severity or routine paths, logs critical safety hazards to a dedicated critical repairs sheet and broadcasts a Slack safety alert, logs routine maintenance to a general sheet and sends a confirmation email to the reporter, with an error alert email that fires if the critical sheet write fails.
Architecture
Watch Form Responses (Google Sheets)
Normalize: Fields + Report ID + Timestamps
Route: High Severity vs. Routine
High Severity - Safety Hazard: Sheet: Log to Critical Repairs
