Quick Overview
Quick Overview This workflow receives ecommerce orders via a webhook, formats key order fields, appends each order to Google Sheets, and posts a Slack notification to different channels based on whether the order total exceeds 200. How it works Receives a POST webhook request containing a new order payload from your store. Extracts and normalizes the order ID, customer name, email, total, and items from the webhook body. Appends the order data to a Google Sheets spreadsheet for logging and reporting. Compares the numeric order total to a 200 threshold to determine whether the order is high value. Posts a message to a Slack VIP channel for orders over 200, or to a standard Slack orders channel for all other orders. Returns a JSON confirmation response (including the order ID) back to the webhook caller. Setup Configure your store to send new order events to this workflow’s webhook URL (POST /new-order). Add a Google Sheets OAuth2 credential and set the target spreadsheet and sheet where orders should be appended. Add a Slack OAuth2 credential and set the channel IDs for the VIP and standard order notifications. Adjust the high-value threshold (currently 200) to match your order routing needs and ensure the incoming payload includes order_id, customer_name, email, total, and items. An n8n automation workflow template by Redowan Ahmed Farhan.
Redowan Ahmed Farhan
web
free
Others in the same category, ranked by how often they are opened.
