Qualify and log form leads with Google Sheets and Slack alerts
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 10 nodes and runs when someone submits an n8n form (“Get in touch”). Along the way it connects Google Sheets and Slack.
How it runs
Trigger: When someone submits an n8n form (“Get in touch”).
- Set sheet and scoring rules (Edit Fields (Set)): sets 4 fields: sheetUrl, freeEmailDomains, hotScore…
- Normalise and validate email (Code): runs custom JavaScript code
- Keep valid emails (Filter): keeps only the items that match a condition
- Look up email in sheet (Google Sheets): uses Google Sheets
- Flag duplicates (Code): runs custom JavaScript code
- Keep new leads only (Filter): keeps only the items that match a condition
- Score lead (Code): runs custom JavaScript code
- Append lead to sheet (Google Sheets): append
- Notify team in Slack (Slack): uses Slack
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 (6)
- n8n Form Trigger
n8n-nodes-base.formTrigger - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - Filter
n8n-nodes-base.filter - Google Sheets
n8n-nodes-base.googleSheets - Slack
n8n-nodes-base.slack
From the author
Quick Overview This workflow captures leads via an n8n Form, normalizes and validates the email, checks Google Sheets to prevent duplicates, scores and tiers new leads, then appends them to Google Sheets and posts an alert to a Slack channel. How it works 1.…