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.
Automated Feedback Summarization and Reporting Using GPT
| Node Count | 6 – 10 Nodes |
|---|---|
| Nodes Used | aggregate, gmail, googleSheets, manualTrigger, markdown, openAi, stickyNote |
