The Scheduled Import as a "Trigger Engine" for Daily Campaigns

While native Shopify Flow offers a "Scheduled Time" (Run daily) trigger, relying on it to query and search through tens of thousands of customer profiles for specific dates—like birthdays or anniversaries—often leads to pagination limits, timeouts, and failed executions. This document outlines a superior, highly scalable architecture: using Accentuate Custom Fields (ACF) Scheduled Imports as the precise "Trigger Engine" to build lightweight, targeted retention flows.

1. Architectural Overview

Instead of forcing Shopify Flow to "pull" and scan your entire database every day, we invert the model so your data "pushes" only the exact targets into Flow.

A daily scheduled import runs in the background, updating a specific boolean (true/false) metafield only for customers who meet the daily criteria (e.g., their birthday is today). This bulk update fires the ACF Metafield Value Changed trigger, feeding Shopify Flow the exact list of customers to email, completely bypassing the need for complex, heavy queries.

2. System Prerequisites

• Accentuate Custom Fields (ACF): A configured customer metafield to act as the trigger flag (e.g., namespace: marketing, key: send_birthday_flow, type: boolean/text).

• External Data Source: A dynamically updating CSV, Google Sheet, or ERP export that calculates whose date is "today" and outputs a list of those specific customer emails/IDs.

• Shopify Flow: Active to handle the event processing and email dispatch.

3. Workflow Construction Matrix

The following table outlines the Flow components required to execute the daily campaign using the ACF trigger.

Component	Configuration Parameters	Strategic Purpose
Trigger	ACF: Metafield Value Changed	Catches the daily scheduled import updates in real-time.
Condition	Check if Namespace = marketing AND Key = send_birthday_flow AND New_Value = true	Filters out background noise. Ensures the Flow only progresses if the import explicitly flags the customer for today's campaign.
Action 1 (Email)	Send Marketing Email (via Shopify Email or integration)	Dispatches the personalized birthday/anniversary discount to the customer.
Action 2 (ACF Reset)	Update Metafield: Set send_birthday_flow to false	Crucial cleanup step: Resets the trigger flag to prevent duplicate emails from being sent in case of overlapping imports.

4. Step-by-Step Implementation

Phase 1: Configure the Scheduled Import

1. In your external CRM or spreadsheet tool, filter your customer list to export only individuals whose targeted date (e.g., Birthday) matches today's date. The export should include the Customer ID (or Email) and a column containing the value true.

2. In the Accentuate dashboard, navigate to the Bulk Import utility.

3. Map the true value column to the marketing.send_birthday_flow metafield definition.

4. Set the Schedule Import to run daily at a designated time (e.g., 08:00 AM) to automatically fetch and process this list.

Phase 2: Build the Flow

1. In Shopify Flow, select the ACF Metafield Value Changed trigger.

2. Add a Condition node verifying the exact namespace and key, ensuring the New_Value equals true.

3. Add the Send Email action to deliver the campaign.

4. Add a final Set Metafield Value action via ACF to overwrite the flag back to false, permanently closing the automation loop for that user until next year.

5. The Advantage Over Native "Run Daily"

By utilizing ACF scheduled imports as the engine, you eliminate the risk of Flow timing out while iterating over 100,000+ customer records. Flow remains dormant until ACF hands it the exact, pre-filtered batch of 50 customers who need emails today. This guarantees 100% deliverability, minimal compute usage, and a completely scalable retention system without needing an expensive enterprise ESP.