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

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