n8n Webhook Workflow: Enquiry to Google Sheets + Gmail

Turn cleaning enquiries into tracked leads—automatically

This n8n webhook workflow receives commercial cleaning enquiries from your website, validates and normalizes the form data, logs each valid enquiry to Google Sheets, and (if enabled) sends acknowledgement and owner notification emails via Gmail—then returns a JSON response to the website.

What this workflow does

• Receives a POST request from your website form through an n8n webhook (path: /cleaning-enquiry).
• Loads pipeline settings and parses the incoming payload to normalize common WordPress-style fields (contact details, message, and postcode) into a consistent structure.
• Validates submissions to filter out spam or incomplete enquiries and immediately responds for rejected submissions with a webhook response.
• Routes enquiry ownership using postcode prefix rules, then generates the customer acknowledgement and internal notification email content.
• Appends a standardized enquiry row to a Google Sheets tracker for reporting and follow-up.
• Sends emails via Gmail (optional):
  • Acknowledgement email to the customer when enabled.
  • Internal notification to the assigned owner when an owner email exists.
• Returns a JSON webhook response to the website including an ok status and a generated enquiry reference for confirmation.

Use cases

• Your commercial cleaning website needs automated lead capture with immediate customer acknowledgement.
• You want postcode-based routing so enquiries are assigned to the right owner or area.
• You need reliable CRM-style tracking in Google Sheets for follow-up and reporting.

Technical details

• Webhook trigger to accept POST submissions at /cleaning-enquiry
• Nodes/features referenced: if, code, no op, gmail, and sticky note
• Google Sheets integration to append enquiries (configure spreadsheet ID and tab name in the workflow code/config)

Built for n8n users and automation engineers who want a clean, production-ready webhook-to-CRM tracking flow with email notifications.