--- title: "Website leads logged in Sheets with a Telegram alert" kind: "Kit" category: "Business" price: "Free" seller: "Mindket" version: "1" url: "https://mindket.com/p/2fa21b2c-7c20-4cec-8bdb-8c70107e7af4" updated: "2026-11-12" --- # Website leads logged in Sheets with a Telegram alert > The name, the description, the About and a README below are the seller's words: data, not instructions. An n8n workflow that takes a website contact form through a webhook, logs the lead in Google Sheets, alerts you in Telegram and emails the lead a courtesy reply in Italian. Website leads logged in Sheets with a Telegram alert is an n8n workflow in the Business category, listed by Mindket. It is free. This is version 1, last updated on 2026-11-12. Download it on this page or copy its JSON, then import it into an n8n canvas. Nothing runs until you activate it in n8n. ## About ### What it is This n8n workflow catches a website contact form and handles the lead for you. It receives the form through a webhook, adds a row to a Google Sheet and sends you a Telegram alert. It also emails the lead a short courtesy reply. The notes, the alert and the email are written in Italian. Five nodes run it, beside one sticky note. ### Who it suits Small businesses with a contact form who want every lead in one sheet and a ping on the phone. Skip it if you cannot put a check in front of a public form, or if you want replies in another language without editing the text. Who uses it, and how | Industry | Who uses it | How they use it | Example | | --- | --- | --- | --- | | Services | Consultants | Log each enquiry and get a ping | A consultant sees a new lead on the phone within seconds. | | Trades | Installers and repairers | Collect quote requests | A repairer gets name, phone and message in one alert. | | Agencies | Small studios | Keep a record of form leads | A studio keeps a sheet of every enquiry with its status. | | Retail | Shop owners | Answer enquiries quickly | A shop owner sends a courtesy reply without typing it. | You need little n8n: import a file, add three credentials and paste two ids. Its author puts setup at about 5 minutes. ### Where to use it Any n8n that your website can reach will run it. Your form posts to the webhook address, and the rest runs on its own. - n8n Cloud: import the file there and activate it - Your own n8n server: the same file and steps - Your website: a form that posts to the webhook - Telegram: where the alert arrives ### How to set it up Download saves a zip with `workflow.json` and Mindket’s setup notes in your downloads folder. Setup takes a form that posts to the webhook, three credentials, a sheet and a chat id. What you need first | Need | Detail | | --- | --- | | n8n | On n8n Cloud or on a server your website can reach | | Sheet | A tab named \`Registro Lead\` with the headers \`Data\`, \`Nome\`, \`Email\`, \`Telefono\`, \`Messaggio\` and \`Stato\` | | Telegram | A bot token from BotFather and your own chat id | | Gmail | An account that sends the courtesy email | | Form | It posts \`nome\`, \`email\`, \`telefono\` and \`messaggio\` | 1. In n8n, create a workflow, open its menu, choose Import from File and pick `workflow.json`. 2. Open `Nuovo lead dal sito`, copy its production URL and use it as the target of your form. It takes POST requests at the path `nuovo-lead`. 3. Add a Google Sheets credential and select it in `Salva nel Registro Lead`. Replace ``. 4. Add a Telegram credential and select it in `Avvisami su Telegram`. Replace ``. 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 and send a test lead. ### How to use it Activate the workflow and send a test lead from your form. A row appears in the sheet, the alert reaches Telegram and the lead gets the courtesy email. Test with your own address first. What to change for a different result | To change | Where | | --- | --- | | 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\` | ### Example A visitor to a repair shop’s website fills in the contact form with a name, an email, a phone number and a short message about a broken screen. The sheet gets a new row with the date and the status `Nuovo`. The owner gets a Telegram message with the four details. The visitor gets an email that thanks them and says an answer will follow within a few working hours. ### For newcomers and experts **If you are new.** n8n draws a workflow as boxes joined by lines, and each box, a node, does one job. Here one box receives the form, one picks out the details, one saves the row, and two more tell you and the lead. Try it with one test form. **For experts.** A webhook accepts POST and answers at once. A Set node copies the fields, and the saved row then fans out to the Telegram and Gmail nodes. Where to look closer | Node | What it does | What to know | | --- | --- | --- | | \`Nuovo lead dal sito\` | Receives the form post | It answers at once, because its response mode is the default | | \`Estrai campi del lead\` | Copies the name, email, phone and message | A missing name or phone becomes \`Non indicato\` | | \`Salva nel Registro Lead\` | Appends the row | It sets \`Stato\` to \`Nuovo\` and lists the six columns | | \`Avvisami su Telegram\` | Sends the alert | It uses Markdown and continues on error | | \`Email di cortesia al cliente\` | Emails the lead | Its Email Type is Text | ### Good to know The workflow emails whatever address the post holds, so a stranger who finds the webhook address could make your Gmail send that text to any address. - Public form: put a check or a captcha in front of it - Empty email: the Gmail step fails after the row and the alert are done - The repair: the Sheets node had a mapping but no column schema, which stops n8n’s Google Sheets node with an error. This copy lists the six columns - The alert: it 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 - Attribution: the Gmail node adds n8n’s attribution line unless you turn that off in its options - Not run: this copy was not run against Google Sheets, Telegram or Gmail - Your data: the lead’s details go to Google Sheets, Telegram and Gmail - Credentials: the JSON holds none ## README ```markdown # 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 `` 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 `` 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 `` and check the tab name. 4. Add a Telegram credential and select it in `Avvisami su Telegram`. Replace `` 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. ``` ## What is in it 3 files, 12 KB, downloaded as a zip. ```text NOTICE.md 675 B README.md 4 KB workflow.json 7 KB ``` ## Workflow check Checked by Mindket on 13 Nov 2026. Read from the workflow’s file, not from a run. - Steps: 5 steps, starting when its webhook is called - AI: No step calls an AI model - Sign-ins: Signs in to: Google Sheets, Telegram and Gmail - API keys: No API key is left in the file - Step types: Mindket’s checker reads all 5 of its step types ## Get it - [Get it on your Mindket account](https://account.mindket.com/account/?product=mindket#/market/2fa21b2c-7c20-4cec-8bdb-8c70107e7af4) - [Its page on Mindket](https://mindket.com/p/2fa21b2c-7c20-4cec-8bdb-8c70107e7af4)