WordPress Cleaning Enquiries to Google Sheets & Gmail

Send WordPress cleaning enquiries straight into Google Sheets — and email the right owner automatically

This n8n automation workflow receives WordPress cleaning enquiry form submissions via a webhook, logs each lead to Google Sheets, and (optionally) sends acknowledgement and owner-notification emails via Gmail based on postcode-to-owner routing.

What this workflow does

• Receives submissions via webhook: The workflow handles a POST request on a webhook endpoint when your website enquiry form is submitted.
• Normalizes WordPress form payloads: Common form fields are normalized into consistent values such as contact details, message, and postcode. It also generates a human-readable enquiry reference.
• Rejects likely spam or incomplete submissions: It blocks entries such as missing/invalid email or filled honeypot fields, and returns a JSON response to the website.
• Routes enquiries by postcode: The workflow matches the postcode prefix against configured rules to assign the enquiry to the appropriate area owner, preparing customer and internal email content (including standard follow-up questions).
• Logs to Google Sheets: Every valid enquiry is appended as a new row in your Google Sheets tracker—so it’s recorded even if email sending fails.
• Optional email notifications via Gmail: 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.

Use cases

• A cleaning business capturing leads from a WordPress form and instantly recording them in a Google Sheets pipeline.
• Routing enquiries to the correct local team using postcode prefix rules.
• Ensuring enquiry tracking continues even if Gmail delivery temporarily fails.

Technical details

• Webhook (POST endpoint) to receive WordPress enquiries
• if, code, and no op for validation, transformation, and workflow control
• Google Sheets for enquiry logging (requires Sheet ID and tab name)
• Gmail for customer acknowledgement and owner notification emails (optional)
• sticky note nodes for workflow guidance

Setup summary: 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.