{"product_id":"n8n-contact-form-filter-google-sheets-gmail-auto-reply","title":"n8n Contact Form Filter: Google Sheets + Gmail Auto Reply","description":"\u003ch3\u003eAuto-reply to real website leads—filter spam first with n8n, Google Sheets, and Gmail\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow receives your website contact form submissions via webhook, filters likely junk, saves valid enquiries to Google Sheets, and sends an acknowledgement email through Gmail—while logging rejected messages (and reasons) to an \u003cstrong\u003eExceptions\u003c\/strong\u003e tab.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives POST submissions\u003c\/strong\u003e from your website form using an \u003cstrong\u003en8n Webhook\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes the payload\u003c\/strong\u003e into consistent fields: \u003cem\u003ename, email, company, phone, message, page, honeypot,\u003c\/em\u003e and \u003cem\u003etimestamps\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates and flags likely spam\u003c\/strong\u003e using rules such as:\n    \u003cul\u003e\n      \u003cli\u003eemail format checks\u003c\/li\u003e\n      \u003cli\u003ehoneypot detection\u003c\/li\u003e\n      \u003cli\u003edisposable domain indicators\u003c\/li\u003e\n      \u003cli\u003eshort-message filtering\u003c\/li\u003e\n      \u003cli\u003eexcessive links detection\u003c\/li\u003e\n      \u003cli\u003ecold-pitch\/copy 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 “real” path.\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eSuspicious submissions\u003c\/strong\u003e go to an “exceptions” path with a rejection reason.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEnriches valid leads\u003c\/strong\u003e with context like email domain, whether it’s likely personal, an enquiry ID, and a status.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends to Google Sheets\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cstrong\u003eLeads\u003c\/strong\u003e tab for accepted enquiries\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eExceptions\u003c\/strong\u003e tab for rejected submissions and why\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a Gmail acknowledgement\u003c\/strong\u003e email back to the submitter.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS teams capturing inbound “contact us” enquiries without manual spam cleanup.\u003c\/li\u003e\n  \u003cli\u003eLanding pages that need reliable lead logging to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e plus instant Gmail replies.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers wanting a practical n8n spam-filtering pattern (honeypot + content rules) with auditability via Exceptions.\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:\u003c\/strong\u003e Webhook, If, Set, Code, Gmail, and sticky note.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets:\u003c\/strong\u003e use a spreadsheet with two tabs named \u003cstrong\u003eLeads\u003c\/strong\u003e and \u003cstrong\u003eExceptions\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup highlights:\u003c\/strong\u003e create Google Sheets + Gmail credentials in n8n, paste the spreadsheet URL into the Google Sheets nodes’ Document ID fields, and configure your website form to POST to the workflow’s production webhook URL.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45889857159347,"sku":"N8N-18604","price":40.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/JxNlmXCjHfIbKKD2f1zAE_N9OJwQs6.png?v=1787498718","url":"https:\/\/buyflowscripts.com\/products\/n8n-contact-form-filter-google-sheets-gmail-auto-reply","provider":"N8N Commerce","version":"1.0","type":"link"}