How to VIP customer tagging with Power Automate

My flows > + New flow > Automated cloud flow

Create new automated flow

Go to make.powerautomate.com and sign in with your Microsoft account. Click 'My flows' in the left sidebar, then click '+ New flow' at the top. Select 'Automated cloud flow' from the dropdown menu. Name your flow 'VIP Customer Tagging' and leave the trigger selection for the next step.

1. 1Click 'My flows' in the left navigation
2. 2Click the '+ New flow' button
3. 3Select 'Automated cloud flow'
4. 4Enter 'VIP Customer Tagging' as the flow name
5. 5Click 'Create' without selecting a trigger

Flow designer > Trigger > Search connectors

Add WooCommerce trigger

Click the trigger step and search for 'WooCommerce' in the connector list. Select 'When an order is created or updated' as your trigger. This polls WooCommerce every 5 minutes for order changes. You'll need to create a new connection by entering your WooCommerce store URL, consumer key, and consumer secret.

1. 1Click the empty trigger step
2. 2Type 'WooCommerce' in the search box
3. 3Select 'WooCommerce' from results
4. 4Choose 'When an order is created or updated'
5. 5Click '+ New connection' and enter your store credentials

Flow designer > + New step > Control > Condition

Add condition to filter orders

Click '+ New step' below the trigger. Search for 'Condition' and select the Control connector's Condition action. This filters out orders that don't meet our VIP threshold. In the left box, we'll add an expression to calculate total customer spend. In the right box, enter 500 as our VIP threshold value.

1. 1Click '+ New step' under the WooCommerce trigger
2. 2Search for 'Condition' and select it
3. 3Leave the left condition box empty for now
4. 4Set the operator to 'is greater than or equal to'
5. 5Enter '500' in the right value box

Between trigger and condition > + > WooCommerce > Get a customer

Get customer total from WooCommerce

Above the condition, add a new step by clicking the '+' button between trigger and condition. Search for 'WooCommerce' and select 'Get a customer'. Map the Customer ID from the trigger's billing email or customer ID field. This retrieves the customer's total spent amount from WooCommerce which we'll use in our condition.

1. 1Click the '+' button between trigger and condition steps
2. 2Search for 'WooCommerce' again
3. 3Select 'Get a customer' action
4. 4Click in Customer ID field
5. 5Select 'customer_id' from dynamic content

Condition step > Left value > Dynamic content

Complete the condition logic

Go back to your condition step and click in the left value box. From dynamic content, select 'total_spent' from the 'Get a customer' step. This compares each customer's lifetime value against your $500 VIP threshold. The condition will only proceed to the 'Yes' branch when customers cross this amount.

1. 1Click back into the Condition step
2. 2Click in the left value box
3. 3Select 'total_spent' from Get a customer dynamic content
4. 4Verify operator is 'is greater than or equal to'
5. 5Confirm right side shows '500'

Condition Yes branch > Add an action > Mailchimp

Add Mailchimp connection

In the 'Yes' branch of your condition, click 'Add an action'. Search for 'Mailchimp' and select the Mailchimp connector. Choose 'Add or update a list member' action. Create a new connection by clicking '+ New connection' and authenticating with your Mailchimp account through OAuth.

1. 1Click 'Add an action' in the Yes branch
2. 2Type 'Mailchimp' in the search box
3. 3Select 'Mailchimp' connector
4. 4Choose 'Add or update a list member'
5. 5Click '+ New connection' and complete OAuth

Mailchimp action > Field mapping

Configure Mailchimp list and member

Select your target audience from the List dropdown. In the Email Address field, map the billing email from your WooCommerce trigger data. Set Status to 'subscribed' to ensure the contact remains active. Leave other demographic fields empty for now — we'll focus on just adding the VIP tag.

1. 1Click the List dropdown and select your main audience
2. 2Click Email Address field
3. 3Select 'billing email' from WooCommerce trigger data
4. 4Set Status dropdown to 'subscribed'
5. 5Leave First Name and Last Name empty

Mailchimp action > Tags section > Add new item

Add VIP tag to member

Scroll down in the Mailchimp action to find the Tags field. Click 'Add new item' and type 'VIP' as your tag name. Set the tag status to 'active' to apply it to the contact. This tag will be visible in Mailchimp for segmentation and can trigger automated email campaigns for VIP-only offers.

1. 1Scroll to the Tags section in Mailchimp action
2. 2Click 'Add new item' button
3. 3Type 'VIP' in the Name field
4. 4Set Status dropdown to 'active'
5. 5Leave other tag fields as defaults

Top toolbar > Save > Test > Manually

Test the flow

Click 'Save' in the top right, then click 'Test' button. Choose 'Manually' and click 'Test' again. The flow will check for recent WooCommerce orders and process any that meet your VIP criteria. Check the run history to see if customers were properly tagged in Mailchimp.

1. 1Click 'Save' button in top toolbar
2. 2Click 'Test' button next to Save
3. 3Select 'Manually' trigger option
4. 4Click 'Test' to start the test run
5. 5Monitor the test results in real-time

Use this Power Fx expression in the condition step to convert WooCommerce's string currency values to numbers for reliable comparison against your VIP threshold. Paste this in the left value box of your condition step.

float(
  replace(
    replace(

float(
  replace(
    replace(
      outputs('Get_a_customer')?['body/total_spent'],
      '$', ''
    ),
    ',', ''
  )
)