Automated feedback analysis

Form responses pile up and nobody reads them until someone needs a summary for a meeting.

A workflow triggered by form submissions that runs each response through sentiment analysis, logs the categorized result to a spreadsheet, and sends one aggregated summary email across all submissions rather than an alert per response.

Demonstrates batched analysis and reporting over a stream of form responses. Built and tested against sample submissions.

• Workflow design
• Prompt engineering
• Evaluation & testing

1. 01A form submission triggers the scenario.
2. 02The response is classified for sentiment and category, then appended to a spreadsheet as a structured row.
3. 03A scheduled step aggregates across submissions and sends a single summary email rather than a per-response notification.

Make.com scenario with a form trigger, a Gemini classification step, a Sheets append, and a scheduled aggregation and Gmail send.

Categories are constrained by prompt so the spreadsheet stays groupable instead of accumulating free text.

• Tested on sample submissions, not a live feedback channel at volume.
• Sentiment labels are model output with no human review step.
• The aggregation is a summary email, not a dashboard, and there is no trend tracking over time.