Log failed WooCommerce orders to Airtable and send OpenAI-powered Slack alerts
Ready for 3.0What this workflow does
This AI workflow has 12 nodes and runs on a schedule (every day). Along the way it connects Airtable, OpenAI and Slack.
How it runs
Trigger: On a schedule (every day).
- Set WooCommerce Domain (Edit Fields (Set)): sets 1 field: wc_domain
- Fetch Failed Orders From WooCommerce (HTTP Request): calls an HTTP API
- Process Each Failed Order (Loop Over Items (Split in Batches)): loops over the items in batches
- Search records (Airtable): search
- Attach Search Result to Order (Merge): merges the data from its input branches
- Is Order Already Logged? (If): checks a condition and branches into true / false
- Send a message (Slack): uses Slack
- Format Order Data (Code): runs custom JavaScript code
- Save Failed Order to Airtable (Airtable): create
- Generate Slack Summary Message (OpenAI): uses OpenAI
…plus 1 more step. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (10)
- Code
n8n-nodes-base.code - Airtable
n8n-nodes-base.airtable - OpenAI
@n8n/n8n-nodes-langchain.openAi - Slack
n8n-nodes-base.slack - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Merge
n8n-nodes-base.merge - If
n8n-nodes-base.if
From the author
WooCommerce Failed Order Fetch, Airtable Logging & Slack Alerts This workflow automatically checks WooCommerce for failed orders on a schedule, processes each order individually, prevents duplicate entries using Airtable, stores new failed orders centrally,…