Collect event feedback with Google Sheets and Gmail
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 8 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”.
- Read Participants Sheet (Google Sheets): uses Google Sheets
- Filter: keeps only the items that match a condition
- Loop Over Participants (Loop Over Items (Split in Batches)): loops over the items in batches
- Generate Unique ID (Code): runs custom JavaScript code
- Update Participant ID (Google Sheets): update
- Set Mail Message (Edit Fields (Set)): sets 1 field: mailmessage
- Send Email Draft (Gmail): work with draft
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (7)
- Code
n8n-nodes-base.code - Filter
n8n-nodes-base.filter - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Edit Fields (Set)
n8n-nodes-base.set - Manual Trigger
n8n-nodes-base.manualTrigger - Gmail
n8n-nodes-base.gmail
From the author
Quick Overview This workflow manually pulls event participants from Google Sheets, generates and stores a unique ID per participant, and creates personalized Gmail draft emails that include a pre-filled Google Forms link to collect missing feedback. How it…