How to Auto-Tag VIP Customers in Mailchimp with N8n

Dashboard > New Workflow

Create new N8n workflow

Start a fresh workflow in N8n. This workflow will monitor WooCommerce customer data and trigger when lifetime value thresholds are met.

1. 1Click 'New Workflow' on the N8n dashboard
2. 2Name it 'VIP Customer Tagging'
3. 3Click 'Save' to create the workflow

Workflow Canvas > Add Node > Schedule Trigger

Add WooCommerce trigger node

Set up a scheduled trigger to check WooCommerce customer data regularly. N8n doesn't have real-time WooCommerce webhooks for customer lifetime value changes.

1. 1Click the '+' button next to the Start node
2. 2Search for 'Schedule Trigger' and select it
3. 3Set interval to 'Hours' with value '2'
4. 4Click 'Execute Node' to test the schedule

Node > WooCommerce > Customer > Get All

Connect to WooCommerce

Add the WooCommerce node to fetch customer data. You'll need to configure API credentials to pull customer order totals.

1. 1Click '+' after the Schedule Trigger node
2. 2Search for 'WooCommerce' and select it
3. 3Choose 'Customer > Get All' operation
4. 4Click 'Create New Credential' for WooCommerce API

Credentials > WooCommerce API

Configure WooCommerce credentials

Input your WooCommerce REST API credentials. These allow N8n to read customer data and calculate lifetime values.

1. 1Enter your WooCommerce store URL (https://yourstore.com)
2. 2Paste Consumer Key from WooCommerce > Settings > Advanced > REST API
3. 3Paste Consumer Secret from the same location
4. 4Click 'Test' then 'Save' if connection succeeds

WooCommerce Node > Parameters

Set customer data parameters

Configure the WooCommerce node to fetch all customers with their order data. This gives you the information needed to calculate lifetime value.

1. 1Set 'Return All' to true
2. 2In 'Additional Fields' click 'Add Field'
3. 3Select 'Include' and choose 'total_spent'
4. 4Click 'Execute Node' to test the connection

Node > Function

Add function node for VIP filtering

Create a JavaScript function to identify customers who meet your VIP threshold. This code will filter for customers with $500+ lifetime value.

1. 1Click '+' after the WooCommerce node
2. 2Search for 'Function' and select it
3. 3Replace default code with the VIP filtering logic
4. 4Set the threshold to 500 (or your preferred amount)

Function Node > Code Editor

Write VIP customer filter code

Add JavaScript to filter customers above the lifetime value threshold and format data for Mailchimp. This prevents tagging existing VIP customers repeatedly.

1. 1Clear the existing function code
2. 2Paste the VIP filtering JavaScript code
3. 3Modify the threshold value if different from $500
4. 4Click 'Execute Node' to test the filter

Drop this into an n8n Code node.

// VIP customer filter with duplicate prevention
const vipThreshold = 500;
const processedCustomers = $('Schedule Trigger').first().json.processed_ids || [];

// VIP customer filter with duplicate prevention
const vipThreshold = 500;
const processedCustomers = $('Schedule Trigger').first().json.processed_ids || [];

const vipCustomers = items.filter(customer => {
  const totalSpent = parseFloat(customer.json.total_spent);
  const customerId = customer.json.id;
  
  return totalSpent >= vipThreshold && !processedCustomers.includes(customerId);
});

return vipCustomers.map(customer => ({
  email: customer.json.email,
  customer_id: customer.json.id,
  total_spent: customer.json.total_spent,
  vip_tier: customer.json.total_spent >= 1000 ? 'VIP Gold' : 'VIP'
}));

Node > Mailchimp > Member > Update

Add Mailchimp connection

Connect to Mailchimp to update customer tags. The Mailchimp node will add VIP tags to the filtered customer list.

1. 1Click '+' after the Function node
2. 2Search for 'Mailchimp' and select it
3. 3Choose 'Member > Update' operation
4. 4Click 'Create New Credential' for Mailchimp

Credentials > Mailchimp API

Configure Mailchimp API credentials

Set up Mailchimp API access using your account's API key. This allows N8n to modify subscriber tags in your audience.

1. 1Go to Mailchimp > Account > Extras > API Keys
2. 2Copy your API key
3. 3Paste it into the N8n credential field
4. 4Click 'Test Connection' then 'Save'

Mailchimp Node > Parameters

Map customer data to Mailchimp fields

Configure which Mailchimp audience to update and map customer email addresses. Set up the VIP tag that will be applied to qualifying customers.

1. 1Select your target Mailchimp audience from the dropdown
2. 2Set Email field to {{$json.email}} from the Function output
3. 3In 'Additional Fields' add 'Tags'
4. 4Set tag operation to 'Add' with tag name 'VIP'

Workflow Canvas > Execute Workflow

Test the complete workflow

Run the full workflow to verify VIP customers are properly identified and tagged in Mailchimp. Check both the N8n execution log and your Mailchimp audience.

1. 1Click 'Execute Workflow' button at the bottom
2. 2Watch each node execute and check for green success indicators
3. 3Verify customer data flows from WooCommerce to Function to Mailchimp
4. 4Check Mailchimp audience for newly applied VIP tags

Workflow Header > Active Toggle

Activate workflow scheduling

Turn on the workflow so it runs automatically every 2 hours. This ensures new VIP customers get tagged without manual intervention.

1. 1Click the 'Inactive' toggle in the top right
2. 2Confirm activation in the popup dialog
3. 3Verify the toggle shows 'Active' with a green indicator
4. 4Save the workflow one final time