Lead automation based on Webhook with transfer to Google Sheet
Enterprise Resource Planning (ERP) 50 USDAn 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