Sync Shopify and WooCommerce sales into a Google Sheets accounting ledger

(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, distinguishes between sales and refunds, and formats the information for accounting readiness. This eliminates manual data entry and ensures real-time financial tracking across multiple storefronts.

Quick Implementation Steps

- Connect Triggers: Authenticate your Shopify and WooCommerce accounts in the respective "Order Events" nodes. - Set Webhooks: Add the generated n8n Webhook URLs to your Shopify and WooCommerce notification settings. - Configure Sheets: Select your target spreadsheet and sheet name in the "Log to Google Sheets" node. - Map Credentials: Ensure Google Sheets OAuth2 is connected to authorize the "Append or Update" action. - Verify Fields: Test the workflow to ensure platform-specific keys map correctly to your sheet columns.

What It Does

The workflow acts as a bridge between e-commerce storefronts and financial reporting tools:

- Multi-Source Ingestion: Listens for real-time webhooks from both Shopify (orders/create) and WooCommerce (order.created). - Data Normalization: Translates platform-specific JSON (like currenttotalprice vs total) into a single internal schema. - Smart Routing: Evaluates the transaction type to determine if the record is a standard sale or a refund. - Accounting Formatting: Structures data into financial-ready blocks, including calculated line items, tax details, and audit notes. - Centralized Logging: Records all activity in Google Sheets, using an "Append or Update" logic to prevent duplicate entries.

Who's It For