Send automated email to customer leaving 5 star review

Shopify Plus

Topic summary

A user is attempting to create a Shopify Flow automation that sends a marketing email to customers who leave 5-star reviews. The flow triggers on review submission, checks for 5-star ratings, then attempts to send an email.

The Problem:
The workflow fails with a “customer data not found” error because the review trigger doesn’t automatically provide customer resource data to Flow.

The Solution:
The review trigger only provides limited data (email or CustomerID string). To fix this:

  • Add a “Get customer data” action after the trigger
  • Query using something like email:{{email}}
  • Add a “for each” loop after this action (since it returns a list)
  • Place the “Send Marketing Email” action inside the loop

A visual workflow structure was shared showing the correct sequence of actions. The user requesting help indicated they’re new to Flow automation and found the technical explanation confusing.

Summarized with AI on November 2. AI used: claude-sonnet-4-5-20250929.
2

That trigger doesn’t provide a customer resource to Flow, so Flow cannot automatically enter the Customer for you.

I believe it provides an email or maybe a string called “CustomerID”. So to use it, you can add a “Get customer data” action with a query of something like email:{{email}}. After that, you’ll need to add a for each loop after the action since it returns a list of customers (a list of 1 in this case). You can put the Send Marketing Email inside that for each loop and it should then find the customer.

Make sure to test this that the “Get customer data” query returns what you expect. The filters required by the API are a bit tricky