video1.0<iframe src="https://www.loom.com/embed/6ba0672fa12141c9bec4b33d3884296d" frameborder="0" width="1920" height="1440" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>14401920Loomhttps://www.loom.com14401920https://cdn.loom.com/sessions/thumbnails/6ba0672fa12141c9bec4b33d3884296d-d49f236867295b03.gif95.742In this Loom, I show my automated feedback analysis workflow to analyze guest feedback in real time using AI, detect sentiment, generate summaries, and alert staff to negative responses. I use Google Forms for data collection, Google Gemini for structured JSON output, Make for automation, a JSON module, Google Sheets, and Gmail. Gemini returns sentiment categories and a short summary, and Sheets updates the correct row by timestamp. If sentiment is negative, Gmail sends an immediate alert. I also address Gemini availability with paid plans, alternative models, and fallbacks.