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 line_item_titles and line_item_prices 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 | abc123@gmail.com | 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

> Tested with Shopify's "Bogus" gateway — works without real card info in a development store.