Guides → How to send website form leads to Google Sheets and Telegram with Make
How to send website form leads to Google Sheets and Telegram with Make
A form submits, the lead is logged in Google Sheets with a timestamp, and sales gets a Telegram message within seconds. Free Make blueprint, the sheet columns, and the two things that go wrong.
The most common lead leak in a small business is not the ads or the website. It is the two hours between a form submission landing in an inbox and someone noticing it. By then the lead has filled in two other forms.
The fix is three modules in Make: a webhook that receives the form, a row in a Google Sheet, and a Telegram message to whoever sells.
Lead comes in → logged → alert. No hands.
A form on the client site sends a lead; it is logged and an alert reaches Telegram in seconds. The first automation every consultant sets up.
How it works
- Any form that can send a POST request (Elementor, Typeform, Webflow, Tally, a custom form) sends the submission to a Make webhook.
- Make adds a row to the leads sheet: time, name, phone, email, source, message.
- Make sends a Telegram message to the sales chat with the name, phone and source, so nobody has to open anything.
What goes wrong
A webhook does not check who is calling it. An open form attracts spam, and every spam submission becomes a row and an alert. Add a hidden field the form always fills and filter on it in Make before the sheet module.
The same person often fills the form twice. Without a check, sales calls them twice. The duplicate check below looks the phone number up in the sheet first and labels the second submission as a returning lead.
Returning lead → recognised → "second contact", not "new lead"
Before a lead is logged, the automation checks whether the phone is already in the log. If it is — the alert says "came back", and sales knows this is a second conversation.
When the form arrives incomplete
Optional fields mean some leads arrive without a phone number. Instead of someone noticing and writing an email, the automation can list exactly what is missing and ask for it.
Form arrives incomplete → an email asking for exactly what is missing
A lead without a phone, an order without an address: instead of someone chasing, one email lists the missing fields. The lead is logged either way, marked "incomplete".
The file, the steps and what does not work — every morning in the channel. No spam, no sign-up.