Sync Shopify and WooCommerce sales into a Google Sheets accounting ledger
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 10 nodes and runs on Shopify events (plus 1 other trigger). Along the way it connects Shopify, WooCommerce and Google Sheets.
How it runs
Trigger: On Shopify events (plus 1 other trigger).
- Shopify Configuration (Edit Fields (Set)): sets 12 fields: orderId, orderNumber, totalAmount…
- WooCommerce Configuration (Edit Fields (Set)): sets 12 fields: orderId, orderNumber, totalAmount…
- Merge: merges the data from its input branches
- Format Transaction Data (Edit Fields (Set)): sets 13 fields: orderId, orderNumber, amount…
- Check Transaction Type (If): checks a condition and branches into true / false
- Format Sale Entry (Edit Fields (Set)): sets 7 fields: TxnDate, CustomerRef, Line…
- Format Refund Entry (Edit Fields (Set)): sets 6 fields: TxnDate, CustomerRef, Line…
- Log to Google Sheets (Google Sheets): append or update
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (6)
- Shopify Trigger
n8n-nodes-base.shopifyTrigger - WooCommerce Trigger
n8n-nodes-base.wooCommerceTrigger - Merge
n8n-nodes-base.merge - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if
From the author
(Retail) Auto-Sync Transactions to Accounting Tools This workflow automates the collection and standardization of sales data from Shopify and WooCommerce into a centralized Google Sheets ledger. It triggers on new orders, normalizes disparate platform data,…