🤝 Track Shopify orders in Google Sheets and send Discord notifications

⚡ 767 views · 🤝 CRM & Sales Operations

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

💬 Discord Message Preview

image.png

> Tested with Shopify’s “Bogus” gateway — works without real card info in a development store.

🔗 Nodes Used

Google Sheets, Discord, Shopify Trigger

📥 Import

Download workflow.json and import into n8n: Workflow menu → Import from File

📖 Importing guide · 🔑 Credential setup