Log Shopify, Etsy and Square orders to Google Sheets and confirm via Gmail

by Atharva Ashtekar ✓ · 19 views · created 2026-09-24 · CRM

What this workflow does

This workflow has 25 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Google Sheets and Gmail.

How it runs

Trigger: When an HTTP POST request hits its webhook URL.

1. config (Code): runs custom JavaScript code
2. read the order (Code): runs custom JavaScript code
3. a usable order? (If): checks a condition and branches into true / false
4. board connected? (If): checks a condition and branches into true / false
5. STOP: not a usable order (Code): runs custom JavaScript code
6. [cred] Sheets - read the board (Google Sheets): uses Google Sheets
7. use the demo board (Code): runs custom JavaScript code
8. Reply to the store (Respond to Webhook): sends the response back to the webhook caller
9. seen this order before? (Code): runs custom JavaScript code
10. already logged? (If): checks a condition and branches into true / false

…plus 14 more steps. See the full node list below.

Services it uses

Google SheetsGmail

Before you upgrade to n8n 3.0

Nodes used (6)

• Webhookn8n-nodes-base.webhook
• Coden8n-nodes-base.code
• Ifn8n-nodes-base.if
• Google Sheetsn8n-nodes-base.googleSheets
• Gmailn8n-nodes-base.gmail
• Respond to Webhookn8n-nodes-base.respondToWebhook

From the author

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” board, and sends a Gmail confirmation email with an estimated ship window based on SKU…

View the original on n8n.io → Check your own copy