Send weekly WooCommerce sales KPIs to Slack and Google Sheets
Ready for 3.0What this workflow does
This workflow has 13 nodes and runs on a schedule (every week at 10:00). Along the way it connects Slack and Google Sheets.
How it runs
Trigger: On a schedule (every week at 10:00).
- Calculate Last Week Date Range (Code): runs custom JavaScript code
- Configure WooCommerce Store (Edit Fields (Set)): sets 1 field: wc_domain
- Merge: merges the data from its input branches
- Get Weekly Orders (Sales Data) (HTTP Request): calls an HTTP API
- Get Weekly Refunds (HTTP Request): calls an HTTP API
- Get Weekly Top Products (HTTP Request): calls an HTTP API
- Prepare Final KPI Report Fields (Edit Fields (Set)): sets 8 fields: total_orders, total_revenue, average_order_value…
- Calculate Order & Revenue KPIs (Code): runs custom JavaScript code
- Calculate Refund KPIs (Code): runs custom JavaScript code
- Calculate Top Products by Revenue (Code): runs custom JavaScript code
…plus 2 more steps. See the full node list below.
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 (7)
- Edit Fields (Set)
n8n-nodes-base.set - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - Merge
n8n-nodes-base.merge - Slack
n8n-nodes-base.slack - Google Sheets
n8n-nodes-base.googleSheets
From the author
WooCommerce Weekly Sales KPI Reporting to Slack & Google Sheets This workflow automatically generates a weekly sales performance report from WooCommerce and shares it with your team. It runs on a weekly schedule, fetches last week’s orders and refunds,…