Automated Feedback Summarization and Reporting Using GPT

This workflow automates the process of collecting, summarizing, and emailing feedback responses from a Google Form integrated with Google Sheets. It begins by manually triggering the workflow or setting a schedule, then fetches responses from a designated Google Sheet. The responses are aggregated into arrays to prepare for analysis. Using OpenAI’s GPT-4 model, it generates a summary report of the feedback, highlighting overall sentiments and suggested improvements. The markdown-formatted summary is converted into HTML and sent via Gmail to a specified email address. This setup is ideal for event organizers, teachers, or business owners who want to streamline feedback analysis and reporting, saving time and ensuring timely insights.