Capture website form leads with deduped logging in Google Sheets and Telegram
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 11 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Google Sheets and Telegram.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- Confirm Form Submission (Respond to Webhook): sends the response back to the webhook caller
- Map Lead Fields (Code): runs custom JavaScript code
- Check Existing Lead in Sheets (Google Sheets): read
- If: checks a condition and branches into true / false
- Build Updated Lead Row (Code): runs custom JavaScript code
- Create New Lead Row (Code): runs custom JavaScript code
- Update Lead in Sheets (Google Sheets): update
- Append Lead to Sheets (Google Sheets): append
- Notify Repeat Inquiry via Telegram (Telegram): send message
- Notify New Lead via Telegram (Telegram): send message
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)
- Webhook
n8n-nodes-base.webhook - Respond to Webhook
n8n-nodes-base.respondToWebhook - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Telegram
n8n-nodes-base.telegram
From the author
Quick overview This workflow receives website form submissions via webhook, normalizes lead fields, detects duplicates using a phone/email dedupe key, and writes the lead to Google Sheets as a new row or an update. It then sends a Telegram alert with…