🤝 Identify and notify WooCommerce VIP customers with Airtable and Slack

⚡ 8 views · 🤝 CRM & Sales Operations

Description

WooCommerce VIP Customer Automation

This workflow automatically identifies VIP customers from your WooCommerce store based on their total spending and number of completed orders. It pulls new orders on a schedule, filters valid transactions, groups customers, calculates their VIP tier, stores them into Airtable and notifies your team in Slack.It removes all manual checking and ensures your team instantly knows when a high-value customer places an order.

Quick Start – Implementation Steps

  1. Add your WooCommerce store domain and API credentials inside n8n.
  2. Configure Airtable and Slack credentials.
  3. Adjust VIP rules (lifetime spend or total orders) if needed.
  4. Activate the workflow — it will automatically detect VIPs and alert your team.

What It Does

This workflow fully automates VIP customer detection for WooCommerce stores. Every few minutes, it retrieves new orders via WooCommerce API. It filters only processing or completed orders and extracts essential fields such as customer ID, customer name order total and timestamps.

The workflow then groups orders by customer to ensure duplicate orders don’t inflate metrics. For each customer, it fetches their complete order history, calculates lifetime value, counts total paid orders and assigns a VIP tier (Platinum, Gold or Silver).

Once a customer qualifies, their details are saved into Airtable for tracking. A Slack message is simultaneously sent to inform your team so they can take immediate action — such as providing priority support, follow-up messages or special offers.

This system runs completely on its own and keeps customer insights up-to-date without manual checks.

Who’s It For

This workflow is ideal for:

Requirements to Use This Workflow

You will need:

How It Works

  1. Scheduled Trigger – Runs every few minutes to check for new orders.
  2. Domain Setup – Assigns the WooCommerce store domain used across API calls.
  3. Fetch Orders – Retrieves all orders from WooCommerce.
  4. Filter Valid Orders – Only keeps completed or processing orders.
  5. Format & Clean Data – Extracts only key order details.
  6. Deduplicate Customers – Only the first order per customer is processed.
  7. Fetch Order History – Gets lifetime order history for each customer.
  8. Calculate VIP Tier – Determines Platinum/Gold/Silver based on spend or order count.
  9. Filter VIP Only – Removes customers who do not qualify.
  10. Save to Airtable – Creates/updates VIP records.
  11. Notify Team on Slack – Sends VIP alerts instantly.

Setup Steps

  1. Import this workflow JSON into n8n.
  2. Enter your WooCommerce API credentials in the HTTP Request nodes.
  3. Update the wc_domain value in the “Set WooCommerce Domain” node.
  4. Configure Airtable credentials and select your Base + Table.
  5. Set your Slack channel ID inside the Slack node.
  6. Adjust VIP rules inside the “Calculate VIP Tier” code node if needed.
  7. Activate the workflow — it will now run automatically.

How to Customize Nodes

Adjust VIP Rules

Edit the logic inside Calculate VIP Tier:

Customize Airtable Fields

You can modify:

Customize Slack Alerts

In the Slack node, change:

Add-Ons (Optional Enhancements)

You can extend this workflow with:

Use Case Examples

  1. Notify support about high-value customers
  2. Track customers crossing spending milestones
  3. Identify loyal customers with 5+ repeat purchases
  4. Automatically sync VIP customers to CRM
  5. Trigger loyalty coupon generation

Troubleshooting Guide

IssuePossible CauseSolution
No orders fetchedWrong domain or API keysUpdate WooCommerce credentials
VIP not detectedCustomer has low spend or low ordersVerify VIP rules in “Calculate VIP Tier”
Airtable record not createdIncorrect table schemaMatch Airtable fields with node mapping
Slack alert missingWrong Slack channel ID or credentialsRe-check Slack authentication
Guest users includedMissing customer_id filterEnsure customer_id != 0 condition stays in place

Need Help?

If you need assistance integrating this workflow, customizing VIP rules or adding new automations, our automation team at WeblineIndia is happy to help.

You can also extend this system with loyalty engines, advanced analytics, multi-store support or any custom automation tailored for your eCommerce business.

đź”— Nodes Used

Airtable, HTTP Request, Slack, Schedule Trigger

đź“Ą Import

Download workflow.json and import into n8n: Workflow menu → Import from File

📖 Importing guide · 🔑 Credential setup