Skip to content
NEWMarketplace and your team: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / Customer Support & Helpdesk

Customer Support & Helpdesk

Log maintenance form requests to Google Sheets and email manager via Gmail

Runs on each maintenance form submission, uploads the damage photo, logs the request to Google Sheets, and emails the maintenance manager an HTML alert via Gmail.

What it does

## 🛠️ Automated Maintenance Ticketing System ### Workflow Overview 1. A resident submits a maintenance request through an online form. 2. The form collects the reporter's name, apartment or room number, issue description, and damage photo. 3. UploadToURL uploads the photo and generates a public URL. 4. Google Sheets records the request details, photo preview, submission timestamp, and initial ticket status. 5. Gmail sends an HTML email alert to the maintenance manager with the request details and damage photo. 6. The manager can use the ticket tracker link to review the logged request.

The steps

  1. Form: Submit Maintenance Request
  2. Create Public Photo Link
  3. Log Ticket in Database
  4. Email Alert to Manager

Similar automations