🤝 Analyze WooCommerce category sales over time with Airtable and Slack
⚡ 31 views · 🤝 CRM & Sales Operations
Description
WooCommerce Product Category Sales Performance Report
This workflow automatically analyzes sales data by product category, compares performance across time periods (daily, weekly or monthly), stores structured results in Airtable and sends a clear summary to Slack for quick decision-making.
This workflow pulls order data for two time periods (current and previous), groups sales by product category and calculates key metrics like revenue, units sold and share of total sales. Each category is then classified (Top Performer, Steady, Needs Attention, etc.) with a recommended action.
The results are saved to Airtable for tracking & history and a short, easy-to-read summary is sent to Slack so stakeholders can understand performance at a glance.
You get:
- Automated sales comparison (daily / weekly / monthly)
- Category-wise performance classification
- Historical tracking in Airtable
- One clean Slack summary — no dashboards required
Ideal for product, sales and operations teams who want fast, consistent insights without manual reporting.
Quick Start – Implementation Steps
- Configure the date granularity (daily, weekly or monthly).
- Connect your Orders data source (API, DB or platform node).
- Connect and configure your Airtable base & table.
- Connect your Slack workspace and choose a channel.
- Activate the workflow — reports start running automatically.
What It Does
This workflow automates category-level sales analysis:
- Builds current and previous date ranges dynamically.
- Fetches orders for both time periods.
- Normalizes and aggregates orders by product category.
- Calculates key metrics:
- Current revenue
- Previous revenue
- Units sold
- Share of total sales
- Classifies each category (Top Performer, Steady, At Risk, etc.).
- Adds a recommended business action for each category.
- Saves the final results to Airtable.
- Generates a short summary message.
- Sends a single Slack report to stakeholders.
This ensures consistent, repeatable insights with no manual effort.
Who’s It For
This workflow is ideal for:
- Sales & revenue teams
- Product managers
- E-commerce operations teams
- Business analysts
- Startup founders & leadership
- Anyone needing automated sales performance insights
Requirements to Use This Workflow
To run this workflow, you need:
- n8n instance (cloud or self-hosted)
- Access to orders data (API, database or platform integration)
- Airtable base + Personal Access Token
- Slack workspace with API permissions
- Basic understanding of sales metrics (revenue, units, categories)
How It Works
- Scheduler Trigger – Workflow runs on a defined schedule.
- Build Date Ranges – Calculates current and previous periods.
- Fetch Orders (Current) – Pulls orders for the active period.
- Fetch Orders (Previous) – Pulls orders for comparison.
- Aggregate by Category – Groups sales and calculates metrics.
- Classify Performance – Assigns tags and actions.
- Save to Airtable – Stores structured results.
- Build Slack Summary – Creates a readable summary message.
- Send to Slack – Delivers insights to the team.
Setup Steps
- Import the provided n8n workflow JSON.
- Configure the Scheduler timing.
- Set your preferred granularity (daily / weekly / monthly).
- Connect and map your Orders data source.
- Connect Airtable and map fields:
- Category ID / Name
- Current Revenue
- Previous Revenue
- Units
- Share
- Tag
- Recommended Action
- Connect Slack API credentials and select a channel.
- Activate the workflow — done!
How To Customize Nodes
Change Time Period
- Switch between daily, weekly or monthly comparisons.
- Adjust rolling windows for testing or analysis.
Adjust Performance Thresholds
- Modify revenue or share thresholds.
- Change category labels or actions.
Customize Airtable Storage
Add optional fields such as:
- Report date
- Growth percentage
- Notes or owner
- Review status
Customize Slack Summary
You may add:
- Emojis or highlights
- Mentions (@channel, @team)
- Links to Airtable records
- Separate sections for risks or wins
Add-Ons (Optional Enhancements)
You can extend this workflow to:
- Add Teams or Email notifications
- Track trends over multiple periods
- Generate charts or dashboards
- Add alerts for sudden drops or spikes
- Include AI-based insights or explanations
- Export reports to Google Sheets or CSV
Use Case Examples
1. Weekly Sales Review
Automatically send category performance every week.
2. Product Decision Support
Identify which categories to promote or discontinue.
3. Leadership Updates
Share clear performance summaries with management.
4. E-commerce Optimization
Spot declining categories before revenue drops.
5. Historical Analysis
Track performance trends over time in Airtable.
Troubleshooting Guide
| Issue | Possible Cause | Solution |
|---|---|---|
| No Slack message | Slack node not connected | Verify Slack credentials |
| No Airtable data | Field mapping mismatch | Match Airtable column names |
| Missing current orders | Date range incorrect | Check UTC date logic |
| Empty summary | No category data | Verify aggregation step |
| Workflow not running | Trigger disabled | Enable Scheduler node |
Need Help?
If you need help extending or customizing this workflow with adding alerts, dashboards, AI insights or scaling it for production then our n8n workflow developers at WeblineIndia can assist with advanced automation and reporting solutions.
🔗 Nodes Used
Airtable, Slack, WooCommerce, Schedule Trigger
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File