Log ecommerce orders, send Slack alerts, and store data in Google Sheets

Description

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.