Get a clear event feedback report without manual work. The flow pulls answers from a Google Sheet, turns them into a short summary, and emails it as a clean HTML report. It is ideal for marketing and event teams that need quick readouts after a form closes.

Here is how it runs end to end. A manual start reads rows from a selected Google Sheet. An Aggregate step bundles each question’s answers into arrays so the model sees the full picture. OpenAI reviews the arrays using a steady tone with low temperature and returns a Markdown summary. A Markdown step converts the text to HTML, and Gmail sends a formatted message to your team.

You need access to the right Google Sheet, an OpenAI API key, and a Gmail account. Expect to cut report prep from hours to minutes while keeping a consistent format every time. It fits post event surveys, webinars, workshops, and user group meetups where fast insight is more useful than raw data.

• Manual start to control when the report is generated
• Reads rows from a chosen Google Sheets document and sheet
• Aggregates each question’s answers into arrays for full context
• Uses OpenAI Chat with a system message and user message to create a concise summary with a steady tone
• Converts model Markdown output into HTML for clean email formatting
• Sends the HTML report through Gmail with a set subject and recipient
• Low temperature setting to keep summaries consistent and focused

• Reduce manual review time from 2 hours to 5 minutes per event
• Streamline feedback reporting by about 80 percent
• Decrease copy and paste errors by up to 90 percent
• Handle hundreds of responses without extra work
• Connect Google Sheets, OpenAI and Gmail in one flow

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Google Sheets, OpenAI and Gmail. See the Tools Required section above for links to create accounts with these services.
3. Open the Get Google Sheets records node. In the credential field, click Create new credential and follow the on screen steps to connect your Google account. Grant access to spreadsheets as requested.
4. Set the Google Sheets document and sheet. Paste the document ID and pick the correct sheet name. Confirm the column headers match the survey questions you plan to aggregate.
5. Open the Aggregate responses into arrays node. Add each question field you want to group, such as What went great, How can we improve, and What is the chance of recommending our event.
6. Open the Summarize via GPT model node. In the credential field, click Create new credential, select API Key, and paste your OpenAI API key from your OpenAI account page.
7. In the same OpenAI node, keep temperature near 0.3 for steady output. Use the provided system message to guide the summary and map the user message to the arrays from the Aggregate node.
8. Open the Markdown node. Keep mode as Markdown to HTML and map the input to the message content coming from the OpenAI node.
9. Open the Send via Gmail node. Click Create new credential, connect your Google account, and allow email permissions. Set the To address and subject line for the report email.
10. Click Test workflow to run it. Check the Aggregate node output for arrays, verify the OpenAI node returns Markdown, and confirm the Gmail step sends an HTML email to your inbox.
11. If you see empty fields, confirm your sheet headers match the fields selected in the Aggregate node. If OpenAI errors appear, check your API key, rate limits, and model selection.
12. Optional scheduling: add a Cron node and connect it in place of the manual start if you want automatic daily or weekly summaries.