{"product_id":"n8n-webhook-workflow-enquiry-to-google-sheets-gmail","title":"n8n Webhook Workflow: Enquiry to Google Sheets + Gmail","description":"\u003ch3\u003eTurn cleaning enquiries into tracked leads—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n webhook workflow receives commercial cleaning enquiries from your website, validates and normalizes the form data, logs each valid enquiry to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and (if enabled) sends acknowledgement and owner notification emails via \u003cstrong\u003eGmail\u003c\/strong\u003e—then returns a JSON response to the website.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives a POST request\u003c\/strong\u003e from your website form through an \u003cstrong\u003en8n webhook\u003c\/strong\u003e (path: \u003cstrong\u003e\/cleaning-enquiry\u003c\/strong\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads pipeline settings\u003c\/strong\u003e and parses the incoming payload to normalize common WordPress-style fields (contact details, message, and postcode) into a consistent structure.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates submissions\u003c\/strong\u003e to filter out spam or incomplete enquiries and immediately responds for rejected submissions with a webhook response.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRoutes enquiry ownership using postcode prefix rules\u003c\/strong\u003e, then generates the customer acknowledgement and internal notification email content.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends a standardized enquiry row\u003c\/strong\u003e to a Google Sheets tracker for reporting and follow-up.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends emails via Gmail (optional)\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003eAcknowledgement email to the customer when enabled.\u003c\/li\u003e\n      \u003cli\u003eInternal notification to the assigned owner when an owner email exists.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReturns a JSON webhook response\u003c\/strong\u003e to the website including an \u003cstrong\u003eok\u003c\/strong\u003e status and a generated enquiry reference for confirmation.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eYour commercial cleaning website needs automated lead capture with immediate customer acknowledgement.\u003c\/li\u003e\n  \u003cli\u003eYou want postcode-based routing so enquiries are assigned to the right owner or area.\u003c\/li\u003e\n  \u003cli\u003eYou need reliable CRM-style tracking in Google Sheets for follow-up and reporting.\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 trigger to accept POST submissions at \u003cstrong\u003e\/cleaning-enquiry\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003eNodes\/features referenced: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003eno op\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, and \u003cstrong\u003esticky note\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets integration\u003c\/strong\u003e to append enquiries (configure spreadsheet ID and tab name in the workflow code\/config)\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eBuilt for n8n users and automation engineers who want a clean, production-ready \u003cstrong\u003ewebhook-to-CRM tracking\u003c\/strong\u003e flow with email notifications.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46047313887411,"sku":"N8N-19663","price":55.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/r__lAS-joauS5QbiOJBlS_MxrSa2Zo.png?v=1789636161","url":"https:\/\/buyflowscripts.com\/products\/n8n-webhook-workflow-enquiry-to-google-sheets-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}