Home/Browse/Score Shopify customer churn risk and sync results to Klaviyo, Slack, and Gmail

Score Shopify customer churn risk and sync results to Klaviyo, Slack, and Gmail

n8n22 modulesv1.0

ShopifyGmailSlackKlaviyo

At a glance

Score Shopify customer churn risk and sync results to Klaviyo, Slack, and Gmail is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Shopify, Gmail, Slack, Klaviyo. It's free to download. Follow the 5-step import below to go live in minutes.

About this workflow

Quick overview This workflow runs weekly to fetch customers from the Shopify Admin GraphQL API, calculate churn risk based on each customer’s median reorder interval, and then sync at-risk customers to Klaviyo while sending a CSV report and summary to Slack and/or Gmail. How it works 1. Runs weekly on a schedule and loads your Shopify domain, thresholds, and toggles for Klaviyo, Slack, and Gmail alerts. 2. Queries the Shopify Admin GraphQL API in pages of 100 customers filtered by minimum order count and an order-date window that excludes very recent purchasers. 3. Calculates each customer’s median days between recent orders, computes days since last order, and labels customers as MEDIUM or HIGH risk based on the days-since-last vs. median interval ratio. 4. Stores at-risk customers across pagination and continues fetching until Shopify reports there are no more pages. 5. Retrieves the full at-risk customer list, clears stored data for the next run, and stops if no at-risk customers are found. 6. If enabled, updates each at-risk customer profile in Klaviyo by writing churnrisk and dayssincelastorder via the Klaviyo API. 7. Generates a dated CSV of at-risk customers, aggregates counts and revenue-at-risk totals, and sends the summary with the CSV attached to Slack and/or Gmail. Setup 1. Add Shopify Admin API credentials (Header Auth) and set your shopifyDomain value in the workflow configuration. 2. Add a Klaviyo Private API key (HTTP Header Auth) if you want to sync profile properties to Klaviyo. 3. Connect your Gmail OAuth2 credential and set the recipient email address if you want email alerts. 4. Connect your Slack credential and set the target Slack channel ID if you want Slack alerts and error notifications. 5. In the workflow configuration, enable or disable emailAlert, slackAlert, and klaviyoEvent, and adjust minimumOrderRequired, customerActiveDays, and safeDays to match your store’s buying cycles. Requirements - Shopify store with Admin API access (GraphQL endpoint). - Klaviyo account for profile updates. - Slack workspace and Gmail account for reporting.

Score Shopify customer churn risk and sync results to Klaviyo, Slack, and Gmail

At a glance

About this workflow

How to import this n8n workflow

Setup guide

Step 1: Connect your apps

Step 2: Import the workflow JSON

More N8n workflows

Reviews