How to tag VIP customers in Mailchimp with Pipedream

Pipedream Dashboard > New Workflow

Create new Pipedream workflow

Go to pipedream.com and click New Workflow in the top right. You'll see the workflow builder with an empty trigger step. This is where you'll configure the WooCommerce webhook that fires when orders are created or updated. The trigger step is automatically created for you.

1. 1Click New Workflow button
2. 2Name your workflow 'VIP Customer Tagging'
3. 3Click Save to initialize the workflow

Trigger Step > Select App > WooCommerce

Configure WooCommerce webhook trigger

Click on the trigger step and search for WooCommerce. Select 'New Order' from the trigger options. You'll need to connect your WooCommerce store by entering your store URL, consumer key, and consumer secret. The webhook will automatically register with your WooCommerce store.

1. 1Click the empty trigger step
2. 2Search for 'WooCommerce' in the app list
3. 3Select 'New Order (Instant)' trigger
4. 4Click Connect Account

WooCommerce Connection > API Settings

Add WooCommerce API credentials

Enter your WooCommerce store URL without the trailing slash. Paste your consumer key and secret from WooCommerce > Settings > Advanced > REST API. Set permissions to Read/Write so Pipedream can fetch customer lifetime value data. Test the connection to verify it works.

1. 1Enter your store URL (e.g., https://mystore.com)
2. 2Paste Consumer Key from WooCommerce REST API settings
3. 3Paste Consumer Secret
4. 4Click Test to verify connection

Add Step > WooCommerce > Get Customer

Add customer lifetime value calculation step

Click the + button below the trigger to add a new step. Choose 'WooCommerce' from the app list and select 'Get Customer' action. This pulls the customer record associated with the order, which contains lifetime value data. Configure it to use the customer ID from the trigger data.

1. 1Click the + button below the WooCommerce trigger
2. 2Search for 'WooCommerce' again
3. 3Select 'Get Customer' action
4. 4Map Customer ID from the trigger data

Add Step > Code > Node.js

Add conditional logic for VIP threshold

Add a Code step to check if the customer's total_spent exceeds $500. Use Node.js to compare the value and stop execution if they don't qualify as VIP. This prevents unnecessary API calls to Mailchimp for customers below the threshold. The code will use async/await syntax.

1. 1Click + to add another step
2. 2Select 'Code' from the step types
3. 3Choose 'Run Node.js code'
4. 4Name the step 'Check VIP Status'

Add Step > Mailchimp > Update Member

Connect to Mailchimp

Add a Mailchimp step and select 'Update Member' action. Connect your Mailchimp account using OAuth — click the Connect button and authorize Pipedream access. Choose your audience from the dropdown list. This step will add the VIP tag to existing subscribers or create them if they don't exist.

1. 1Click + to add a Mailchimp step
2. 2Select 'Update Member' action
3. 3Click Connect Account and authorize OAuth
4. 4Select your target audience from dropdown

Mailchimp Step > Field Mapping

Map customer email and data

Map the email address from WooCommerce customer data to Mailchimp's email_address field. Set the status to 'subscribed' if you want to add new customers automatically. Configure merge fields like first name, last name, and any custom fields your audience uses. The email field is required for the update to work.

1. 1Map email from WooCommerce customer to email_address
2. 2Set status to 'subscribed'
3. 3Map first_name and last_name from customer data
4. 4Configure any custom merge fields

Mailchimp Step > Tags Section

Configure VIP tag assignment

In the Mailchimp step, find the tags section and add 'VIP' as a static tag. You can also add dynamic tags based on order data, like the total spent amount or order date. Mailchimp tags are case-sensitive, so be consistent with your naming. Test the step to verify the tag applies correctly.

1. 1Scroll to the Tags section in Mailchimp step
2. 2Click Add Tag
3. 3Enter 'VIP' as tag name
4. 4Optionally add dynamic tags from order data

Workflow > Deploy > Test

Test the complete workflow

Click Deploy to activate your workflow. Place a test order in WooCommerce for a customer whose lifetime value exceeds $500. Check your Pipedream workflow logs to see each step execute. Verify the customer receives the VIP tag in your Mailchimp audience. The entire process should complete within 30-60 seconds.

1. 1Click Deploy button to activate workflow
2. 2Place test order in WooCommerce
3. 3Check workflow execution logs
4. 4Verify VIP tag in Mailchimp audience

Add this code to the VIP threshold check step to handle edge cases like refunds and prevent duplicate tagging. Paste this in the Code step after the WooCommerce customer lookup.

export default defineComponent({
  async run({ steps, $ }) {
    const customer = steps.get_customer.$return_value;

export default defineComponent({
  async run({ steps, $ }) {
    const customer = steps.get_customer.$return_value;
    const currentOrder = steps.trigger.event;
    
    // Add current order to lifetime total
    const totalSpent = parseFloat(customer.total_spent) + parseFloat(currentOrder.total);
    const vipThreshold = 500.00;
    
    // Check if customer qualifies for VIP
    if (totalSpent < vipThreshold) {
      $.flow.exit('Customer total $' + totalSpent.toFixed(2) + ' below VIP threshold');
      return;
    }
    
    // Check if already VIP to prevent duplicate processing
    const wasVip = parseFloat(customer.total_spent) >= vipThreshold;
    const isNewVip = !wasVip && totalSpent >= vipThreshold;
    
    return {
      total_spent: totalSpent,
      is_new_vip: isNewVip,
      customer_email: customer.email,
      vip_date: isNewVip ? new Date().toISOString().split('T')[0] : null
    };
  }
});