Track Shopify orders in Google Sheets and send Discord notifications

This workflow tracks new Shopify orders in real-time and logs them to a Google Sheet, while also sending a structured order summary to a Discord channel. Perfect for keeping your team and records updated without checking your Shopify admin manually. ✅ Features: - Trigger: Listens to orders/create event via the Shopify Trigger node - Authentication: Uses Shopify Access Token, generated via a custom/private Shopify app - Google Sheets Logging: Automatically appends order details to a sheet with the following columns: - Order Number - Customer Email - Customer Name - City - Country - Order Total - Currency - Subtotal - Tax - Financial Status - Payment Gateway - Order Date - Line Item Titles - Line Item Prices - Order Link - Discord Alerts: Sends a clean and formatted summary to your Discord server - Line Item Extraction: Breaks down item titles and prices into readable format using code - Multi-currency Compatible: Displays currency type dynamically (not hardcoded) --- 🧩 Nodes Used: - Shopify Trigger (Access Token) - Code — extract lineitemtitles and lineitemprices - Google Sheets — Append row - Code (JavaScript) — Format Discord message - Discord — Send message --- 📒 Sticky Notes: - 🛠️ Use your own Google Sheet link and Discord webhook - 🔄 You can duplicate and adapt this for orders/updated or refunds/create events - 🔐 No hardcoded API keys — credentials managed via UI --- 🖼️ Sample Outputs 📄 Google Sheet Entry | Order Number | Customer Email | Customer Name | City | Country | Order Total | Currency | Subtotal | Tax | Financial Status | Payment Gateway | Order Date | Line Item Titles | Line Item Prices | Order Link | |--------------|------------------|----------------|-----------|----------|--------------|----------|----------|--------|-------------------|------------------|------------------------------|----------------------------------------------------------------------------------------------------|----------------------------------|------------| | 1003 | [email protected] | test name | test city | Pakistan | 2522.77 | PKR | 2174.8 | 347.97 | paid | bogus | 2025-07-31T13:45:35-04:00 | Selling Plans Ski Wax, The Complete Snowboard, The Complete Snowboard, The Collection Snowboard: Liquid | 24.95, 699.95, 699.95, 749.95 | View Order | 💬 Discord Message Preview !image.png(fileId:1930) --- > Tested with Shopify's "Bogus" gateway — works without real card info in a development store.