{"product_id":"n8n-workflow-score-route-b2b-leads-with-google-sheets-gmail","title":"n8n Workflow: Score \u0026 Route B2B Leads with Google Sheets + Gmail","description":"\u003ch3\u003eScore and route every B2B lead automatically—using Google Sheets + Gmail\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow captures website lead and demo-request payloads via webhook, enriches company context, scores urgency, and routes the result to the right Gmail alerts—while logging a full audit trail in Google Sheets.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives structured lead requests through a webhook\u003c\/strong\u003e so the complete routing path runs from one input payload.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes key fields\u003c\/strong\u003e including contact details, company information, source, message, budget, and requested timeline, then prepares scoring inputs and initial ownership.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates contact availability early\u003c\/strong\u003e: if usable contact details are missing, it returns a clear “missing-contact” response before any enrichment or notification work runs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEnriches using submitted company page content (when provided)\u003c\/strong\u003e to produce deterministic signals such as company\/intent\/source-quality and urgency.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends an audit row to Google Sheets\u003c\/strong\u003e containing the normalized lead, score, priority, owner, SLA deadline, and context fields for reporting and replay.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRoutes leads into separate Gmail alerts\u003c\/strong\u003e for hot, review-queue, and normal categories, including recommended action and follow-up angle.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePerforms executive-escalation checks\u003c\/strong\u003e and sends an additional alert when the criteria are met.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReturns a structured success response\u003c\/strong\u003e to the original webhook requester.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTurn website form and demo-request submissions into \u003cstrong\u003eSLA-ready follow-up instructions\u003c\/strong\u003e with consistent scoring and ownership.\u003c\/li\u003e\n  \u003cli\u003eEnsure \u003cstrong\u003efast routing for high-urgency B2B leads\u003c\/strong\u003e while keeping lower-priority leads in a review queue.\u003c\/li\u003e\n  \u003cli\u003eMaintain a \u003cstrong\u003eGoogle Sheets audit log\u003c\/strong\u003e for performance tracking, replay, and operational transparency.\u003c\/li\u003e\n  \u003cli\u003eTrigger \u003cstrong\u003eexecutive escalation\u003c\/strong\u003e for leads that meet predefined criteria.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWebhook entry:\u003c\/strong\u003e “When Lead Submitted Webhook” to accept lead payloads and run the full path in one request.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCore logic:\u003c\/strong\u003e \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, and \u003ccode\u003ecode\u003c\/code\u003e for normalization, validation, and scoring-related decisions.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOutbound notifications:\u003c\/strong\u003e \u003ccode\u003egmail\u003c\/code\u003e for hot\/review\/normal routing and optional executive alerts.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFlow control:\u003c\/strong\u003e \u003ccode\u003eswitch\u003c\/code\u003e to route based on lead score\/priority\/urgency signals.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eSetup tip:\u003c\/strong\u003e import into n8n, configure the webhook test URL in the “When Lead Submitted Webhook” node, keep the workflow inactive until sample cases pass, and connect your Google Sheets credential for “Append Audit Row in Sheets”.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45876837023923,"sku":"N8N-18528","price":45.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/kPyWiZKwGwF5bsfsTwIW2_spFKOCDI.png?v=1787303081","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-score-route-b2b-leads-with-google-sheets-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}