Shopify Etsy Square Orders to Google Sheets + Gmail Confirmation

Automate order capture from Shopify, Etsy, or Square into Google Sheets—then email customers with a Gmail confirmation

Stop manually copying order details. This n8n workflow receives Shopify, Etsy, or Square webhooks, normalizes them into a single order format, logs new orders into a Google Sheets “Orders” tab, and sends a Gmail confirmation email that includes an estimated ship window based on SKU lead-time rules.

What this workflow does

• Receives webhook orders via an HTTP webhook endpoint.
• Detects the storefront source (Shopify, Etsy, or Square), normalizes the payload into a common order structure, and rejects orders missing required details—including Square orders where a deposit hasn’t been captured.
• Deduplicates orders by generating a unique key in the format source|order-no, using existing rows loaded from Google Sheets.
• Validates SKU rules for every line item, calculates a working-day ship window from the longest lead time plus buffers, and can hold orders with unknown SKUs depending on configuration.
• Writes to Google Sheets in a single new row on the “Orders” board—or outputs a demo preview when the sheet isn’t configured.
• Sends a Gmail confirmation (test/live mode), then updates the sheet row with a Confirmed stage and timestamp.
• Returns a JSON response to stop storefront webhook retries, including for held, rejected, duplicate, demo, or preview outcomes.

Use cases

• Capture orders from multiple storefronts and keep one centralized “Orders” record in Google Sheets.
• Automatically email customers a ship window estimate driven by SKU-specific lead times.
• Prevent duplicate processing by enforcing the source|order-no deduplication key.
• Hold or reject problematic orders (e.g., unknown SKUs or Square deposits not captured).

Technical details

• n8n nodes used: webhook, if, code, google sheets, gmail, plus sticky note for workflow documentation.
• Data storage: Google Sheets “Orders” tab with configured column headings.
• Output behavior: demo/preview mode when the sheet isn’t enabled; JSON responses to control webhook retries.