Auto-Collect WooCommerce Orders to Discord & Google Sheets

Description

This n8n workflow automates WooCommerce order processing by capturing order updates via webhook and converting them into Discord notifications and Google Sheets entries.

What This Workflow Does
Automatically captures WooCommerce orders and sends real-time Discord notifications while logging paid orders to Google Sheets for tracking and reporting.

Key Benefits
Save 90% Time**: Eliminates manual order logging and monitoring
Never Miss Orders**: Instant Discord alerts for all order activities
80% Faster Response**: Team gets structured order info immediately
Dual Tracking**: Real-time alerts + permanent spreadsheet records

Perfect For
Ecommerce Teams**: Monitor orders without constantly checking admin panel
Small Business Owners**: Professional order tracking without extra staff
Fulfillment Teams**: Get organized order data for quick processing

How It Works
WooCommerce sends order webhook to n8n
Order data is parsed and formatted beautifully
All orders trigger Discord notifications (color-coded by status)
Paid orders (PROCESSING status) are logged to Google Sheets
Webhook confirms successful receipt to WooCommerce

Features
Smart Status Colors**: Yellow (pending), Blue (processing), Green (completed), Gray (cancelled)
Rich Discord Embeds**: Customer info, items, shipping, totals - all formatted nicely
Flexible Data Parsing**: Handles various WooCommerce webhook structures
Indonesian Currency**: Proper IDR formatting for local businesses
Product Thumbnails**: Shows product images in Discord notifications

Setup Requirements
n8n instance (self-hosted or cloud)
Discord server with bot access
Google account for Sheets
WooCommerce admin access

Quick Setup
Import workflow JSON to n8n
Add Discord bot token
Connect Google Sheets OAuth
Set WooCommerce webhook to n8n endpoint
Create Google Sheet with required columns
Test with a sample order

Customization Options
Change Discord embed colors for your brand
Modify which order statuses get logged
Add custom fields to Google Sheets
Adjust currency and language settings
Filter orders by specific conditions

Google Sheets Columns
Month (order date)
Brand Name
Web Order Number
Expedition (shipping method)
Tracking Number
Status

Future Enhancement Ideas
Add SMS/WhatsApp customer notifications
Connect to shipping label services
Integrate with CRM for customer insights
Add inventory management triggers
Create sales analytics dashboard

Support
Created by Khmuhtadin
Need customization? Contact us!