📋 Log maintenance tickets from forms into Google Sheets and notify via Gmail
⚡ 16 views · 📋 Project Management
Description
Quick overview
This workflow captures maintenance requests via an n8n form, uploads the attached damage photo with UploadToURL, logs each ticket in Google Sheets, and notifies a manager via Gmail with an embedded image and link to the ticket tracker.
How it works
- Receives a maintenance request submission through an n8n form, including reporter details, location, issue description, and an uploaded photo.
- Uploads the submitted photo to UploadToURL to generate a public, shareable image link.
- Appends a new row to a Google Sheets tracker with the request details, a photo preview formula, and an initial “Pending” ticket status.
- Sends a Gmail email alert to the manager containing the ticket details and embedded damage photo, plus a link to the Google Sheets tracker.
Setup
- Configure an UploadToURL account credential so the workflow can upload images and return a public URL.
- Connect Google Sheets OAuth credentials and set the target spreadsheet and sheet for the ticket tracker.
- Connect Gmail OAuth2 credentials and update the recipient email address and the “View Ticket Tracker” link in the email body to your actual Google Sheets URL.
🔗 Nodes Used
Google Sheets, Gmail, n8n Form Trigger
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File