{"product_id":"n8n-webhook-filter-form-leads-to-google-sheets-gmail-replies","title":"n8n Webhook: Filter Form Leads to Google Sheets + Gmail Replies","description":"\u003ch3\u003eFilter website form leads, save them to Google Sheets, and reply by Gmail—automatically\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n webhook workflow\u003c\/strong\u003e receives your website contact form submissions, screens out likely spam, \u003cstrong\u003eappends valid enquiries to Google Sheets\u003c\/strong\u003e, and sends an \u003cstrong\u003eacknowledgement email via Gmail\u003c\/strong\u003e. Suspicious submissions are logged separately in an \u003cstrong\u003eExceptions\u003c\/strong\u003e tab with a clear rejection reason.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives POST requests\u003c\/strong\u003e from your website form via an n8n \u003cstrong\u003eWebhook\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes incoming data\u003c\/strong\u003e into consistent fields: \u003cem\u003ename, email, company, phone, message, page, honeypot\u003c\/em\u003e, plus timestamps.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates and flags likely junk\u003c\/strong\u003e by checking email structure, honeypot usage, disposable domains, overly short messages, excessive links, common cold-pitch phrases, and all-caps content.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRoutes results\u003c\/strong\u003e: valid enquiries go to the main flow; flagged submissions go to an exceptions path with a rejection reason.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEnriches valid enquiries\u003c\/strong\u003e with context such as email domain, personal-vs-business email detection, a derived account name, a likely website, an enquiry ID, and a default 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 filtered submissions\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a Gmail acknowledgement\u003c\/strong\u003e to the submitter for valid enquiries.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTurn website form submissions into a clean \u003cstrong\u003elead pipeline\u003c\/strong\u003e in Google Sheets while automatically responding.\u003c\/li\u003e\n  \u003cli\u003eReduce spam in your inbox by using honeypot + content checks before writing to your CRM-like sheet.\u003c\/li\u003e\n  \u003cli\u003eAudit suspicious traffic by reviewing the \u003cstrong\u003eExceptions\u003c\/strong\u003e tab and rejection reasons.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations \/ nodes used\u003c\/strong\u003e: \u003cstrong\u003eWebhook\u003c\/strong\u003e, \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, plus a \u003cstrong\u003esticky note\u003c\/strong\u003e for workflow guidance.\u003c\/li\u003e\n  \u003cli\u003eRequires Google Sheets OAuth for two tabs named \u003cstrong\u003eLeads\u003c\/strong\u003e and \u003cstrong\u003eExceptions\u003c\/strong\u003e (paste the spreadsheet URL into both Google Sheets nodes).\u003c\/li\u003e\n  \u003cli\u003eRequires a configured \u003cstrong\u003eGmail\u003c\/strong\u003e connection to send acknowledgement replies.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45889854046387,"sku":"N8N-18606","price":64.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/sa7hA0dc8hyhHGSnM6xx6_nsgEnipG.png?v=1787498675","url":"https:\/\/buyflowscripts.com\/products\/n8n-webhook-filter-form-leads-to-google-sheets-gmail-replies","provider":"N8N Commerce","version":"1.0","type":"link"}