Score and route B2B website leads 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 20 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Google Sheets and Gmail.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- Normalize and Assign Owner (Code): runs custom JavaScript code
- If: checks a condition and branches into true / false
- Fetch Page Context (HTTP Request): calls an HTTP API
- Prepare Missing Contact Response (Edit Fields (Set)): sets 3 fields: ok, status, response_message
- Parse Page Signals (Code): runs custom JavaScript code
- Send Missing Contact Response (Respond to Webhook): sends the response back to the webhook caller
- Set Audit Row Data (Edit Fields (Set)): sets 11 fields: received_at, priority, lead_score…
- Append Audit Row in Sheets (Google Sheets): append
- Route by Lead Priority (Switch): routes items into 2 branches
- Set Hot Lead Alert Email (Edit Fields (Set)): sets 2 fields: email_subject, email_body
…plus 9 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 (9)
- Webhook
n8n-nodes-base.webhook - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Edit Fields (Set)
n8n-nodes-base.set - Respond to Webhook
n8n-nodes-base.respondToWebhook - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets - Switch
n8n-nodes-base.switch - Gmail
n8n-nodes-base.gmail
From the author
Quick overview This workflow captures website lead payloads, enriches company context, scores urgency, routes ownership, logs the result, and returns SLA-ready follow-up instructions. How it works 1. Receives a website lead or demo-request payload through a…