{"product_id":"n8n-lead-routing-workflow-webhook-to-email-google-sheets","title":"n8n Lead Routing Workflow: Webhook to Email \u0026 Google Sheets","description":"\u003ch3\u003eRoute every incoming lead automatically—webhook to emails to Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow instantly accepts lead submissions via a POST webhook, validates and scores the lead, sends an acknowledgment to the lead and a notification to the correct owner, then records everything in Google Sheets. You get faster response times, consistent routing, and full visibility in one automated pipeline.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives inbound leads\u003c\/strong\u003e as JSON or form-encoded data using an n8n \u003cstrong\u003eWebhook\u003c\/strong\u003e. It returns \u003cstrong\u003eHTTP 200 immediately\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes and validates lead fields\u003c\/strong\u003e using fixed business settings (sender, reply-to, and Hot\/Warm\/Cold owner emails). It validates that \u003cstrong\u003ea single valid email address\u003c\/strong\u003e is present.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScores and categorizes leads deterministically\u003c\/strong\u003e based on rules including \u003cem\u003eintent\u003c\/em\u003e, \u003cem\u003etimeline\u003c\/em\u003e, \u003cem\u003ecompany presence\u003c\/em\u003e, and \u003cem\u003emessage length\u003c\/em\u003e. The score determines the \u003cstrong\u003eHot\/Warm\/Cold\u003c\/strong\u003e category and selects the corresponding owner email.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a plain-text acknowledgment email\u003c\/strong\u003e to the lead using the configured \u003cstrong\u003efrom\u003c\/strong\u003e and \u003cstrong\u003ereply-to\u003c\/strong\u003e addresses.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a plain-text owner notification email\u003c\/strong\u003e to the routed owner with lead details and the scoring reasons, setting \u003cstrong\u003ereply-to\u003c\/strong\u003e to the lead’s email.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends the lead to Google Sheets\u003c\/strong\u003e (the workflow writes score, category, reasons, and timestamps into a \u003cstrong\u003eLeads\u003c\/strong\u003e sheet).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFails on errors\u003c\/strong\u003e: if the email or Google Sheets actions report errors, the execution is marked as failed.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCapture leads from a website form and route them to the right sales owner by Hot\/Warm\/Cold score.\u003c\/li\u003e\n  \u003cli\u003eCentralize lead tracking so every webhook submission is recorded with timestamps and scoring reasons in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eEnsure sales teams receive immediate notifications with reply-to set to the prospect’s email.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWebhook\u003c\/strong\u003e for lead intake (JSON or form-encoded) with immediate HTTP 200 response.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmail Send\u003c\/strong\u003e steps using \u003cstrong\u003eSMTP\u003c\/strong\u003e credentials (same credential selected for both email actions).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e integration via OAuth to append records to a \u003cstrong\u003eLeads\u003c\/strong\u003e tab.\u003c\/li\u003e\n  \u003cli\u003eWorkflow logic uses nodes including \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003ewebhook\u003c\/strong\u003e, \u003cstrong\u003eemail send\u003c\/strong\u003e, and supporting elements like a \u003cstrong\u003esticky note\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46058948722867,"sku":"N8N-19692","price":32.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/ViKt_VQro9pOYq8gtZA4k_XtZjik2J.png?v=1789722467","url":"https:\/\/buyflowscripts.com\/products\/n8n-lead-routing-workflow-webhook-to-email-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}