Send a daily WooCommerce sales snapshot to Slack with Google Sheets logging

Daily WooCommerce Sales Snapshot to Slack with Google Sheets Logging

This workflow automatically collects WooCommerce sales data every day, calculates key sales metrics, sends a clean summary to Slack and logs the same data into Google Sheets for historical tracking. It helps teams stay informed about daily performance without manually checking dashboards or reports.

Quick Implementation Steps (Get Started Fast)

1. Import the workflow JSON into n8n. 2. Connect your WooCommerce, Slack and Google Sheets credentials. 3. Verify the Slack channel and Google Sheet selection. 4. Activate the workflow. 5. Receive daily sales updates automatically.

What It Does

This workflow runs on a daily schedule and fetches all recent orders from a WooCommerce store. It filters the orders to include only paid ones (Processing and Completed) and further narrows them down to those created within the last 24 hours.

Using separate Code nodes, the workflow calculates essential sales metrics such as total revenue, number of orders, average order value (AOV) and the top-selling products. These metrics are merged into a single structured object for consistent downstream use.

Finally, the workflow sends a formatted sales summary to a Slack channel for quick visibility and appends the same data as a row in Google Sheets. This creates a reliable daily log that can be used for trend analysis and reporting.