Send weekly WooCommerce sales KPIs to Slack and Google Sheets

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, calculates key sales KPIs, stores the results in Google Sheets and sends a summarized report to a Slack channel.

Quick Implementation Steps (Get Started Fast)

Connect WooCommerce, Slack and Google Sheets credentials in n8n.
Update the WooCommerce store domain in the Configure WooCommerce Store node.
Review the Slack channel and Google Sheet settings.
Activate the workflow.

That’s it — your weekly sales KPIs will now be generated and shared automatically.

What It Does

This workflow helps you track and share weekly WooCommerce performance without manual effort. It automatically calculates key sales metrics such as total orders, total revenue, average order value, refunds and top-performing products based on the previous week’s data.

The workflow begins on a weekly schedule and determines the exact date range for the last completed week. Using this date range, it pulls sales orders and refund data from WooCommerce through HTTP requests. Multiple calculations are then performed to generate meaningful KPIs that are useful for both operational and leadership-level reporting.

Once the KPIs are calculated, the workflow consolidates them into a clean report format. The data is saved in Google Sheets for long-term tracking and a readable summary is sent to a Slack channel so stakeholders can quickly review weekly performance.

Who’s It For

E-commerce store owners using WooCommerce
Operations and sales teams tracking weekly performance
Business managers who want automated KPI reporting
Teams using Slack and Google Sheets for collaboration and reporting

Requirements to Use This Workflow

An active WooCommerce store with REST API access
WooCommerce Consumer Key and Secret (Basic Auth)
An n8n instance with scheduled workflows enabled
A Slack workspace with permission to post messages
A Google Sheets account with access to the target spreadsheet

How the Workflow Works

Weekly Schedule Trigger
The workflow runs once per week. The exact day and time are configurable.

Calculate Last Week’s Date Range
A Code node calculates the start and end dates of the previous week.

Configure WooCommerce Store
The WooCommerce store domain is defined once and reused across API requests.

Fetch Weekly Data from WooCommerce
Orders with completed and processing status
Refund data for the same date range

Calculate KPIs
Separate Code nodes calculate: Total orders and total revenue
Average order value
Refund count and refund amount
Top products based on revenue

Merge KPI Results
All calculated KPIs are combined into a single dataset.

Prepare Final KPI Report Fields
Only required, clean fields are retained for reporting.

Store Data in Google Sheets
Each workflow run appends one new row with weekly KPI data.

Send Weekly Report to Slack
A formatted summary is posted to the selected Slack channel.

Setup Instructions

Update the WooCommerce domain in the Configure WooCommerce Store node. Verify WooCommerce API credentials in all HTTP Request nodes. Select the desired Slack channel in the Slack node. Confirm the target Google Sheet and worksheet. Adjust the weekly schedule if needed. Activate the workflow.

How To Customize Nodes

Weekly Sales KPI Trigger**
Change the day or time to run the workflow at any point during the week.

Configure WooCommerce Store**
Update the domain if you move to a different store or environment.

HTTP Request Nodes**
Modify order statuses or add filters as needed.

KPI Calculation Code Nodes**
Add new metrics or adjust existing calculations.

Slack Node**
Send reports to a different channel or workspace.

Google Sheets Node**
Store data in another sheet or spreadsheet.

Add-ons (Additional Features)

Monthly or daily KPI reporting
Email-based KPI reports
Separate reports for different WooCommerce stores
Alerting when revenue drops below a threshold
Dashboard integration using BI tools

Use Case Examples

Weekly sales performance review for management
Tracking revenue and refunds trends over time
Sharing automated reports with remote teams
Maintaining a historical KPI log in Google Sheets
Supporting business decisions with consistent weekly data

There can be many more use cases depending on how this workflow is customized or extended.

Troubleshooting Guide

| Issue | Possible Cause | Solution | |------|---------------|----------| | No data in Slack | Workflow not active | Activate the workflow | | Empty KPIs | No orders in the selected week | Verify WooCommerce data | | Incorrect dates | Schedule misconfiguration | Review trigger timing | | Google Sheets not updating | Permission issue | Reconnect Google Sheets credentials | | WooCommerce API error | Invalid credentials | Check Consumer Key and Secret |

Need Help?

If you need help setting up this workflow, customizing KPIs or building advanced reporting automation, our n8n workflow developers at WeblineIndia are here to help.

Our team has strong expertise in n8n workflow automation, WooCommerce integrations and business intelligence reporting. Whether you want to extend this workflow or build a similar solution tailored to your business needs, feel free to reach out to WeblineIndia for expert support.