Back to Templates

Track Shopify Orders in Google Sheets and Send Discord Notifications

Created by

Created by: moosa || moosa

moosa

Last update

Last update a day ago

Categories

Share


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

image.png


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