Segment retail customers by purchase behavior with CRM and Google Sheets

(Retail Automation) Auto-Segment Customers by Purchase Behavior

This workflow automatically segments customers based on their purchase behavior whenever a new order or customer update event is received from platforms like WooCommerce, Shopify, or a CRM. It classifies customers into meaningful segments such as new customers, repeat customers, VIP customers, or inactive customers, syncs these segment tags to a CRM or email platform and logs each segmentation event in Google Sheets for tracking and auditing.

Quick Implementation Steps

1. Import the workflow JSON into n8n. 2. Configure the Webhook URL in your eCommerce platform or CRM. 3. Review and adjust segmentation rules if needed. 4. Configure the CRM API endpoint and Google Sheets credentials. 5. Activate the workflow and test with sample events.

What It Does

This workflow listens for customer-related events such as order creation or customer updates via a webhook. Incoming payloads are normalized to extract essential customer and behavioral data, including order count, lifetime spend, last order date, product categories and source system.

Using rule-based logic, the workflow evaluates customer behavior and assigns an appropriate segment tag. Customers are classified into segments such as new customers, repeat customers, VIP customers, or inactive customers based on purchase frequency, total spend and recency of activity.

Once a segment is determined, the workflow syncs the assigned segment tag to a CRM or email marketing platform and logs the segmentation event in Google Sheets. This ensures clean customer segmentation, consistent tagging and visibility for reporting and audits.