Lead automation based on Webhook with transfer to Google Sheet
An automated lead processing system has been created using n8n.
The workflow receives lead data through a webhook, cleans and normalizes the fields (name, phone, email, status), checks for existing records in Google Sheets, and updates the existing row or adds a new one, preventing duplication.
After processing, the system sends real-time notifications to Telegram, distinguishing between new leads and updated contacts.
This automation helps the business centralize all incoming leads, avoid duplicates, and instantly inform managers.
Tools: n8n, Webhooks, Google Sheets, Telegram Bot API
The workflow receives lead data through a webhook, cleans and normalizes the fields (name, phone, email, status), checks for existing records in Google Sheets, and updates the existing row or adds a new one, preventing duplication.
After processing, the system sends real-time notifications to Telegram, distinguishing between new leads and updated contacts.
This automation helps the business centralize all incoming leads, avoid duplicates, and instantly inform managers.
Tools: n8n, Webhooks, Google Sheets, Telegram Bot API