# Log cleaning enquiries to Google Sheets and auto-reply with Gmail

> Quick overview This workflow receives Shopify, Etsy, or Square order webhooks, normalizes them into a single order format, logs new orders to a Google Sheets “Orders” tab, and sends a confirmation email via Gmail (with preview/test modes), then updates the sheet to mark the order as confirmed. How it works 1. Receives an order payload via a Webhook endpoint and loads shared settings (sheet IDs, product rules, and email mode) from the configuration. 2. Detects whether the payload is from Shopify, Etsy, or Square, extracts a common set of order fields, and rejects orders missing required data (and holds Square orders until the deposit is paid). 3. Reads existing rows from Google Sheets (or a built-in demo board if the sheet is not enabled) and checks whether the order key already exists to prevent duplicate logging. 4. Validates each line item against the configured product rules and calculates a working-day shipping window from the longest lead time plus buffers, holding orders that con

- **Domain**: `n8n-workflow-20936.n8n.io`
- **Provider**: n8n.io (https://n8n.io)
- **Kind**: workflow
- **Live-responds (last probe)**: None
- **Signed card**: False
- **Streaming**: False
- **Quality score**: 40%

## URLs
- Agent card: https://n8n.io/workflows/20936
- Page (HTML): https://agenstry.com/agents/n8n-workflow-20936.n8n.io
- Documentation: https://n8n.io/workflows/20936