How to Add WooCommerce Customers to Mailchimp Audience with Pipedream

Pipedream Dashboard > Workflows > New

Create new Pipedream workflow

Navigate to pipedream.com and click Workflows in the left sidebar. Hit the green New button in the top right corner. You'll see the workflow builder with an empty trigger step. This is where we'll configure the WooCommerce webhook listener.

1. 1Click Workflows in the left navigation
2. 2Click the green New button
3. 3Select 'Build your own' from the template options

Workflow Builder > Select a trigger > HTTP / Webhook

Add WooCommerce webhook trigger

Click on the trigger step and search for 'webhook' in the app list. Select 'HTTP / Webhook' as your trigger type. Choose 'New Requests' which gives you an instant webhook URL. Copy this URL - you'll paste it into WooCommerce in the next step.

1. 1Click 'Select a trigger' in the workflow
2. 2Type 'webhook' in the search box
3. 3Select 'HTTP / Webhook' from the results
4. 4Choose 'New Requests' as the trigger event
5. 5Copy the webhook URL that appears

WordPress Admin > WooCommerce > Settings > Advanced > Webhooks

Configure WooCommerce webhook

In your WordPress admin, go to WooCommerce > Settings > Advanced > Webhooks. Click Add webhook and set the Topic to 'Order updated'. Paste your Pipedream webhook URL in the Delivery URL field. Set Status to Active and save.

1. 1Navigate to WooCommerce > Settings in WordPress admin
2. 2Click the Advanced tab, then Webhooks
3. 3Click 'Add webhook' button
4. 4Set Topic to 'Order updated'
5. 5Paste the Pipedream URL in Delivery URL field
6. 6Set Status to Active and click Save webhook

Pipedream Workflow > Trigger Step > Test

Test webhook connection

Place a test order in your WooCommerce store and mark it as completed. Go back to Pipedream and click the refresh icon on your trigger step. You should see the order data appear in the trigger test section.

1. 1Complete a test order in your WooCommerce store
2. 2Change the order status to 'Completed' in WooCommerce admin
3. 3Return to Pipedream workflow
4. 4Click the refresh icon on the webhook trigger
5. 5Select the test event from the dropdown

Workflow Builder > Add Step > Filter

Add order status filter

Click the + button below your trigger to add a new step. Search for 'filter' and select the built-in Filter step. Set the condition to only continue when order status equals 'completed'. This prevents processing draft or pending orders.

1. 1Click the + button below the trigger step
2. 2Search for 'filter' and select Filter
3. 3Set the condition to 'Continue when...'
4. 4Choose 'steps.trigger.event.status' equals 'completed'
5. 5Save the filter configuration

Workflow Builder > Add Step > Mailchimp > Add Member to List

Add Mailchimp step

Add another step and search for Mailchimp. Select the 'Add Member to List' action. You'll need to connect your Mailchimp account by clicking 'Connect Account' and following the OAuth flow. Choose your target audience from the dropdown.

1. 1Click + to add a step after the filter
2. 2Search for 'Mailchimp' and select it
3. 3Choose 'Add Member to List' action
4. 4Click 'Connect Account' and authorize Pipedream
5. 5Select your target audience from the List ID dropdown

Mailchimp Step > Field Mapping

Map customer fields

Map the email field to the billing email from your WooCommerce order data. Add the customer's first and last name from the billing details. Set the status to 'subscribed' if you have explicit consent, or 'pending' to send a confirmation email.

1. 1Set Email to steps.trigger.event.billing.email
2. 2Set First Name to steps.trigger.event.billing.first_name
3. 3Set Last Name to steps.trigger.event.billing.last_name
4. 4Choose 'subscribed' for Status (or 'pending' for double opt-in)
5. 5Leave other fields blank for now

Workflow Builder > Add Step > Code > Node.js

Add tagging logic step

Before the Mailchimp step, add a Node.js code step to generate tags based on purchase data. This code will analyze line items for product categories and order total for value tiers. The output becomes tags for Mailchimp.

1. 1Add a code step between the filter and Mailchimp step
2. 2Select 'Run Node.js Code'
3. 3Delete the default code
4. 4Paste the tagging logic code
5. 5Save the code step

Mailchimp Step > Tags Field

Configure Mailchimp tags

In your Mailchimp step, scroll down to find the Tags field. Map this to the tags array output from your code step. This ensures each customer gets tagged with their product categories and order value tier automatically.

1. 1Scroll to the Tags section in Mailchimp configuration
2. 2Click in the Tags field
3. 3Select the tags array from your code step output
4. 4Verify the mapping shows as an array
5. 5Save the Mailchimp step

Workflow Builder > Deploy

Test complete workflow

Deploy your workflow by clicking the Deploy button. Place another test order in WooCommerce, mark it completed, and check your Mailchimp audience. The customer should appear with appropriate tags within 30 seconds.

1. 1Click the Deploy button in the top right
2. 2Place and complete a test order
3. 3Wait 30 seconds and check Mailchimp audience
4. 4Verify the contact appears with correct tags
5. 5Check the workflow execution log for any errors

This Node.js code analyzes WooCommerce order data to generate smart tags for customer segmentation. Paste it into a code step between your filter and Mailchimp action.

export default defineComponent({
  async run({ steps, $ }) {
    const order = steps.trigger.event;

export default defineComponent({
  async run({ steps, $ }) {
    const order = steps.trigger.event;
    const tags = [];
    
    // Add category tags from line items
    if (order.line_items && order.line_items.length > 0) {
      const categories = new Set();
      
      order.line_items.forEach(item => {
        // Extract categories from product metadata
        if (item.meta_data) {
          const categoryMeta = item.meta_data.find(meta => meta.key === '_product_categories');
          if (categoryMeta && categoryMeta.value) {
            categoryMeta.value.split(',').forEach(cat => {
              categories.add(`${cat.trim().toLowerCase()}-buyer`);
            });
          }
        }
      });
      
      tags.push(...Array.from(categories));
    }
    
    // Add order value tier tags
    const total = parseFloat(order.total || '0');
    if (total >= 200) {
      tags.push('high-value-customer');
    } else if (total >= 75) {
      tags.push('mid-value-customer');
    } else {
      tags.push('low-value-customer');
    }
    
    // Add purchase frequency tag for returning customers
    if (order.customer_id && order.customer_id !== '0') {
      tags.push('returning-customer');
    } else {
      tags.push('first-time-buyer');
    }
    
    // Add seasonal tags based on order date
    const orderDate = new Date(order.date_created);
    const month = orderDate.getMonth();
    if (month >= 10 || month <= 1) {
      tags.push('holiday-shopper');
    }
    
    return { tags: tags.filter(tag => tag.length > 0) };
  }
});