Automation that captures salon feedback from Google Forms in real time, formats the timestamp, routes submissions by star rating, appends promoters (4–5 stars) to a Testimonial sheet and sends Slack notifications, appends detractors (1–3 stars) to an Urgent Follow-Up sheet and sends Gmail alert emails, stops further processing with Break nodes after each path, and sends an admin Gmail alert on form errors.
Make · workflow canvasproduction build
Context
A salon needed to capture Google Forms feedback in real time, celebrate positive reviews with the team via Slack, and respond quickly to low-rating submissions with urgent follow-up tracking and email alerts.
Approach
Built a Make scenario that watches Google Sheets for new form responses, formats the response timestamp, routes by star rating into promoter (4–5) and detractor (1–3) paths, appends promoters to a Testimonial sheet and sends Slack notifications, appends detractors to an Urgent Follow-Up sheet and sends Gmail alert emails, uses Break nodes to stop further processing after each path completes, and includes an error path that sends an admin Gmail alert when the form trigger encounters an error.
Architecture
Trigger
Google Forms (Watch Responses)
Format Date/Time
Route By Star Rating
Promoter (4 or 5): Google Sheets: Append Row (Testimonial)
