{"product_id":"n8n-webhook-triage-openai-spam-scoring-to-google-sheets","title":"n8n Webhook Triage: OpenAI Spam Scoring to Google Sheets","description":"\u003ch3\u003eStop spam form submissions and triage every lead automatically—directly into Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n Webhook Triage\u003c\/strong\u003e workflow receives website form submissions via an \u003cstrong\u003en8n webhook\u003c\/strong\u003e, uses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to classify and \u003cstrong\u003escore spam\u003c\/strong\u003e, and appends results to the right \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e tab for fast human review.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives form data\u003c\/strong\u003e (name, email, company, message) through a webhook \u003cem\u003ePOST\u003c\/em\u003e request.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRejects invalid emails\u003c\/strong\u003e with an \u003cstrong\u003eHTTP 400\u003c\/strong\u003e response.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetects bots\u003c\/strong\u003e using a hidden \u003cstrong\u003ehoneypot\u003c\/strong\u003e field and returns a quiet \u003cstrong\u003eHTTP 200\u003c\/strong\u003e response without logging the submission.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDe-duplicates enquiries\u003c\/strong\u003e by checking for the same email + message within a configured time window; duplicates are acknowledged with \u003cstrong\u003eHTTP 200\u003c\/strong\u003e and not reprocessed.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eClassifies and scores with OpenAI\u003c\/strong\u003e: sends the enquiry plus an allowed category list to an OpenAI chat model to return JSON including \u003cstrong\u003ecategory\u003c\/strong\u003e, \u003cstrong\u003econfidence\u003c\/strong\u003e, \u003cstrong\u003eurgency\u003c\/strong\u003e, and a short \u003cstrong\u003esummary\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates AI output and routes results\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003eLow-confidence, unknown-category, or error cases go to a \u003cstrong\u003ehuman review queue\u003c\/strong\u003e.\u003c\/li\u003e\n      \u003cli\u003eSpam is handled using a stricter \u003cstrong\u003econfidence threshold\u003c\/strong\u003e.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites to Google Sheets\u003c\/strong\u003e and replies \u003cstrong\u003eHTTP 200\u003c\/strong\u003e on success (or \u003cstrong\u003eHTTP 500\u003c\/strong\u003e if the sheet write fails).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomatically triage high-volume \u003cstrong\u003ewebsite enquiry\u003c\/strong\u003e traffic into “Enquiries”, “Review”, and “Spam”.\u003c\/li\u003e\n  \u003cli\u003eReduce workload for sales\/support teams by catching bot submissions early via a honeypot.\u003c\/li\u003e\n  \u003cli\u003eEnsure consistent lead categorization and urgency scoring using \u003cstrong\u003eOpenAI\u003c\/strong\u003e before routing for action.\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\/logic\u003c\/strong\u003e: webhook, if, code, switch (plus a sticky note for workflow guidance).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI integration\u003c\/strong\u003e: chat model call returning JSON classification.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets integration\u003c\/strong\u003e: appends to tabs named \u003cstrong\u003eEnquiries\u003c\/strong\u003e, \u003cstrong\u003eReview\u003c\/strong\u003e, and \u003cstrong\u003eSpam\u003c\/strong\u003e (or updated tab names via workflow settings).\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eOptimize your n8n automation for lead intake\u003c\/strong\u003e—with spam scoring, de-duplication, and structured triage into Google Sheets.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46326520217779,"sku":"N8N-21826","price":57.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Ae442OZZM3OvfNMDdo1x4_o9Bc8AId.png?v=1793351338","url":"https:\/\/buyflowscripts.com\/products\/n8n-webhook-triage-openai-spam-scoring-to-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}