Slack and WooCommerce integration

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) Import the workflow JSON into n8n. Connect your WooCommerce, Slack and Google Sheets credentials. Verify the Slack channel and Google Sheet selection. Activate the workflow. 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. Who’s It For WooCommerce store owners Sales and operations teams Marketing teams tracking daily performance Business managers who prefer Slack updates Analysts maintaining sales history in spreadsheets Requirements to Use This Workflow Active WooCommerce store with API access n8n instance (self-hosted or cloud) Slack workspace with permission to post messages Google Sheets document for logging data Valid credentials configured in n8n for: WooCommerce Slack Google Sheets How It Works A Schedule Trigger runs the workflow once per day. Orders are fetched from WooCommerce. Only paid orders (Processing / Completed) are considered. Orders from the last 24 hours are filtered. Sales metrics are calculated: Total Revenue Order Count Average Order Value (AOV) Top Selling Products Metrics are merged into a single object. A formatted summary is: Sent to Slack Appended or updated in Google Sheets How To Set Up Configure the Schedule Trigger time. Add WooCommerce credentials. Review paid order filtering logic. Select Slack channel. Select Google Sheet and worksheet. Test the workflow. Activate it. How To Customize Nodes Change schedule time in the Schedule Trigger. Modify order statuses in the Filter Paid Orders node. Adjust the 24-hour window in the Code node. Increase or decrease top products count. Customize Slack message formatting. Add or remove Google Sheets columns. Add-ons (Optional Enhancements) Weekly or monthly summaries Revenue comparison (day-over-day / week-over-week) Revenue threshold alerts Multiple Slack channels Dashboard integrations from Google Sheets Use Case Examples Daily sales snapshot for store owners Morning updates for sales teams Automated sales logging for finance teams Performance tracking without dashboards Remote team visibility via Slack Many more variations are possible depending on business needs. Troubleshooting Guide | Issue | Possible Cause | Solution | |------|---------------|----------| | Slack message not received | Slack credentials or channel issue | Verify Slack API and channel | | Google Sheet not updating | Incorrect sheet or mapping | Recheck sheet selection | | Orders missing | Order status filter too strict | Update filter conditions | | Revenue incorrect | Time filter issue | Verify last 24-hour logic | | Workflow not running | Workflow inactive | Activate workflow | Need Help? If you need help setting up, customizing or extending this workflow, our n8n automation experts at WeblineIndia can assist. We specialize in: n8n automation workflows Business process automation Custom integrations and reporting Contact WeblineIndia to build reliable and scalable automation tailored to your business.

WooCommerce Inventory Reorder Automation with n8n, Gmail & Slack Alerts Automatically track product sales and inventory levels in WooCommerce and trigger reorder notifications when stock runs low or sales spike. This n8n workflow runs daily, analyzes all WooCommerce orders to calculate SKU-wise sales, compares them with current product stock, calculates an optimal reorder quantity and sends automated alerts via Email (Gmail) and Slack when a product meets reorder conditions. Quick Implementation Steps (Get Started Fast) Import the workflow JSON into your n8n instance. Connect WooCommerce, Gmail and Slack credentials. Set the Schedule Trigger to run daily. Update email recipients and Slack channel. Activate the workflow. What It Does This workflow automates inventory monitoring and reorder decision-making for WooCommerce stores. On a daily schedule, it fetches all orders from WooCommerce and calculates how many units of each SKU were sold. This gives you a clear picture of recent sales velocity without manual reporting. The workflow then retrieves live product inventory data from WooCommerce, including current stock levels and low-stock thresholds. Sales data and product data are merged using SKU matching and evaluated using logical conditions to determine whether a product should be reordered. When a product meets the reorder criteria, the workflow calculates an optimal reorder quantity using average daily sales, supplier lead time and safety stock logic. It then automatically notifies the purchasing team via email and Slack, ensuring no critical stock replenishment is missed. Who’s It For This workflow is ideal for: WooCommerce store owners Inventory and supply chain managers E-commerce operations teams Businesses looking to reduce stockouts Teams that want proactive, automated purchase alerts Requirements to Use This Workflow To use this workflow, you will need: An active n8n instance A WooCommerce store with: Products using SKUs Stock management enabled WooCommerce API credentials with access to: Orders Products A Gmail account connected to n8n (OAuth2) A Slack workspace with bot permissions Basic understanding of n8n nodes and credentials How It Works & How To Set Up Step-by-Step Workflow Logic Schedule Trigger (Daily) The workflow runs automatically once per day. Fetch All WooCommerce Orders Retrieves all available orders from WooCommerce. No status or date filtering is applied. Calculate Sales per SKU A JavaScript Code node loops through order line items. Quantities sold are aggregated per SKU. Fetch All WooCommerce Products Retrieves product inventory data including: Stock quantity Low stock threshold Product name Merge Sales & Product Data Sales data and product inventory data are merged using SKU matching. Reorder Eligibility Filter A product qualifies if either condition is met: Current stock ≤ low-stock threshold OR recent sales quantity ≥ 1.5× low-stock threshold Reorder Quantity Calculation Uses: Average daily sales Fixed lead time (7 days) Safety stock (5 units) Calculates recommended reorder quantity. Email Notification Sends a formatted HTML email with reorder details. Slack Notification Sends a real-time alert to a specified Slack channel. How To Customize Nodes You can easily adapt this workflow to your business needs: Schedule Trigger** Change execution frequency (daily, weekly, etc.). Sales Calculation Code** Modify logic to: Ignore certain SKUs Add time-based filtering Apply weighted averages Filter Conditions** Adjust reorder rules: Change sales multiplier Use AND logic instead of OR Reorder Formula** Update lead time or safety stock values. Integrate supplier-specific rules. Email & Slack Nodes** Replace recipients and channels. Customize message formatting or branding. Add-ons (Extend the Workflow) You can enhance this workflow with: Automatic purchase order creation in ERP systems Google Sheets logging for reorder history Vendor-specific reorder logic Forecast-based inventory planning Approval workflows before notifications Webhook integration with procurement tools Use Case Examples Primary use cases include: Preventing stockouts in fast-moving WooCommerce stores Automating daily inventory monitoring Supporting purchasing teams with data-driven reorder alerts Replacing manual stock checks and spreadsheets Improving response time to sudden sales spikes There are many more variations of this workflow that can be adapted to different industries and store sizes. Troubleshooting Guide | Issue | Possible Cause | Solution | |-----|---------------|----------| | No emails sent | Gmail credentials not connected | Reconnect Gmail OAuth2 | | No Slack alerts | Wrong channel ID or permissions | Update channel and Slack app scopes | | Reorder triggered too often | Filter logic too sensitive | Adjust threshold values | | Missing sales data | Products without SKUs | Ensure all products have SKUs | | Workflow fails | WooCommerce API limits | Reduce frequency or paginate data | Need Help? Need assistance setting up this workflow or customizing it for your business? Our n8n workflow development team at WeblineIndia specializes in building advanced n8n automations, WooCommerce integrations and end-to-end business process workflows. Whether you need enhancements, add-ons or a completely custom automation solution, our experts are here to help you streamline operations and scale efficiently. Contact WeblineIndia to get started with smarter automation today.

Retail – New Product Drop Notifications This workflow automatically detects when a new product is created in WooCommerce and instantly notifies internal teams through Slack and email. At the same time, it logs all product details into Google Sheets for tracking and reporting. A centralized data formatting step ensures consistent and reusable product data across all nodes. Quick Implementation Steps Import the workflow JSON into n8n. Connect WooCommerce, Slack, Gmail and Google Sheets credentials. Review the Format Product Details node for field mappings. Select the Slack channel and Google Sheet. Activate the workflow. What It Does This workflow listens for new product creation events from WooCommerce. When a product is created, the workflow extracts key product attributes such as name, price, status, permalink and images and prepares them in a single centralized configuration node. Using this standardized data, the workflow sends a real-time Slack notification to inform internal teams, sends a formatted HTML email announcing the product launch and appends the same product information into a Google Sheet for historical reference and reporting. By centralizing data preparation and reusing it across all downstream nodes, the workflow remains easy to maintain, highly readable and simple to extend for future requirements. Who’s It For This workflow is ideal for: E-commerce teams using WooCommerce Marketing teams managing product launches Operations teams maintaining product logs Sales teams needing instant product visibility Business owners tracking new product releases Prerequisites To use this workflow, you need: An active n8n instance (self-hosted or cloud) WooCommerce REST API credentials Slack workspace with API access Gmail account with OAuth2 access Google Sheets API access A Google Sheet with predefined columns How to Use & Setup Import the workflow JSON into n8n. Configure WooCommerce – New Product Created with your WooCommerce credentials. Review the Format Product Details node to verify product field mappings. Configure Notify Team on Slack and select the target Slack channel. Configure Send Product Launch Email and update the recipient email if required. Configure Log Product in Google Sheets and select the target spreadsheet and sheet. Save and activate the workflow. Once activated, the workflow runs automatically whenever a new product is created in WooCommerce. How To Customize Nodes Format Product Details** Add or remove product attributes such as SKU, categories or tags. Modify how images are processed or stored. Slack Notification** Customize message format, emojis or mentions. Email Notification** Adjust branding, layout or additional product details. Google Sheets Logging** Add more columns like product ID, category or creator. Add-ons (Optional Enhancements) This workflow can be extended to: Prevent duplicate product entries in Google Sheets Route Slack notifications to different channels by category Send emails to multiple stakeholder groups Add approval or review steps before notifications Integrate with CRM or ERP systems Generate daily or weekly product launch summaries Use Case Examples Marketing teams receiving instant alerts for new product launches. Operations teams maintaining a centralized product creation log. Sales teams staying updated on new offerings. Business owners tracking product launch activity over time. Teams ensuring consistent communication across Slack, email and reports. There can be many additional use cases depending on business needs. Troubleshooting Guide | Issue | Possible Cause | Solution | |------|---------------|----------| | Slack message not sent | Invalid Slack credentials | Reconnect Slack API credentials | | Email not delivered | Gmail OAuth expired | Reauthorize Gmail account | | Google Sheet not updated | Sheet permissions missing | Verify Google Sheets access | | Images missing | Product has no images | Check WooCommerce product data | | Workflow not executing | Workflow inactive | Activate the workflow | Need Help? If you need help setting up, customizing or extending this workflow or want to build similar automations tailored to your business, our n8n developers at WeblineIndia can assist with advanced workflow design and automation solutions.

Sync Shopify products to WooCommerce with AI enhancement This workflow automates the process of synchronizing your Shopify catalog to WooCommerce, enriching product data along the way. It uses AI to identify the best external sources (like Amazon or G2) for additional product details, scrapes that data using BrowserAct, synthesizes a high-converting description, and then pushes the enhanced product to your WooCommerce store. Target Audience Dropshippers, e-commerce store owners managing multiple storefronts, and digital marketers looking to automate product data enrichment. How it works Fetch Products: The workflow starts by retrieving all products from your Shopify store. Classify & Research: An AI Agent analyzes each product title to determine the best source for external data (e.g., physical goods -> Amazon, software -> G2). Scrape Data: BrowserAct executes a background task to scrape the target site for specifications, reviews, and images. Enhance Content: A second AI Agent (acting as a copywriter) processes the scraped data to write a compelling HTML description, generate a logical SKU, and format image lists. Sync to WooCommerce: The workflow checks if the product already exists in WooCommerce via SKU check. If not, it creates a new product with the enriched data. Error Handling: If product creation fails, a notification is sent to Slack. How to set up Configure Credentials: Connect your Shopify, WooCommerce, Slack, BrowserAct, and Google Gemini accounts in n8n. Prepare BrowserAct: Ensure the Shopify to WooCommerce Multi-Store Sync template is saved in your BrowserAct account. Configure Notifications: Open the Notify user and Send Error nodes to select your preferred Slack channel. Activate: Run the workflow manually to start the sync. Requirements BrowserAct* account with the Shopify to WooCommerce Multi-Store Sync* template. Shopify** account (Access Token). WooCommerce** account (API Key/Secret). Google Gemini** account. Slack** account. How to customize the workflow Filter Products: Add logic after the "Get many products" node to only sync specific collections or tags. Change AI Persona: Modify the system prompt in the Create Product agent to change the tone of the product descriptions (e.g., more technical vs. more salesy). Add More Sources: Update the Analyze the Products agent to include other data sources like eBay or Best Buy. Need Help? How to Find Your BrowserAct API Key & Workflow ID How to Connect n8n to BrowserAct How to Use & Customize BrowserAct Templates Workflow Guidance and Showcase Video One-Click Shopify to WooCommerce Sync with n8n & AI 🛒

WooCommerce Daily Sales & Revenue Spike Monitor → Slack Alert This workflow automatically checks your WooCommerce store’s last 24 hours of revenue, top-selling products, and cancelled orders on a daily schedule. It sends Slack notifications when sales cross a defined threshold or provides a detailed status update—including cancellation impact—if the target hasn’t been met, helping teams react quickly without manual reporting. 🚀 Quick Implementation Steps Set up the Schedule Trigger to run daily Connect WooCommerce and fetch recent orders Filter paid and cancelled orders separately Filter both datasets to the last 24 hours Calculate revenue, top products, and cancellation impact Merge and format sales and cancellation data Compare revenue with a configurable threshold Send enriched Slack alerts with sales and cancellation insights What It Does This workflow serves as a daily sales and revenue health monitoring assistant for your WooCommerce store. It runs automatically on a schedule and collects recent order data from WooCommerce via API. Only paid orders (Completed / Processing) are considered for revenue calculations. Cancelled orders are processed in a separate branch to track revenue loss. Orders created within the last 24 hours are filtered for both paid and cancelled orders. The workflow calculates total revenue, order count, average order value, and top-selling products. It also calculates cancelled order count and cancelled revenue to highlight potential revenue leakage. Sales and cancellation data are merged into a single structured object. An IF node checks whether revenue exceeds a predefined threshold. If the threshold is crossed, a Slack Sales Spike Alert is sent with cancellation context. If the threshold is not reached, a Slack Status / Pending Alert is sent showing progress, top products, and cancellation impact—keeping the team informed without noise. Who’s It For Business owners monitoring daily sales and revenue health Sales and marketing teams tracking revenue spikes and losses E-commerce managers using WooCommerce Operations teams monitoring cancellations and fulfillment risks Non-technical users who want actionable insights without dashboards Requirements to Use This Workflow An active WooCommerce store WooCommerce REST API credentials** An n8n instance (cloud or self-hosted) A Slack workspace with incoming webhook or Slack credentials Permission to read WooCommerce orders and post Slack messages How It Works & Set Up Schedule Trigger Configure the Schedule Trigger to run once per day at your preferred time. Fetch Orders from WooCommerce Use the WooCommerce node to retrieve recent orders from your store. Filter Paid Orders Keep only orders with status Completed or Processing. Filter Last 24 Hours Orders A Code node filters paid orders created within the last 24 hours. Calculate Top Products A Code node aggregates product quantities sold in the last 24 hours. Calculate Total Revenue A Code node calculates total revenue, order count, and average order value. Fetch & Process Cancelled Orders A separate WooCommerce branch fetches orders with status Cancelled. Cancelled orders are filtered to the last 24 hours using a Code node. A Code node calculates cancelled order count and cancelled revenue. Merge & Format Sales Data A Merge node combines sales metrics and cancellation metrics. A Code node formats all results into a single JSON object for Slack. Threshold Check An IF node compares total revenue against a fixed threshold. Send Slack Alerts TRUE path: Sends a **Sales Spike Alert including revenue, top products, and cancellation impact. FALSE path: Sends a **Status / Pending Alert showing current performance, top products, and cancellation insights. Activate Workflow Test once and activate the workflow for daily monitoring. How To Customize Nodes Threshold Value**: Update the IF node condition to match your business target Schedule Time**: Change the Schedule Trigger execution time Slack Channels**: Update Slack nodes to post in your desired channels Order Status Logic**: Adjust filters for paid or cancelled orders if needed Time Window**: Modify the 24-hour logic to 12 hours, 48 hours, or weekly Cancellation Sensitivity**: Add conditions to alert on high cancellation volume or revenue impact Add-ons (Optional Enhancements) Add cancellation rate (%) and net revenue calculations Trigger alerts when cancellation revenue exceeds a defined percentage Store daily sales and cancellation history in Google Sheets or a database Add day-over-day or week-over-week comparisons Send alerts to Microsoft Teams or Email Attach a CSV report with order and cancellation details Use Case Examples Detect viral product sales quickly Monitor flash sale performance Identify revenue loss due to cancellations Alert leadership on high-revenue or high-risk days Track campaign-driven sales spikes and drop-offs Support inventory, operations, and customer experience planning > Many more business scenarios can be addressed based on your store’s needs. Troubleshooting Guide | Issue | Possible Cause | Solution | | ---------------------------------- | -------------------------------- | ---------------------------------------- | | No Slack alert received | Revenue did not exceed threshold | Check threshold or test with lower value | | Workflow fails | WooCommerce API error | Verify API credentials and permissions | | Revenue or cancellation shows zero | Orders filtered out | Validate order status and date logic | | Slack message not sent | Wrong Slack credentials | Reconnect Slack node | | Orders missing | Timezone mismatch | Align WooCommerce and n8n timezone | Need Help? Need help setting up this workflow or customizing it further? Our n8n workflow development team at WeblineIndia can assist you with implementation, add-ons, performance optimization and building similar n8n automations tailored to your business needs. 👉 Contact WeblineIndia today to automate smarter and scale faster.

WooCommerce Seasonal Sales Planning & Monitor → SET Pattern Compare → Slack This workflow automatically aggregates sales data, calculates performance trends (Revenue & Orders) against previous months and years, identifies the top-selling SKU and sends a strictly formatted, professional summary report to Slack. This workflow runs on a schedule (e.g., daily or weekly) to generate a snapshot of your business performance. It fetches sales data from your database or e-commerce platform, calculates growth percentages (vs. Month, vs. Year), formats the data into a clean JSON structure and sends a structured report to Slack without unnecessary clutter or emojis. You receive: Automated comparison of Revenue & Order counts** Trend analysis (Percentage change & directional trend)** Identification of the Top Performing SKU** A clean, professional Slack alert for team visibility** Ideal for management teams needing a quick, data-driven pulse check on store performance without manually running reports. Quick Start – Implementation Steps Add your Database or API Credentials (e.g., Postgres, Shopify, WooCommerce) in the data fetching nodes. Connect your Slack account credentials and select the target channel. Ensure your data source provides current, vsMonth and vsYear metrics (or use the calculation nodes provided). Review the Slack Node to ensure the JSON block formatting matches your preference. Activate the workflow — automated reporting begins instantly. What It Does This workflow automates the generation of your business trend report: Trigger: Starts automatically based on a schedule (e.g., every morning at 8 AM). Fetch Data: Retrieves raw sales numbers for the current period, previous month and previous year. Process Trends: Calculates the percentage difference and determines the trend direction (Increase, Flat, Decrease). Identify Top SKU: Sorts product sales to find the highest-performing item of the period. Format Report: Constructs a strict JSON object containing: Revenue (Current, vs Month, vs Year) Orders (Current, vs Month, vs Year) Top SKU Name Send Slack Alert: Pushes a cleanly formatted message (using Block Kit or Markdown) to your team channel. This ensures your team focuses on the numbers that matter, with zero manual effort. Who’s It For This workflow is ideal for: E-commerce Store Owners Sales & Marketing Managers Data Analysts Operations Teams Executive leadership requiring daily snapshots Teams preferring data-heavy, emoji-free reports Requirements to Use This Workflow To run this workflow, you need: n8n instance** (cloud or self-hosted) Data Source** (PostgreSQL, MySQL, Shopify, WooCommerce or Google Sheets) Slack workspace** with API permissions (Webhook or Bot Token) Basic understanding of JSON structure for Slack Block Kit How It Works Scheduled Trigger – Initiates the workflow at a specific time. Get Sales Data – Queries your backend to get the raw numbers. Calculate Logic – Compares current numbers vs. historical data to generate percentages. Create Report Object – Maps the values into a standardized JSON format (e.g., revenue.current, orders.vsYear). Format Message – Converts the JSON object into a Slack-readable text block or UI block. Send Notification – Posts the final report to Slack. Setup Steps Import the provided n8n JSON file. Open the Data Fetch nodes and configure your database/API connection. Ensure your query returns the necessary fields (Revenue Orders, SKU). Verify the Format Data node is correctly mapping your variables to the JSON structure: {{ $json"revenue" }} {{ $json"orders"["percent"] }} Connect Slack API credentials and choose your channel. Run a test execution to verify the numbers appear correctly in Slack. Activate the workflow — done! How To Customize Nodes Customize Report Metrics Modify the Set/Calculation nodes: Add Average Order Value (AOV) Include Customer Acquisition Cost (CAC) Change the comparison period (e.g., vs Last Week instead of Month) Customize Slack Layout You can modify the JSON in the Slack node to: Use Block Kit for a table-like structure (columns for Revenue/Orders) Use Plain Text for a simple list view Add or remove bold formatting (bold) Add a "View Dashboard" button link Customize Data Source Replace the generic database node with: Shopify Node** (Get Orders) WooCommerce Node** (Get Sales Report) Stripe Node** (Get Balance Transactions) Google Sheets** (Read Row) Add-Ons (Optional Enhancements) You can extend this workflow to: Send reports to Email or Microsoft Teams in addition to Slack. Generate a PDF report using an HTML-to-PDF service. Save the daily snapshot into a "History" table in Airtable/Database. Add conditional alerts (e.g., @mention the CEO if Revenue drops by >20%). Integrate with OpenAI to write a qualitative analysis of the trends. Use Case Examples Morning Standup Report Delivers key metrics to the team channel 15 minutes before the daily meeting. Performance Monitoring Quickly identifies if a new marketing campaign is driving order volume. Inventory Awareness Highlights the "Top SKU" so the warehouse team knows what is moving fast. Executive Summaries Provides leadership with a noise-free, "just the numbers" view of the business. Troubleshooting Guide | Issue | Possible Cause | Solution | | :--- | :--- | :--- | | "N/A" in Trend | No historical data found | Ensure database has data for previous month/year | | Slack formatting broken | Invalid JSON syntax | Check quotes and brackets in Slack node | | Wrong Top SKU | Sorting logic incorrect | Verify the "Sort" node is ordering by Count DESC | | Authentication Error | Slack token expired | Re-connect Slack credentials in n8n | | Workflow not running | Schedule disabled | Toggle "Active" switch to ON | Need Help? If you need help customizing or extending this workflow — integrating specific ERPs, creating complex visual dashboards or scaling your data reporting, feel free to contact our n8n workflow development experts at WeblineIndia. We are happy to assist you with advanced automation solutions.

This workflow let's a bot in Slack notify a specific channel when a new product in WooCommerce is published and live on the site. Prerequisites WooCommerce account Slack and a Slack bot How it works Listen for WooCommerce product creation If permalink starts with https://[your-url-here].com/product/ Slack bot notifies channel that a new product has been added. Please note, you must update the URL in the IF node to match your url. If your WooCommerce doesn't use the slug /product/, that will need to be updated too.

This workflow uses a WooCommerce trigger that will run when an order has been updated and the status is refunded. If the value of this is over 100 it will post it to a Slack channel. To use this workflow you will need to set the credentials to use for the WooCommerce and Slack nodes, You will also need to pick a channel to post the message to.

This workflow uses a WooCommerce trigger that will run when a new product has been added, It will then post it to Slack so your team is always kept up to date with new products. To use this workflow you will need to set the credentials to use for the WooCommerce and Slack nodes, You will also need to pick a channel to post the message to.

This workflow uses a WooCommerce trigger that will run when an order has been placed. If the value of this is over 100 it will post it to a Slack channel. To use this workflow you will need to set the credentials to use for the WooCommerce and Slack nodes, You will also need to pick a channel to post the message to.