Automate e-commerce orders, inventory & feedback with Slack, Sheets & Gmail

How It Works ⚙️

This workflow acts as a central nervous system for your e-commerce operations, automating three critical areas:

A. Order Fulfillment Notification 1. Webhook: New Order: 🚀 The workflow is instantly triggered when a new order is placed on your e-commerce platform (e.g., Shopify, WooCommerce) via a webhook. This provides real-time data to initiate fulfillment. 2. Extract Order Data (Function): 🧹 This node parses the incoming JSON data from the new order, extracting crucial details such as Order ID, customer name, email, total amount, products purchased, and shipping address. 3. Send Fulfillment Notification (Slack/Email): 📢 A detailed, formatted notification containing all necessary order information is immediately sent to your designated fulfillment team's Slack channel or email inbox, ensuring prompt order processing.

B. Low Stock Alert 1. Schedule Trigger (Daily Inventory Check): ⏰ The workflow runs automatically once every 24 hours (or at your configured interval) to regularly monitor your product inventory levels. 2. Read Inventory Data (Google Sheets/API): 📊 It connects to your chosen inventory data source (e.g., a Google Sheet configured with product IDs, names, and stock levels, or an e-commerce platform API) to retrieve current stock data for all products. 3. Filter Low Stock (Function): 🧹 This node processes the retrieved inventory data. It uses a defined threshold (e.g., 10 units) to identify and filter out any products whose current stock level falls below this critical limit. 4. If Low Stock Items?: 🚦 This conditional node checks if the previous step found any products that are low on stock. If yes, it proceeds to send an alert. 5. Send Low Stock Alert (Slack/Email): 🚨 A warning notification is sent to your purchasing or inventory management team via Slack or email, providing details on the low-stock items and prompting them to reorder before stock runs out, preventing lost sales.

C. Post-Purchase Feedback Request 1. Webhook: Order Fulfilled (Delayed): 📦 This branch is triggered when an order is marked as fulfilled or delivered in your e-commerce system. Crucially, this webhook should be sent by your e-commerce platform or a separate automation after a specific delay (e.g., 3-7 days post-delivery) to ensure the customer has received and experienced the product. 2. Extract Customer Data (Feedback) (Function): 🧹 This node extracts the customer's name and email address from the fulfilled order data, preparing it for the feedback request. 3. Send Feedback Request (Gmail/Email Service): 📧 A personalized email is sent to the customer. This email thanks them for their purchase and includes a direct link to your chosen customer feedback form (e.g., Google Form, Typeform). This systematic approach encourages valuable insights for continuous business improvement.

---

How to Set Up 🛠️

Follow these steps carefully to get your "E-commerce Operations Hub" workflow up and running in n8n: