How to Tag Inactive WooCommerce Customers in Mailchimp with N8n

Dashboard > New > Workflow

Create New Workflow

Start a fresh N8n workflow for the win-back campaign automation. This workflow will run daily to check purchase dates and tag inactive customers.

1. 1Click the 'New' button in the N8n dashboard
2. 2Select 'Workflow' from the dropdown menu
3. 3Name it 'WooCommerce Win-back Tagging'

Nodes > Trigger > Schedule Trigger

Add Schedule Trigger

Set up a daily schedule to check for customers who need win-back tags. Daily checking ensures you catch customers right at the 90-day mark.

1. 1Click the + icon next to the Start node
2. 2Search for 'Schedule Trigger' in the node list
3. 3Set Interval to 'Days' and Value to '1'
4. 4Set Trigger Time to '09:00' for morning execution

Nodes > Regular > WooCommerce

Connect WooCommerce Node

Add WooCommerce node to fetch all orders from the past 91 days. We need 91 days to identify customers whose last purchase was exactly 90 days ago.

1. 1Click + after the Schedule Trigger node
2. 2Search for 'WooCommerce' and select it
3. 3Choose 'Order > Get All' operation
4. 4Enter your WooCommerce API credentials (Consumer Key and Secret)
5. 5Set 'After' parameter to {{ $now.minus({days: 91}).toISO() }}

Nodes > Regular > Code

Add JavaScript Filter Node

Filter customers whose last purchase was exactly 90 days ago. This code node will calculate purchase dates and identify win-back candidates.

1. 1Click + after WooCommerce node
2. 2Select 'Code > JavaScript'
3. 3Paste the customer filtering code in the editor
4. 4Set the node name to 'Filter 90-Day Inactive'

Drop this into an n8n Code node.

// Filter orders to exactly 90 days ago and dedupe customers
const targetDate = new Date();
targetDate.setDate(targetDate.getDate() - 90);

// Filter orders to exactly 90 days ago and dedupe customers
const targetDate = new Date();
targetDate.setDate(targetDate.getDate() - 90);
const targetDateStr = targetDate.toISOString().split('T')[0];

const uniqueCustomers = [];
const seenEmails = new Set();

for (const order of $input.all()) {
  const orderDate = order.json.date_completed.split('T')[0];
  if (orderDate === targetDateStr && order.json.status === 'completed') {
    const email = order.json.billing.email.toLowerCase();
    if (!seenEmails.has(email)) {
      seenEmails.add(email);
      uniqueCustomers.push({email: email, order_total: order.json.total});
    }
  }
}

return uniqueCustomers.map(customer => ({json: customer}));

Nodes > Regular > Code

Add Customer Email Extraction

Extract unique customer emails from the filtered orders. Multiple orders from the same customer should only generate one tag operation.

1. 1Click + after the JavaScript node
2. 2Add another 'JavaScript' node
3. 3Name it 'Extract Unique Emails'
4. 4Add code to deduplicate customer emails from order data

Nodes > Regular > Mailchimp

Connect Mailchimp Node

Add Mailchimp connection to find contacts by email address. We need to locate existing contacts before we can tag them.

1. 1Click + after the email extraction node
2. 2Search for 'Mailchimp' and select it
3. 3Choose 'Member > Get' operation
4. 4Enter your Mailchimp API key
5. 5Set List ID to your main customer list
6. 6Map Email field to {{ $json.email }}

Node Settings > Settings > Continue on Fail

Add Error Handling for Missing Contacts

Handle cases where WooCommerce customers don't exist in Mailchimp. Some customers might have unsubscribed or been manually removed.

1. 1Click the Mailchimp node settings (three dots)
2. 2Go to 'Settings' tab
3. 3Set 'Continue on Fail' to true
4. 4Add an IF node after Mailchimp to check for successful responses

Nodes > Regular > Mailchimp

Add Win-back Tag Application

Apply the 'win-back' tag to found Mailchimp contacts. This tag will trigger your existing Mailchimp automation sequence.

1. 1Click + after the IF node (true branch)
2. 2Add another Mailchimp node
3. 3Choose 'Member > Update' operation
4. 4Set List ID to the same list as before
5. 5Map Email to {{ $json.email_address }}
6. 6Add 'win-back' to the Tags array field

Nodes > Regular > HTTP Request

Add Success Logging

Log successful tag applications for monitoring and debugging. Track how many customers get tagged each day.

1. 1Click + after the Mailchimp Update node
2. 2Add 'HTTP Request' node pointing to a logging service
3. 3Or add 'Webhook' node to send data to Google Sheets
4. 4Include email, tag date, and success status in the log

Workflow > Execute Workflow

Test with Sample Data

Execute the workflow manually with a small date range to verify tagging works correctly. Test prevents accidentally tagging your entire customer base.

1. 1Change the WooCommerce date filter to last 7 days temporarily
2. 2Click 'Execute Workflow' button
3. 3Check N8n execution log for any errors
4. 4Verify tags appeared in Mailchimp for test contacts

Workflow > Active Toggle

Activate Scheduled Execution

Turn on the workflow to run automatically each morning. The schedule trigger will execute daily at your configured time.

1. 1Click the 'Inactive' toggle in the top-right corner
2. 2Confirm activation in the popup dialog
3. 3Restore the 91-day date filter in WooCommerce node
4. 4Save the workflow with Ctrl+S