What This Workflow Does
This automation transforms how you monitor your WooCommerce store's financial health. Instead of manually checking reports or waiting for monthly statements, this workflow runs daily to calculate your total revenue, order count, average order value, and top-selling products from the last 24 hours. It simultaneously tracks cancelled orders to highlight potential revenue leakage.
The system compares your daily revenue against a configurable threshold you set. If sales exceed your target, it sends an immediate Slack alert celebrating the spike with key metrics. If not, it delivers a detailed status update showing progress toward the goal, top products, and cancellation impact—keeping your team informed without creating alert fatigue.
This creates a proactive financial monitoring system that helps e-commerce managers, marketing teams, and business owners spot trends, respond to opportunities faster, and identify issues before they escalate, all without touching a spreadsheet.
How It Works
The workflow follows a logical sequence to gather, process, analyze, and communicate your store's daily performance.
1. Scheduled Daily Trigger
The workflow activates automatically each day at your specified time using n8n's Schedule Trigger. You can set it for morning reviews, end-of-day summaries, or any frequency that matches your business rhythm.
2. Fetch WooCommerce Orders
It connects to your WooCommerce store via REST API to retrieve recent orders. The workflow runs two parallel branches: one for paid orders (Completed/Processing status) and another for cancelled orders to track lost revenue.
3. Filter & Calculate Metrics
Code nodes filter orders from the last 24 hours, then calculate total revenue, order count, average order value, and identify top-selling products by quantity. The cancellation branch calculates cancelled order count and total cancelled revenue.
4. Decision & Alert Logic
An IF node compares your daily revenue against your predefined threshold. Based on the result, the workflow takes one of two paths: sending a "Spike Alert" for exceptional days or a "Status Update" for normal performance.
5. Slack Notification Delivery
Formatted messages with emojis, metrics, and actionable insights are sent to your designated Slack channel. The alerts include clear data visualization through Slack's formatting options, making them instantly understandable at a glance.
Who This Is For
This workflow is ideal for WooCommerce store owners, e-commerce managers, marketing teams, and operations specialists who need real-time visibility into daily performance without manual work. It's particularly valuable for:
- Business owners who want daily revenue snapshots without logging into dashboards
- Marketing teams tracking campaign impact on daily sales
- Operations managers monitoring fulfillment efficiency through cancellation rates
- Multi-store operators needing consolidated daily reports
- Teams using Slack for daily standups and quick decision-making
Pro tip: Set different revenue thresholds for weekdays vs. weekends, or create seasonal adjustments to account for expected sales variations throughout the year.
What You'll Need
- WooCommerce store with REST API access (Consumer Key and Consumer Secret)
- n8n instance (cloud or self-hosted) with internet access to your WooCommerce site
- Slack workspace with permission to create incoming webhooks or app installations
- Basic understanding of your store's typical daily revenue patterns to set appropriate thresholds
- 5-10 minutes for initial setup and testing
Quick Setup Guide
Follow these steps to implement this automation in your n8n instance:
- Import the template into your n8n workspace using the downloaded JSON file.
- Configure WooCommerce connection with your store URL, Consumer Key, and Consumer Secret in the WooCommerce nodes.
- Set up Slack integration by creating an incoming webhook in your Slack workspace and adding the URL to the Slack nodes.
- Adjust the revenue threshold in the IF node to match your business targets (e.g., $1000, $5000).
- Test the workflow with a manual trigger to verify data flows correctly and alerts appear as expected in Slack.
- Activate the schedule to run daily at your preferred time (e.g., 8 AM for morning review).
Key Benefits
Save 2-3 hours weekly on manual revenue reporting and spreadsheet updates. This automation eliminates daily data gathering, calculation, and distribution tasks.
React 10x faster to sales opportunities or problems. Instant alerts mean you can capitalize on viral products or address cancellation issues within hours, not days.
Reduce revenue leakage by tracking cancellation patterns. Early detection of rising cancellation rates lets you investigate fulfillment issues, payment problems, or customer experience gaps immediately.
Improve team alignment with transparent, shared metrics. Everyone sees the same numbers at the same time, reducing confusion and creating shared accountability for daily performance.
Scale monitoring effortlessly as your business grows. The same workflow works for $100 or $100,000 daily revenue without additional configuration or manual effort.