{"product_id":"n8n-webhook-filter-spam-send-leads-to-google-sheets-gmail","title":"n8n Webhook: Filter Spam \u0026 Send Leads to Google Sheets + Gmail","description":"\u003ch3\u003eStop Spam. Capture Real Leads. Auto-Reply with Gmail (n8n Webhook → Google Sheets)\u003c\/h3\u003e\n\u003cp\u003eThis n8n automation workflow accepts website form submissions via a \u003cstrong\u003ewebhook\u003c\/strong\u003e, filters out likely spam\/bot enquiries, appends valid leads to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and sends an acknowledgement email to the submitter using \u003cstrong\u003eGmail\u003c\/strong\u003e—while logging rejected submissions for review.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives enquiries\u003c\/strong\u003e as a POST request sent to an n8n webhook.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes fields\u003c\/strong\u003e (e.g., name, email, message, page, honeypot) into a consistent structure and stamps a \u003cstrong\u003ereceived timestamp\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates and flags junk\u003c\/strong\u003e by checking:\n    \u003cul\u003e\n      \u003cli\u003eEmail format\u003c\/li\u003e\n      \u003cli\u003eHoneypot usage\u003c\/li\u003e\n      \u003cli\u003eDisposable domain indicators\u003c\/li\u003e\n      \u003cli\u003eShort or link-heavy messages\u003c\/li\u003e\n      \u003cli\u003eCommon cold-pitch patterns\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRoutes results\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cstrong\u003eValid enquiries\u003c\/strong\u003e go to the main lead flow.\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eFlagged submissions\u003c\/strong\u003e go to an exceptions flow with rejection reasons.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEnriches lead context\u003c\/strong\u003e with fields like email domain, whether the address is personal, best-guess account name\/website, an enquiry ID, and a default status.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates Google Sheets\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003eAppends valid leads to the \u003cstrong\u003eLeads\u003c\/strong\u003e tab\u003c\/li\u003e\n      \u003cli\u003eAppends rejected entries to the \u003cstrong\u003eExceptions\u003c\/strong\u003e tab for auditing (nothing is discarded)\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends acknowledgement email\u003c\/strong\u003e to the submitter via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eConvert “Contact Us” submissions into clean CRM-ready rows in Google Sheets—without spam noise.\u003c\/li\u003e\n  \u003cli\u003eSend immediate confirmation emails for legitimate enquiries while keeping bot attempts in an Exceptions tab.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators validating inbound form traffic before sales review.\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 node to receive POST submissions\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, and \u003cstrong\u003ecode\u003c\/strong\u003e logic for normalization, validation, and routing\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003egmail\u003c\/strong\u003e node to send acknowledgement emails\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSticky note\u003c\/strong\u003e elements for workflow documentation\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eSetup:\u003c\/strong\u003e Connect Google Sheets (ensure tabs named “Leads” and “Exceptions”), connect Gmail for the sending account, then copy the generated webhook URL into your website form.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45889855848627,"sku":"N8N-18605","price":15.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/S3fr7g-YrEUOwEgrIaKop_potX8M8d.png?v=1787498700","url":"https:\/\/buyflowscripts.com\/products\/n8n-webhook-filter-spam-send-leads-to-google-sheets-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}