Website leads logged in Sheets with a Telegram alert

Website leads logged in Sheets with a Telegram alert

An n8n workflow that receives a website contact form through a webhook and adds the lead to a Google Sheet. It alerts you in Telegram and emails the lead a short courtesy reply. Its notes, messages and email are in Italian.

What is inside

• workflow.json: the workflow as n8n exports it, six nodes: five that do the work and one sticky note, written in Italian. It holds no credential.
• README.md: these notes.

What we changed from the original copy

• The credential links are gone. Select your own for Google Sheets, Telegram and Gmail.
• The original had no node positions. This copy places the nodes from left to right.
• The sheet id was empty, and it is <YOUR_SHEET_ID> now, with the tab Registro Lead. The append node also had a column mapping with no columns.schema. In n8n's code for Google Sheets 4.5, that case stops with an error that asks for the schema, so the six columns are listed.
• The Telegram chat id was a text placeholder. It is <YOUR_TELEGRAM_CHAT_ID> now.
• The Telegram step now continues on error. Its text uses Markdown, and Telegram's Bot API page says some characters must be escaped in that mode, so a name or message with a stray _, *, backtick or [ can make Telegram refuse the alert. A failure there could stop the run before the courtesy email.
• The Gmail node's Email Type is set to Text. The node's default is HTML, which would run the message's line breaks together.
• Nothing else.

Before you start

• An n8n instance that your website can reach, on n8n Cloud or your own server.
• A Google Sheet with a tab named Registro Lead and the headers Data, Nome, Email, Telefono, Messaggio and Stato in row 1.
• A Telegram bot token from BotFather and your own chat id.
• A Gmail account to send the courtesy email.
• A form that posts nome, email, telefono and messaggio. The English names name, phone and message work too.

Set it up

1. In n8n, create a workflow, open its menu and choose Import from File. Pick workflow.json.
2. Open Nuovo lead dal sito, copy its production URL and use it as the target of your form. It accepts POST at the path nuovo-lead.
3. Add a Google Sheets credential and select it in Salva nel Registro Lead. Replace <YOUR_SHEET_ID> and check the tab name.
4. Add a Telegram credential and select it in Avvisami su Telegram. Replace <YOUR_TELEGRAM_CHAT_ID> with your chat id.
5. Add a Gmail credential and select it in Email di cortesia al cliente. In its message, replace [IL TUO NOME / AZIENDA] with your name or company.
6. Activate the workflow, then send a test lead.

How a run goes

1. Nuovo lead dal sito receives the POST and answers at once, because its response mode is left at the default.
2. Estrai campi del lead copies the name, email, phone and message from the body. A missing name or phone becomes Non indicato, and the date is written as day, month, year, hour and minute.
3. Salva nel Registro Lead adds a row with Stato set to Nuovo.
4. The row goes on to two nodes. Avvisami su Telegram sends you the name, email, phone and message. Email di cortesia al cliente emails the lead with the subject Abbiamo ricevuto la tua richiesta ✔ and says an answer will follow within a few working hours.

Change the look

• The columns: the mapping and the schema in Salva nel Registro Lead.
• The alert text: Avvisami su Telegram.
• The email's subject and wording: Email di cortesia al cliente.
• The fields it reads: Estrai campi del lead.

Good to know

• Its own note puts setup at about 5 minutes.
• The workflow emails whatever address the post holds, so a stranger who finds the webhook address can make your Gmail send that text to any address. Put a check or a captcha in front of a public form.
• With an empty email field, the Gmail step fails after the row and the alert are done.
• The alert ends with a line that says hot leads close seven times more often. No source is given, so remove it or replace it with your own figure.
• The Gmail node adds n8n's attribution line unless you turn that off in its options.
• This copy was not run against Google Sheets, Telegram or Gmail.
• The lead's details go to Google Sheets, Telegram and Gmail.
• The JSON holds no credential.