{"product_id":"n8n-lead-scoring-auto-reply-openrouter-gmail-sheets","title":"n8n Lead Scoring \u0026 Auto Reply: OpenRouter + Gmail + Sheets","description":"\u003ch3\u003eTurn every website lead into a scored priority and an instant email reply—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow receives new website enquiries via webhook, uses \u003cstrong\u003eOpenRouter\u003c\/strong\u003e to score each lead (hot\/warm\/cold) and draft a concise reply, then sends the message through \u003cstrong\u003eGmail\u003c\/strong\u003e and records everything in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e—including errors and “Reply Sent” status.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives lead submissions\u003c\/strong\u003e via a \u003cstrong\u003ePOST webhook\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes and enriches data\u003c\/strong\u003e (name, email, phone, message), adds a timestamp, and applies business-specific settings.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses OpenRouter for lead scoring\u003c\/strong\u003e to classify the enquiry as \u003cem\u003ehot\/warm\/cold\u003c\/em\u003e, summarize the need, and generate a short, ready-to-send email reply.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eParses and validates OpenRouter output\u003c\/strong\u003e, falling back to safe defaults if JSON parsing fails.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends the reply via Gmail\u003c\/strong\u003e when an email address is present, then \u003cstrong\u003eappends lead details + score + “Reply Sent”\u003c\/strong\u003e to the Google Sheets \u003cstrong\u003e“Leads”\u003c\/strong\u003e tab.\u003c\/li\u003e\n  \u003cli\u003eIf \u003cstrong\u003eno email is supplied\u003c\/strong\u003e, it skips sending and still appends the lead with an \u003cstrong\u003e“email not supplied”\u003c\/strong\u003e status to the \u003cstrong\u003e“Leads”\u003c\/strong\u003e tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEscalates hot leads\u003c\/strong\u003e by emailing the business owner via Gmail with the lead details.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eError handling\u003c\/strong\u003e: if any step fails, logs to the Google Sheets \u003cstrong\u003e“Errors”\u003c\/strong\u003e tab and alerts the owner by email.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eScore and respond to \u003cstrong\u003ehigh-intent website forms\u003c\/strong\u003e without manual triage.\u003c\/li\u003e\n  \u003cli\u003ePrioritize follow-ups by automatically tagging leads as \u003cstrong\u003ehot\/warm\/cold\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eMaintain an auditable pipeline by logging every lead and any failures to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\u003c\/strong\u003e: OpenRouter, Gmail, Google Sheets\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\u003c\/strong\u003e: \u003cem\u003ewebhook\u003c\/em\u003e, \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003eset\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e, \u003cem\u003egmail\u003c\/em\u003e, plus \u003cem\u003esticky note\u003c\/em\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup requirements\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003eCreate an OpenRouter credential in n8n and ensure the selected model (e.g., \u003cstrong\u003estealth\/space-bunny-alpha\u003c\/strong\u003e) is available.\u003c\/li\u003e\n      \u003cli\u003eConnect a Gmail account for lead replies and owner alerts.\u003c\/li\u003e\n      \u003cli\u003eConnect Google Sheets and set the target Google Sheet document ID in the workflow settings.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46192854794419,"sku":"N8N-20537","price":49.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/piTV0ZzkN2sxvCxsxWsFP_VTtjTOxa.png?v=1791537390","url":"https:\/\/buyflowscripts.com\/products\/n8n-lead-scoring-auto-reply-openrouter-gmail-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}