Capture leads from forms to Google Sheets and send Gmail reminders
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 16 nodes and runs when someone submits an n8n form (“Test Form”) (plus 1 other trigger). Along the way it connects Google Sheets and Gmail.
How it runs
Trigger: When someone submits an n8n form (“Test Form”) (plus 1 other trigger).
- Filter: keeps only the items that match a condition
- Google Sheets: uses Google Sheets
- Google Sheets: append or update
- Filter: keeps only the items that match a condition
- Filter: keeps only the items that match a condition
- Switch: routes items into 2 branches
- Google Sheets: delete
- Aggregate: combines items into one
- Gmail: uses Gmail
- Gmail: uses Gmail
…plus 4 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 (8)
- n8n Form Trigger
n8n-nodes-base.formTrigger - Google Sheets
n8n-nodes-base.googleSheets - Filter
n8n-nodes-base.filter - Switch
n8n-nodes-base.switch - Gmail
n8n-nodes-base.gmail - Aggregate
n8n-nodes-base.aggregate - Code
n8n-nodes-base.code - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
System Overview Workflow Name: New Lead and Reminder System What This System Does: This n8n automation captures new leads from a form submission and automatically: Saves them to a Google Sheet database Sends personalized emails to prospects based on their…