{"product_id":"n8n-webhook-property-lead-scoring-with-groq-google-sheets","title":"n8n Webhook Property Lead Scoring with Groq + Google Sheets","description":"\u003ch3\u003eAutomatically score real estate (or property) leads from a webhook—then log and notify your agents\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow accepts property enquiries via a \u003cstrong\u003eWebhook\u003c\/strong\u003e, validates the submission, uses \u003cstrong\u003eGroq\u003c\/strong\u003e to generate a \u003cstrong\u003e1–10 buying-intent score\u003c\/strong\u003e, and instantly saves the lead to the right \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e tracker (Personal or Business) while emailing your team via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives enquiry data\u003c\/strong\u003e with a POST request from your website contact form (expects details including at least \u003cstrong\u003ename, email, and phone\u003c\/strong\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates email\u003c\/strong\u003e: if the email address is missing, it logs the raw enquiry to the \u003cstrong\u003eIncomplete Lead\u003c\/strong\u003e Google Sheets tab and returns \u003cstrong\u003eHTTP 400\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eClassifies lead type\u003c\/strong\u003e: flattens the incoming payload and determines whether the lead is \u003cstrong\u003ePersonal\u003c\/strong\u003e or \u003cstrong\u003eBusiness\u003c\/strong\u003e based on the \u003cstrong\u003eemail domain\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScores buying intent with Groq\u003c\/strong\u003e: sends lead details to the \u003cstrong\u003eGroq Chat Completions API\u003c\/strong\u003e to produce a \u003cstrong\u003e1–10 score\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFallback for reliability\u003c\/strong\u003e: if the AI request fails, it uses a \u003cstrong\u003edefault score of 5\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpserts into Google Sheets\u003c\/strong\u003e: routes the lead to the Personal or Business path and upserts the record using \u003cstrong\u003eemail as the unique key\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNotifies agents\u003c\/strong\u003e: sends a formatted lead alert email via \u003cstrong\u003eGmail\u003c\/strong\u003e including lead type and the AI score, then returns \u003cstrong\u003eHTTP 200\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eProperty websites that need instant lead triage after form submissions.\u003c\/li\u003e\n  \u003cli\u003eTeams who want \u003cstrong\u003eAI-assisted lead scoring\u003c\/strong\u003e without manual review.\u003c\/li\u003e\n  \u003cli\u003eOperations that maintain separate reporting tabs for \u003cstrong\u003ePersonal vs Business leads\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\u003en8n nodes\/integrations\u003c\/strong\u003e: Webhook, IF, Code, HTTP Request, Gmail, Google Sheets (tabs for Personal, Business, and Incomplete Lead), plus Sticky Note documentation.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCredentials required\u003c\/strong\u003e: Groq API credential for Chat Completions, Google Sheets credentials, and Gmail credentials.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46063680520371,"sku":"N8N-19708","price":19.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/5cgLj08Ek19AYWOPlNlQC_KYi3855q.png?v=1789809015","url":"https:\/\/buyflowscripts.com\/products\/n8n-webhook-property-lead-scoring-with-groq-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}