Log maintenance tickets from forms into Google Sheets and notify via Gmail

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. An n8n automation workflow template by Jitesh Dugar.

Community Metrics

Categories

• Automation

Tags

• n8n
• workflow
• google-sheets
• gmail

Capabilities

• 2 nodes

Information