Turn survey responses in a Google Sheet into a clear email report you can read in minutes. Ideal for event teams and marketing managers who need fast insight without digging through raw rows.

Here is how it works. A manual run pulls rows from a chosen Google Sheet. Answers to three questions are combined into arrays so you see themes across all responses. OpenAI then writes a short summary with highlights, fixes, and a sense of recommendation strength. The text is formatted as HTML and sent to your inbox with Gmail. You get one clean message that removes copy and paste work and reduces bias.

Setup is simple. Connect Google Sheets, OpenAI, and Gmail in n8n, then point the sheet and columns to your form questions. Expect to cut weekly reporting time and get consistent summaries for each event or campaign. Great for post event debriefs, workshop reviews, and survey roundups when speed and clarity matter.

• Manual start for on demand reporting using the manual trigger
• Reads responses from a specific Google Sheet and tab you select
• Combines answers into arrays so themes across all rows are easy to summarize
• Creates a clear summary with OpenAI using a fixed prompt and low temperature for stable tone
• Converts Markdown output to HTML for clean email formatting
• Sends the final HTML report to your inbox through Gmail
• Prompt separates system guidance and user data for structured results
• Supports long forms by splitting questions or batches when needed

• Reduce manual work from 2 hours to 5 minutes per report
• Streamline feedback review by 70 percent with one email summary
• Improve data accuracy by removing up to 90 percent of copy paste errors
• Connect Google Sheets, OpenAI, and Gmail in one simple flow
• Handle 10 times more responses without extra effort

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. In the n8n credentials manager, connect Google Sheets: double click the Google Sheets node, open the Credential to connect with dropdown, click Create new credential, then follow the on screen steps to sign in with your Google account and grant access.
4. In the Google Sheets node, set the Document ID and Sheet Name to your survey sheet and tab. Make sure the form responses include the three question columns used by the flow.
5. Open the Aggregate node and confirm the fields match your exact column headers such as What went great, How can we improve, and What is the chance of recommending our event.
6. Connect OpenAI: double click the OpenAI node, choose Create new credential, paste your API key from your OpenAI account API page, and save. Use a clear name like prod-openai for easy tracking.
7. Review the OpenAI messages. Keep the system message instructions and ensure the user message passes the JSON arrays from the Aggregate node. Leave temperature at 0.3 for consistent outputs.
8. Check the Markdown node settings. It should convert from Markdown to HTML and use the model output field for the content.
9. Connect Gmail: double click the Gmail node, click Create new credential, then complete the Google sign in and grant send email permission. Name the credential clearly such as prod-gmail.
10. Set the Gmail To and Subject fields. Use your team's shared inbox if you want broad visibility.
11. Click Test workflow to run a sample. Confirm the email arrives and the HTML is readable on desktop and mobile. If the message is empty, verify the Markdown node is using the correct output field.
12. Troubleshoot common issues: if no rows appear, check Sheet permissions and the correct tab. If OpenAI fails, confirm the API key and reduce content size by limiting columns or batching. If Gmail blocks send, review account access and remove any images or scripts from the HTML.