StacksGPT
Research & Analysis

Summarize Form Feedback into an Email Report

Summarize all responses to a feedback form with OpenAI and email the report as formatted HTML.

The Problem

Survey responses are collected but rarely read in full, and writing a summary for the team takes hours.

How This Template Solves It

After an event survey closes, the organizer runs the workflow. It groups all answers by question, asks OpenAI for an overall analysis, converts the result to HTML and emails the report.

How It Works

  1. 1Reads responses from a Google Sheet linked to Google Forms.
  2. 2Combines all answers for each question.
  3. 3OpenAI writes a summary report in Markdown.
  4. 4Converts it to HTML and sends it with Gmail.

What You Need

  • A Google Sheet of form responses
  • An OpenAI API key
  • A Gmail account

What Stays Under Your Control

  • People decide what to change based on the report.

Watch Out For

  • Very long forms or many responses may need splitting into smaller batches, as the author notes.

Adapted from a community workflow template. Before publishing we removed credentials, account and file IDs, email addresses and sample data. The original author's setup notes are kept inside the workflow file.

More Research & Analysis Templates

Research & Analysis

Weekly Google Analytics Report by Email and Telegram

Each week, compare the last seven days of Google Analytics data with the same days last year and send an AI-written report by email and Telegram.

Starts on: Schedule

Email (SMTP)Google AnalyticsOpenAI+1 more