> For the complete documentation index, see [llms.txt](https://help.accentuate.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.accentuate.io/flow-examples/the-scheduled-import-as-a-trigger-engine-for-daily-campaigns.md).

# 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            | <p>Check if Namespace = marketing</p><p>AND Key = send\_birthday\_flow</p><p>AND New\_Value = true</p> | 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.        |

\ <br>

### 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.

<br>


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://help.accentuate.io/flow-examples/the-scheduled-import-as-a-trigger-engine-for-daily-campaigns.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.