Summarize Google Sheets form feedback via OpenAI's GPT-4
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: OpenAI (legacy). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 6 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets and Gmail.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Get Google Sheets records (Google Sheets): uses Google Sheets
- Aggregate: combines items into one
- Summarize via GPT model (OpenAI): work with chat
- Convet from Markdown to HTML (Markdown): converts between Markdown and HTML
- Send via Gmail (Gmail): uses Gmail
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- OpenAI (legacy) in Summarize via GPT model: replace with OpenAI node (AI section).
| Removed in 3.0 | Replace with |
|---|---|
| OpenAI (legacy) Summarize via GPT model | OpenAI node (AI section) |
Nodes used (6)
- Manual Trigger
n8n-nodes-base.manualTrigger - Google Sheets
n8n-nodes-base.googleSheets - Aggregate
n8n-nodes-base.aggregate - OpenAI
n8n-nodes-base.openAi - Markdown
n8n-nodes-base.markdown - Gmail
n8n-nodes-base.gmail
From the author
This n8n workflow was developed to collect and summarize feedback from an event that was collected via a Google Form and saved in a Google Sheets document. The workflow is triggered manually by clicking on the "Test workflow" button. The Google Sheets node…