{"product_id":"wordpress-cleaning-enquiries-to-google-sheets-gmail","title":"WordPress Cleaning Enquiries to Google Sheets \u0026 Gmail","description":"\u003ch3\u003eSend WordPress cleaning enquiries straight into Google Sheets — and email the right owner automatically\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n automation workflow\u003c\/strong\u003e receives \u003cstrong\u003eWordPress cleaning enquiry form\u003c\/strong\u003e submissions via a webhook, logs each lead to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and (optionally) sends acknowledgement and owner-notification emails via \u003cstrong\u003eGmail\u003c\/strong\u003e based on postcode-to-owner routing.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives submissions via webhook:\u003c\/strong\u003e The workflow handles a \u003cem\u003ePOST\u003c\/em\u003e request on a webhook endpoint when your website enquiry form is submitted.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes WordPress form payloads:\u003c\/strong\u003e Common form fields are normalized into consistent values such as contact details, message, and postcode. It also generates a human-readable \u003cstrong\u003eenquiry reference\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRejects likely spam or incomplete submissions:\u003c\/strong\u003e It blocks entries such as missing\/invalid email or filled honeypot fields, and returns a \u003cstrong\u003eJSON response\u003c\/strong\u003e to the website.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRoutes enquiries by postcode:\u003c\/strong\u003e The workflow matches the postcode prefix against configured rules to assign the enquiry to the appropriate \u003cstrong\u003earea owner\u003c\/strong\u003e, preparing customer and internal email content (including standard follow-up questions).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs to Google Sheets:\u003c\/strong\u003e Every valid enquiry is appended as a new row in your Google Sheets tracker—so it’s recorded even if email sending fails.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOptional email notifications via Gmail:\u003c\/strong\u003e If enabled, it sends the acknowledgement to the customer and notifies the assigned owner (when the owner email is set), then returns a JSON response with the enquiry reference.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eA cleaning business capturing leads from a WordPress form and instantly recording them in a Google Sheets pipeline.\u003c\/li\u003e\n  \u003cli\u003eRouting enquiries to the correct local team using postcode prefix rules.\u003c\/li\u003e\n  \u003cli\u003eEnsuring enquiry tracking continues even if Gmail delivery temporarily fails.\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 (POST endpoint) to receive WordPress enquiries\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, and \u003cstrong\u003eno op\u003c\/strong\u003e for validation, transformation, and workflow control\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e for enquiry logging (requires Sheet ID and tab name)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e for customer acknowledgement and owner notification emails (optional)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003esticky note\u003c\/strong\u003e nodes for workflow guidance\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eSetup summary:\u003c\/strong\u003e Create\/choose a Google Sheets tracker with expected header columns (e.g., Ref, Received, Stage, Owner, Email, Postcode, Notes) and configure the Sheet ID\/tab name in n8n. Connect your Google Sheets credentials to the workflow.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46019071475891,"sku":"N8N-19543","price":70.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/fm6TDvKaFZGLIzu7VNd-h_lGF98p1q.png?v=1789376952","url":"https:\/\/buyflowscripts.com\/products\/wordpress-cleaning-enquiries-to-google-sheets-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}