Variable on Send Email - Flow Apps

Shopify Plus

Topic summary

A user seeks help creating a Flow automation to email daily sales reports containing: yesterday’s total net sales, yesterday’s total orders, and month-to-date net sales. The store owner prefers email reports over checking the Shopify app.

Current Challenge:

  • Flow’s “Get order data” action can retrieve order information, but accessing aggregated sales data isn’t straightforward via API
  • With 60-70 daily orders (under 100), pulling yesterday’s data is feasible
  • Month-to-date reporting is problematic due to the volume of orders that would need to be retrieved over an entire month

Suggested Approach:

  • Daily and yesterday metrics (items 1 & 2) are achievable
  • Month-to-date totals (item 3) likely won’t work due to data volume limitations
  • Using Flow’s “Run code” action is recommended for aggregating order values instead of Liquid templating

Status: The discussion remains open with a partial solution identified. The user wants to avoid paid apps and utilize Flow’s built-in capabilities, though Flow currently lacks direct integration with Shopify Analytics reports.

Summarized with AI on October 30. AI used: claude-sonnet-4-5-20250929.
1

Hi there,

Can someone help me with flow app?

I just need help to know variable to get data with this condition

  1. Total Net Sales - Yesterday

  2. Total Orders - Yesterday

  3. Total Net Sales month to Date.

Can someone with good experience with flow apps, helping me. ^^

1 Like
2

To get order data in Flow, you would use “Get order data”. But none of this data is easily accessible via API, and getting it may require you to pull quite a bit of data. If your # of orders is over 100 per day, it just won’t work.

Ideally, Flow wants better integration with Shopify Analytics so you can use data from reports in Flow, rather than trying to pull all the data into Flow.

3

Thanks for the update. My idea is to send a daily email with the total sales for the day.

On average, my orders range from 60 to 70 per day, never exceeding 100.

My store owner prefers the old-school way—checking reports via email rather than using the Shopify app. I manually send him a report every morning, which is getting quite annoying for me. Haha.

If you suggest using an app, it’s possible, but I don’t see the need to spend money when I can use Flow. It used to be easier to use, but now the variables in Flow feel a bit confusing.

4

Ok, so you might be able to do (1) and (2) but not (3) because it’s that volume over a whole month.

To do it, you’ll need to get orders from that time period and then total up the values for the email report. I’d recommend exploring Run code as it’s a good way to aggregate data (instead of liquid).