Automated Feedback Analysis
Sentiment-tagged customer reviews flow into a spreadsheet automatically — and negative ones fire an instant alert.
PROBLEM
Survey responses pile up faster than anyone can read them. By the time a team notices a wave of negative reviews, the damage is already done.
SOLUTION
A Make scenario watches a Google Form for new submissions, sends each review to Gemini 2.5 for sentiment classification (positive / negative / neutral) and a one-paragraph summary, then logs the result to a Google Sheet. Negative reviews trigger an automatic Gmail alert to the right team.
BENEFITS
- Real-time visibility into customer sentiment
- Negative feedback gets acted on within minutes, not weeks
- Summaries make it easy to skim hundreds of responses at a glance
CHALLENGES & WHAT I'D IMPROVE
Early versions overwrote spreadsheet cells and dropped inputs. Simplifying the workflow and tightening the data mapping resolved both. Next iteration: capture optional contact info in the form so alerts include who to follow up with.