Track Shopify Orders in Google Sheets and Send Discord Notifications

Description

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 | [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



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