Automate event registration and reminder emails with Forms, Sheets & Gmail
Ready for 3.0What this workflow does
This workflow has 28 nodes and runs when someone submits an n8n form (“Event Registration”) (plus 1 other trigger). Along the way it connects Google Sheets and Gmail.
How it runs
Trigger: When someone submits an n8n form (“Event Registration”) (plus 1 other trigger).
- Edit Fields (Edit Fields (Set)): sets 1 field: source
- Edit Fields (Edit Fields (Set)): sets 1 field: source
- Switch: routes items into 2 branches
- Read Existing Registrations (Google Sheets): uses Google Sheets
- Get Confirmed Aptitude Candidates (Google Sheets): uses Google Sheets
- Check for Duplicate Email (Code): runs custom JavaScript code
- Filter Reminder Candidates (Code): runs custom JavaScript code
- If: checks a condition and branches into true / false
- Switch: routes items into 2 branches
- Store Registration (Google Sheets) (Google Sheets): append
…plus 16 more steps. See the full node list below.
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 (10)
- Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - n8n Form Trigger
n8n-nodes-base.formTrigger - Code
n8n-nodes-base.code - Gmail
n8n-nodes-base.gmail - Edit Fields (Set)
n8n-nodes-base.set - Switch
n8n-nodes-base.switch - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Wait
n8n-nodes-base.wait - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
How it works This workflow automates event registrations and attendee communication from initial signup to event day. It captures form submissions, prevents duplicate entries, and stores registrations in Google Sheets. Confirmed attendees receive immediate…