Website Lead Capture to Sheets with Telegram and Gmail Alerts

How it works

1. 1.A Webhook node listens for POST requests on the path nuovo-lead with the form fields from the site.
2. 2.A Set node extracts the fields with fallback values (e.g., 'Non indicato') and adds a formatted date string.
3. 3.A Google Sheets node appends a row to the 'Registro Lead' sheet with defined columns and initial status 'Nuovo'.
4. 4.After the append, the flow splits to a Markdown-formatted Telegram notification and a Gmail auto-reply to the lead's email.

Use cases

• Centralizing website contact form submissions in a spreadsheet lead register.
• Getting instant Telegram alerts so a sales team can respond to hot leads quickly.
• Sending an automatic acknowledgment email to every new lead.

Requirements

• Point the website form (e.g., WPForms/Elementor webhook or custom POST) at the Webhook production URL, sending nome, email, telefono and messaggio fields.
• Google Sheets credentials plus manual selection of the target document and sheet name, which are currently unselected placeholders.
• Telegram credentials from a @BotFather bot and a real Chat ID to replace the INSERISCI-CHAT-ID placeholder.
• Gmail credentials and customization of the sender name/company placeholder in the email body.

Setup and testing in n8n

1. Send a test POST request with the form fields to the Webhook URL and verify the execution completes.
2. Confirm a new row with status 'Nuovo' appears in the Google Sheets register.
3. Verify the Telegram alert arrives on the configured chat and the courtesy email reaches the test lead address.

Service Value

Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.